Principal Oracle Dba

**Preferred Qualifications**

**Good to have Qualifications**

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

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

Career Level - IC4
- 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

**Detailed Description and Job Requirements**

As a SME, you will be instrumental in researching, evaluating, designing, testing, recommending, and planning implementation of new versions of Oracle Middleware and databases. May act as a team lead during database implementations and for system operation and maintenance.

Experience in automating the operations activities with required technical skills around devops is a must.