Senior Oracle Database Administrator

$92,000 - $196,500/Yr

Delta Dental - Rancho Cordova, CA

Full-time - Mid Level

Rancho Cordova, CA

501-1,000 employees

Insurance Carriers and Related Activities

About the position

The Senior Database Administrator will be responsible for administering production and non-production databases within the Enterprise. This role encompasses all aspects of database administration for Oracle and Snowflake databases, focusing on problem-solving, configuration, and implementation efforts for multiple projects. The emphasis is on operational excellence and continuous improvement of database-related processes and procedures. The Senior Database Administrator will regularly review production database performance reports, identifying potential performance bottlenecks, including SQL and PL/SQL code execution, and will collaborate with Storage and UNIX teams to remediate issues before they impact operations. In addition to performance monitoring, the role involves engaging in new technology initiatives and performing database server hardware upgrades to maximize return on investment (ROI). The Senior Database Administrator will participate in triage calls, driven to identify root causes of issues, providing analysis data to other teams, and actively troubleshooting during outages. The position also requires reviewing critical database parameters, recommending adjustments, and managing cross-platform database migrations, including documenting the various steps involved. The Senior Database Administrator will implement high availability solutions for databases and work closely with development teams for SQL and PL/SQL code tuning, as well as schema design updates identified during pre-production installations. Researching and implementing proof of concept (POC) solutions for new features of the latest database technologies is also a key responsibility. Maintaining data security is paramount, and the administrator will ensure databases are secure while communicating any security loopholes to the security team. Additionally, the role includes participating in an on-call support rotation for production databases that require 24/7/365 availability.

Responsibilities

• Reviews production database performance reports on a regular basis and identifies 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 maximize ROI.
• Attends triage calls and is driven to identify the root cause, providing analysis data to other teams and actively troubleshooting during outages.
• Reviews critical database parameters and recommends adjustments.
• Manages cross-platform database migrations, 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 the latest database technologies.
• Maintains security of data by keeping databases secure and communicates security loopholes to the security team.
• Participates in on-call support rotation for production databases that require 24/7/365 availability.

Requirements

• 4+ years of 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.
• 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).

Nice-to-haves

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

Benefits

• Competitive salary range of $92,000 - $196,500 based on experience and qualifications.
• Opportunities for advancement and professional development.
• A supportive work environment focused on teamwork and camaraderie.