Description:
Position Requirements: This position is for a Microsoft SQL Server database administrator. The successful candidate will maintain SQL Server databases in enterprise environments consisting of approximately 2000 Windows servers. This position is responsible for development and sustainment of SQL Server 2019 Microsoft Failover Clusters. The successful candidate will standardize, consolidate, and optimize the existing SQL Server environments and monitor and maintain database performance. The successful candidate will also collaborate with internal and external customers to gather requirements for special processing, and work and track issues to resolution using an in-house ticket system. Responsibilities include: • Design, install, configure, audit, and maintain highly available enterprise database systems • Monitor backups on all SQL Server databases • Perform routine disaster recovery testing scenarios • Troubleshoot and maintain database performance, including the proposal of short term fixes, long term solutions, and the regular scheduling of index maintenance and database integrity checks • Establish and maintain database policies and standards • Generate database schema definitions and modifications as required • Refresh data from one processing environment to another as required • Develop, follow, and maintain team documentation for repeatable processes, including database feature installation, disaster recovery, and common problem resolution • Adhere to ITIL (Information Technology Infrastructure Library) practices for Change Management • Work trouble tickets • Participate in security audits • Strong interpersonal skills, including the demonstrated ability to be a team player • Participate in 24x7 on-call support rotation Desired Skills: • Experience with DoD (Department of Defense) Security Technical Implementation Guides (STIGs), Security Readiness Review (SRR) scripts, and Information Assurance Vulnerability Management (IAVM) • Experience with PowerShell (5.1 or higher) • Experience with Microsoft Azure • Experience with script-based automation
Skills:
SQL DBA, Secret Clearance, Windows server 2016, SQL Server 2019, SQL Server High Availability, DOD stigs, PowerShell, MS Azure, Automation
Top Skills Details:
SQL DBA,Secret Clearance,Windows server 2016,SQL Server 2019,SQL Server High Availability
Additional Skills & Qualifications:
Must have active Secret Clearance Must have Sec+ before starting- or any IAT Level II certification Must have Microsoft SQL Server 2016 cert or higher
Experience Level:
Expert Level
About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
We are an equal opportunity employers and will consider all applications without regard to race, genetic information, sex, age, color, religion, national origin, veteran status, disability or any other characteristic protected by law. To view the EEO is the law poster click here. Applicants with disabilities that require an accommodation or assistance a position, please call 888-472-3411 or email [email protected]. This is a dedicated line designed exclusively to assist job seekers whose disability prevents them from being able to apply online. Messages left for other purposes will not receive a response.