SQL Server DBA (Local to IL)
At a glance
Mid-level Data Architecture & Governance role at Sonoma Consulting Inc. Rosemont · full-time · no salary stated · we estimate $97,988–$155,000 across the United States.
Sonoma Consulting Inc. has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Install, configure and upgrade SQL Server, then monitor performance and report on system health
- Build and test backup and recovery plans, while managing database security across production and test environments
- Help developers tune SQL statements and move database objects through established change controls
- Refresh test databases, investigate database problems and run requested ad-hoc queries
- Provide round-the-clock production database support, including on-call troubleshooting and storage monitoring
What you bring
- At least six years working as a SQL Server DBA
- Recent work with SQL Server versions 2008, 2012 or 2014, plus strong T-SQL knowledge
- Hands-on background in performance tuning, backup and recovery, and SQL Server high availability and disaster recovery
- Experience automating operations with scripts and using SSIS and SSRS
Who this fits
This is a non-supervisory DBA role for someone comfortable supporting production databases on call at any hour, every day of the week. The position is onsite in Rosemont, Illinois, and the listing calls for a local candidate.
From the employer
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.
Title: Lead SQL Server DBA
Location : Rosemont, IL
Contract to Hire
Description:
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
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,
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.