Senior Database Administrator (Jamnagar)

Remote: Remote Job Title
- Sr Database Administrator (PostgreSQL + AWS RDS)Experience Required
- 7+ YearsTimezone: 12 PM to 9 PM ISTWork Mode
- RemoteJob SummaryWe’re looking for a Senior DBA with deep hands-on experience in PostgreSQL, especially around version upgrades and AWS RDS environments.This role is critical for ensuring database performance, stability, and scalability across on-prem and cloud systems. You’ll lead PostgreSQL upgrades, optimize performance, and manage cloud-native database operations with minimal downtime and zero surprises.Key ResponsibilitiesPostgreSQL Administration- Manage, monitor, and optimize PostgreSQL databases (on-prem and AWS RDS)- Analyze and tune complex and long-running queries- Optimize performance via indexing, query rewriting, and configuration tuning- Handle vacuum, autovacuum, memory, and checkpoint tuning- Ensure high availability, reliability, and data integrity- Manage backup, restore, and disaster recovery strategiesPostgreSQL Version Upgrades (Core Focus)- Lead end-to-end PostgreSQL version upgrades across environments- Perform pre-upgrade assessments for compatibility risks and breaking changes- Validate extensions, stored procedures, functions, and queries- Design and execute upgrade testing plans- Ensure application compatibility and performance post-upgrade- Plan rollback strategies and production cutoversAWS RDS PostgreSQL- Design, provision, and manage AWS RDS PostgreSQL instances- Configure security, access control, backups, and snapshots- Monitor and optimize RDS performance- Implement high availability and failover strategies- Work closely with DevOps on cloud architecture and deploymentsMigration & Modernization- Lead migrations between on-prem PostgreSQL and AWS RDS- Ensure minimal downtime and smooth cutovers- Perform post-migration validation and performance checks- Recommend modernization strategies and improvementsAutomation & DevOps- Automate database operations (provisioning, monitoring, maintenance)- Support CI/CD pipelines for database changes- Use scripting (Python/Bash) and IaC approaches- Collaborate with DevOps and engineering teamsRequired Skills & Experience- 7+ years of DBA experience with a strong PostgreSQL focus- Proven hands-on experience with PostgreSQL version upgrades (must-have)- Strong experience with AWS RDS PostgreSQL- Deep expertise in query optimisation and performance tuning- Solid understanding of PostgreSQL internals- Experience with large-scale or high-traffic systems- Strong Linux/Unix knowledge- Experience with backup, recovery, replication, and failover- Familiarity with monitoring tools and performance diagnostics- Scripting skills (Python, Bash, or similar)- Strong communication and stakeholder management skillsGood to Have- Experience with AWS services like EC2, S3, IAM, VPC- Exposure to DevOps tools and CI/CD pipelines- Experience with database automation and infrastructure-as-codeWhat Success Looks Like- Zero-downtime PostgreSQL upgrades- Faster query performance and reduced latency- Secure, scalable RDS environments- Smooth migrations with no data loss- Proactive performance improvements, not reactive firefighting Apply on Kit Job: kitjob.in/job/4m2l33