Google Cloud Platform PostgreSQL DBA

Google Cloud Platform PostgreSQL Database Engineer (Migration Focus)

Job Description:

About the Role:

We are seeking a highly motivated and experienced Google Cloud Platform PostgreSQL Database Engineer with a strong focus on database migration. In this role, you will be responsible for planning, executing, and optimizing the migration of on-premises or other cloud-based database systems to Google Cloud Platform's Cloud SQL for PostgreSQL. You will leverage your deep expertise in PostgreSQL and Google Cloud Platform services to ensure seamless, efficient, and secure database migrations. You will collaborate closely with development, infrastructure, and data teams to deliver scalable and reliable database solutions.

Responsibilities:

• Database Migration Planning and Execution:

o Assess existing database environments (on-premises, other cloud platforms) for migration feasibility and complexity.

o Develop comprehensive migration plans, including schema conversion, data transfer strategies, and testing procedures.

o Execute database migrations to Cloud SQL for PostgreSQL using appropriate tools and techniques (e.g., pg_dump/pg_restore, Data Migration Service, logical replication).

o Perform thorough validation and testing to ensure data integrity and application functionality post-migration.

o Troubleshoot and resolve migration-related issues in a timely manner.

• Cloud SQL for PostgreSQL Management:

o Provision, configure, and manage Cloud SQL for PostgreSQL instances.

o Optimize database performance through indexing, query tuning, and resource allocation.

o Implement and maintain database security best practices, including access control, encryption, and auditing.

o Monitor database health and performance using Cloud Monitoring and other relevant tools.

o Perform database backups, restores, and disaster recovery procedures.

o Manage database scaling and high availability configurations.

• Google Cloud Platform Integration:

o Integrate Cloud SQL for PostgreSQL with other Google Cloud Platform services, such as Cloud Storage, Cloud Functions, and BigQuery.

o Utilize Google Cloud Platform networking services (VPC, firewall rules) to ensure secure and efficient database connectivity.

o Leverage Infrastructure as Code (IaC) tools like Terraform to automate database deployments and configurations.

• Collaboration and Communication:

o Work closely with application developers, system administrators, and data engineers to understand database requirements and provide technical guidance.

o Document database configurations, migration procedures, and best practices.

o Communicate effectively with stakeholders regarding migration progress and potential risks.

o Participate in on-call rotations as needed.

• Performance and Optimization:

o Perform query analysis, and provide indexing strategies.

o Optimize database configurations for optimal performance and resource utilization.

o Implement and maintain database monitoring and alerting systems.

Qualifications:

• Required:

o Bachelor's degree in Computer Science, Information Technology, or a related field.

o Minimum of 5+ years of experience in PostgreSQL database administration and migration.

o Strong understanding of database migration methodologies and best practices.

o Hands-on experience with Google Cloud Platform (Google Cloud Platform) and Cloud SQL for PostgreSQL.

o Proficiency in SQL and database performance tuning.

o Experience with database backup and recovery procedures.

o Knowledge of database security principles and best practices.

o Familiarity with Infrastructure as Code (IaC) tools (e.g., Terraform).

o Experience with pg_dump, pg_restore, and logical replication.

o Experience with the Google Cloud Platform Data Migration Service.

• Preferred:

o Google Cloud Platform Professional Cloud Database Engineer certification.

o Experience with other database technologies (e.g., MySQL, Oracle).

o Experience with scripting languages (e.g., Python, Bash).

o Experience with containerization technologies (e.g., Docker, Kubernetes).

o Experience with CI/CD pipelines.

Skills:

• PostgreSQL Administration
• Google Cloud Platform Cloud SQL
• Database Migration
• SQL Performance Tuning
• Database Security
• Infrastructure as Code (Terraform)
• Data Migration Service
• Logical Replication
• Cloud Monitoring
• Problem-solving and analytical skills
• Excellent communication and collaboration skills.