Lead Database Developer

Dear     Candidate  ,

Greetings for the Day !!

W are   Hiring   for a   Lead Database Developer   role for   Hyderabad   Location, Please find below attached job Description for you reference,

Job Description :

Designation: AWS Aurora Database Lead Developer & Administrator

Experience:

6+ Years
Notice Period: immediate to 15 Days
Work Mode:
Work From Office( 5 Days in a week)
Interview Mode: 1st Level is online & 2nd Level is F2F.

Work Location:

Ameerpet, Hyderabad

Required Skills :

Database Development ( 6+ Years )
AWS ( At least 3+ Years )
Database Migration
Database Integration
Python Scripting ( Basic )
Data Recovery

Job Description :

7–10 years of experience as a Postgre

SQL DBA, including 2+ years on Amazon Aurora PostgreSQL

· Lead and mentor a team of 7–8 Database developers.

· Proven experience leading teams in an Agile/Scrum environment.

· Excellent communication and stakeholder management skills.

· Demonstrated expertise in administering, configuring, and maintaining Postgre

SQL databases across multiple environments, with at least 2+ years of hands-on experience managing Aurora Postgre

SQL clusters on AWS. Proven track record of ensuring high availability, scalability, and security in production-grade database systems. Expertise in schema design, normalization, and indexing strategies.

· Strong understanding of Postgre

SQL internals, replication, WAL management, and query execution plans. Deep knowledge of how Postgre

SQL handles processes, memory, and storage structures (shared buffers, WAL, vacuum, checkpoints, etc.). Skilled in setting up and managing physical and logical replication, monitoring replication lag, and troubleshooting failover issues. Ability to analyze query execution plans for performance optimization and root-cause analysis.

Skills to be Proficient in :

· Proficiency in performance tuning, indexing strategies, and analyzing slow queries.
Hands-on experience with diagnosing and resolving database performance issues using tools like _activity, _statements, and AWS Performance Insights.
Adept at designing and implementing indexing strategies, optimizing SQL queries, and tuning Postgre

SQL configuration parameters (, , _mem, etc.) for optimal throughput and latency.

· Experience managing large-scale, mission-critical databases in AWS environments. Proven ability to manage and monitor large, complex database ecosystems supporting high transaction volumes and low-latency workloads.

Experience with capacity planning, scaling Aurora clusters, handling read replicas, and ensuring database availability across multiple Availability Zones. Strong focus on reliability, disaster recovery, and data protection.

· Expertise in Linux administration and shell scripting for automation. Solid command over Linux-based systems for database hosting, performance monitoring, and troubleshooting. Skilled in writing shell scripts for routine database tasks, log analysis, backups, and automating maintenance activities like reindexing, vacuuming, or integrity checks.

· Hands-on experience with AWS RDS/Aurora features (parameter groups, snapshots, performance insights, failover). Proficient in configuring and managing Aurora-specific components such as parameter groups, option groups, and cluster configurations. Experienced with automated backups, snapshots, and point-in-time recovery (PITR). Well-versed in using AWS Performance Insights, Cloud Watch metrics, and alarms for proactive performance monitoring and incident response.

· Familiarity with data migration tools (DMS, /) - Experience planning and executing data migrations, upgrades, and environment refreshes using AWS Database Migration Service (DMS), , and . Skilled in validating data integrity, minimizing downtime during migration, and troubleshooting compatibility issues between different Postgre

SQL versions or environments.

· Monitor and optimize database performance using Datadog, Cloud Watch, and other tools.

· Familiarity with Heimdall Proxy, data migration tools, and embedding models.

· Proficient with pgvector setup, development, and optimization.

· Exposure to ISO/IEC 27001 or other compliance frameworks.

· Having an AWS Certified Database – Specialty or AWS Certified Solutions Architect certification will be an added advantage.