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 Self Healing 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 Deploy Implement Solutions Perform Capacity Planning and DR Planning
- Expertise in Troubleshooting Performance Issues and providing solutions
- Expertise in RMAN Backup Restore Recovery
- Expertise in Role swap Failover planning and implementation
- Robust technical knowledge of database space management
- Implementing releases service requests
- Expertise in Golden Gate
- 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 Dev Ops tools

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