Senior Oracle Database Administrator

Delta Dental•Rancho Cordova, CA

3d•$92,000 - $196,500

About The Position

This position does not offer work visa sponsorship The Senior Database Administrator will be responsible for administering production and non‐production databases within the Enterprise. The role also has responsibility for all aspects of database administration for Oracle and Snowflake databases including problem‐solving, configuration, and implementation efforts for multiple projects with an emphasis in operational excellence and continuous improvement of database related processes and procedures.

Requirements

4+ years of professional experience with a Bachelor’s degree in Computer Engineering or similar.
Experience working with Oracle release 19c.
Experience in Oracle Cloud for E Business SaaS, ATP a plus
Ability to work independently with advanced analytical skills.
Strong knowledge in disaster recovery, capacity planning and troubleshooting complex database problems.
In depth working knowledge of operating systems, storage, database server and network.
Knowledge of data replication technologies and ETL tools like Attunity, GoldenGate, SAP data services.
Highly skilled in SQL, PL/SQL, PowerShell and UNIX Shell script coding.
Ability to establish, document and enforce procedures and policies related to database management.
Ability to analyze and determine data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities.
Strong understanding of data center operations and applications development.
Strong knowledge of Data Center Virtualization technologies (e.g. Cloud, PaaS).
This role will require production support with an on-call rotation every 5-6 weeks.
Strong Linux shell script and SQL knowledge.

Nice To Haves

Experience with Snowflake is preferred but not required.
Oracle certification preferred but not required.

Responsibilities

Reviews production database performance reports on regular basis, and identifies any potential performance bottlenecks including SQL, PL/SQL code execution and works with Storage and UNIX teams to remediate before impact.
Engages in new technology initiatives and performs database server hardware upgrades to get maximum ROI.
Attends triage calls and is strongly driven to identify the root cause which may involve providing analysis data to other teams and proactively lending active hands with trouble shooting while the outage is in progress.
Reviews critical database parameters and recommends adjustments.
Manages cross platform database migrations including documenting various steps involved.
Implements high availability solutions for databases.
Works with development teams for SQL, PL/SQL code tuning, and schema design updates identified in pre-production installs.
Researches and implements POC solutions for new features of latest database technologies.
Maintains security of data by keeping databases secure and communicates security loopholes, if any, to security team.
Participates in on-call support rotation for production databases that require 24/7/365.