Principal Oracle DBA - Exadata/ Goldengate
Principal Oracle DBA - Exadata/ Goldengate
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 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.
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 hadprior 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.
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.
Career Level - IC4
Responsibilities
- 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 ASHTKPROF 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
- Candidate must need to to work in US hours ( 10 PM IST to 6 AM IST)
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.
Required Experience:
Staff IC
Employment Type
Full-Time
