Senior PostgreSQL Database Engineer – GCP / Cloud SQL

About the CompanyThis is a build-and-run role — you'll be the person accountable for the database itself: sizing, securing, deploying, operating, and migrating it, not just connecting to it or transforming data that flows through it. Day-to-day, this role leans DBA/DataDevOps rather than pipeline development.ResponsibilitiesMigrationPlan and execute database migrations to Cloud SQL (PostgreSQL), including schema conversion, data validation, and cutover planningUse Database Migration Service (DMS) to migrate on-prem or cloud-based databases into Cloud SQL with minimal downtimeConfigure and manage Datastream for change data capture (CDC) and near real-time replication from source databasesOwn rollback planning for migrations — able to explain what happens if a cutover goes wrong, not just what happens if it goes rightDay-to-Day OperationsAdminister and tune Cloud SQL (PostgreSQL) instances — performance, indexing, backups, high availabilityDiagnose slow-running databases: query analysis, missing indexes, CPU/memory/IO bottlenecks, locking/contentionSet 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 schedulePlan and execute database version upgrades and maintenance windows on live systemsAutomate recurring database work (provisioning as code, scheduled maintenance, index upkeep)Design & SizingSize database instances (CPU, memory, storage) based on workload and growth projectionsDesign and configure high-availability setups (multi-zone/multi-region, read replicas)Make and justify cost/performance tradeoffsQualificationsStrong hands-on PostgreSQL experience — administration, performance tuning, schema design, as the person who owned a production database, not just someone who queried oneExperience with Cloud SQL (PostgreSQL) on GCP — ideally provisioned and configured, not just usedExperience with Database Migration Service (DMS) and Datastream (or equivalent CDC tools) for migration and replicationDemonstrated on-call/incident-response experience for a database (not just for pipeline job failures)Solid understanding of migration best practices — minimal-downtime cutovers, validation, rollback strategiesComfortable troubleshooting replication lag and data consistency issuesRequired SkillsStrong hands-on PostgreSQL experienceExperience with Cloud SQL (PostgreSQL) on GCPExperience with Database Migration Service (DMS) and DatastreamOn-call/incident-response experience for a databaseUnderstanding of migration best practicesTroubleshooting replication lag and data consistency issuesPreferred SkillsExperience with heterogeneous migrations (e.g., Oracle → PostgreSQL)Experience with Terraform or similar for database infrastructure automation