SQL Server Database Administrator

SAIC•Quantico, VA

About The Position

SAIC is seeking a SQL Server Database Administrator to support DCSA/OneIT program out of Quantico, VA. Introduction Make a difference for national security by joining a team of dedicated IT professionals who will sustain, modernize and transform the enterprise IT capabilities of the Defense Counterintelligence and Security Agency (DCSA). The Air Force Space and Intel Business Group of SAIC is seeking a SQL Server Database Administrator to support a transformational infrastructure program for DCSA. SAIC is proud to be supporting DCSA in safeguarding our nation's information. DCSA is the designated oversight authority on the accreditation of classified facilities, information systems, and the insider threat program. This involves security oversight of more than 10,000 companies and approximately 13,000 facilities involved in classified work throughout the DoD and 31 Federal agencies. Specifically, on the DCSA One IT program, SAIC will provide an enterprise IT solution that delivers highly secured and adaptable IT infrastructure, provides customer support, an cutting-edge technologies that support operations and advance the DCSA mission under a single IT environment (i.e., One IT). Job Description The SQL Server Database Administrator (DBA) will be responsible for the administration, support, and maintenance of SQL Server databases to ensure high performance, availability, and security of critical business applications. This role involves troubleshooting database issues, optimizing performance, implementing security measures, and managing backups and disaster recovery processes. The ideal candidate will have a deep understanding of SQL Server database architecture and administration, as well as the ability to collaborate with application developers, system administrators, and other stakeholders.

Requirements

Bachelor's degree in Computer Science, Information Technology, or a related field.
Nine (9) or more years of experience. An additional four (4) years of relevant experience may be considered in lieu of a degree.
Three (3) to five (5) years of experience working as a SQL Server Database Administrator in a production environment.
US Citizen and Active Top Secret clearance with SCI eligibility.
IAT-II Certification (i.e., Security + CE, etc.).
Proficiency with Microsoft SQL Server (versions 2012, 2016, 2019, or Azure SQL).
Strong knowledge of SQL language for querying, scripting, and debugging.
Experience with database backup, recovery, performance tuning, and high availability technologies.
Familiarity with SQL Server Management Studio (SSMS), Profiler, and monitoring tools (e.g., SolarWinds DPA, Redgate).
Understanding of operating systems (Windows Server/Linux) and hardware compatibility with SQL Server.
Strong troubleshooting and analytical problem-solving skills.
Excellent verbal and written communication skills for effectively working with team members and stakeholders.
Ability to manage multiple tasks and prioritize responsibilities in a fast-paced environment.

Nice To Haves

Experience with cloud-based database solutions (e.g., Azure SQL Database, AWS RDS) is a plus.
Experience with additional tools (e.g., SSRS, SSAS, Power BI, Tableau) is a plus.
Knowledge of ITIL processes and incident management practices is beneficial.

Responsibilities

Database Administration and Maintenance:
Install, configure, upgrade, and maintain Microsoft SQL Server instances across development, testing, and production environments.
Perform routine maintenance tasks such as backups, index maintenance, monitoring, and performance tuning.
Monitor database system health, ensuring high availability and low downtime.
Performance Tuning and Optimization:
Analyze database performance and implement tuning recommendations (e.g., query optimization, index management, etc.).
Identify resource bottlenecks and optimize server and query performance for efficient processing.
Capacity Planning:
Proactively plan for future database needs based on application usage and growth trends.
Monitor database storage and design strategies to optimize space utilization and scalability.
Security and Compliance:
Implement and maintain database security policies, including role-based access control (RBAC), audit trails, and encryption across SQL Server instances.
Ensure compliance with data privacy standards (e.g., GDPR, CCPA, HIPAA, etc.) and corporate security policies.
Disaster Recovery and High Availability:
Develop and implement database backup, restoration, and recovery plans. Perform disaster recovery testing regularly.
Configure and manage high availability solutions such as clustering, Always On Availability Groups, or replication.
Collaboration with Other Teams:
Work closely with application developers to design and optimize database structures for new and existing systems.
Collaborate with IT administrators on server resources (e.g., CPU, memory, storage) required to support database operations.
Scripting and Automation:
Create and maintain scripts to automate repetitive tasks such as backups, deployments, and monitoring.
Documentation and Reporting:
Develop and maintain detailed documentation of database configurations, standard operating procedures (SOPs), and maintenance schedules.
Generate reports for monitoring key database performance metrics and trends over time.