Senior Database Administrator

KonnectIT
Chicago, IL

We are seeking a Senior Database Administrator (DBA) with more than six years of experience supporting enterprise database environments. The ideal candidate will have deep expertise in SQL Server (2008–2022) administration, performance tuning, and troubleshooting, with advanced skills in SSIS, HA/DR solutions, database security, automation, and data integration . This role involves not only managing mission-critical databases but also mentoring junior DBAs, guiding modernization initiatives, and ensuring compliance with industry standards.

Key Responsibilities

Lead administration, monitoring, and optimization of SQL Server (2008–2022) environments.

Develop, deploy, and optimize SSIS packages for ETL and data warehouse integration.

Architect and maintain High Availability (HA) and Disaster Recovery (DR) solutions, including Always On, Log Shipping, Clustering, and Replication .

Ensure database compliance with security best practices , encryption, and regulatory standards.

Oversee logical and physical database design, creation, maintenance, and integrity .

Manage backup, recovery, and failover strategies for critical systems.

Automate administration tasks using PowerShell scripting .

Provide administration support for MySQL databases.

Mentor junior DBAs and collaborate across teams to improve performance and reliability.

Contribute to database modernization projects (cloud migrations, automation, advanced monitoring).

Mandatory Skills

Extensive expertise in SQL Server (2008–2022) administration, optimization, and troubleshooting.

Strong skills in SSIS development, deployment, and tuning .

Proven experience with HA/DR solutions : Always On, Log Shipping, Clustering, Replication.

In-depth knowledge of database security best practices (encryption, compliance, auditing).

Proficiency with PowerShell scripting for database automation.

Experience with data warehouse integration .

Hands-on experience with MySQL administration .

Desirable Skills

Experience architecting cloud-based database solutions (Azure SQL, AWS RDS).

Familiarity with automation/orchestration frameworks (Ansible, Terraform).

Advanced knowledge of performance monitoring and tuning (SQL Profiler, Extended Events, third-party tools).

Proven ability to design database roadmaps for modernization and scalability.

Leadership experience mentoring DBAs or contributing to cross-functional IT strategy.

Exposure to big data technologies (Hadoop, Spark) and modern data pipelines.

Posted 2025-09-29

Recommended Jobs

Applied AI Engineer & Researcher

Speechify
Champaign, IL

PLEASE APPLY THROUGH THIS LINK: DO NOT APPLY BELOW The mission of Speechify is to make sure that reading is never a barrier to learning. Over 50 million people use Speechify's text-to-speec…

View Details
Posted 2025-09-22

Speech Language Pathologist (SLP)

The Grand at Batavia
Batavia, IL

The Grand Rehabilitation and Nursing at The Grand at Batavia is currently seeking a Speech Language Pathologist (SLP) Job Title: Speech Language Pathologist (SLP) Position Type: Per-Diem Pay Range: …

View Details
Posted 2025-09-30

NSC Awards Manager

National Safety Council
Itasca, IL

Save lives, from the workplace to anyplace. The National Safety Council is America’s leading nonprofit safety advocate.  We focus on eliminating the leading causes of preventable injuries and deat…

View Details
Posted 2025-11-13

Commercial Cleaner

Building Value Cleaning Services Co
Hickory Hills, IL

Job Description Job Description We are seeking a Commercial Cleaner to join our team! You will be responsible for maintaining a clean and orderly environment. We are hiring in South Holland, I…

View Details
Posted 2025-07-28

Assembly Operator

Aerotek
Cary, IL

Job Description Job Description Job Title: Assembly Operator 1st: 8:20am - 4:30pm 2nd: 4:20pm - 12:30am 3rd: 12:20am - 8:30am Job Description We are seeking dedicated Assembly Operato…

View Details
Posted 2025-11-07

Full Time Faculty - Welding (Tenure Track, Fall 2026)

College of DuPage
Glen Ellyn, IL

Full Time Faculty - Welding (Tenure Track, Fall 2026) Full Time Faculty - Welding (Tenure Track, Fall 2026) The College of DuPage is a comprehensive community college located 27 miles west of d…

View Details
Posted 2025-11-06

Cook - UChicago Medicine - Ingalls Patient Svc & Retail

Aramark
Harvey, IL

Do you love to cook? Are you passionate about food? As a Cook on our team, you’ll help bring recipes to life while being able to flex your creativity! Surrounded by fresh ingredients and the best equ…

View Details
Posted 2025-09-24

Front end developer - web developer html

Creative Circle
Vernon Hills, IL

This job was posted by : For more information, please see: Web Programmer \ \ Position Overview \ Our well-known biopharmaceutical client is seeking a Front End Developer to join their team…

View Details
Posted 2025-11-12

Assistant Manager Hair Stylist

Supercuts + Cost Cutters
Elk Grove Village, IL

Job Description Job Description   Join the best team in the hair industry! Our Supercuts salons are fun and fashionable! We have a fast growing client base to make your career successful! If …

View Details
Posted 2025-11-06

Sanitation Supervisor

All About Personnel
Bensenville, IL

Job Description Job Description Position Summary: We are seeking an experienced and hands-on Sanitation Supervisor to oversee all sanitation operations within our food manufacturing facility…

View Details
Posted 2025-11-08