What are the responsibilities and job description for the SQL Database Engineer position at TEKsystems?
TEKsystems has a client that is seeking a SQL Server DBA:
* 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
oEquivalent 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
oEquivalent 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.
Salary : $60 - $70
