Applications Database Administrator - 2788_8-4953

Honu Services • Springfield, IL • 6h ago

This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/13361470 Overview

Job Summary

Galapagos Federal Systems LLC is seeking a motivated Application Database Administrator (DBA) to join our team and work alongside a diverse group of professionals committed to mission success.

The Application DBA provides database administration support for the Defense Travel Management Office (DTMO) Enterprise Infrastructure, supporting Oracle (19c or higher) and Microsoft SQL Server (2014 or higher) environments. This role is responsible for designing, developing, testing, modifying, and managing databases within DTMO\'s multi-tier architecture.

Responsibilities include monitoring and optimizing database performance, tuning operations, and ensuring reliable data processing during core business hours (0600-2200 ET, Monday-Friday) with on-call support for mission-critical incidents outside those hours. The role also supports technologies such as SSIS, clustering, mirroring, and replication.

The DBA coordinates with DMDC to support data security standards, storage scalability, backups, and disaster recovery activities, including Information System Contingency Plans (ISCP), Business Impact Analyses (BIA), and annual Continuity of Operations (COOP) exercises supporting the DTMO Passport website.

Key Responsibilities

The Application Database Administrator will:

Provide database administration support for Oracle (19c or higher)

and Microsoft SQL Server (2014 or higher) environments

Design, develop, modify, test, and manage databases supporting

DTMO\'s multi-tier enterprise architecture

Monitor, maintain, and optimize database performance, including

query tuning and operational optimization

Perform SQL performance tuning and code optimization, including

rewriting queries as necessary

Administer and maintain database objects including tables, views,

indexes, sequences, clusters, packages, procedures, and triggers

Maintain and fine-tune databases using monitoring tools, utilities,

and performance management software

Support database clustering, mirroring, and replication to ensure

high availability and system resiliency

Implement and manage application deployments, database upgrades, and

patching for DTMO enterprise systems

Support and maintain database tools such as SQL Server Integration

Services (SSIS) and other ETL or integration technologies

Facilitate data integration with external systems and data sources

to enable ingestion into DTMO databases

Perform data purging and retention activities in accordance with

Department of Defense policies and DTMO guidelines

Conduct data refresh and data scrubbing activities across designated

environments and regions

Monitor disk usage, storage capacity, and database growth trends,

providing recommendations for capacity planning

Plan and implement database security controls, including access

management and enforcement of database constraints to ensure data integrity

Coordinate with Defense Manpower Data Center (DMDC) to analyze and

implement data security standards and storage security requirements

Collaborate with DMDC to analyze database scalability and storage

performance

Support backup, recovery, and disaster recovery operations,

including quarterly validation of backup processes and documentation in Monthly Status Reports

Assist in the development and maintenance of Information System

Contingency Plans (ISCP) and Business Impact Analyses (BIA) for supported systems

Support Continuity of Operations (COOP) exercises annually to ensure

operational availability of DTMO enterprise services such as the DTMO Passport website

Conduct semi-annual reviews of Standard Operating Procedures (SOPs)

to ensure documentation accuracy and operational compliance

Maintain comprehensive technical documentation, database standards,

and operational procedures

Provide operational monitoring during core support hours (0600-2200

ET, Monday-Friday) and participate in on-call support for mission-critical incidents outside of standard hours

Responsibilities

Skills and Experience

The Applications Database Administrator must have:

Must obtain and maintain a Tier 3 (T3) or higher background investigation

5+ years of experience as a Database Administrator in enterprise environments

Experience administering Oracle Enterprise Database environments

Experience with Microsoft SQL Server administration and development

Experience with SQL Server Integration Services (SSIS) or comparable ETL tools

Experience implementing and managing database clustering, mirroring, and replication technologies

Humana • Springfield, IL • 2d ago

IT & Engineering

Become a part of our caring community and help us put health first Humana's IT Enterprise Observability Engineering team is seeking a seasoned Senior Software Engineer with a strong background in observability platforms,...

2d ago

Go to Apply

Manufacturing Engineer

Ford Motor Company • Springfield, IL • 2d ago

IT & Engineering

At Ford Motor Company, we believe freedom of movement drives human progress. We also believe in providing you with the freedom to define and realize your dreams. With our incredible plans for the future of mobility, we h...

2d ago

Go to Apply

Senior Data Scientist

Cardinal Health • Springfield, IL • 3d ago

IT & Engineering

The Data & Analytics Function oversees the analytics life-cycle in order to identify, analyze and present relevant insights that drive business decisions and anticipate opportunities to achieve a competitive advantag...

3d ago

Go to Apply

Senior Software Engineer

Amentum • Springfield, IL • 3d ago

IT & Engineering

Purpose and Impact: The Geospatial Enterprise Open Data Store (GEODS) contract provides integration, design, development, and sustainment for data services in support of the Federal Government. Regularly, developers on G...

3d ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.