Job Description :
Position: Oracle DBA
Sacramento, CA
Duration: 1 year

Interview Process: Onsite interview required, must be local

Position Summary Our Client is looking for a qualified Oracle Database Administrator to provide our client with support for the current Actuarial (ACTO) environments, both production and non-production, as well as participate in the database design and analysis of the ACTO database. Work will include supporting, tuning, refresh and backup of the client''s PeopleSoft Oracle environments.

The selected consultant will provide services in operational assessments, systems analysis, design, integration, build, configure, test, implementation, maintenance, training and support for hardware and software for data and voice networks, server hosting and server infrastructure (e.g., Active Directory, LDAP, DNS, DHCP, etc, storage appliances, database technologies, desktops, mobile computers, , data backup, restore, archive, disaster recovery.
o Hardware includes but not limited to:
Data Center equipment including, uninterrupted power supplies, power distribution units, computer room air condition units, network cables and management systems.
Network firewalls, routers, switches, load balancers, VPN appliances
Server enclosures, servers
Storage Area Network (SAN), Network Attached Servers (NAS) , Exa Data, Exa Logic, and ZFS appliances
Personal computers, mobile computers, tablets, smart phones, printers, monitors, etc.

o Software includes but not limited to:
Virtualization software – VMWare, KVM, etc.
Cisco IOS, Cisco Call Manager, network access control
Server Operating Systems (e.g., Windows, Linux, etc, firmware, drivers, service packs, anti-virus, utilities and tools
Active Directory, Ms Exchange, SCCM, SCOM, SCSM
Remote Access -Citrix, VPN, Ms OWA
Call Center Genesis Interactive Voice Response, workforce management, quality management
Data backup, archive, disaster recovery
Web and Application server software – Web Logic, IIS, Web sphere, Apache Tom Cat, etc.
Third party vendor software - Adobe, IBM Cognos, Oracle OBIEE, Microsoft Share Point, Open source, etc.
Middleware software – Oracle SOA suite, Internet connectivity, Firewall, Oracle Identity Management, etc.
Relational Database Management software – Oracle 11.x, Oracle 12C, Oracle Enterprise Manager (OEM), Oracle Data Integrator, Golden Gate, Ms SQL Server, etc.
Business Intelligence – Statistical Analysis System (SAS) software suite, ETL Tools, etc.
Desktop productivity applications and tools – Windows OS, Macintosh OS, Microsoft Office Suite, tool, utility, etc.
Desktop Security software - Anti-Virus/Spyware/Adware, Active Directory (AD) and Group Policy (GPO) Administration and Reporting management, etc.
The scope of this project encompasses the following tasks in Oracle 11g /12c; Red Hat Linux 5.x/6.x, Exadata and Windows environment for Actuarial environments:
Designing a database from a logical data model
Creating the DDL to implement and modify a database using ERwin
Sizing database tables and indexes
Designing a physical database, capacity planning, ASM storage requirements
Generating views
Optimizing and tuning SQL statements using hints, explain plan, TKPROF, StatsPack, ADDM and AWR
Writing PL/SQL objects including database triggers
Executing customer created scripts, i.e. stored procedures, packages, data fixes, etc.
Setting up database replication
Setting up partitioned tables/indexes
Installing Oracle software
Creating Oracle instances
Creating and recovering Oracle databases from a variety of sources: RMAN, “cold” and “hot” backups
Monitoring Oracle databases using Oracle Grid Control
Creating/maintaining Unix Shell scripts
Documenting procedures and best practices
Responding to help desk tickets
Following established change control procedures
Setting up Oracle Data Guard or Standby databases
Supporting Oracle RAC 11gR2 databases
Supporting databases on Oracle Exadata and ZFS appliances
Automation of ZFS cloned Oracle databases
Automation of ZFS backups and restores for the Enterprise Oracle databases
Migration of databases to VMWare platform.

Requirement Mandatory Qualifications
Five (5) years of experience as an Oracle Database Administrator (DBA) on Oracle database version 11g or above.
Five (5) years of experience as a DBA supporting databases on Red Hat Linux 5.x or higher.
Five (5) years of experience writing Unix Shell scripts.
Five (5) years of experience as a DBA supporting databases with a size of at least 7 TB.
Five (5) years of experience with Oracle 11g or higher:
Using Tuning Pack, Diagnostics Pack, Change Management Pack and/or Automatic Workload Repository (AWR)
Writing PL/SQL objects.
Supporting Oracle databases that utilize the RMAN backups to disk and tape.
Supporting Oracle databases using replication/materialized views.
Supporting Oracle databases using triggers.
Using Oracle database auditing utilities
Five (5) years of experience writing documentation (standards, best practices, procedures
Five (5) years of experience designing a database from a logical data model using ERWin and creating a physical database from a logical model.
Five (5) years of experience supporting Oracle databases on ASM (Automatic Storage Management
Three (3) years of experience with Oracle Exadata and Oracle ZFS storage appliance with Oracle databases.
Five (5) years of experience with Oracle Real Application Clusters (RAC) database version 11g or higher.
Five (5) years of experience as a DBA supporting actuarial systems.
Oracle DBA 11g or higher Certified Professional (provide proof of certification
Must have a minimum of five (5) years of experience with one or more of the above listed hardware, software and services, and at least four (4) years of said experience must have been at a high level both technically and in measure of responsibility.
Must have the appropriate certifications with specific technical specialties that are applicable to the above listed hardware, software and services.
Must have four (4) years of experience with leading multi-disciplinary teams.

Desired Qualifications
Experience as a DBA supporting government retirement database systems.
Experience with virtualizing Oracle databases.
Experience working (i.e. database design, SQL scripting and tuning, SDLC processes) in an actuarial environment.