Job Title: Senior Database Administrator (PostgreSQL / AWS RDS)nnJob type: 6-month contractnnShift: 2 to 11 pm ISTnnLocation: RemotennJob SummarynnWe are seeking a highly experienced Senior Database Administrator (DBA) to manage, monitor, nnoptimize, 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.nnThe ideal candidate will bring deep expertise in query performance tuning, database version upgrades,nnand 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.nnKey ResponsibilitiesnnPostgreSQL Administration (On-Premise u0026 Cloud) nn- Monitor, analyze, and tune heavy and long-running SQL queries across PostgreSQLnnenvironments n- Identify and resolve performance bottlenecks using PostgreSQL statistics, logs, and system metricsn- Optimize database performance through:n- Index design and optimizationn- Query analysis and rewritingn- PostgreSQL configuration tuning (memory, vacuum, autovacuum, checkpoints)n- Detect and propose data archival mechanism for unused datan- Ensure database availability, reliability, and data integrityn- Manage backup, restore, and disaster recovery strategiesnnDatabase Version Upgrades u0026 Compatibility Testingnn- Lead and execute PostgreSQL database version upgrades in on-premises and AWS RDS environments n- Perform pre-upgrade assessments to identify: n- Deprecated features and breaking changes n- Extension, stored procedure,



and function compatibility issues n- Query behavior and performance changes between versions n- Design and execute comprehensive upgrade testing plans to ensure: n- Stored procedures, functions, triggers, and views remain compatible n- Existing SQL queries execute correctly and efficiently n- Applications function as expected on the upgraded database version n- Validate data integrity, performance, and stability post-upgrade nnAWS RDS PostgreSQL u0026 Cloud Operationsnn- Design, provision, and manage AWS RDS PostgreSQL instancesn- Spin up and configure RDS environments following best practices for:n- Security and access controln- Performance tuning and scalabilityn- High availability, backups, and snapshotsn- Monitor RDS performance using AWS and PostgreSQL monitoring toolsn- Partner with DevOps and infrastructure teams on cloud database architecturennDatabase Migration u0026 Modernizationnn- Lead and support database migrations between on-premises PostgreSQL and AWS RDSn- Plan and execute migrations with minimal downtime and riskn- Perform data validation and performance testing after migrationn- Provide strategic recommendations for PostgreSQL modernization,



architecture improvements,nnand version adoption DevOps u0026 Automationnn- Apply DevOps principles to database operationsn- Automate database provisioning, configuration, monitoring, and maintenancen- Support CI/CD pipelines involving database schema and data changesn- Use scripting and infrastructure-as-code approaches to improve operational efficiencynnRequired Qualificationsnn- Minimum 7 years of experience as a Database Administrator, with solid focus on PostgreSQLn- Deep hands-on knowledge of PostgreSQL internals, performance tuning, and query optimizationn- Proven experience planning and executing PostgreSQL version upgrades, including:n- Compatibility testing of stored procedures, functions, and SQL queriesn- Managing risks, rollback plans, and production cutoversn- Strong experience managing AWS RDS PostgreSQL environmentsn- Solid understanding of Linux/Unix operating systemsn- Experience working with DevOps tools, automation, and modern infrastructure practicesn- Excellent troubleshooting, analytical, and problem-solving skillsn- Experience supporting large-scale or high-traffic PostgreSQL environmentsn- Robust communication and technical documentation skillsn- Ability to work independently and take ownership of complex database platformsn- Comfortable collaborating with application, DevOps, and infrastructure teamsn- Proactive, improvement-driven mindset focused on performance, stability, and scalabilityn- Familiarity with PostgreSQL monitoring and diagnostic toolsn- Knowledge of high-availability, replication, and failover strategiesn- Experience with AWS services such as VPC, IAM, EC2, and S3n- Scripting skills (Bash, Python, or similar) .

📌 Senior Database Administrator -PostgreSQL -AWS RDS | 6M | Remote (Gurugram) (India)
🏢 Highspring India
📍 India