Principal Oracle DBA - Exadata/ Goldengate

Preferred Qualifications

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.

.

prior experience administering large scale oracle databases preferably Exadata and GoldenGate deployments

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

• 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 Masters 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

Detailed Description and Job Requirements

Work with a world class team to provide enterprise-wide, Middleware and Oracle Database Administration support for production systems and provide DBA services to application development teams, including database design, database production support. Provide Middleware / DBA support with a high degree of customer service, technical expertise, and timeliness. Provide accurate and creative solutions to user problems of moderate nature to ensure user productivity.

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.Leading contributor individually and as a team member, providing direction and mentoring to others.

Work is non-routine and very complex, involving the application of advanced technical/business skills in area of specialization. 8 years of experience supporting relational databases as a DBA, with multiple distributed relational DBSM*s or a depth and focus in Oracle and related tools. Success at using the DBMS to optimize performance of large databases for enterprise use is greatly preferred. Experience with an organization with a key 24 X 7 reliance on its database is desirable.

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