Senior PostgreSQL Database Administrator (DBA)
Experience: 7+ Years
Employment Type: Contract
Primary Skill: PostgreSQL Internals
Work Location: Remote
Job Summary
We are looking for a highly experienced Senior PostgreSQL Database Administrator (DBA) with 7+ years of database administration experience and solid expertise in PostgreSQL internals, performance tuning, upgrades, AWS RDS, and database migrations.
The ideal candidate should have hands-on experience managing high-load PostgreSQL environments across on-premises infrastructure and AWS RDS, with strong capabilities in query optimization, database version upgrades, compatibility testing, high availability, disaster recovery, and cloud database operations.
Key ResponsibilitiesPostgreSQL Administration & Performance Tuning
Administer, monitor, troubleshoot, and optimize enterprise PostgreSQL databases in on-premises and cloud environments.
Analyze and tune heavy, complex, and long-running SQL queries.
Identify performance bottlenecks using PostgreSQL statistics, logs, and system metrics.
Perform query optimization,



execution plan analysis, indexing, and database configuration tuning.
Optimize PostgreSQL parameters related to memory, VACUUM, autovacuum, checkpoints, and workload management.
Identify opportunities for data archival and implement strategies for unused or historical data.
Ensure database availability, reliability, scalability, and data integrity.
Manage backup, restore, disaster recovery, replication, and failover strategies.
PostgreSQL Version Upgrades & Compatibility
Plan, test, and execute PostgreSQL version upgrades across on-premises and AWS RDS environments.
Conduct pre-upgrade assessments covering deprecated features, breaking changes, extensions, stored procedures, functions, triggers, views, and SQL compatibility.
Develop comprehensive upgrade and rollback plans.
Perform compatibility and regression testing for database objects and application workloads.
Validate query performance, data in

📌 Senior PostgreSQL Database Administrator (India)
🏢 MindBrain
📍 India