Senior Oracle App DBA Administrator

Job Description:

Dear Candidate ,

Greetings from MM Management,

MM Management is into Global Recruitment Service Provider. Your profile is shortlisted for the initial screening of Senior Oracle app DBA Administrator. Please find the description below.

About Company :

The company is a leading technology solutions and services company specializing in comprehensive IP-led services in Cloud, Automation, Product Engineering, and Data & AI. We offer purpose-built 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 location- Bangalore/ Hybrid/Remote

Experience- 7 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 on-premise and cloud-based 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 CDB’s and PDB’s and experience in moving PDB’s across environments.
• Should have knowledge on administrating and working with ADW database.
• Experience in working with wallets and ability to create password-less 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 to fatema@m3consultant.net at your earliest convenience.