10 years

Bengaluru

Posted:18 hours ago

Job Description

About the Company

Greetings from Teamware Solutions a division of Quantum Leap Consulting Pvt. Ltd


Teamware Solutions


About the Role


  • Locations: Chennai, Bangalore, Hyderabad, Pune, Mumbai, Noida, Trivandrum
  • Work Model: Hybrid
  • Experience: 10+ Years
  • Notice Period: Immediate - 15 days


Mandatory skills:

Good to have:


Postgress (Senior or Manager)



PostgreSQL Architect – Key Responsibilities

  • Define enterprise PostgreSQL architecture, database topology, and design standards.
  • Design HA/DR, replication, failover, backup, and recovery strategies.
  • Establish database security, RBAC, RLS, authentication, and encryption standards.
  • Drive query optimization, indexing, partitioning, and performance tuning.
  • Guide logical/physical data modeling and database scalability.
  • Lead database automation, Infrastructure as Code (IaC), migrations, and CI/CD.
  • Define monitoring, observability, and production support standards.
  • Lead architecture reviews, governance, technical decisions, and mentor PostgreSQL teams.


Required Skills & Experience

  • Strong hands-on expertise with

    PostgreSQL architecture and internals

    .
  • Experience designing enterprise-scale, highly available PostgreSQL environments.
  • Deep understanding of:
  • PostgreSQL roles and privileges
  • Row-Level Security
  • Indexing and query optimization
  • Execution plans
  • Partitioning
  • Replication
  • Backup and recovery
  • Connection management
  • Vacuum/autovacuum and database maintenance
  • Performance tuning
  • Strong SQL and relational database design experience.
  • Experience designing

    HA/DR and multi-environment production architectures

    .
  • Knowledge of cloud-hosted PostgreSQL platforms, preferably

    Azure Database for PostgreSQL, AWS RDS/Aurora PostgreSQL, or equivalent managed PostgreSQL services

    .
  • Experience with

    CI/CD, Infrastructure-as-Code, database migrations, and automated deployments

    .
  • Experience with enterprise identity, security, encryption, secrets management, and audit requirements.
  • Understanding of

    microservices, APIs, event-driven architecture, and CQRS/read-model patterns

    .
  • Ability to translate business and non-functional requirements into practical database architecture.
  • Strong communication skills with the ability to work across architecture, engineering, security, infrastructure, and application teams.

Preferred Qualifications

  • 10+ years of database engineering/architecture experience with significant PostgreSQL experience.
  • Experience supporting PostgreSQL in large-scale enterprise production environments.
  • Experience architecting databases for high-volume API and read-intensive workloads.
  • Experience with Kafka/event streaming and event-driven data synchronization.
  • Experience implementing enterprise

    RBAC/RLS authorization models

    .
  • Experience with PostgreSQL monitoring and observability platforms.
  • Experience leading architecture reviews and establishing organization-wide database engineering standards.

What Success Looks Like

The PostgreSQL Architect will ensure that PostgreSQL solutions are:

  • Scalable

    for enterprise workloads and data growth.
  • Highly available and recoverable

    with tested HA/DR capabilities.
  • Secure by design

    , with standardized RBAC/RLS and least-privilege access.
  • Performant

    , with measurable engineering and operational standards.
  • Automated and repeatable

    across environments.
  • Observable and supportable

    in production.
  • Consistent

    , through reusable enterprise PostgreSQL patterns rather than application-by-application implementations.



Please let me know if you are interested in this position and send me your resume to netra.s@twsol.com

Skills Required

Consulting IT Staffing SQL Postgresql Backup and Recovery Database Security Query Optimization Performance Tuning Data Modeling Automation Ci/cd Production Support

Learn the skills this job asks for

Free courses, interview questions and practice for each skill.

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific 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.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Teamware Solutions logo
Teamware Solutions

IT Services and IT Consulting

Chennai Tamilnadu

RecommendedJobs for You