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
More Info
Key Skills
Oracle GoldenGate (OGG)
Oracle 19c
Oracle Enterprise Manager (OEM)
PostgreSQL Administration
PostgreSQL Architecture
SQL Performance Optimization
Root Cause Analysis (RCA)
24x7 Database Support
High Availability (HA)
Disaster Recovery (DR)
RMAN Backup & Recovery
Backup Restore Recovery
Failover Planning
Role Switchover
WAL Archiving
Database Upgrades
Role Based Access Control (RBAC)
Authentication Management
Locking & Concurrency Control
Autovacuum
Schema Management
Table Management
UNIX/Linux Administration
Tanium
MIR
PIR
Self-Healing Automation
Database Growth Management
Oracle Cloud Infrastructure (OCI)
About Company
LTM is a global technology consulting and digital solutions LTM company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 750 clients, LTM brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by more than 90,000 talented and entrepreneurial professionals across 30 countries, LTM — a Larsen & Toubro Group company — combines the industry-acclaimed strengths of erstwhile L&T Infotech and Mindtree in solving the most complex business challenges and delivering transformation at scale. For more, please visit https://ltm.com.