Senior PostgreSQL / Database Developer

Project description

We are seeking a hands-on PostgreSQL/Database Developer to lead all database-related delivery and operational excellence for the CDU team. This person will own migration CR execution, database automation via Azure DevOps pipelines, periodic database health reporting, and proactive remediation across performance, data model quality, availability, and scalability. The role also requires regular liaison with the Production DBA team for planned weekend production changes, primarily on Saturdays.

Responsibilities

• - Own and execute all DB-related CRs, including schema and data changes, rollout sequencing, and validation. - Partner with development teams to action migration CRs and all production/ non-production DB activities. - Automate production database migrations (DDL/DML) using tooling integrated with Azure DevOps (ADO) pipelines. - Establish and run periodic DB health reports; prioritize and drive remediation actions. - Monitor table growth trends and flag anomalies for investigation. - Analyze usage/update patterns on critical-path tables; identify and resolve read/write contention. - Identify heavy queries and optimize, redesign, or eliminate them where feasible. - Review and tune connection pool usage and settings. - Define and implement archival/housekeeping strategy, including scheduled DB-native jobs/stored procedures where appropriate. - Recommend partitioning/sharding strategies for largest hot-path tables. - Ensure indexing strategy is comprehensive and usage-driven across heavy workloads. - Identify data model redundancies and opportunities to coalesce/simplify table structures. - Provide normalization and denormalization recommendations based on backend and UI access patterns. - Review cursor and pagination implementation and recommend better-performing patterns. - Perform PostgreSQL configuration tuning for performance and stability. - Assess replication/read-instance setup and improve read scaling and failover readiness. - Assess and certify DR/HA posture; validate or define realistic RTO/RPO targets. - Define practical methods to create production-like dumps for dev/test environments quickly and safely. - Analyze p90/p99 variability and provide capacity sizing recommendations for DB resources. Weekend Production Support (Mandatory): - Serve as CDU's DB point-of-contact for planned weekend production release windows (primarily Saturdays). - Liaise directly with the Production DBA team to coordinate and execute approved production DB CRs. - Support pre-change checks, change execution, validation, rollback readiness, and post-change reporting. - Provide regular Saturday availability aligned to release calendars. - Work under a compensatory day-off-in-lieu model during the work week for approved weekend activities.

SKILLS

Must have

• - Overall 9+ years of experience - Strong production PostgreSQL experience in high-availability environments. - Proven ownership of zero/low-downtime migration rollouts in live systems. - Deep SQL tuning expertise (query plans, indexing, locking/concurrency, vacuum/analyze behavior). - Experience with DB migration tooling (for example: Flyway, Liquibase, Sqitch, or equivalent). - Strong experience integrating database changes into ADO CI/CD pipelines. - Strong understanding of replication, backup/restore, failover, DR testing, and HA operations. - Practical expertise in partitioning, archival, and data lifecycle strategies. - Ability to produce clear operational runbooks and remediation plans with measurable outcomes. - Strong cross-team communication with engineering, platform, and DBA stakeholders.

Nice to have

• Release Management approach/tools • General Enterprise Technical Aptitude: networks, servers, load balancing, storage, etc • Financial Domain knowledge