Principal DBA

About the Company
We are seeking accomplished database SME, self-driven and have a great combination of design skills, performance tuning/troubleshooting around EXADATA / GoldenGate and have been part of large enterprise class software product teams, have worked on deployment of services on the popular Cloud platforms like OCI, AWS or Azure. The ideal candidate is expected to possess skills needed for automations around scripting, devops and work towards making operations more efficient by automating key and routine operational activities. The candidate is expected to be the Oracle face for GBU product suite over customer calls / escalations and should possess SME technical skills along with strong written / verbal communication & should possess effective convincing and negotiation skills.

About the Role
The successful candidate is a self-motivated, progressive software professional with minimum 10 years of industry experience and can deal with complex problems without supervision. They should have had prior experience administering large scale oracle databases preferably Exadata and GoldenGate deployments. The Engineer is expected to be a key member of the technical problem solving as well as problem avoidance team, routinely sought after to address extremely complex, critical customer issues. We as a team, work towards improving the customer interaction, support and engagement experience, deflect or avoid service tickets.

Responsibilities
Influence the design, capacity planning tuning and the actual build out of Exadata DB instances on Oracle Cloud infrastructure.
Work towards automating key operational activities.
Middleware environment administration (Install, configure, migrations, tuning, patching, administration & monitoring) on any middleware platform such as Oracle.
Ensure the effective daily operation of the production / Middleware applications and provides administrative support for new implementations, upgrades, and migrations.
Ensure the DB system is always up to date and patched to the latest version in an automated fashion.
Develop solutions that ensure DB health check are done in an automated and proactive fashion.
Interact with customers and developers for any priority situations and react/respond timely manner.
Play a key role in the design of HA/DR solutions for the new Identity cloud service.
Get involved in Performance, Scalability and Reliability Analysis and database query tuning.
Troubleshoot HA/DR and Database Performance issues on the existing cloud service.
Work with architects and development managers in requirements specification definition and detailed engineering analysis from data requirements perspective.
Own database/schema design documentation at component and product level.
Participate in rapid delivery in planning, building, configuring, deploying, monitoring and documenting for Oracle Cloud projects.
Architecture and design: create and improve current service deployment infrastructure using automation and the latest cloud capabilities to improve agility, reliability, and observability.
Migration: move/re-implement existing On-Prem services to Oracle Cloud Infrastructure in a manner that is secure and leverages the latest cloud services.
Troubleshooting: have a deep understanding of our services and dependencies in order to respond quickly and efficiently to major incidents and minimize service disruptions when they occur. Root cause issues so that improvements can be made. Customer support, configuration, and address escalated issues in timely manner.
Environment support: Need expertise in cutting-edge products and technologies like Real Application Clusters, GoldenGate, High Availability, Data Guard, Corruption, Backup and Recovery, RMAN, Performance, Memory Management, Parallel query, Query tuning, Storage, ASM, Security, Networking, Enterprise Manager etc.

Qualifications
Minimum of 10 years working experience in Database administration activities such as deploying large EXADATA systems, GoldenGate deployment, tuning, DB provisioning, define efficient and automated processes for LCM, patch/upgrade, RMAN backup/recovery and performance troubleshooting. Minimum of 4 years working experience in RAC / Oracle Exadata, Data Guard, Golden Gate. Bachelors or Master's degree or equivalent experience relevant to the functional area. Strong understanding in database Performance Troubleshooting/Tuning, be skillful in SQL execution plan, AWR, ADDM, ASH,TKPROF, etc reports. Full life-cycle product development experience. Experience in PL/SQL and SQL Programming. Oracle database server 11g/12c/18c concepts and its administration concepts. Experience in Unix/Linux Shell, Perl, Ansible and Python scripting. Experience in REST API. Understanding of the DevOps Toolchain components and how they fit together; experience developing automation and using open source tools, github, Jenkins. Strong technical background in cloud networking, storage, and security.

Preferred Skills
Worked in a solutions architect role for deployment / migration / upgrade of large customers on OCI.

Pay range and compensation package
Pay range or salary or compensation.

Equal Opportunity Statement
Include a statement on commitment to diversity and inclusivity.

---