Job Description
TECHEAD is celebrating over thirty-five years of incredible heritage, talent, and accomplishments! To learn more about TECHEAD, visit us at TECHEAD.com or on Glassdoor.
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's mission is to make our on-site associates successful by placing them in the right environment so they can grow and prosper. How we treat and respond to our clients and employees is a reflection of who we are and makes us stand out from the rest. Keeping our business focused on building and maintaining relationships with our employees and clients is the key to our success. We won't strive for anything less.
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.
For more information on TECHEAD please visit www.techead.com.
No second parties will be accepted.