Senior Database Analyst

Senior Database Analyst

12 Month Contract
Onsite in Norfolk, VA
Must Hold active Top Secret Clearance

Responsible for performing as a Senior Database Base Analyst for Microsoft SQL solutions in both NIPR and SIPR, QA and production environments

Responsibilities:

• Participates in the design, maintenance, enhancement, coding, and administration of relational databases


• Performs day-to-day SQL administration; maintenance, troubleshooting, repair, ensuring data availability


• Performs Database Backup and Recovery functions as needed


• Installs SQL SW, Instances and perform upgrades and patching as needed


• Writes/maintains SQL scripts and processes as needed


• Creates indexes to enhance performance


• Designs/implements data transfer processes needed to support upgrades or movement to from different physical/virtual Machine/OS


• Authors/maintains System Security Plans, white papers and change management proposals, SOPs


• Creates, manages and performs troubleshooting Windows Clustering and SQL Server high-availability solutions


• Creates and monitors SQL Server Policy Objects


• Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities.


• Coordinates new data development ensuring consistency and integration with existing data warehouse structure.


• Monitors Ticketing System queue for DBA assignments


• Participates in continuous improvement efforts in enhancing performance and providing increased functionality, including performing proactive maintenance such as ensuring continued space availability, monitoring activity, and documenting problems, changes, and solutions.


• Assignments may include design of data dictionaries, database structure and layout, installing, upgrading, and managing database applications.


• May provide guidance and work leadership to less-experienced Analysts.


• Stay current on vendors' best security practices in relation to organizational requirements.


• Maintains current knowledge of relevant technologies as assigned.


• Monitors SQL Event Logs and use to identify/troubleshoot issues


• Creating and managing SQL Server Maintenance Plans for routine tasks and backup solutions as well as ability to create, troubleshoot and monitor SQL Server Agent jobs


• Reviews database jobs, backup logs, user connections and system memory


• Reviews performance information for SQL instances


• Completes STIG Checklists for SQL servers

Education:

• Bachelor Degree in Computer Science or a related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience required.

Required Qualifications:

• Minimum 8-10 years of directly related experience in in Systems or Bachelor of Science in IT Discipline and 6 years' experience.


• Experience with Microsoft SQL Server in Microsoft clusters.


• Hands-on STIG/SCAP experience required.


• Active DOD Secret clearance required; SSBI required


• Current Security certification required.

Preferred Qualifications:

• Microsoft SQL 2012 and MySQL administration


• Microsoft Operating Systems (Windows Server 2008/2012, Windows 10 SHB, etc.) a plus


• T-SQL scripting knowledge


• PowerShell a plus


• Understanding of IT Security best practices to meet DOD STIGs