Job Description
- The job holder is responsible for technical delivery of 24x7 production support to Oracle and Postgres preferred 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
- Solid 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

📌 PostgreSQL-DB Administration (Chennai)
🏢 LTM
📍 Chennai