PostgreSQL-DB Administration

LTM; Chennai District; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

LTM is seeking a skilled Database Engineer to provide 24x7 production support for Oracle and PostgreSQL databases. The role requires deep expertise in Oracle RAC, RMAN, GoldenGate, and high-availability configurations to ensure service reliability.

You will lead troubleshooting, conduct root-cause analyses, and mentor the team while driving automation and DR planning initiatives to minimize manual work. Strong UNIX and Oracle Cloud knowledge are a plus.

Qualifications

• Strong expertise in Oracle RAC, RMAN, and GoldenGate
• Proficient in PostgreSQL architecture, WAL, archiving and maintenance
• Experience in 24x7 production support and incident handling
• Hands-on knowledge of high availability replication setups
• Knowledge of Oracle Cloud and UNIX-based OS environments

Responsibilities

• Lead production support for Oracle and PostgreSQL databases
• Perform root cause analysis and provide permanent fixes
• Mentor team members and participate in crisis calls and post-incident reviews
• Drive automation to reduce manual effort and standardize processes
• Contribute to capacity planning, DR planning and release implementations

Skills

Oracle RAC

PostgreSQL

Performance tuning

RMAN

GoldenGate

Oracle Cloud

High Availability

Disaster Recovery

Automation

Unix

DevOps

Tools

Oracle OEM

Ansible

Puppet

Tanium

Job description

Shift: 24/7 Rotational

Job Description:

Principal responsibilities

The job holder is responsible for technical delivery of 24x7 production support to Oracle and Postgrespreferred databases and work as a Subject Matter Expert for the production support team

Expertise in Oracle RAC and Database

Perform troubleshooting Root Cause Analysis and provide permanent fixes

EXPERT knowledge in Investigate and provide solutions to database performance related issues in Oracle Database

Lead Database team in crisis calls participate in MIR and PIR calls also mentor team members

Experience and expertise in maintaining complex High Availability Replication setups

Provide consultancy for complex setups and Disaster Recovery

Identify automation and SelfHealing opportunities and develop automation to reduce manual efforts and standardize processes

Knowledge on PostgreSQL architecture background processes and storage structure

Knowledge of database objects such as schemas tables indexes constraints and partitioning

Awareness of replication concepts and high availability architecture

Hands on experience of WAL mechanism archiving and basic backup recovery concepts

Knowledge of transaction management locking and concurrency control

In Postgres Basic performance monitoring concepts including query behaviour and database growth management

Experience on autovacuum process and database maintenance activities

Knowledge of rolebased access control authentication methods and security best practices

Familiarity with production support processes and incident handling in PostgreSQL environments

Required Skill

Strong technical knowledge of Oracle concepts like RAC Dataguard OGG

Expertise in 12c19c versions OEM

Build and DeployImplement Solutions Perform Capacity Planning and DR Planning

Expertise in Troubleshooting Performance Issues and providing solutions

Expertise in RMAN BackupRestoreRecovery

Expertise in Role swap Failover planning and implementation

Strong technical knowledge of database space management

Implementing releases service requests

Expertise in GoldenGate

Expertise in Database upgrades and migrations

Additional Skill

Knowledge on Oracle Cloud

Knowledge on UNIX based OS

Knowledge of MongoDB Db2 LUW technology

knowledge of automation tool like Ansible Puppet Tanium

Knowledge about Agile practices and DevOps tools