Oracle DBA - El Dorado Hills California

Location: El Dorado Hills, California
Posted On: 11/21/2024

<span>Major Healthcare Services client is looking for a lead Performance Oracle DBA, who will be working in a senior capacity as part of a team of DBAs. Working in collaboration with cross-functional teams to design, build, upgrade, modify and operationally administer new or existing Oracle databases in support of critical enterprise applications. Candidate will be working on a large scale multi-year project migrating from a legacy system to a state-of-the-art health care administration system.<br>&nbsp;<br>This role can be staffed in either their El Dorado Hills office or at headquarter office at San Francisco. This starts as a 6 month conttract.<br>&nbsp;<br>**Must be eligible to work on W2 without sponsorship**<br>&nbsp;<br>Responsibilities:<br>* Acts as a oracle database performance subject matter expert, working with cross functional teams in building, scalable enterprise solutions.<br>* Establish and maintain performance baselines, troubleshoot performance issues and provide recommendations/fixes for identified issues. <br>* Provides architectural guidelines to build and maintain scalable multi-terabyte database environments. <br>* Will develop and distribute performance metric reports and dashboards highlighting the health of the database environments.<br>* Creates, supports and administers relational databases.<br>* Oversees administration and performs hands-on administration of databases, related tools, processes and operations in large oltp and batch environments.<br>* Recommends solutions that require definition of the physical structure and functional capabilities of databases and required data security and data backup/recovery specifications.<br>* Ensures proper design, implementation, performance, availability, security, auditing and capacity management of related database systems.<br>&nbsp;<br>Knowledge/Skills and Experience:<br>Must have prior experience in and deep knowledge of the following:<br>* Practical experience in pro-active and reactive database performance tuning. <br>* Database capacity forecasting<br>* Administering large hybrid environments with OLTP and Batch processing loads. <br>* Oracle Database Architecture <br>* Performance tuning best practices<br>* Supporting multi terabyte Oracle databases on unix based systems, preferably AIX and Solaris<br>* Databases hosted on virtualized platforms (AIX LPARs, VMware)<br>* Excellent understanding and practical experience with Oracle performance views, OEM, ASM, backup and recovery concepts (RMAN) and operating system concepts. <br>*Well versed in reviewing AWR, ASH reports and 10046, 10053 trace files to identify potential performance problems. <br>* SQL statement tuning skills.<br>&nbsp;<br>Desirable skills include:<br>* Experience with databases supporting three tier SOA/Web Services bases applications is highly desirable.<br>* Replication technologies including Oracle Logical and Physical Dataguard, Goldengate, Oracle Streams. <br>* Experience building and managing highly available Database environments using Oracle RAC or Symantec VCS. <br>* Recent experience installing, configuring and managing Oracle 11g and 12c environments.<br>* Ability to read and understand PL/SQL code and provide recommendations to developers is highly desirable. <br>* Good understanding of Database Design and Data Modeling concepts.<br>Good understanding and practical experience troubleshooting Oracle SQLNet connectivity and performance issues.<br>* Experience working with storage administrators in setting up storage sub-systems for optimal database performance is highly desirable. <br>* Unix shell scripting, perl scripting skills are highly desirable. <br>* Experience supporting system migration from legacy systems is highly desirable.<br>&nbsp;<br>Other requirements:<br>* Excellent written and oral communication skills. Ability to communicate technical concepts in an easy to understand form is essential. <br>* Operates under general direction. Assignments are very broad in nature and of the highest level of complexity. Ability to influence and have impact beyond own area of responsibility. <br>* May instruct, guide and oversee work of lower-level technical professionals. <br>* Consults and makes recommendations to management on significant issues. <br>* Responsible for developing and implementing new products and/or approaches in conjunction with implementing new/existing technologies.<br>* Knowledge encompasses entire scope of a technical discipline and has received recognition for development of one or more unique sub-specialties. <br>* Generally requires 8 to 12 years of directly related professional experience and possesses deep technical abilities in one or more primary products, programs or technologies.<br>* Experience working in a team which delivers a highly available environment supporting large project development efforts 24 x 7 onshore and offshore is desired. Familiarity with SDLC, Data Modeling, ITIL concepts and practices is required. <br>* Participation in On-Call Rotation is required<br>&nbsp;<br>&nbsp;<br></span> More...

Register an account with us and set up job agents! We'll email you immediately when jobs like this are posted on our site.