Lead Database Developer & Administrator

Job Title : Lead Database Developer & Administrator

Location : Bengaluru, India (Work from office)

Experience : 7+ years

Employment Type : Full-time

Job Description :

- 7- 10 years of experience as a PostgreSQL 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 PostgreSQL databases across multiple environments, with at least 2+ years of hands-on experience managing Aurora PostgreSQL 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 PostgreSQL internals, replication, WAL management, and query execution plans.

- Deep knowledge of how PostgreSQL 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.

- Proficiency in performance tuning, indexing strategies, and analyzing slow queries.

- Hands-on experience with diagnosing and resolving database performance issues using tools like pg_stat_activity, pg_stat_statements, and AWS Performance Insights.

- Adept at designing and implementing indexing strategies, optimizing SQL queries, and tuning PostgreSQL configuration parameters (work_mem, shared_buffers, maintenance_work_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, CloudWatch metrics, and alarms for proactive performance monitoring and incident response.

- Familiarity with data migration tools (DMS, pg_dump/pg_restore)

- Experience planning and executing data migrations, upgrades, and environment refreshes using AWS Database Migration Service (DMS), pg_dump, and pg_restore.

- Skilled in validating data integrity, minimizing downtime during migration, and troubleshooting compatibility issues between different PostgreSQL versions or environments.

- Monitor and optimize database performance using Datadog, CloudWatch, 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.