Senior SQL DBA - Contract

1872 Consulting; Chicago (IL); Remote; USD 90,000 - 120,000; Full time

Job summary

A leading consulting firm is seeking a Senior SQL Server DBA to support and maintain SQL Server environments. The ideal candidate will have extensive experience with SQL Server and proficiency in Transact-SQL. Responsibilities include troubleshooting, security administration, and collaboration with project teams. This role offers remote work initially, with opportunities for growth in a dynamic environment.

Qualifications

• 5+ years of SQL Server DBA experience.
• Experience with SQL Server 2014-2019 and SSIS packages.

Responsibilities

• Support and maintain SQL Server environments.
• Troubleshoot performance problems and administer security.
• Develop and maintain documentation for systems.

Skills

SQL Server

Transact-SQL

Database Administration

Troubleshooting

Tools

SSIS

SSRS

PowerShell

Idera

RedGate

SentryOne

Job description

Senior SQL Server DBA
Chicago, IL (Remote to start)

What you'll be doing

• Support, administer, and maintain development, test, and production SQL Server environments.
• Work with project teams comprised of project managers, developers, application vendors, application engineers, and application users to provide DBA support for database deployments and upgrades.
• Create and maintain SQL Server Integration Services (SSIS) packages.
• Review, deploy, and administer security for SQL Server Reporting Services (SSRS) reports.
• Troubleshoot server and database performance problems and identify solutions to resolve the problems.
• Administer SQL Server security and protect sensitive data.
• Adhere to the Firm's IT Service Delivery standards and Change Control processes.
• Adhere to the Firm's Security and Governance requirements across all administered applications.
• Develop and maintain troubleshooting, configuration, and integration documentation for administered systems.
• Function as a primary or backup DBA for assigned applications. Have a working knowledge of all database applications.
• Work with server engineers, storage engineers, and network engineers to resolve issues and prevent downtime.

Requirements

• 5+ years of experience with SQL Server DBA experience

• Ideally experience with: SQL Server 2014, 2016, 2017, and 2019.
• Proficiency with Transact-SQL including the ability to write, debug, and maintain scripts, stored procedures, functions, and views.
• Experience configuring and maintaining replication, log shipping, and availability groups.
• Experience installing and configuring SQL Server on virtual machines.
• Experience developing SSIS packages.
• Experience optimizing and administering SSRS reports.
• A solid understanding of normalized database design and modeling.

Nice to have experience

• A working knowledge of Idera, RedGate, and SentryOne database tools.
• Proficiency with PowerShell scripting.