What are the responsibilities and job description for the SQL DBA position at TEKsystems?
Role: SQL DBA
Location: Montgomery, AL 100% onsite
Rate: Up to $70/HR
Duration: long term contract (renews annually)
Position Description
The resource in this position will handle database administration for mission critical transactional and Datawarehouse SQL servers with a significant focus on continuous improvement and technology strategy. The resource manages and maintains all production and non-production databases; responsible for standards and design of physical data storage, maintenance, access and security administration; performs backup and recovery on Database Management Systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements. This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost. Additionally, this position will handle web administration for mission critical web servers with a significant focus on web applications' deployment ,connectivity and maintenance. This will include expert escalation for troubleshooting production issues, assists in development lifecycle, capacity management and strategy, operational standards and procedures, stabilization and optimization, performance tuning and monitoring, standards identification and compliance, continuous improvement, and security enhancement. The Database Administrator (DBA) in this position must have passion for data, databases, web applications, and bring expertise to help us deliver best in class data delivery solutions.
Skills Required
Intermediate professional level role. Supports multiple services and multiple databases of medium to high complexity (complexity defined by database size, technology used, systems feeds and interfaces) with multiple concurrent users, ensuring control, integrity and accessibility of data. Works on multiple projects as a project leader or sometimes as a project advisor. May coach more junior technical staff. Advanced knowledge in MS SQL Server and Datawarehouse, MS Internet Information Services (IIS), PowerBI and SSAS; advanced knowledge in creating, deploying, and monitoring SSIS packages; good knowledge on maintaining SQL report servers (SSRS); good knowledge with SQL server encryption; familiar with industry-level best practices for Microsoft SQL Server security standards; expert knowledge on backup & recovery; expert knowledge of on-prem to cloud migration; good knowledge of Azure, industry standard server hardware, operating systems, storage, virtualization, and networking technologies; familiar with PowerShell, database source control and continuous integration tools; familiar with RedGate, Tableau and Idera Data Architect tools; strong problem solving skills and a commitment to getting things done right; eagerness to learn and help others; good written and verbal communication skills and professionalism.
Skills Preferred
Power BI capacity Admin, connecting gateways to data sources, granting access permissions, creating workspaces, publishing Power BI reports and dashboards. Familiar with Snowflake; strong teamwork and interpersonal skills with the ability to communicate and persuade to all levels of management.
Experience Required
8 years of experience in working as MS SQL Server database administrator and database internals, with strong focus in SQL Server 2016, 2019, and 2022; 8 years in SQL Server database performance tuning along with good understanding of indexing, execution plans, DMV, database storage, database problem identification, problem diagnosis and resolution; 8 years writing scripts or using leading tools to monitor, perform backup & recovery, and maintenance automation; hands on experience in on-prem to cloud migration; hands on experience in creating and troubleshooting SSIS packages; 5 years of experience in performing code; 5 years of experience with MS Internet Information Services (IIS) with strong focus on server administration and web applications deployment.
Experience Preferred
5 years of experience with creating SSIS packages.
Education Required
Bachelor's Degree in Computer Science, Information Systems, or other related field.
Education Preferred
Microsoft Certification in SQL Server Database Administration.
Additional Benefit Info:
oEligibility 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)
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.
Location: Montgomery, AL 100% onsite
Rate: Up to $70/HR
Duration: long term contract (renews annually)
Position Description
The resource in this position will handle database administration for mission critical transactional and Datawarehouse SQL servers with a significant focus on continuous improvement and technology strategy. The resource manages and maintains all production and non-production databases; responsible for standards and design of physical data storage, maintenance, access and security administration; performs backup and recovery on Database Management Systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements. This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost. Additionally, this position will handle web administration for mission critical web servers with a significant focus on web applications' deployment ,connectivity and maintenance. This will include expert escalation for troubleshooting production issues, assists in development lifecycle, capacity management and strategy, operational standards and procedures, stabilization and optimization, performance tuning and monitoring, standards identification and compliance, continuous improvement, and security enhancement. The Database Administrator (DBA) in this position must have passion for data, databases, web applications, and bring expertise to help us deliver best in class data delivery solutions.
Skills Required
Intermediate professional level role. Supports multiple services and multiple databases of medium to high complexity (complexity defined by database size, technology used, systems feeds and interfaces) with multiple concurrent users, ensuring control, integrity and accessibility of data. Works on multiple projects as a project leader or sometimes as a project advisor. May coach more junior technical staff. Advanced knowledge in MS SQL Server and Datawarehouse, MS Internet Information Services (IIS), PowerBI and SSAS; advanced knowledge in creating, deploying, and monitoring SSIS packages; good knowledge on maintaining SQL report servers (SSRS); good knowledge with SQL server encryption; familiar with industry-level best practices for Microsoft SQL Server security standards; expert knowledge on backup & recovery; expert knowledge of on-prem to cloud migration; good knowledge of Azure, industry standard server hardware, operating systems, storage, virtualization, and networking technologies; familiar with PowerShell, database source control and continuous integration tools; familiar with RedGate, Tableau and Idera Data Architect tools; strong problem solving skills and a commitment to getting things done right; eagerness to learn and help others; good written and verbal communication skills and professionalism.
Skills Preferred
Power BI capacity Admin, connecting gateways to data sources, granting access permissions, creating workspaces, publishing Power BI reports and dashboards. Familiar with Snowflake; strong teamwork and interpersonal skills with the ability to communicate and persuade to all levels of management.
Experience Required
8 years of experience in working as MS SQL Server database administrator and database internals, with strong focus in SQL Server 2016, 2019, and 2022; 8 years in SQL Server database performance tuning along with good understanding of indexing, execution plans, DMV, database storage, database problem identification, problem diagnosis and resolution; 8 years writing scripts or using leading tools to monitor, perform backup & recovery, and maintenance automation; hands on experience in on-prem to cloud migration; hands on experience in creating and troubleshooting SSIS packages; 5 years of experience in performing code; 5 years of experience with MS Internet Information Services (IIS) with strong focus on server administration and web applications deployment.
Experience Preferred
5 years of experience with creating SSIS packages.
Education Required
Bachelor's Degree in Computer Science, Information Systems, or other related field.
Education Preferred
Microsoft Certification in SQL Server Database Administration.
Additional Benefit Info:
oEligibility 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)
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 : $70
SQL Server DBA
Eagle Eye Technologies -
Montgomery, AL
Sr. Oracle DBA Sr. PL/SQL Developer
Koniag Management Solutions -
Montgomery, AL
Sr. MS SQL Server Database Developer, MARKS Operational DBA
Koniag Management Solutions -
Montgomery, AL
