SE.INF08 – IPPS-A - Oracle DBA
Clearanace: Active Secret clearance, SSBI preferred
Job Description Summary
Responsible for knowledge and proficiency with an enterprise database technology (e.g., Relational, SQL database, In-Memory databases, NoSQL databases and new emerging databases). Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of the system. Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; and participating in professional societies. Identifies customer database requirements. Defines optimal conceptual, logical and physical data models that address customer requirement and balances performance (e.g., indexes, views, snapshots) and storage (e.g., normalization, de-normalization). Incorporates security, back-up, and disaster recovery into database designs. Establishes database parameters that maximize database performance. Installs, configures, and patches database management systems (DBMS). Writes database documentation, including data standards, procedures and definitions for the data dictionary (metadata). Controls access permissions and privileges. Ensures that storage and archiving procedures are functioning correctly. Conducts capacity planning. Communicates regularly with technical, applications and operational staff to ensure database integrity and security. Clones application environments. Ensures availability of related application technology (e.g., web services, applications, batch processors, job schedulers, etc.). Provides Tier III support for the application technology stack. Applies application, security, and database patches. Migrates new software code and break fixes. Verifies shell/SQL scripts, packages, and stored procedures for system enhancements. Installs and configures third party products that integrates with the underlying application.
Job Description
The System Integration Team integrating Increment II of the US Army's Integrated Personnel and Pay System (IPPS-A) is looking for an experienced Database Administrator. The selected candidate will support the program by joining the IPPS-A Infrastructure team to support activities of multiple teams including development, test, data, reporting, sustainment and operations. Activities including but not limited to: source file acquisition, data loading of various data types (eg. xml, flat files, Oracle dmp, SQL server, etc.), DDL/DML/SQL execution, table and schema creation, user/role security, table maintenance, data migration between data centers, etc. General Oracle database support activities will include: database sizing, cloning, testing, debugging, replication, backups, restores, disaster recovery, and ongoing support to include status checks and critical patch updates.
Required Qualifications:
- BA/BS degree and 7-10 years of related experience
- Current Secret Clearance required; SSBI preferred
- Current Security+ Accreditation required
- 5+ years hands-on experience as an Oracle DBA
- 3+ years experience working as a DBA in support of PeopleSoft
- Solid understanding of Oracle database, Exadata, Solaris
Desired Qualifications:
- Solid experience installing, configuring, upgrading and tuning Oracle 11g/12c on Solaris & Linux
- Experience implementing Oracle Database Vault
- Experience implementing Oracle Audit Vault
- Experience supporting Oracle Golden Gate
- Experience working in support of PeopleSoft ERP
- Good working knowledge of SAN vSAN technologies
- Experience with volatile storage and recovery techniques
- Experience with ZFS helpful
- Experience with Oracle Superclusters
- Experience working in DISA and working with the DISA DECC environment
- Direct hands-on experience with the DISA DECC SAN technologies and COOP process
- Experience with DOD and/or GSA database security requirements is a major plus
- Experience with Oracle Enterprise Manager (OEM) 12c, Oracle Recovery Manager (RMAN) and have Unix shell scripting, SQL Scripting and PL/SQL experience
- Minimum of 4 years of Oracle Database Administration experience in Solaris and LINUX environments
- Minimum of 2 years of Oracle SQL or PL/SQL development experience
- Oracle Database Administrator Certified Professional helpful but not required