Vacancy expired!
ASD is seeking a SQL database Administrator to support its DoD contract. Must have an Active Top Secret Clearance. This position is part of the IT Technology Operations division within the NCIS ITD organization and performs the following responsibilities/functions:
- Deploying MS SQL servers in highly available configurations via multiple SQL nodes
- Setting up MS SQL Always On Availability Groups with multiple SQL server synchronization
- Deploying HA/AOAG stretched over a metro style clustering for disaster recovery support
- Performance tune DB and server connections
- Upgrading DB to newer versioning via best practices
- Working with MS SQL Transparent Data Encryption (TDE)
- Securing Windows, MS SQL, and DBs per DoD guidance in RMF accredited environments
- Patching servers and MS SQL installation during non-peak hours
- Administering MS SQL Reporting Services and Power BI instances
- Work with backup team to ensure user and system DBs have appropriate backups
- Work with CND team to assist in providing log review for threat incidents
- Assist in managing other SQL versions to include MySQL and PostgreSQL (PSQL)
- Performs software upgrades, patch installs, firmware upgrades
- Diagnose and troubleshoot problems related to the OS, hardware, network, and related software
- Daily written and oral communications with coworkers and leadership
- Continual attention to periodic SCAP and SPower BI requirements needed to harden the servers
- Create scripts in various shells to automate daily and periodic tasks
- Document work for leadership, update/create Standard Operating Procedures, and brief staff and customers various tasks
- 5+ years of experience in systems administration
- 2+ years of specialized experience in MS SQL administration
- Experienced with SQL Server 2012/2014/2016/+
- Experienced with SQL administration via SQL Server Management Studio, CMS, as well as transact statements
- Experienced with Windows Server 2012/2016/2019
- Experienced with MS Power BI
- Familiar working with Linux OS supporting MySQL PSQL instances
- Familiar working with servers in a VMware virtual environment
- Requires ability to work in a collaborative environment to troubleshoot and resolve problems
- Required: Current DoD 8570 - IAT Level II
- Required: Fully adjudicated active Top-Secret clearance is required to start, must be eligible to obtain SCI-level adjudication