Job Summary
Responsible for managing enterprise database operations, ensuring SLA compliance, resolving complex technical issues, and maintaining high availability and performance of Oracle database environments.
Key Responsibilities
Manage Oracle databases in the cloud and on-prem, patching, documentation
Skill Requirements
Oracle 19c, Oracle RDS, OEM, ASM, RAC, Data Guard, AWS
Other Requirements
Job Description : Responsibilities: -\\\\r\\\\n\\\\r\\\\n• Adhering to SLAs.\\\\r\\\\n• Mentoring / Training Team Members.\\\\r\\\\n• Handling tickets / requests.\\\\r\\\\n• Perform root cause analysis.\\\\r\\\\n• Troubleshooting technical issues.\\\\r\\\\n• Defining processes [SOP/MOP\\\\\\\'s] and ensuring that the processes are adhered to.\\\\r\\\\n• Oversees and is responsible for successful completion of database tasks.\\\\r\\\\n• Responsible for maintaining customer database standards.\\\\r\\\\n• Responsible for strategizing a backup plan and test plan for failure scenario.\\\\r\\\\n• Improves and maintains customer satisfaction.\\\\r\\\\n• Suggests Database environment Gaps, Improvements, and new technologies.\\\\r\\\\n• Monitoring and maintaining SLA requirements by the team members.\\\\r\\\\n• Identify Skill gaps and plan for training / knowledge updating.\\\\r\\\\n• To independently resolve tickets and ensure that the agreed SLA of ticket volume and time are met for the team.\\\\r\\\\n• To provide support for on call escalations orL3 level support and doing incident, change, and problem management.\\\\r\\\\n• To adhere to quality standards, regulatory requirements, and company policies to ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions or Reopen Cases To participate or contribute on EN business in creation of proposals to drive Service improvement plans.\\\\r\\\\n\\\\r\\\\n\\\\r\\\\nTechnical Requirements:-\\\\r\\\\n\\\\r\\\\n• Position: Database L3 Support: A minimum of 12 years’ experience in an IT operations / large-scale services environment A minimum of 8 years’ Production DBA experience in an enterprise level environment.\\\\r\\\\n• Expertise in Oracle database installation and administration.\\\\r\\\\n• Experience in AWS and EC2 instance types.\\\\r\\\\n• Hands-on experience in Oracle RAC, dataguard and patching.\\\\r\\\\n• Ability to validate quarterly patches and work with Oracle vendor on bug fixes and one-off patches.\\\\r\\\\n• Experience in installing, administering, and working of Oracle 12c through 19c databases.\\\\r\\\\n• Experience in configuring and managing Oracle RAC, Grid infrastructure, Oracle ASM, OEM\\\\r\\\\n• Hands-on experience in data refresh and migration using datapump. \\\\r\\\\n• Hands on experience in database upgrade procedures.\\\\r\\\\n• Experience with RMAN database backup and recovery\\\\r\\\\n• Knowledge on User management, profiles and auditing.\\\\r\\\\n• Create/manage Oracle SR and support team in issue resolution. \\\\r\\\\n• Hands on experience in Performance Tuning, AWR, ASH, ADDM, Explain Plan etc\\\\r\\\\n• Experience in OEM monitoring.\\\\r\\\\n• Ability to iteract and understand customer requirements for performance tuning.\\\\r\\\\n• Troubleshoot database issues, maintain database systems availability and scalability. \\\\r\\\\n• Create and maintain Oracle databases required for development, testing, Integration, QA and production usage.\\\\r\\\\n• Performs the capacity planning required to create and maintain the databases. \\\\r\\\\n• The DBA should work closely with Server, Backup and storage administrator to meet Backup, Hardware, Storage and Operating system requirements.\\\\r\\\\n• The DBA should work closely customer to understand the requirements and standards. \\\\r\\\\n• Perform ongoing analysis and tuning of the Oracle database. \\\\r\\\\n• Experience in MySQL and PostgreSQL would be advantage ~\\\\r\\\\n\\\\r\\\\n