5 years of relevant experience in DBMS technologies.
IT-II security clearance or current NACLC.
Microsoft Certified: Azure Database Administrator Associate required.
Experience in DBMS system analysis and programming.
Knowledgeable in Oracle and Microsoft SQL database management.
Responsibilities
Evaluate and recommend DBMS products to meet user needs.
Develop and maintain database backup and recovery procedures.
Monitor, optimize, and tune database performance.
Control user access and maintain system security.
Assist application teams with data loading and schema management.
Benefits
Four medical/vision options including an HSA plan.
Dental and orthodontia coverage.
Paid life, short-term, and long-term disability.
401K retirement program with company contribution.
Generous leave policies including paid vacation and holidays.
Full Job Description
Summary:
Client Agency is Defense Logistics Agency.
Experience in DBMS system analysis and programming.
Experience in using current DBMS technologies and application design using various database management systems; experience with DBMS internals.
Must be capable of providing highly technical expertise and support in the use of DBMS.
Must be able to evaluate and recommend available DBMS products to support validated user requirements.
Defines file organization, indexing methods, and security procedures for specific user applications.
Develops, implements, and maintains database backup and recovery procedures for the processing environments and ensures that data integrity, security, and recoverability are built into the DBMS applications.
Support for all Oracle application database implementations in physical/cloud environments.
Assist application team(s) by loading schemas, scripts, and data into Oracle or Microsoft SQL databases as required.
Create primary objects (tables, views, indexes) and modify primary objects, as necessary, to address issues raised by application developers.
Control and monitor user access to the database. Enroll users and maintain system security.
Monitor and optimize the performance of the database by running monthly Oracle Automated Workload Repository (AWR) reports, reviewing reports, and recommending database optimizations to improve application performance.
Assist with performance tuning or troubleshooting application database-related issues/errors that may occur specific to the use of Oracle database technology for the application as appropriate.
Provide consultation and knowledge sharing on database requirements for new and existing projects.
Assist application team with interfacing with the J64 DBA infrastructure team.
Assist in finding, researching, documenting, and remediating application Security Technical Implementation Guide (STIG) findings.
Assist with troubleshooting and resolving database problems.
Provide support for the upgrade of Oracle to later releases once approved for use by DLA.
Requirements:
Must possess IT-II security clearance or have a current National Agency Check with Local Agency Check and Credit Check (NACLC). (Basic Federal Clearance requirements are U.S. Citizenship, clear criminal history check, no recent or pending bankruptcies)
Five (5) years relevant experience
Ability to run Automated Workload Repository (AWR) reports.
Must have a Microsoft Certified: Azure Database Administrator Associate.
Benefits We Offer:
Four Medical/Vision options including an HSA plan
Dental and Orthodontia plan
Vision Materials plan
Paid Life, Short-Term Disability, and Long-Term Disability
