Are you looking for your next challenge? Are you ready to work with a performance-based small company? At Zantech, we are a dynamic Woman Owned Small Business focused on providing complex, mission-focused solutions with a proven track record of outstanding customer performance and high employee satisfaction. We would love to talk with you regarding the next step in your career. Come join our team!
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:
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.
Responsibilities include, but will not be limited to:
Database Administration & Design:
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
Quality Control & Auditing:
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
Database Management System (DBMS) Support:
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
Security & Compliance:
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
Backup, Recovery & COOP:
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
Database Environment Management:
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
Data Management & Reporting:
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
Project Management Support:
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
Stakeholder Support:
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
Required Experience or Knowledge of the following technologies/functions:
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
Skills Required:
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
