Job Description :
Job Title: RBAC Database Administrator
Location: Alexandria, VA
Duration: Long term contract
Start Date: Immediate
Client: AEEC/USPTO

This position will primarily be responsible for the migration from Oracle 11g to 12c.

The selected candidate will:
Provide Subject Matter Expertise and have proven experience with upgrading Oracle Databases from 11g to 12c
Provide a detailed design and architectural diagram to upgrade Oracle databases from 11g to 12c.
Carefully examine the source databases and look for areas of consolidation, optimization, and maximized performance in 12c as part of the migration strategy.
Provide mitigation plans to resolve issues that occur from upgrading Oracle databases from 11g to 12c.
Provide detailed rollback and mitigation plans after upgrading databases from 11g to 12c, implementing data propagation, and any other changes to the Oracle iDM system.
Team with onsite personnel on design, provide an architectural diagram and configure and implement Data Propagation within and between two sites (VA and PA) using appropriate database replication technologies recommended by Oracle such but not limited to Golden Gate and Data Guard.

Required skills include:
Good organizational skills
Good with multi-tasking, Attention to Detail, Thoroughness
Able to handle high-pressure situations
Experienced at resource management and scheduling
Technical
Hands-on experiences with 11g/12c
Experience with large RAC, OLTP databases using ASM, ACFS filesystem
Working experience on Linux
DataGuard Physical standby experience
Proficient with Unix Shell scripting
Hands-on experience on installation and configuration and troubleshooting of Oracle products and patches, including RAC, ASM, Clusterware, Data Guard, OID, Grid/Cloud Control, OEM, RAT, AWR, PL/SQL
Working knowledge on GoldenGate performance and configuration
Strong working experience with RMAN configuration, job maintenance and backup & recovery
Experience with monitoring tools like OEM
Tuning ORACLE RDBMS systems, both at the system and SQL levels
Redundant backup strategies using Oracle Data Pump as a secondary backup and contingency planning strategy.
Exporting data to a dump files via Data Pump
Knowledge and use of multitenant container database (CDB) and pluggable databases (PDB
Database Upgrade Assistant (DBUA) or command-line upgrade script to upgrade the databases to Oracle Database 12c
Oracle Certified Professional (OCP) and/or Oracle Certified Expert (OCE) certificate preferred.