₹13L – ₹25L a year estimatetypical for IT Jobs in Bangalore, 254 posts
Posted 3 days ago
Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
You will
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.
Experience
9+ years
Must-have skills
CI/CDHigh AvailabilityPostgreSQLSQL
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
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/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
Most IT Jobs posts in Bangalore ask for 3–6 years of experience (41% of 4885 that say).
Hiring most for IT Jobs in Bangalore
Bosch Group188 open jobs
Brillio121 open jobs
Eurofins118 open jobs
Jobs asking for CI/CD in Bangalore also ask for
Python53%
AWS46%
Microsoft Azure39%
Kubernetes38%
Docker32%
From live job posts on CoreHRx, updated 18 Nov 2026. Skill figures count posts that list their skills; salary figures only posts that show a salary.
Questions about this job
What is the salary for this Senior PostgreSQL / Database Developer job?
The post does not state the pay. As an estimate, comparable posts on CoreHRx advertise ₹13L – ₹25L a year (typical for IT Jobs in Bangalore, 254 posts).
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?