NCIS SQL Database Administrator - HYBRID

Type of Requisition:

Regular

Clearance Level Must Currently Possess:

Top Secret

Clearance Level Must Be Able to Obtain:

Top Secret/SCI

Suitability:

Public Trust/Other Required:

None

Job Family:

Database Analysis/Design

Job Qualifications:

Skills:

PL/SQL (Programming Language), SQL Databases, Structured Query Language (SQL)

Certifications:

CompTIA - Security+ - CompTIA

Experience:

5 + years of related experience

US Citizenship Required:

Yes

Job Description:

Join General Dynamics IT and be a part of the team of men and women that solve some of the world’s most complex technical challenges. The Navy Criminal Investigative Services (NCIS) team is seeking a SQL DBA Systems Administrator (Systems Administrator with both SQL Server Database Administration and Windows Systems Administration experience) to join them in Quantico, VA.

This is a 3/2 Hybrid scheduling position.

The Naval Criminal Investigative Service (NCIS) is an organization of over 2,200 personnel of which 700 serve at HQ and the remaining staff serve at offices worldwide. NCIS is the Department of Navy (DON) component with primary responsibility for criminal investigation, law enforcement (LE), counter-terrorism (CT), counterintelligence (CI), and cyber matters.  NCIS not only has primary responsibility for all criminal investigative, CI, CT, and cyber matters within the DON, but it also has exclusive investigative jurisdiction in non-combat matters involving actual, potential, or suspected criminal, terrorism, sabotage, espionage, and subversive activities.

As the SQL DBA Administrator, you will manage all current and planned SQL Server databases that support our customer’s COTS applications. You will also be part of a team of systems administrators managing Windows Server 2016-2019, desktops, and printers. In addition:

• You will be responsible for the operations and maintenance of these databases. If additional databases are required in the future, the candidate will be responsible for designing, planning, and implementing those databases, including database creation, security, access, backup and recovery, and documentation.

• You must be experienced with applying STIGs to SQL Server databases and be familiar with the impacts on the related applications. 

• You must have excellent documentation skills, and will be responsible for creating related standards, operating procedures, and security documentation. 

Responsibilities:

• Database monitoring, maintenance, troubleshooting, and tuning

• Perform administration and management of Microsoft SQL Server 2012-2019 and Microsoft SQL Reporting Services

• Familar with SQL Always-on setup and management and Microsoft Failover Clustering

o Perform day-to-day monitoring and maintenance of SQL Server databases.

o Perform database and system performance monitoring and troubleshooting

• Database backup and recovery

o Develop, document, and apply procedures for database backup and recovery

o Perform scheduled and nonscheduled database backups and recovery with Microsoft SQL Server SSMS, or SQL CMD

• Database creation

o Participate in the analysis of database solutions o Responsible for the definition, design, creation, and implementation of a database environment with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security

• Systems Administration

o Evaluate and install new software releases, patches, and system upgrades

o Identify and troubleshoot system issues

o Develop, document, and apply procedures for systems backup and recovery

o May program in an administrative language (PowerShell, VBS, etc.)

o Perform ACAS and SCAP scans and remediation

o Assist Tier 2 help desk with issues elevated to systems administrators

o Create and update user accounts, perform accounts management in Active Directory

• Security and STIGs

o Support the Certification and Accreditation process - run scans; resolve findings; document solutions, workarounds or provide justifications for exceptions

o Document, implement, and maintain database security policies in accordance with DISA STIG requirements

• Documentation

o Define and oversee database standards, controls, procedures, and documentation

o Create all documentation required for Release Management Framework (RMF)

o Complete planning and documentation prior to new integration or implementation

• SSIS and PowerBI Re