TS/SCI SQL DBA — High Availability & Security

Inflow NS; Fort Belvoir (VA); On-site; USD 120,000 - 150,000; Full time

Job summary

Inflow NS in Fairfax County, Virginia, seeks a senior SQL Database Administrator to provide administration and support for RDMS in a Microsoft SQL Server environment, ensuring data integrity, security, and availability across DoD and related networks. Active TS/SCI clearance and CI polygraph readiness required.

You will lead and execute maintenance, backups, and upgrades; improve disaster recovery and replication; work with stakeholders to implement secure data access and optimize performance

Qualifications

• Active Top Secret / SCI clearance and able to take/pass a Counterintelligence (CI) polygraph examination.
• 8 years experience in SQL database administration supporting and managing databases in a production environment.
• 5 years experience installing, configuring, and supporting Microsoft SQL Server in High Availability Group configurations.
• 5 years experience with T-SQL and ability to write scripts, stored procedures, triggers, and views to automate maintenance functions.
• 3 years experience serving as a team leader working as both part of a team and independently to assign/review immediate tasks, set priorities, maintain task progress, validate team members’ work consistent with the organizational goals and deadlines
• 3 years experience mentoring junior personnel on proper practices and procedures
• 3 years experience planning and implementing security measures to safeguard information against accidental or unauthorized damage, modification or disclosure in accordance with industry best practices and DISA STIGs
• Azure Administrator Associate, Microsoft 365 Administrator, Azure Database Administrator, MSCA, SQL Server 2016, or SQL Database Administration Certification
• DoD 8140.03 IAT Level II/Intermediate certification

Responsibilities

• Provide database administration and management support for RDMS in a Microsoft SQL Server-based environment hosting databases across the supported networks for various .NET applications
• Maintain quality of service and availability of DCD RDMSs by establishing and enforcing organizational defined standards ensuring the performance, integrity and security of databases through daily system checks with 100% of findings and statuses being recorded to DCD IT Portal
• Ensure all SQL servers and instances have the latest DISA STIGs applied
• Ensure healthy and reliable data replication is maintained using technologies such as availability groups
• Configure and utilize database connectivity tools and utilities
• Research, test, and implement new versions of the DBMS for inclusion into DCD infrastructure
• Develop and maintain database documentation
• Develop, manage, and test backup and recovery plans
• Review and complete assigned Daily System Checks
• Update configuration management data
• Monitor and assume responsibility of trouble tickets assigned to the Database Administration branch
• Provide restoration services sufficient to ensure high availability
• Provide after-hours on-site support, as needed, to respond to system/application malfunctions
• Perform regular database testing
• Conduct capacity planning and assist with storage and architecture design
• Produce entity relationship and data flow diagrams, and database normalization schemas
• Implement security requirements for least privileged access to organizational databases and monitor user access and security
• Map out a conceptual design for database enhancements
• Monitor performance and manage parameters to provide fast query responses to front-end users
• Manipulate database objects and develop stored procedures, stored functions, and packages when needed based on customer requirements
• Maintain, report, and update daily checklists
• Other duties as assigned

Skills

SQL database administration

Microsoft SQL Server

T-SQL

Security & DISA STIGs

Leadership / mentoring

DoD / CI clearance knowledge

Education

Active DoD TS/SCI clearance

DoD 8140.03 IAT Level II/Intermediate certification

Azure Administrator Associate

MCSA / SQL Server 2016 certification

Tools

DISA STIGs

Job description

Inflow NS in Fairfax County, Virginia, seeks a senior SQL Database Administrator to provide administration and support for RDMS in a Microsoft SQL Server environment, ensuring data integrity, security, and availability across DoD and related networks. Active TS/SCI clearance and CI polygraph readiness required.

You will lead and execute maintenance, backups, and upgrades; improve disaster recovery and replication; work with stakeholders to implement secure data access and optimize performance