Job Description

Senior Database Architect with migration with GCP Or AWS

Location - Remote

Job Summary

"We are looking for an experienced GCP Database Architect with a strong focus on database migration to join our team. The ideal candidate will have deep expertise in migrating complex database environments from on-premises and other cloud providers to Google Cloud Platform (GCP). You will be responsible for architecting, implementing, and managing scalable, reliable, and high-performance database solutions on GCP. This role requires extensive knowledge of GCP's database services, as well as hands-on experience with migration tools, best practices, and Methodologies."

Key Responsibilities

Database Migration Planning and Execution -

1. Lead the design, planning, and execution of database migrations from on-premises or other cloud environments to GCP.
2. Assess current database environments and create comprehensive migration strategies, including analysis of application dependencies, downtime requirements, and risk mitigation.
3. Utilize tools such as Google Database Migration Service, Cloud Data Fusion, and third-party solutions to facilitate seamless migrations while ensuring data integrity and minimal disruption.

Database Architecture and Optimization -

1. Design and implement scalable database architectures using GCP's managed database services, such as Cloud SQL, BigQuery, Cloud Spanner, Firestore, and Cloud Datastore.
2. Optimize database performance through schema design, indexing, partitioning, sharding, and query optimization techniques tailored for cloud environments.
3. Architect database solutions that ensure high availability, disaster recovery, and data replication across GCP regions.

Cloud Database Management -

1. Manage and administer databases deployed on GCP services, monitoring performance using tools like Cloud Monitoring, Cloud Logging, and third-party solutions.
2. Implement and maintain automated backups, disaster recovery plans, and security protocols to safeguard database environments.
3. Collaborate with cloud engineers and DevOps teams to automate database deployments and configuration management using tools like Terraform and Google Cloud Deployment Manager.

Collaboration and Stakeholder Engagement -

1. Work closely with application development, data engineering, and IT operations teams to align database solutions with business requirements.
2. Communicate complex technical concepts to both technical and non-technical stakeholders, providing guidance on best practices for database architecture and migration.
3. Collaborate with external vendors, consultants, and partners to ensure successful project delivery and integration of advanced database solutions.

Security, Compliance, and Governance -

1. Implement data security best practices, including encryption, identity access management (IAM), and network security configurations to protect sensitive data.
2. Ensure compliance with industry regulations (e.g., GDPR, HIPAA) and organizational policies throughout the migration and implementation processes.
3. Establish data governance policies and manage access controls to secure database environments and maintain data integrity.

Continuous Improvement and Documentation -

1. Document database architecture, migration processes, and best practices to create reusable playbooks for future projects.
2. Stay up-to-date with GCP database services, new features, and best practices to continually enhance the database architecture and migration processes.
3. Identify opportunities for automation and improvement in existing processes to increase efficiency and reduce manual efforts.

Qualifications -

1. 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.
2. 7+ years of experience in database architecture and management, with 3+ years of hands-on experience specifically with database migration projects to GCP.
3. Strong expertise in GCP database services such as Cloud SQL (MySQL, PostgreSQL, SQL Server), BigQuery, Cloud Spanner, Firestore, and Cloud Datastore.
4. Proven experience in using migration tools like Google Database Migration Service, Cloud Data Fusion, or third-party solutions such as Striim or Datastream.
5. In-depth knowledge of database management systems (DBMS) like Oracle, MySQL, PostgreSQL, SQL Server, and NoSQL databases.
6. Demonstrated skills in designing and optimizing cloud-native database architectures, ensuring performance, scalability, and security.
7. Familiarity with Infrastructure as Code (IaC) tools such as Terraform and Google Cloud Deployment Manager for automating database deployments and configurations.
8. Experience with database performance tuning, backup and restore procedures, disaster recovery, and security best practices in cloud environments.

Preferred Skills -

1. GCP certifications such as Professional Data Engineer or Professional Cloud Architect.
2. Experience with multi-cloud and hybrid cloud database migration strategies and implementations.
3. Familiarity with Kubernetes and containerized database management (e.g., deploying databases within GKE clusters).
4. Experience in data governance, compliance frameworks, and implementing database policies to ensure adherence to regulatory standards.
5. Knowledge of big data and real-time processing technologies, such as Apache Beam, Cloud Dataflow, or Apache Kafka.

Job Tags

Similar Jobs