What are the responsibilities and job description for the SQL DBA position at TEKsystems?
*Secret Clearance at minimum *
*IAT ll Certification (Security CE)*
*Must have Microsoft SQL Server 2016 cert or higher*
*Bachelor's 12 years of experience shown on resume *
*Master's 10 years of experience shown on resume *
*Hybrid work schedule- 2/3 days on site per week and must live local to area (1HR of Radford, VA.)*
*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
*Pay and Benefits*
The pay range for this position is $50.00 - $70.00
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
* Medical, dental & vision
* Critical Illness, Accident, and Hospital
* 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
* Life Insurance (Voluntary Life & AD&D for the employee and dependents)
* Short and long-term disability
* Health Spending Account (HSA)
* Transportation benefits
* Employee Assistance Program
* Time Off/Leave (PTO, Vacation or Sick Leave)
*Workplace Type*
This is a hybrid position in Radford,VA.
*Application Deadline*
This position will be accepting applications until Feb 7, 2025.
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.
*IAT ll Certification (Security CE)*
*Must have Microsoft SQL Server 2016 cert or higher*
*Bachelor's 12 years of experience shown on resume *
*Master's 10 years of experience shown on resume *
*Hybrid work schedule- 2/3 days on site per week and must live local to area (1HR of Radford, VA.)*
*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
*Pay and Benefits*
The pay range for this position is $50.00 - $70.00
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
* Medical, dental & vision
* Critical Illness, Accident, and Hospital
* 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
* Life Insurance (Voluntary Life & AD&D for the employee and dependents)
* Short and long-term disability
* Health Spending Account (HSA)
* Transportation benefits
* Employee Assistance Program
* Time Off/Leave (PTO, Vacation or Sick Leave)
*Workplace Type*
This is a hybrid position in Radford,VA.
*Application Deadline*
This position will be accepting applications until Feb 7, 2025.
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.
Salary : $50 - $70
