Database Administration Architect

at  TELUS Digital

We are seeking a highly skilled and experienced Database Architect to join our team and lead the migration of our database environments to Google Cloud Platform (GCP). In this critical role, you will be responsible for architecting, implementing, and managing scalable, reliable, and high-performance database solutions on GCP.

QUALIFICATIONS:

• Bachelor’s degree in Computer Science, Information Technology, Data Engineering, or a related field.
• Advanced certifications (e.g., Google Professional Data Engineer, Professional Cloud Architect) are a plus.
• 7+ years of experience in database architecture and management, with 3+ years of hands-on experience specifically with database migration projects to GCP.
• Strong expertise in GCP database services (Cloud SQL, BigQuery, Cloud Spanner, Firestore, Cloud Datastore).
• Proven experience in using migration tools like Google Database Migration Service, Cloud Data Fusion, or third-party solutions.
• In-depth knowledge of database management systems (DBMS) like Oracle, MySQL, PostgreSQL, SQL Server, and NoSQL databases.
• Demonstrated skills in designing and optimizing cloud-native database architectures.
• Familiarity with Infrastructure as Code (IaC) tools such as Terraform and Google Cloud Deployment Manager.
• Experience with database performance tuning, backup and restore procedures, disaster recovery, and security best practices in cloud environments.

PREFERRED SKILLS:

• GCP certifications such as Professional Data Engineer or Professional Cloud Architect.
• Experience with multi-cloud and hybrid cloud database migration strategies.
• Familiarity with Kubernetes and containerized database management.
• Experience in data governance, compliance frameworks, and implementing database policies.
• Knowledge of big data and real-time processing technologies (e.g., Apache Beam, Cloud Dataflow, Apache Kafka).

• Database Migration:
• Lead the design, planning, and execution of database migrations from on-premises or other cloud environments to GCP.
• Assess current database environments and develop comprehensive migration strategies, including analysis of application dependencies, downtime requirements, and risk mitigation.
• Utilize migration tools such as Google Database Migration Service, Cloud Data Fusion, and third-party solutions to facilitate seamless migrations while ensuring data integrity.
• Database Architecture & Optimization:
• Design and implement scalable database architectures using GCP’s managed database services (Cloud SQL, BigQuery, Cloud Spanner, Firestore, Cloud Datastore).
• Optimize database performance through schema design, indexing, partitioning, sharding, and query optimization techniques.
• Architect database solutions that ensure high availability, disaster recovery, and data replication across GCP regions.
• Cloud Database Management:
• Manage and administer databases deployed on GCP services, monitoring performance using tools like Cloud Monitoring and Cloud Logging.
• Implement and maintain automated backups, disaster recovery plans, and robust security protocols.
• Collaborate with cloud engineers and DevOps teams to automate database deployments and configuration management using tools like Terraform and Google Cloud Deployment Manager.
• Collaboration & Stakeholder Engagement:
• Work closely with application development, data engineering, and IT operations teams to align database solutions with business requirements.
• Communicate complex technical concepts effectively to both technical and non-technical stakeholders.
• Collaborate with vendors, consultants, and partners to ensure successful project delivery.
• Security, Compliance, and Governance:
• Implement data security best practices, including encryption, IAM, and network security configurations.
• Ensure compliance with industry regulations (e.g., GDPR, HIPAA) and organizational policies.
• Establish data governance policies and manage access controls to secure database environments.
• Continuous Improvement & Documentation:
• Document database architecture, migration processes, and best practices for future use.
• Stay updated with GCP database services, new features, and best practices.
• Identify opportunities for automation and improvement in existing processes.