The Senior Oracle DBA implements and optimizes the computerized database systems that support the client’s ability to function daily. Implements and maintains smooth operation and physical design of databases. Conducts performance tuning of indexes and databases, in general. Reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements. Maintains security and integrity controls. Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization. May develop stored procedures and/or triggers. Develops and enforces database administration and user standards and procedures, audits, modifies, and amends data in systems using SQL and PL/SQL commands. Oversees the scheduling of database projects, database and transaction log backups, notifications, and database replication between multiple Oracle RDBMS Servers and remote sites. Administers the critical Oracle Exadata Engineering Systems as well as the ZDLRA Engineering backup systems. Reviews technical designs, reports, documentation, and other materials produced by staff; creates, automates, and maintains high-level reporting systems using products such as Oracle BI publisher with OMS and WebLogic.
Responsibilities

• Leads and maintains the integrity, security, and availability of a true global 24×7 OLTP database(s) environment. Duties include disaster recovery, performance analysis and tuning, index maintenance, monitoring database health, and troubleshooting critical incidents.
• Performs the upgrade from Oracle 11g to 19c with RDBMS containerization via DBCA utility.
• Participates in and facilitates the full life cycle implementation of Oracle 19c RDBMS and 19c Oracle GoldenGate data replication for production environments.
• Leverages experience:
• Upgrading the Oracle RAC database from 11g to 19c, containerization of the 19c DB to CDB/PDB, configuring the Oracle GoldenGate replications from 11g to 19c, and deploying OEM 13.5 agents.
• Managing Oracle Exadata Engineering systems from X2-8 to X8M-8 and ZDLRA backup engineering systems.
• Upgrading the Oracle RDBMS system from 11g to 19c as well as the Transparent Data Encryption.
• Applies database administration skills to Oracle Real Cluster Application and Data Guard installation, configuration, and troubleshooting production issues.
• Performs database and software life-cycle activities to ensure the highest level of system performance and availability and compliance with business requirements.
• Applies advanced methods, theories, and research techniques in the investigation and solution of the complex system requirements and problems.

Qualifications

• Must have an active Secret security clearance
• Bachelor’s degree and 12-15 years of experience or (4 additional years of experience with a High School Diploma or equivalent); Master’s degree and 10-13 years of experience; PhD and 10 years of experience.
• At least seven years of experience in a role whose responsibilities are the same or similar to those defined for this position
• Experience as an Oracle 11g or Oracle 18c/19c database administrator with specific knowledge of RAC, ASM, GoldenGate, Data Guard, RMAN, Patching, AND/OR Security
• Experience upgrading/migrating Oracle 11g/12c to 19c RDBMS
• Foundational knowledge of/experience with Agile/Scrum processes
• Ability to organize tasks for self and others, prioritize and balance tasks, and lead complex projects
• Ability to communicate systems proposals to team leaders

Preferred Qualifications

• Experience as an Oracle DBA supporting a federal agency’s Oracle migration initiatives following Agile Software Development Methodology (Agile or the Scaled Agile Framework (SAFe))
• Experience with Oracle Cloud Computing (private or public)
• Experience with Oracle Engineered Systems, such as Exadata and Sun Super Cluster
• Oracle Certified Professional

Equal Employment OpportunityGovTact and Insperity provide equal employment opportunities to all employees and applicants in all company facilities without regard to race, color, religious creed, sex, national origin, ancestry, citizenship status, pregnancy, childbirth, (or related medical conditions, including, but not limited to lactation), physical disability, mental and/or intellectual disability, age, military status or status as a Vietnam-era or special disabled veteran, marital status, registered domestic partner or civil union status, gender (including sex stereotyping and gender identity or expression), medical condition (including, but not limited to, cancer related or HIV/AIDS related), genetic information, or sexual orientation in accordance with applicable federal, state and local laws.
This applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.