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:
Desired Qualifications: