Operate and maintain Platform Services Microsoft SQL Server High Availability (HA) Cluster Environments and database servers/instances in NIPR, SIPR, TIPR, and JWICS at primary and alternate site locations
Provide full database administration O&M for SQL Server enterprise application databases (CORE, Domain Services, DMZ, SharePoint, VMware Infrastructure, SCCM, SCOM, Skype) and Mission Application databases listed in the JSP Environmental Document
Provide basic database administration for customer-managed databases hosted on JSP enterprise SQL Server HA Cluster Environments, including attaching/detaching of databases and coordination with database owners
Install, configure, and maintain SQL Server services and software, including upgrades, patches, third-party tools, and dependencies (clients, drivers, providers)
Allocate and manage database storage; perform database, instance, and cluster configuration tuning and modifications
Create and manage database environment accounts, profiles, and permissions in accordance with cybersecurity requirements; manage application accounts for customer application administrators with direct DB access
Configure, schedule, monitor, and restore database, instance, server, and cluster backups; test and validate backup procedures at least annually
Configure, manage, and monitor database replication, synchronization, and failover for HA Cluster Environments and Mission Essential Systems (MES)
Provide T-SQL development, debugging, and performance tuning; produce entity-relationship and data flow diagrams and database architecture diagrams as needed
Operate and maintain databases in accordance with DISA STIGs/SRGs; patch and remediate IAVA findings; validate and document cybersecurity compliance for application RMF accreditation at least annually; manage assigned cybersecurity POA&Ms
Provide after-hours support for scheduled Authorized Service Interruptions (ASIs), break/fix incidents, and incidents impacting Enterprise and MES Mission Application databases
Manage assigned incidents and service requests with detailed status/tasks/actions in the JSP ITSM tool
Requirements
Five (5) or more years of hands-on experience as a Microsoft SQL Server DBA in a large enterprise environment
Strong experience with SQL Server administration, T-SQL development, performance tuning, query optimization, indexing, and database recovery
Working knowledge of Windows Server platforms, PowerShell scripting, and SQL Server integration with VMware virtual environments
Experience with database backup tools, encryption (TDE), and DoD STIG/SRG hardening for SQL Server
Familiarity with Risk Management Framework (RMF), IAVM remediation, and cybersecurity POA&M management for database environments