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
- 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
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.