SQL Database Administrator

Microsoft SQL Server (MSSQL) Database Administrator (On-Site)

Norfolk, VA $-$ 2 months ago

TECHEAD is celebrating over thirty-five years of incredible heritage, talent, and accomplishments! To learn more about TECHEAD, visit us at or on Glassdoor
.

Seniority level:
Mid-Senior level

Employment type:

Full-time

Job function:
Information Technology

Industries: IT Services and IT Consulting

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.

TECHEAD provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws governing non-discrimination in employment in every location in which the company has facilities.

This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

No second parties will be accepted.

Apply BELOW