Senior PostgreSQL / Database Developer

Luxoft

Bengaluru

On-site

INR 4,000,000 - 7,000,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Luxoft in Bengaluru is seeking a hands-on PostgreSQL/Database Developer to lead database delivery and operational excellence for the CDU team. You will own migration CR execution, automate migrations via Azure DevOps pipelines, and drive periodic health reporting and remediation for performance, data quality, and scalability.

The role requires coordinating with Production DBA for weekend release windows, ensuring rollback readiness, and implementing robust backup, replication and HA strategies

Qualifications

  • Overall 9+ years of experience in PostgreSQL/Database development and operations.
  • 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 (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.
  • 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.

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

PostgreSQL tuning
Zero-downtime migrations
SQL performance tuning
ADO pipelines
Replication/HA
Partitioning/archival
Database monitoring
Cross-team communication

Tools

Flyway
Liquibase
Sqitch
Azure DevOps

Job description

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/simplifytable 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/testenvironments 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 executeapproved 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
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Developer
Database Developer

Luxoft • Bengaluru

On-site
INR 1,500,000 - 3,500,000
Database Administrator
Database Administrator

Minfy Technologies • Hyderabad

On-site
INR 1,500,000 - 2,400,000
Senior PostgreSQL DBA
Senior PostgreSQL DBA

Programmers • Jaipur

On-site
INR 1,500,000 - 2,300,000
Database Expert
Database Expert

Fluentgrid • Visakhapatnam

On-site
INR 1,200,000 - 2,400,000
Senior Database Administrator
Senior Database Administrator

Bcits Pvt Ltd • Bengaluru

On-site
INR 1,000,000 - 2,000,000
Database Lead - PostgreSQL
Database Lead - PostgreSQL

Experion • Ernakulam, Thiruvananthapuram

On-site
INR 1,200,000 - 2,400,000
Database Administrator (DBA) - PostgreSQL and SQL Server
Database Administrator (DBA) - PostgreSQL and SQL Server

Ample Success HR • Mumbai

On-site
INR 1,500,000 - 2,100,000
Senior PostgreSQL DBA
Senior PostgreSQL DBA

Programmers.io • India

Remote
INR 1,400,000 - 2,400,000
Senior PostgreSQL DBA
Senior PostgreSQL DBA

Programmers • Pune District

On-site
INR 1,200,000 - 1,800,000
Senior PostgreSQL DBA
Senior PostgreSQL DBA

Programmers • Hyderabad

On-site
INR 1,200,000 - 2,100,000