What are the responsibilities and job description for the SQL Database Engineer position at TEKsystems c/o Allegis Group?
Job Details
TEKsystems has a client that is seeking a SQL Server DBA:
Design, implement and maintain database architectures and strategies to ensure performance, availability, integrity and security of company databases. Monitor and improve database performance and capacity utilization to provide high database availability and redundancy. Plan and execute future expansion requirements including the installation and testing of DBMS upgrades and patches when needed. Deploy security measures to safeguard all internal databases.
Analyze and tune database for optimal efficiency.
Analyze and sustain capacity and performance requirements, including effective use of indexes, enabling parallel query execution, and other DBMS features, such as query store.
Create and maintain scripts for DBA task automation.
Create, test and execute database management plans and SQL jobs.
Develop database utilities and automated reporting.
Monitor systems and platforms for database health, availability and optimum performance. Provide 24/7 support for critical situations as part of an on-call rotation.
Design, implement and oversee database backup and recovery plans, replication and high availability architectures.
Work with software design and development teams in designing database architectures and data modeling, building database schemas, tables, procedures and views.
Interact with and coach developers in SQL scripting and with database performance considerations.
Evaluate, install and test DBMS upgrades and patches for DBMS software, application software, and other software related to DBMS administration.
Work with the system administrators for hardware and software installations and configurations. Implement and administer DBMS security.
Add and remove users, administer roles and permissions, audit, and check for security problems.
Evaluate and recommend new database technologies, database server and storage hardware, DBMS tools and utilities.
Additional Skills & Qualifications
Bachelor's Degree in Computer Science or other related field
o Equivalent combination of education, experience and/or applicable military experience will be considered
Minimum 10 years' experience as a SQL Server DBA in an enterprise environment
Proven experience in design, analysis, development, enhancement, automation, tuning and optimizing databases for high availability, performance and security
Experience in administration and support of MS SQL Server in production, testing and development environments, including backup and recovery procedures, replication and Always On
Must have extensive operational experience implementing and maintaining multiple relational databases including backup and recovery procedures, replication and clustering
Experience with SQL 2016 - 2022
Experience with Windows 2016 - 2022
Expert knowledge of MS SQL Management Studio
Thorough knowledge of Microsoft SQL Server database management systems architecture
Thorough knowledge of the techniques and methodologies of data management systems, including relational, network and hierarchical systems
Thorough understanding of database I/O and memory allocation and tuning methods
Knowledge of database security and auditing functions
Attention to detail
Strong analytical skills and creativity in troubleshooting and problem-solving
Strong oral and written communications skills
Ability to perform in a self-directed and well-organized manner
Ability to manage multiple projects/issues concurrently, and to meet tight deadlines
Ability to work in a fast paced constantly evolving workplace
Ability to interact with a diverse group of IT professionals including developers, architects, business and data analysts, system and security administrators
Pay and Benefits
The pay range for this position is $60.00 - $70.00/hr.
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 fully remote position.
Application Deadline
This position is anticipated to close on Apr 15, 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.
- Architecture and management of enterprise level SQL Server Always-On High Availability groups. (SQL 2016 or higher).
- In-depth knowledge of data security with regards to Confidential Unclassified Information.
- Deep knowledge of SQL waits, locking, blocking and resource contention.
- Extensive experience with change management systems, such as ServiceNow and Jira.
- 10 years of proven experience as a Principal Data Engineer in an enterprise-level environment.
- 5 years of proven experience as a SQL Server architect/Principal Data Engineer with experience in design, implementation, and management of SQL Server High Availability Groups with disaster recovery on SQL Server 2016 or higher.
- Prior experience with federal contracts, including STIG, NIST, SOC auditing, CUI, PII/PHI.
- Current security clearance and/or Security certification is a plus.
Design, implement and maintain database architectures and strategies to ensure performance, availability, integrity and security of company databases. Monitor and improve database performance and capacity utilization to provide high database availability and redundancy. Plan and execute future expansion requirements including the installation and testing of DBMS upgrades and patches when needed. Deploy security measures to safeguard all internal databases.
Analyze and tune database for optimal efficiency.
Analyze and sustain capacity and performance requirements, including effective use of indexes, enabling parallel query execution, and other DBMS features, such as query store.
Create and maintain scripts for DBA task automation.
Create, test and execute database management plans and SQL jobs.
Develop database utilities and automated reporting.
Monitor systems and platforms for database health, availability and optimum performance. Provide 24/7 support for critical situations as part of an on-call rotation.
Design, implement and oversee database backup and recovery plans, replication and high availability architectures.
Work with software design and development teams in designing database architectures and data modeling, building database schemas, tables, procedures and views.
Interact with and coach developers in SQL scripting and with database performance considerations.
Evaluate, install and test DBMS upgrades and patches for DBMS software, application software, and other software related to DBMS administration.
Work with the system administrators for hardware and software installations and configurations. Implement and administer DBMS security.
Add and remove users, administer roles and permissions, audit, and check for security problems.
Evaluate and recommend new database technologies, database server and storage hardware, DBMS tools and utilities.
Additional Skills & Qualifications
Bachelor's Degree in Computer Science or other related field
o Equivalent combination of education, experience and/or applicable military experience will be considered
Minimum 10 years' experience as a SQL Server DBA in an enterprise environment
Proven experience in design, analysis, development, enhancement, automation, tuning and optimizing databases for high availability, performance and security
Experience in administration and support of MS SQL Server in production, testing and development environments, including backup and recovery procedures, replication and Always On
Must have extensive operational experience implementing and maintaining multiple relational databases including backup and recovery procedures, replication and clustering
Experience with SQL 2016 - 2022
Experience with Windows 2016 - 2022
Expert knowledge of MS SQL Management Studio
Thorough knowledge of Microsoft SQL Server database management systems architecture
Thorough knowledge of the techniques and methodologies of data management systems, including relational, network and hierarchical systems
Thorough understanding of database I/O and memory allocation and tuning methods
Knowledge of database security and auditing functions
Attention to detail
Strong analytical skills and creativity in troubleshooting and problem-solving
Strong oral and written communications skills
Ability to perform in a self-directed and well-organized manner
Ability to manage multiple projects/issues concurrently, and to meet tight deadlines
Ability to work in a fast paced constantly evolving workplace
Ability to interact with a diverse group of IT professionals including developers, architects, business and data analysts, system and security administrators
Pay and Benefits
The pay range for this position is $60.00 - $70.00/hr.
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 fully remote position.
Application Deadline
This position is anticipated to close on Apr 15, 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Salary : $60 - $70
