Sonoma Consulting Inc.
Technology & SoftwareDirect SmartRecruiters career site

SQL Server DBA (Local to IL)

Location
Rosemont, IL · On-site
Job type
Contract
Level
Lead / Staff
Experience
6+ years
Listed
Today

Skills & highlights for this role

  • SQL Server administration
  • T-SQL
  • performance tuning
  • backup and recovery
  • high availability and disaster recovery

Also useful

  • SSIS
  • SSRS
Free · No account needed

How well does your resume fit this job?

Upload your resume to see your score for this Sonoma Consulting Inc. role, what matches, what's missing, and your best other matches.

Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.

About the role

  • Title: Lead SQL Server DBA
  • Location: Rosemont, IL
  • Contract to Hire

General Position Summary

This is a non-supervisory position. The incumbent is responsible for the installation, configuration, maintenance, operation and support of SQL Server databases. Works as a team member on technical functions related to creating and maintaining databases, performance and tuning analysis, software upgrades, backup and recovery procedures. The incumbent will provide technical expertise and support to staff members within CTS and less experienced DBAs. Additional responsibilities are likely to include planning, development and troubleshooting.

The tasks and duties outlined below do not include all possible tasks and do not limit the assignment of tasks for these positions.

Duties and Responsibilities

  • Installation, configuration and upgrades of SQL Servers.
  • Monitor, optimize and report on system performance.
  • Develop, manage and test back-up and recovery plans.
  • Manage security of databases in production and test environments.
  • Assist developers in performance tuning of SQL statements.
  • Code migration of all objects following established change control procedures.
  • Create and refresh test database instances.
  • Provide on call 24 hour, 7 day per week database support for production databases.
  • Troubleshoot, investigate, offer and execute resolution to database issues.
  • Monitor and report on database storage utilization.
  • Create and execute various ad-hoc database queries, as needed.

Required Qualifications

  • Minimum 6 years SQL DBA experience
  • Recent experience in MS SQL Server versions 2008/2012/2014;
  • Experience in troubleshooting and resolving database problems;
  • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
  • Experience with backups, restores and recovery models;
  • Experience with SQL Server High Availability (HA) and Disaster Recovery (DR).
  • Extensive knowledge with T-SQL.
  • Experience implementing operational automation using scripts;
  • Expertise with SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
  • Strong verbal and written communication skills with the ability to interact professionally with all levels in the organization.
  • Education (R-Required, P-Preferred)
  • Certifications

Additional Information

Titles:SQL Server DBA, Lead SQL DBA, SQL Database Admin, SQL Server Database Admin

Skills: SQL DBA, PTO, Performance Tuning and Optimization, T-SQL, SSIS, SSRS,

About the Company

Sonoma Consulting is one of the fastest growing national IT Consulting and Executive Search company in the United States, which was founded in 2011 by Mark McGee, the President and CEO. Sonoma Consulting has two business divisions - IT Consulting Services & Executive Search to serve its 150 national clients which range from entrepreneurial start-ups to Global Fortune 500.

Read the original posting

From Sonoma Consulting Inc.'s careers page, first listed on Rolev.ai on November 19, 2026. Rolev.ai is not the employer.

How Rolev.ai helps with this application

Rolev.ai is a job search and application tool for US job seekers. For this SQL Server DBA (Local to IL) role at Sonoma Consulting Inc., it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.

  • See how you fit

    Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.

  • Tailor without inventing

    Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.

  • Draft the full kit

    Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.

  • 1-Click Extension Autofill

    The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.

Common questions

Where is the SQL Server DBA (Local to IL) job at Sonoma Consulting Inc. located?

This SQL Server DBA (Local to IL) position at Sonoma Consulting Inc. is located in Rosemont, IL (On-site). Always check Sonoma Consulting Inc.'s application page for specific state eligibility or relocation policies.

What qualifications are required for SQL Server DBA (Local to IL) at Sonoma Consulting Inc.?

For the SQL Server DBA (Local to IL) role, Sonoma Consulting Inc. highlights 6+ years of relevant experience; experience with SQL Server administration, T-SQL, performance tuning, backup and recovery, high availability and disaster recovery. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.

How do I apply for the SQL Server DBA (Local to IL) position at Sonoma Consulting Inc.?

This listing links directly to Sonoma Consulting Inc.'s SmartRecruiters application page. You can apply directly on Sonoma Consulting Inc.'s site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.