[Remote] Senior PostgreSQL Database Engineer – GCP / Cloud SQL
Note: The job is a remote job and is open to candidates in USA. iTech US Inc is seeking a Senior PostgreSQL Database Engineer. This build-and-run role is responsible for migrating, deploying, securing, operating, sizing, monitoring, tuning, and automating PostgreSQL databases on GCP Cloud SQL, including database migration, replication, backup, high availability, and incident response.
Responsibilities
- Plan and execute database migrations to Cloud SQL (PostgreSQL), including schema conversion, data validation, and cutover planning
- Use Database Migration Service (DMS) to migrate on-prem or cloud-based databases into Cloud SQL with minimal downtime
- Configure and manage Datastream for change data capture (CDC) and near real-time replication from source databases
- Own rollback planning for migrations — able to explain what happens if a cutover goes wrong, not just what happens if it goes right
- Administer and tune Cloud SQL (PostgreSQL) instances — performance, indexing, backups, high availability
- Diagnose slow-running databases: query analysis, missing indexes, CPU/memory/IO bottlenecks, locking/contention
- Set up and maintain monitoring and alerting (CPU, memory, storage, connections, replication lag, error rates)
- Manage database users, permissions, and secure connectivity (private networking, encryption, connection pooling)
- Own backup strategy and — critically — have actually performed a restore, not just configured a backup schedule
- Plan and execute database version upgrades and maintenance windows on live systems
- Automate recurring database work (provisioning as code, scheduled maintenance, index upkeep)
- Size database instances (CPU, memory, storage) based on workload and growth projections
- Design and configure high-availability setups (multi-zone/multi-region, read replicas)
- Make and justify cost/performance tradeoffs
Skills
- Strong hands-on PostgreSQL experience
- Experience with Cloud SQL (PostgreSQL) on GCP
- Experience with Database Migration Service (DMS) and Datastream
- On-call/incident-response experience for a database
- Understanding of migration best practices
- Troubleshooting replication lag and data consistency issues
- Experience with heterogeneous migrations (e.g., Oracle → PostgreSQL)
- Experience with Terraform or similar for database infrastructure automation
Company Overview
Company H1B Sponsorship