Sr Database Administrator

Zantech•Battle Creek, MI

13d•Hybrid

About The Position

Zantech is looking for a talented Sr Database Administrator to contribute to the success of our upcoming Operations and Sustainment Support Services project for a Hybrid role based out of Battle Creek, MI. The Sr Database Administrator will play a crucial role in providing: Defense Business Systems (DBS) Life Cycle Management Acquisition Sustainment Maintenance Technical Support The Sr Database Administrator provides expert-level database administration services for mission-critical Defense Business Systems supporting DLA Disposition Services. This role is responsible for all activities related to the administration, design, creation, and maintenance of computerized databases in client/server environments supporting applications including Electronic Turn-in Document (ETID), Reutilization Transfer and Donation (RTD) Web and Mobile, Compliance Suite, Generator Communications Interface (GenComm), Employee Suggestion Program (ESP), and future mobile applications. The DBA Senior works with Oracle, SQL Server, SSRS, and manages databases across DISA, J64 TFS, and Azure GovCloud environments. Impact: This role directly impacts the availability, performance, security, and integrity of databases that enable DLA's mission to manage disposal of excess property from military services and support disaster relief operations nationwide.

Requirements

10 years of progressive experience with database query languages such as Oracle, PL/SQL, SQL Server, and MS Access
10 years of hands-on experience and expertise in Relational Database Management Systems
Experience in at least two projects in a large organization responsible for administering, operating, maintaining, and securing large-scale computer databases with Oracle, SSRS, and SQL Server
Expert-level proficiency in Oracle database administration
Advanced PL/SQL and SQL Server skills
SSRS (SQL Server Reporting Services) configuration and troubleshooting
Experience with MS Access
Expertise in Relational Database Management Systems (RDBMS)
Capability to work on various operating systems
Knowledge of additional programming languages
Database modeling and architecture design
Performance tuning and optimization
Database security implementation and management
Quality control and auditing of databases
Experience with DISA environments
Familiarity with J64 TFS and Azure GovCloud platforms
Understanding of database backup and recovery procedures
Experience with database CERT/CTO/IA compliance management
Knowledge of Security Technical Implementation Guides (STIGs)
Proficiency in data management, cleansing, and reporting
Experience with database dictionaries and standards monitoring
Ability to develop database-related processes and procedures
Strong analytical and problem-solving skills
Excellent communication skills for advising users on database access
Ability to work independently and as part of a team
Experience with configuration management processes
Knowledge of DoD/DLA processes, policies, and procedures
Understanding of Section 508 compliance requirements
Proficiency with Microsoft Office suite for documentation
Education Required: Bachelor's degree in information technology related field with 10 years of relevant experience
DoD 8570/8140 certification as applicable for IT-II Critical Sensitive position (Information Assurance certification)
Relevant database certifications (Oracle, SQL Server) from nationally recognized technical authorities
All certifications must be current and maintained throughout the period of performance
US Citizenship and the ability to obtain and maintain an active Secret or higher clearance, per contract requirements.

Nice To Haves

Master's degree in Computer Science, Information Systems, Database Management, or related field
Advanced database certifications beyond baseline requirements
Oracle Certified Professional (OCP) - Database Administrator
Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics
Oracle Database 12c/19c Administrator Certified Professional
Microsoft SQL Server certifications
ITIL Foundation or higher
CompTIA Security+ or higher

Responsibilities

Provide all activities related to the administration of computerized databases
Project long-range requirements for database administration and design in conjunction with other managers in the information systems function
Design, create, and maintain databases in client/server environment and other required environments
Design, implement, and maintain complex databases with respect to JCL, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods
Apply knowledge and experience with database technologies, development methodologies, and front-end/back-end programming languages (e.g., SQL)
Perform database programming and support systems design
Assist in database modeling as requested, offering design options/solutions
Conduct quality control and auditing of databases in client/server environment to ensure accurate and appropriate use of data
Advise users on access to various client/server databases
Include maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design
Develop database-related processes/procedures that enforce/complement other data integrity processes and procedures implemented by DIW
Research, analyze, and determine Database Management System (DBMS) software/patch/upgrade availability and applicability
Research and recommend software/hardware requirements to the government for approval
Customize installations for application sustainment
Develop implementation plan and schedule
Obtain Government POC approval for installation schedule
Coordinate schedule through configuration management with the PMO who will go through the DLA Enterprise CM process
Install/Configure DBMS software/upgrades/patches where applicable
Provide database CERT/CTO/IA directives/mandates/regulations management where applicable
Research, analyze, determine applicability and impacts of DBMS CERTS, CTOs, IA directives/mandates/regulations
Develop implementation plan and schedule for security compliance
Obtain customer approval for installation schedule from the PMO
Coordinate schedule through configuration management and obtain approval
Install and implement CERTS, CTOs, other IA directives, mandates and regulations including Security Technical Implementation Guides (STIGs) and Security Readiness Reviews (SRRs)
Prepare Plans of Action and Milestones (POAMs) as required and implement mitigation measures/strategies as required
Provide database backups and recoveries where applicable
Determine, set up, coordinate backup schedule for DBMS and other related files
Provide database Continuity of Operations (COOP) where applicable
Participate in all phases of COOP planning as needed
Participate in COOP exercises and related activities as required
Prepare documentation for COOP exercise and related activities
Administer application databases across DISA, J64 TFS and Azure GovCloud, and any future Amazon Cloud service
Assist HP and DIW system administrators as required
Provide both local and remote maintenance support to various operational systems deployed at more than one location
Run queries and develop reports from databases
Perform data cleansing of production database data
Assist DIW customers as requested with data management concerns/issues/problems
Provide support to DIW in the assessment and implementation of concepts and technologies regarding data mining, data warehousing, data standardization, data management and data administration
Develop policies, processes and procedures for effective data management and administration
Assist with SQL Server Reporting Services database configuration and setup when needed, including troubleshooting SSRS issues
Provide project management services and support for DBMS and DBA related projects and efforts
Prepare requested documentation such as lists, word documents, spreadsheets, POAMs, Work Breakdown Schedules (WBS)
Track status and progress and report both formal and informal progress to government personnel and management
Assist stakeholders in resolving issues/concerns/problems as they relate to database access and availability
Interface with clients to determine database requirements
Provide technical guidance and recommendations
Support application development teams with database needs