Database Architect/Developer/CloudDB-AWS RDS Aurora (PostgreSQL)Remote

Greetings from HR Central!!!

AWS RDS Aurora (PostgreSQL) for one of the Leading Company for

Requires immediate joiner.

Please find the below requirement

• Job Title

  : Technical Lead / Database Architect

  AWS RDS Aurora (PostgreSQL)

• Experience

  : 10 to 15 years (flexible based on expertise)

• Location

  : Remote (Permanent role, on companies payroll)

Job Summary

• We are seeking a Technical Lead / Database Architect with strong expertise in AWS RDS Aurora (PostgreSQL-compatible) environments. The ideal candidate will

  architect, optimize, and scale distributed data systems on AWS

  - ensuring performance, reliability, and cost efficiency. While

  PostgreSQL

  knowledge remains important, this role focuses primarily on

  Auroras architecture, configuration, and operational

  excellence within large-scale, production-grade systems. You will partner with development, DevOps, and product teams to guide data layer design, lead optimization initiatives, and shape the overall database strategy across cloud workloads.

Key Responsibilities

• Lead the a

  rchitecture and optimization of AWS RDS Aurora clusters

  for high performance, scalability, and fault tolerance.

• Design and implement multi-AZ deployments,

  read replica strategies, and failover mechanisms for mission-critical workloads.
• Work with engineering teams to ensure

  query design, indexing, and schema strategies

  align with Auroras distributed storage model.
• Perform advanced performance tuning, connection management, and workload balancing across Aurora instances.
• Establish database governance, monitoring, and automation frameworks using CloudWatch, Performance Insights, and AWS-native tools.
• Collaborate with architects and developers to ensure application-database interaction patterns are efficient and resilient.
• Guide the migration and modernization of PostgreSQL databases to Aurora.
• Conduct capacity planning, cost optimization, and benchmarking for data services.
• Mentor engineers on Aurora best practices, database performance analysis, and SQL optimization.
• Participate in architectural design reviews, ensuring scalability, reliability, and data security standards are met.

Required Skills & Qualifications

• 10+ years of experience with relational databases, with at least 5 years focused on AWS RDS Aurora (PostgreSQL-compatible).

• Deep understanding of

  Auroras architecture, including storage engine, cluster endpoints, and failover mechanisms.

• Experience in

  Finetuning and Query optimisation

• Strong experience in query and schema optimization, indexing, and partitioning strategies.
• Hands-on expertise in

  RDS parameter tuning,

  connection pooling (pgBouncer / RDS Proxy), and Performance Insights.
• Solid grasp of data modeling, normalization, and designing for scale and high availability.
• Experience implementing automated monitoring, alerting, and backup strategies using AWS CloudWatch, Lambda, and CloudFormation.
• Strong collaboration skills across DevOps, SRE, and engineering teams to embed database best practices.
• Familiarity with migration tools such as AWS DMS or pg_dump/pg_restore for cloud transitions.

Preferred Skills

• Exposure to multi-region architectures, Aurora Global Database, and cross-region replication.
• Working knowledge of PostgreSQL internals and extensions (e.g., PostGIS, pg_partman, pg_stat_statements).
• Scripting knowledge (Python, Bash, or PowerShell) for automation and custom tooling.
• Understanding of microservices architectures and database access patterns in distributed systems.
• Familiarity with other AWS services like Lambda, S3, CloudFormation, CloudWatch Logs, and Secrets Manager.

tina.sapra@hr-central.in

1. Current CTC

2. Expected CTC

3. Notice Period

4. Years of experience as a Database Architect

5. Years of experience in AWS RDS Aurora

6. Years of experience in PostgreSQL

7. Are you designing or maintaining database

8. Scripting knowledge on which of these (Python, Bash or PowerShell)

9. Familiarity with which other AWS services

10. Explain your understanding on Auroras architecture

11. Explain your current job role.

Thanks and Regards,

Tina Sapra

HR Central

https://www.linkedin.com/in/tina-sapra-331954241

https://hr-central.in/