Postgresql Database Administrator

Job Description

Job Title: The Title Exception: PostgreSQL database Administrator

Position Details

Location: Navi Mumbai

Mode of Work: Hybrid

Domain: Open to Any Domain

Contract Length: 12 Months

Number of Positions: 1

Shift Timings: General Shift (9 hours); occasional overlap required for US calls

Experience & Availability

Overall Experience Required:8-10 Years

Notice Period: Immediate / Serving Notice

Interview Details

Interview Mode: Virtual

Interview Rounds: 3 Rounds

Mandatory Skills / Requirements

Aurora PostgreSQL DBA

ETL Pipelines

Data ware housing

Troubleshooting

AWS Cloud

Job Description

Role Overview

As a Senior Data Engineer, you will be responsible for designing, building, and operating data platforms that rely on Amazon

Aurora PostgreSQL as a core data store. Being a part of Data Engineering Team, you will work closely with other infrastructure and

security teams to ensure data systems are scalable, performant, secure, and compliant.

This role requires strong handson Aurora PostgreSQL expertise along with endtoend ownership of databasecentric data

engineering solutions, supporting analytics and emerging AIdriven use cases.

Key Responsibilities

Aurora PostgreSQL Administration

Own the design, implementation, and operation of Amazon Aurora PostgreSQL databases supporting data engineering

workloads.

Define, review, and evolve database schemas, data models, and access patterns optimized for downstream consumption.
Be accountable for database lifecycle activities including provisioning, upgrades, patching, backups, and high availability.
Ensure consistent standards and configurations across Dev, NonProd, and Prod environments.

Performance, Reliability & Scalability

Take responsibility for database performance tuning, including query optimization, indexing strategies, and connection

management.

Monitor database health, capacity, and growth trends, and proactively drive scaling and optimization activities.
Design, validate, and maintain highavailability and disasterrecovery strategies using native Aurora capabilities.

Security, Governance & Compliance

Own implementation of secure, leastprivilege access models and rolebased controls for database access.
Enable and maintain audit logging and integrations with centralized SOC platforms.
Ensure databases comply with organizational security standards and regulatory requirements (e.g., GDPR).
Act as a key technical contributor during SOC reviews, audits, and security investigations.

Data Engineering Enablement

Work to support and optimize ETL/ELT pipelines, batch and nearrealtime ingestion workloads.
Provide guidance on data access patterns, schema evolution, and performance best practices.
Support integrations with platforms such as Databricks, S3based data pipelines, and analytics tools. Automation & Operational Excellence
Drive automation of routine operational and database tasks using scripts, AWSnative services, InfrastructureasCode, and AIassisted tools to streamline repetitive activities such as performance analysis, log review, and incident investigation.

• Own troubleshooting and resolution of complex data platform issues, including participation in oncall rotations and production support.

• Create, maintain, and continuously improve runbooks, SOPs, and operational documentation for data platforms. MustHave Skills

• 6+ years of strong experience as a Senior Data Engineer with deep handson expertise in Amazon Aurora PostgreSQL.

Advanced PostgreSQL knowledge (query optimization, indexing, vacuuming, replication concepts).
Experience owning and supporting dataintensive platforms in production environments.
Solid understanding of AWS services related to data platforms (Aurora/RDS, IAM, CloudWatch, S3).
Proven ability to independently troubleshoot and resolve complex production issues. GoodtoHave Skills
Experience with Amazon Aurora MySQL and MongoDB Atlas.
Familiarity with Databricks or similar analytics/lakehouse platforms.
Understanding of modern data engineering patterns (ETL/ELT, batch vs streaming).
Working knowledge of AI/ML concepts.
Experience in regulated industries such as fintech, payments, or financial services. Preferred Qualifications
Experience with InfrastructureasCode tools (Terraform, CloudFormation).

Exposure to CI/CD practices for data platforms.