Senior Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL

HCLTech

Lucknow, Uttar Pradesh
Job Summary

PostGres L2 : 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 L2 escalation point for complex PostgreSQL and RDS database incidents and performance issues. Design, review, and optimize PostgreSQL architectures including HA, replication, clustering (Patroni, PgBouncer, 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.). Qualification – 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., ServiceNow) 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

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., ServiceNow) 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

#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.