Job Title: Senior Database Administrator (PostgreSQL / AWS RDS)nnnJob type: 6-month contractnnnShift: 2 to 11 pm ISTnnnLocation: RemotenJob SummarynWe are seeking a highly experienced Senior Database Administrator (DBA) to manage, monitor,noptimize, 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.nnnThe ideal candidate will bring deep expertise in query performance tuning, database version upgrades,nnnand 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.nnnKey ResponsibilitiesnPostgreSQL Administration (On-Premise u0026 Cloud)nnMonitor, analyze, and tune heavy and long-running SQL queries across PostgreSQLnnenvironmentsnnIdentify and resolve performance bottlenecks using PostgreSQL statistics, logs, and system metricsnOptimize database performance through:nIndex design and optimizationnQuery analysis and rewritingnPostgreSQL configuration tuning (memory, vacuum, autovacuum, checkpoints)nDetect and propose data archival mechanism for unused datanEnsure database availability, reliability, and data integritynManage backup, restore, and disaster recovery strategiesnnDatabase Version Upgrades u0026 Compatibility TestingnnLead and execute PostgreSQL database version upgrades in on-premises and AWS RDS environmentsnnPerform pre-upgrade assessments to identify:nnDeprecated features and breaking changesnnExtension,



stored procedure, and function compatibility issuesnnQuery behavior and performance changes between versionsnnDesign and execute comprehensive upgrade testing plans to ensure:nnStored procedures, functions, triggers, and views remain compatiblennExisting SQL queries execute correctly and efficientlynnApplications function as expected on the upgraded database versionnnValidate data integrity, performance, and stability post-upgradennnAWS RDS PostgreSQL u0026 Cloud OperationsnnDesign, provision, and manage AWS RDS PostgreSQL instancesnSpin up and configure RDS environments following best practices for:nSecurity and access controlnPerformance tuning and scalabilitynHigh availability, backups, and snapshotsnMonitor RDS performance using AWS and PostgreSQL monitoring toolsnPartner with DevOps and infrastructure teams on cloud database architecturennDatabase Migration u0026 ModernizationnnLead and support database migrations between on-premises PostgreSQL and AWS RDSnPlan and execute migrations with minimal downtime and risknPerform data validation and performance testing after migrationnProvide strategic recommendations for PostgreSQL modernization,



architecture improvements,nnand version adoptionnDevOps u0026 AutomationnnApply DevOps principles to database operationsnAutomate database provisioning, configuration, monitoring, and maintenancenSupport CI/CD pipelines involving database schema and data changesnUse scripting and infrastructure-as-code approaches to improve operational efficiencynnRequired QualificationsnnMinimum 7 years of experience as a Database Administrator, with strong focus on PostgreSQLnDeep hands-on knowledge of PostgreSQL internals, performance tuning, and query optimizationnProven experience planning and executing PostgreSQL version upgrades, including:nCompatibility testing of stored procedures, functions, and SQL queriesnManaging risks, rollback plans, and production cutoversnStrong experience managing AWS RDS PostgreSQL environmentsnSolid understanding of Linux/Unix operating systemsnExperience working with DevOps tools, automation, and up-to-date infrastructure practicesnExcellent troubleshooting, analytical, and problem-solving skillsnExperience supporting large-scale or high-traffic PostgreSQL environmentsnStrong communication and technical documentation skillsnAbility to work independently and take ownership of complex database platformsnComfortable collaborating with application, DevOps, and infrastructure teamsnProactive, improvement-driven mindset focused on performance, stability, and scalabilitynFamiliarity with PostgreSQL monitoring and diagnostic toolsnKnowledge of high-availability, r .

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