Senior Oracle Database Administrator

*This role does not offer visa sponsorship. Candidates must be authorized to work in the U.S. without current or future sponsorship (including CPT, OPT, TN or H‑1B). 

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.

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

   

• 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.
• Experience with Snowflake is preferred but not required.
• Oracle certification preferred but not required.
• Strong Linux shell script and SQL knowledge.

Base Pay Information

The national base pay range at the end is a good-faith estimate of what Delta Dental may pay for new hires. Actual pay may vary based on Delta Dental’s assessment of the candidate’s knowledge, skills, abilities (KSAs), related experience, education, certifications and ability to meet required minimum job qualifications. Other factors impacting pay include prevailing wages in the work location and internal equity. Pay Grade 22. $92,000 - $196,500