PostgreSQL Developer
PostgreSQL Developer (Cloud DBA migration focus)
Location: Preference to Hybrid (3 days per month in Denver, CO office), Open to remote
Pay Rate: $70-$80 /hr. on W2 with benefits
Contract: Long term contract
Summary
We are seeking a highly motivated and experienced GCP 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 GCP 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:
• Assess existing database environments (on-premises, other cloud platforms) for migration feasibility and complexity.
• Develop comprehensive migration plans, including schema conversion, data transfer strategies, and testing procedures.
• Execute database migrations to Cloud SQL for PostgreSQL using appropriate tools and techniques (e.g., pgdump/pgrestore, Data Migration Service, logical replication).
• Perform thorough validation and testing to ensure data integrity and application functionality post-migration.
• Troubleshoot and resolve migration-related issues in a timely manner.
Cloud SQL for PostgreSQL Management:
• Provision, configure, and manage Cloud SQL for PostgreSQL instances.
• Optimize database performance through indexing, query tuning, and resource allocation.
• Implement and maintain database security best practices, including access control, encryption, and auditing.
• Monitor database health and performance using Cloud Monitoring and other relevant tools.
• Perform database backups, restores, and disaster recovery procedures.
• Manage database scaling and high availability configurations.
GCP Integration:
• Integrate Cloud SQL for PostgreSQL with other GCP services, such as Cloud Storage, Cloud Functions, and BigQuery.
• Utilize GCP networking services (VPC, firewall rules) to ensure secure and efficient database connectivity.
• Leverage Infrastructure as Code (IaC) tools like Terraform to automate database deployments and configurations.
Collaboration and Communication:
• Work closely with application developers, system administrators, and data engineers to understand database requirements and provide technical guidance.
• Document database configurations, migration procedures, and best practices.
• Communicate effectively with stakeholders regarding migration progress and potential risks.
• Participate in on-call rotations as needed.
Performance and Optimization:
• Perform query analysis, and provide indexing strategies.
• Optimize database configurations for optimal performance and resource utilization.
• Implement and maintain database monitoring and alerting systems.
Required Qualifications
• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Minimum of 5+ years of experience1 in PostgreSQL database administration and migration.
• Strong understanding of database migration methodologies and best practices.
• Hands-on experience with Google Cloud Platform (GCP) and Cloud SQL for PostgreSQL.
• Proficiency in SQL and database performance tuning.
• Experience with database backup and recovery procedures.
• Knowledge of database security principles and best practices.
• Familiarity with Infrastructure as Code (IaC) tools (e.g., Terraform).
• Experience with pgdump, pgrestore, and logical replication.
• Experience with the GCP Data Migration Service.
Preferred Qualifications
• GCP Professional Cloud Database Engineer certification.
• Experience with other database technologies (e.g., MySQL, Oracle).
• Experience with scripting languages (e.g., Python, Bash).
• Experience with containerization technologies (e.g., Docker, Kubernetes).
• Experience with CI/CD pipelines.
PostgreSQL Developer (Cloud DBA migration focus)
Location: Preference to Hybrid (3 days per month in Denver, CO office), Open to remote
Pay Rate: $70-$80 /hr. on W2 with benefits
Contract: Long term contract
Summary
We are seeking a highly motivated and experienced GCP 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 GCP 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:
• Assess existing database environments (on-premises, other cloud platforms) for migration feasibility and complexity.
• Develop comprehensive migration plans, including schema conversion, data transfer strategies, and testing procedures.
• Execute database migrations to Cloud SQL for PostgreSQL using appropriate tools and techniques (e.g., pgdump/pgrestore, Data Migration Service, logical replication).
• Perform thorough validation and testing to ensure data integrity and application functionality post-migration.
• Troubleshoot and resolve migration-related issues in a timely manner.
Cloud SQL for PostgreSQL Management:
• Provision, configure, and manage Cloud SQL for PostgreSQL instances.
• Optimize database performance through indexing, query tuning, and resource allocation.
• Implement and maintain database security best practices, including access control, encryption, and auditing.
• Monitor database health and performance using Cloud Monitoring and other relevant tools.
• Perform database backups, restores, and disaster recovery procedures.
• Manage database scaling and high availability configurations.
GCP Integration:
• Integrate Cloud SQL for PostgreSQL with other GCP services, such as Cloud Storage, Cloud Functions, and BigQuery.
• Utilize GCP networking services (VPC, firewall rules) to ensure secure and efficient database connectivity.
• Leverage Infrastructure as Code (IaC) tools like Terraform to automate database deployments and configurations.
Collaboration and Communication:
• Work closely with application developers, system administrators, and data engineers to understand database requirements and provide technical guidance.
• Document database configurations, migration procedures, and best practices.
• Communicate effectively with stakeholders regarding migration progress and potential risks.
• Participate in on-call rotations as needed.
Performance and Optimization:
• Perform query analysis, and provide indexing strategies.
• Optimize database configurations for optimal performance and resource utilization.
• Implement and maintain database monitoring and alerting systems.
Required Qualifications
• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Minimum of 5+ years of experience1 in PostgreSQL database administration and migration.
• Strong understanding of database migration methodologies and best practices.
• Hands-on experience with Google Cloud Platform (GCP) and Cloud SQL for PostgreSQL.
• Proficiency in SQL and database performance tuning.
• Experience with database backup and recovery procedures.
• Knowledge of database security principles and best practices.
• Familiarity with Infrastructure as Code (IaC) tools (e.g., Terraform).
• Experience with pgdump, pgrestore, and logical replication.
• Experience with the GCP Data Migration Service.
Preferred Qualifications
• GCP Professional Cloud Database Engineer certification.
• Experience with other database technologies (e.g., MySQL, Oracle).
• Experience with scripting languages (e.g., Python, Bash).
• Experience with containerization technologies (e.g., Docker, Kubernetes).
• Experience with CI/CD pipelines.
