Location
Salt Lake City, UT | United States
Job description
Exadata Oracle DBA
Zion Bank
7 months (April 15 Nov 30th ). Straight contract but there is potential to convert to full time at the end of the contract.
Position can sit fully remote. Office is located in Salt Lake City, Utah.
Project Name: Exadata Sphere Team
Company Overview : Zions Bank originated in Utah. Since then, Zions has acquired multiple banks and has a presence in multiple states. The company is a well-established household name in Salt Lake. There is an opportunity for growth within the organization. Their tenure speaks volumes to the organization, opportunity, ect.
Top requirements?
1. 8+ years of DBA experience
2. Exadata
3. Machine Administration - configure and administer racks, ASM, and grid infrastructure patching
4. Oracle - Installs, upgrades and patches Oracle Exadata databases and Oracle Applications.
5. Data Guard - configuration and administration for high resiliency
Project Scope : This person will be helping Zion migrate Oracle databases off/onto of current Exadata x7 machines that are end of life to new Exadata x10 machines.
Team Size & Environment Breakdown:
- 15 DBA's that cover various platforms, DB2 postgres, SQL Server. The specific oracle team's are divided into two: Exadata and Non-Exadata. The non-exadata team is working on stuff that is hosted on linux. The other half of the team is supporting Exadata sphere. This person would sit on the Exadata sphere team
- They will be mainly working with the specific Exadata Sphere DBA team. Will have some involvement working with application owners to schedule and coordinate efforts.
- In terms of Cloud, what does the production environment look like? Not really working in a cloud environment. On-prem normal DBA work. Cloud support is through service tickets and bare metal patching.
High-Level Individual Duties:
- Will be working with the Exadata platform heavily.
- A lot of Machine Administration:
- configure rack will be working in a multi-tenant rack with 2 nodes in current environment.
- ASM
- Grid Infrastructure patching
- Preform Data Guard configuration and administration for high resiliency
- Will be helping patch infrastructure
- DOMU patching related to Exadata customers
Challenges in hiring: Have not been able to find anyone locally in Utah yet. Have recently opened it up nationwide for remote candidates.
++++++++++++++++++++++++++++++++++++++++++++++++
Formal Job Description
Responsibilities
- Support of migration efforts utilizing Oracle Cloud@Customer with Exadata, releases of Oracle, installing, upgrading and patching Oracle databases.
- Writes scripts or JCL and tuning complex SQL code.
- Analyzes and resolve data issues and troubleshoots problems.
- Responsible for tuning existing and new databases.
- Maintains databases, ongoing systems technical support, and ensure the integrity of the environment.
- Participate in projects as required.
- Design and plan Exadata deployments and configurations.
- Migrate databases onto and off of Exadata x7 and x9.
- Perform platform health checks.
- Perform periodic patches/updates for both DOMU and system patches.
- Tune the performance of Oracle Databases on Exadata.
- Oracle Exadata Patching (GI, DB, DOMU).
- ADG Active Data Guard Configuration in multiple Data Centers.
Job tags
Salary
