Track Manager - Oracle Administration,PostgreSQL,MYSQL, MS SQL

Job Summary

Post Gres Sql & RDS Cloud SME : The PostgreSQL Database Administrator is responsible for installation, configuration, and operational support of enterprise PostgreSQL database platforms across on‑premises and cloud environments including AWS RDS. The role ensures availability, performance, reliability, and compliance of database services in line with agreed SLAs, security standards, and operational procedures.

Key Responsibilities

Act as L3 escalation point for complex PostgreSQL and RDS database incidents and performance issues. Design, review, and optimize PostgreSQL architectures including HA, replication, clustering (Patroni, Pg Bouncer, etc.). Administer and manage AWS RDS for PostgreSQL including provisioning, scaling, backup, and automation. Lead database performance tuning, query optimization, and index management activities. Plan and execute PostgreSQL upgrades, migrations (on-prem to cloud/RDS), and patching. Ensure high availability, disaster recovery (replication, failover strategies), and backup validation. Define and enforce database standards, best practices, and continuous improvement initiatives. Monitor database performance using tools (CloudWatch, pg_stat views, etc.) and provide health reports. Manage database security, access controls, encryption, and compliance requirements. Perform capacity planning, storage scaling, and lifecycle management for database environments. Mentor L2 DBAs and collaborate with application, infrastructure, and cloud teams. Automate operational tasks using scripting (Shell, Python, Ansible, etc.).

Skill Requirements

PostgreSQL Certified (preferred) Hands-on experience with PostgreSQL and AWS RDS Strong understanding of database performance tuning and query optimization Fluent in English Willingness to work in shifts Knowledge of ITSM tools (e.g., Service Now) Linux/Unix system administration awareness Strong scripting skills (Shell/Python) Problem solving and analytical skills Experience in change implementation and infrastructure setup B-Tech or equivalent Bachelor’s degree in Computer Science or related field

Other Requirements

NA