Senior Oracle App DBA Administrator

Job Description:

Dear Candidate

Greetings from MM Management

MM Management is into Global Recruitment Service Provider. Your profile isshortlisted for the initial screeningofSenior Oracle app DBA Administrator. Please find the description below.

About Company :

The company is a leading technology solutions and services company specializing in comprehensive IPled services in Cloud Automation Product Engineering and Data & AI. We offer purposebuilt solutions and prebuilt platforms to meet diverse client needs. Our expertise lies in integrating innovative technology with strategic methodologies and adopting a DevOps approach focused on continuous improvement. This combination enables us to effectively address pain points for our clients enhancing their capabilities to optimize customer experiences modernize processes and improve overall performance.

Job Title: Senior Oracle app DBA Administrator

Job locationBangalore/ Hybrid/Remote

Experience7 to 12 years

Budget : 28 LPA

Work Timings 4:00 p.m to 12:00 a.m (midnight)

Job Description:

This role ensures databases are run effectively and securely. It requires a high focus on analysing and resolving the issues within the assigned SLA. It also needs a good sense of ownership of the problems and maintaining communication with concerned team to keep them updated on the status and work with various teams to get to the resolution. Must adhere to the guidelines while implementing changes to production. Production DBA Team.

Position Responsibilities

• Database Administration experience with onpremise and cloudbased environments
• Experience working on MySQL/Postgres/AWS RDS MySQL/Aurora /Postgres/ Amazon Redshift environment.
• Experience working on OCI DBCS ADW environment.
• Working experience of Hadoop
• Having knowledge of working with CLI command line tools like OCI CLI & Strong experience with Python
• Proactive monitoring of databases both from a performance and capacity management perspective.
• Experience with backups restores and recovery models. Proactive housekeeping/ archiving
• Experience in Performance Tuning and Optimization using native monitoring and troubleshooting tools.
• Should have enough knowledge on OCI services like DBCS Autonomous services cloud storage notifications and alarms.
• Experience in monitoring Oracle databases via SQL developer OMC tool OCI metrics & performance hub.
• Experience in implementing Oracle alerts via OCI alarm & metrics.
• Experience in monitoring ASM usage and archive log usage via scripting.
• Should have enough knowledge in troubleshooting Oracle tablespace issue index issue & database mount issues.
• Familiar with Oracle CDBs and PDBs and experience in moving PDBs across environments.
• Should have knowledge on administrating and working with ADW database.
• Experience in working with wallets and ability to create passwordless wallets.
• Familiarity with Database Monitoring and alerting tools SolarWinds DPA CloudWatch Opsgenie
• Experience in troubleshooting and resolving database problems using various troubleshooting tools.
• Ability to detect and troubleshoot and resolve database related CPU memory I/ O disk space and other resource contention issues.
• Experience in implementing operational automation using Shell/Perl/Python scripts
• Perform database maintenance activities such as backup/recovery replication rebuilding and reorganizing indexes.
• Experience in troubleshooting and resolving database integrity issues performance issues blocking/deadlocking issues connectivity issues data replication issues etc.
• Experience in raising support ticket with various vendors like AWS Oracle Solarwinds and work with them and get issue to the closure.
• Good interpersonal communication and documentation skills.

Please send your updated CV toat your earliest convenience.