Database Administrator, Mid

American Systems•Colorado Springs, CO

4d•$115,000 - $150,000

About The Position

AMERICAN SYSTEMS is an employee-owned federal government contractor supporting national priority programs through our strategic solutions in the areas of Information Technology, Test & Evaluation, Program Mission Support, Engineering & Analysis, and Training.

Requirements

Bachelor's degree
5-7 years of related work experience
U.S. Citizenship
Active TS/SCI Clearance

Responsibilities

Administers and sustains mission-data and database services supporting Red LAN applications, data storage, data integrity, access controls, backups, performance, and recovery.
Supports schema/data validation, structured-data handling, data transformation, and interface dependencies for Bifrost, customer additions, and other approved mission-data changes.
Conducts performance tuning of indexes and databases in general.
Reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements.
Maintains security and integrity controls.
Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization.
May develop stored procedures and/or triggers.
Administers a variety of database systems.
Develops and enforces database administration and user standards and procedures; audits, modifies, and amends data in systems using SQL commands.
Oversees the scheduling of database projects, database and transaction log backups, notifications, and database replication between multiple SQL Servers and remote sites.
Reviews technical designs, reports, documentation, and other materials produced by staff; creates and maintains high-level reporting systems; researches and implements new database and online technology.