Oracle DBA

Unclassified - El Dorado Hills, CA

Full-time - Senior

El Dorado Hills, CA

About the position

The lead Performance Oracle DBA will work in a senior capacity within a team of DBAs, focusing on the design, build, upgrade, modification, and operational administration of Oracle databases. This role supports a large-scale multi-year project aimed at migrating from a legacy system to a modern healthcare administration system. The position is available at either the El Dorado Hills office or the San Francisco headquarters and is structured as a 6-month contract.

Responsibilities

• Acts as a Oracle database performance subject matter expert, collaborating with cross-functional teams to build scalable enterprise solutions.
• Establishes and maintains performance baselines, troubleshoots performance issues, and provides recommendations/fixes for identified issues.
• Provides architectural guidelines to build and maintain scalable multi-terabyte database environments.
• Develops and distributes performance metric reports and dashboards highlighting the health of the database environments.
• Creates, supports, and administers relational databases.
• Oversees administration and performs hands-on administration of databases, related tools, processes, and operations in large OLTP and batch environments.
• Recommends solutions that define the physical structure and functional capabilities of databases, including data security and backup/recovery specifications.
• Ensures proper design, implementation, performance, availability, security, auditing, and capacity management of related database systems.

Requirements

• Practical experience in proactive and reactive database performance tuning.
• Database capacity forecasting.
• Administering large hybrid environments with OLTP and batch processing loads.
• Deep knowledge of Oracle Database Architecture.
• Performance tuning best practices.
• Supporting multi-terabyte Oracle databases on UNIX-based systems, preferably AIX and Solaris.
• Experience with databases hosted on virtualized platforms (AIX LPARs, VMware).
• Excellent understanding and practical experience with Oracle performance views, OEM, ASM, backup and recovery concepts (RMAN), and operating system concepts.
• Well-versed in reviewing AWR, ASH reports, and 10046, 10053 trace files to identify potential performance problems.
• SQL statement tuning skills.

Nice-to-haves

• Experience with databases supporting three-tier SOA/Web Services-based applications.
• Replication technologies including Oracle Logical and Physical Data Guard, Goldengate, Oracle Streams.
• Experience building and managing highly available Database environments using Oracle RAC or Symantec VCS.
• Recent experience installing, configuring, and managing Oracle 11g and 12c environments.
• Ability to read and understand PL/SQL code and provide recommendations to developers.
• Good understanding of Database Design and Data Modeling concepts.
• Experience troubleshooting Oracle SQLNet connectivity and performance issues.
• Experience working with storage administrators in setting up storage subsystems for optimal database performance.
• Unix shell scripting and Perl scripting skills.
• Experience supporting system migration from legacy systems.

Benefits

• Contract position with potential for extension or conversion to full-time.
• Opportunity to work in a collaborative environment with cross-functional teams.