Hiring For Senior DBA (PostgreSQL / AWS RDS) - Remote - 6 months C2H

Job Title: Senior Database Administrator (PostgreSQL / AWS RDS) Job type: 6 months contract Shift: 2 to 11 pm IST Location: Remote Job Summary We are seeking a highly experienced Senior Database Administrator (DBA) to manage, monitor, optimize, and evolve our PostgreSQL database environments. This role is responsible for supporting high-load on-premises PostgreSQL systems as well as AWS RDS PostgreSQL deployments. The ideal candidate will bring deep expertise in query performance tuning, database version upgrades, and cloud database operations, with a proven ability to plan, test, and execute PostgreSQL upgrades and migrations while ensuring application compatibility, data integrity, and system stability. Key Responsibilities PostgreSQL Administration (On-Premise & Cloud) • Monitor, analyze, and tune heavy and long-running SQL queries across PostgreSQL environments • Identify and resolve performance bottlenecks using PostgreSQL statistics, logs, and system metrics • Optimize database performance through: Index design and optimization Query analysis and rewriting PostgreSQL configuration tuning (memory, vacuum, autovacuum, checkpoints) Detect and propose data archival mechanism for unused data • Ensure database availability, reliability, and data integrity • Manage backup, restore, and disaster recovery strategies Database Version Upgrades & Compatibility Testing • Lead and execute PostgreSQL database version upgrades in on-premises and AWS RDS environments • Perform pre-upgrade assessments to identify: Deprecated features and breaking changes Extension, stored procedure, and function compatibility issues Query behavior and performance changes between versions • Design and execute comprehensive upgrade testing plans to ensure: Stored procedures, functions, triggers, and views remain compatible Existing SQL queries execute correctly and efficiently Applications function as expected on the upgraded database version • Validate data integrity, performance, and stability post-upgrade AWS RDS PostgreSQL & Cloud Operations • Design, provision, and manage AWS RDS PostgreSQL instances • Spin up and configure RDS environments following best practices for: Security and access control Performance tuning and scalability High availability, backups, and snapshots • Monitor RDS performance using AWS and PostgreSQL monitoring tools • Partner with DevOps and infrastructure teams on cloud database architecture Database Migration & Modernization • Lead and support database migrations between on-premises PostgreSQL and AWS RDS • Plan and execute migrations with minimal downtime and risk • Perform data validation and performance testing after migration • Provide strategic recommendations for PostgreSQL modernization, architecture improvements, and version adoption DevOps & Automation • Apply DevOps principles to database operations • Automate database provisioning, configuration, monitoring, and maintenance • Support CI/CD pipelines involving database schema and data changes • Use scripting and infrastructure-as-code approaches to improve operational efficiency Required Qualifications • Minimum 7 years of experience as a Database Administrator, with strong focus on PostgreSQL • Deep hands-on knowledge of PostgreSQL internals, performance tuning, and query optimization • Proven experience planning and executing PostgreSQL version upgrades, including: Compatibility testing of stored procedures, functions, and SQL queries Managing risks, rollback plans, and production cutovers • Strong experience managing AWS RDS PostgreSQL environments • Solid understanding of Linux/Unix operating systems • Experience working with DevOps tools, automation, and modern infrastructure practices • Excellent troubleshooting, analytical, and problem-solving skills • Experience supporting large-scale or high-traffic PostgreSQL environments • Strong communication and technical documentation skills • Ability to work independently and take ownership of complex database platforms • Comfortable collaborating with application, DevOps, and infrastructure teams • Proactive, improvement-driven mindset focused on performance, stability, and scalability • Familiarity with PostgreSQL monitoring and diagnostic tools • Knowledge of high-availability, replication, and failover strategies • Experience with AWS services such as VPC, IAM, EC2, and S3 • Scripting skills (Bash, Python, or similar)