IRS MBI Cleared (mandatory) Oracle DBA

*** ACTIVE IRS SPECIFIC MBI CLEARANCE IS MANDATORY. NO EXCEPTIONS ***

Minimum Federal Background Investigation MBI/ 58C Tier 2RS clearance required. (Permanent Resident or U.S. Citizenship required for MBI/58C Tier 2RS.)

Sr Oracle DBA w CMMi Level 3 experience

Responsible for administering Oracle databases to include performance, integrity and security of the databases and for managing in such a way as to provide all users access in a form that suits their needs.

50 % of effort will be Troubleshooting user issues

20% of time will be spent ensuring that storage, archiving, back-up and recovery procedures are functioning correctly.

Also - Monitoring performance and managing parameters.

Managing user access, permissions and privileges &

Database documentation

Required Experience:

10 years Oracle 19c installation, backup and recovery procedures & Database account and schema creation and maintenance

6 years or more of Unix shell scripting

7 years + Database and SQL tuning with AWR/ADDM or Statspack reports

6 years + Data import and export

6 years + GoldenGate installation and setup

5 years + Create and maintain Logical Data Model and Physical Data Model document & Experience with ERWin tools

Preferred Skills:
Oracle Enterise Management (OEM) tool
Table and index partitioning