Database Administrator (Mid)

Overview

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.

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,…