Senior Database Administrator
Location
US-VA-Stafford
ID
2025-1988
| Category |
Databases & Data Warehousing
|
Position Type |
Full-Time
|
Remote |
No
|
Clearance Required |
Top Secret
|
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
As a Database Administrator with AMERICAN SYSTEMS, you will have an opportunity to do the following:
Support a Department of Justice program, who designs, builds, and implements highly technical data collection systems.
- Support a technology lab who dynamically implements technology to meet their outside customers uniquely defined evidence collection needs.
- Architect, implement and administer globally distributed SQL Server instances, using clustering and DR/COOP for high availability.
- Analyze large, complex systems to determine performance bottlenecks, application bugs, and opportunities to improve efficiency.
- Optimize SQL Server to accommodate large data volumes and high throughput processing.
- Capture and analyze database activity to identify improvements in indexing, file structure, and maintenance processes.
- Plan and conduct database architecture assessments that examine the database.
- Management System (DBMS) and database configuration and performance.
- Identify areas of instability and deviations from best practices with database components.
- Participate in performance, load and stress testing, and remediation of issues identified.
- Lead the implementation of security hardening and auditing of all SQL server instances across the enterprise.
- Develop scripts to automate SQL tasks as needed.
- Participate in all aspects of the application lifecycle, e.g., requirements analysis and definition, system design, implementation, testing, development, and sustainment.
- Prepare technical designs and documentation (i.e., knowledgebase articles) for use by the help desk.
Qualifications
- Bachelor's Degree (BS) with 8+ years of relevant experience or Associates Degree (AS) with 10+ years relevant experience or High School/GED with 13+ years' relevant experience.
- Experience designing, deploying, and maintaining SQL Server infrastructure on versions 2016 and newer.
- Minimum of 3 years' experience creating and managing SQL server infrastructure using PowerShell (preferred) or another automation technology.
- Experience in MS SQL server database administration, design, and development.
- Proficiency securing SQL server and databases, according to Defense Systems Information Agency (DISA) Security Technical Implementation Guides (STIG) guidelines.
- Experience developing and maintaining scripting for automating SQL server tasks.
- Active Top-Secret Clearance.
- Willing to take a CI polygraph when required by the customer.
EEO Statement
EEO Race/Sex/Disability Status/Veteran Status |
AMERICAN SYSTEMS
Feb 19, 2025