Senior PostgreSQL Database Administrator (DBA)Experience: 7+ Years

Employment Type: Contract

Primary Skill: PostgreSQL Internals

Work Location: Remote

Job SummaryWe are looking for a highly experienced Senior PostgreSQL Database Administrator (DBA) with 7+ years of database administration experience and strong 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 integrity, and application functionality after upgrades.
- Execute production cutovers with minimal downtime and operational risk.

AWS RDS PostgreSQL
- Design, provision, configure, and manage AWS RDS PostgreSQL environments.
- Configure RDS instances based on security, performance, scalability, availability, and backup requirements.
- Monitor RDS health and performance using AWS and PostgreSQL monitoring tools.
- Manage snapshots, backups, recovery, scaling, and high-availability configurations.
- Collaborate with DevOps and infrastructure teams on cloud database architecture.

Database Migration & • Modernization
- Lead and support migrations between on-premises PostgreSQL and AWS RDS PostgreSQL.
- Develop migration strategies with minimal downtime and business disruption.
- Perform data validation, reconciliation, and post-migration performance testing.
- Identify opportunities for PostgreSQL modernization and architecture improvements.
- Provide recommendations for version adoption, scalability, reliability, and cost optimization.

DevOps & • Automation
- Apply DevOps principles to database administration and operations.
- Automate database provisioning, configuration, monitoring, maintenance, and operational tasks.
- Support CI/CD pipelines involving database schema and data changes.
- Develop scripts and automation using Bash, Python, or similar scripting languages.
- Work with Infrastructure-as-Code and modern infrastructure practices where applicable.

Required Skills & • Qualifications




- 7+ years of experience as a Database Administrator with strong PostgreSQL expertise.
- Deep hands-on knowledge of PostgreSQL internals.
- Strong expertise in PostgreSQL performance tuning and SQL query optimization.
- Proven experience with PostgreSQL version upgrades and compatibility testing.
- Strong experience managing AWS RDS PostgreSQL.
- Experience with PostgreSQL backup, recovery, replication, high availability, and failover.
- Robust Linux/Unix administration knowledge.
- Experience supporting large-scale, high-traffic, or high-load PostgreSQL environments.
- Hands-on experience with PostgreSQL monitoring and diagnostic tools.
- Strong understanding of indexes, execution plans, VACUUM, autovacuum, checkpoints, and configuration parameters.
- Experience with database migration and modernization projects.
- Working knowledge of AWS services including VPC, IAM, EC2, and S3.
- Experience with DevOps tools, automation, CI/CD, and infrastructure practices.
- Strong scripting skills in Bash, Python, or similar.
- Excellent troubleshooting, analytical, and problem-solving abilities.
- Strong technical documentation and communication skills.
- Ability to work independently and take ownership of complex database platforms.
- Ability to collaborate effectively with application, DevOps, cloud, and infrastructure teams.

Preferred Expertise
- PostgreSQL internals and advanced performance diagnostics.
- High availability and replication architectures.
- AWS RDS PostgreSQL architecture and optimization.
- PostgreSQL major-version upgrade projects.
- On-premises-to-AWS database migrations.
- Database automation and Infrastructure-as-Code.
- Experience working with mission-critical production databases.

Key SkillsPostgreSQL Internals | PostgreSQL Performance Tuning | AWS RDS PostgreSQL | PostgreSQL Upgrades & • Migration | Linux/Unix | SQL Query Optimization | HA/Replication/Failover | Bash/Python | AWS

📌 Senior PostgreSQL Database Administrator (7+ yrs) (India)
🏢 MindBrain
📍 India