SQL DBA

Job Requirements Norfolk, VA Secret Polygraph not specified Early Career (2+ yrs experience) Salary not specified Join Premium to unlock estimated salaries

Job Description Job Responsibilities:

• Manage and maintain all required security level/posture of all MS SQL Servers.
• Servers must be IA compliant to the latest policies and standards (i.e. STIG, IAVA, etc.)
• Document and generate report on all changes applied to MS SQL Servers.
• Provide assistance in the processing and submission of C&A for MS SQL Servers.
• Provide recommendation on industry best practices in the use of MS SQL Server and upcoming trends in database design implementation and sustainment.
• Manage and maintain all MS SQL services to ensure that they are always at peak performance (greater than 99.99%).
• Improve slow performing database(s) and/or code(s) to attain their peak performance throughout the life cycle of the database.
• Must ensure that all Transact-SQL code are bug free and executes effectively and efficiently.

Develop and maintain Analysis Services (such as

DAX, OLAP/MOLAP

), SQL Reporting Services, Data Transformation Services packages, Business Intelligence, Availability Groups, Clustering, and SQL Agent jobs. These items must be responsive and optimized to execute close to 99.99% efficiency.

• Manage and maintain all database backup and recovery. There must not be any loss of any data (in part or in whole). Provide effective and quality training and/or assistance to data analysts, coders/programmers (including pre-production co reviews), data modelers, managers, and users.
• Perform auditing, base lining/enhancing/optimizing/tuning (especially index tuning and custom statistics), monitoring and troubleshooting.
• Report to government lead about system conditions, failures and future needs.
• Plan configuration changes, future workloads, and future system resources that are aligned to government mission
• Support monthly ASIs and emergent outages.
• Develop POAM for all projects and tasks. In case of malfunctions, immediately report to government lead all issues and provide appropriate resolution or mitigation and associated documentation.
• Attend meetings either physical or virtual. Oversee and influence cloud service providers in infrastructure management and maintenance. Tasks may also include cloud infrastructure data migration, database application analysis and design, optimization testing, support and management of cloud infrastructure.
• Configure and perform daily backup and perform monthly restores to confirm backups
• Align SQL databases and servers with DOD ZeroTrust policy and architecture standards
• Participates in requirements gatherings and meetings.
• Plan, coordinate, and support migration effort according to changing technologies

Job Requirements:

• Bachelor Degree in Computer Science/Engineering or Associate Degree in Computer Science with additional 2 year experiences
• Minimum 8 years of experience as DBA in Microsoft SQL Server.
• Minimum 8 years of in-depth knowledge and experience in database theory and design.
• Minimum 8 years of in-depth experience in planning, implementing, administering and programming Microsoft SQL
• Minimum 4 years of in-depth knowledge and experience of Windows O/S, distributed computing architecture (client networking, storage area network (SAN), and Virtualization (Hyper-V and VMware).
• Experience in Microsoft .NET programming (C# or VB.NET)
• Minimum six years of in-depth knowledge and experience in Transact SQL and PowerShell.

Microsoft Certified Solutions Expert:

Data Platform or Microsoft Certified Solutions Expert:

Data Management and A MCSE certification must be one of the current published paths by Microsoft with emphasis on the platform or system supported in this PWS.

• Must have an active secret clearance
• Must have an IAT II certification which is typically a CompTIA Security+ group id: 10202776 N Name Hidden Senior IT Recruiter Apply now