Idexcel Technologies

Job Title : AWS Aurora Database Lead Developer & AdministratorLocation : Bengaluru, India (Work from office)Experience : 7+ yearsEmployment Type : Full-timeJob 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. (ref:hirist.tech)