Technical Lead / Database Architect

10 - 16 years

17 - 18 Lacs

Posted:Just now| Platform: Naukri logo

Apply

Work Mode

Remote

Job Type

Full Time

Job Description

Hi,

Greetings of the day !!!!

Please find here under the details of the requirment.

  • Job Title

    : Technical Lead / Database Architect

    AWS RDS Aurora (PostgreSQL)

  • Experience

    : 10 to 15 years (flexible based on expertise)
  • Location

    : Remote

Please note- apply only if can join in 15-30 days max.

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.

CV

1. Total Experiences :

2. Current Location

3. Present CTC

4. Expected CTC

5. Notice Period Required

6. Do you have any job offer on Hand

7. Reason for change

amita@hr-central.in

Looking forward to hearing from you.

Best Wishes,

Amita Bhatia

9724502430

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
HR Central logo
HR Central

Staffing and Recruiting

Mumbai

RecommendedJobs for You

mumbai suburban, navi mumbai, mumbai (all areas)