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

Precision Tooling Machining Specialist - CNC Lathe and Wire EDM

Klein Tools Manufacturing
Elk Grove Village, IL

Are you the person who can turn a blueprint into a flawless die repair? If you thrive on tight tolerances, efficient setups, and tidy workspaces, this role is built for you. Your challenge Ca…

View Details
Posted 2025-12-18

Accounts Payable Specialist

Chemring Energetic Devices Inc
Downers Grove, IL

Description Description Be part of a growing team. Join Chemring Energetic Devices (CED) as we build products that protect our Country, protect the individual warfighter, and send rockets into ou…

View Details
Posted 2025-11-19

Automotive Service Advisor

McGrath KIA of Highland Park
Highland Park, IL

McGrath Kia of Highland Park is a leader in the automotive retail sales and service sector, and we're looking to add a Service Advisor. If you have what it takes to join our award winning team, apply …

View Details
Posted 2025-08-28

WAREHOUSE ASSOC II - SSC

Mohawk Industries
Elk Grove Village, IL

Join the largest manufacturer of tile and natural stone in the United States and watch your career stand out with Dal-Tile, a subsidiary of Mohawk Industries. Our close-knit team of dedicate…

View Details
Posted 2025-12-17

Senior Human Resource Generalist

LaSalle Network
Chicago, IL

LaSalle Network is hiring a Senior HR Generalist – Contract (6 Months). This Senior HR Generalist will step into a highly visible, hands-on role, partnering closely with leaders and employees across t…

View Details
Posted 2025-12-24

Quick Lane Technician

Sunset Ford of Waterloo
Waterloo, IL

Do you want to join a fast-paced, dynamic team? We’re seeking Quick Lube Technicians to join us at Sunset Ford of Waterloo. * We strongly encourage you to apply. We offer weekends off. We have Part…

View Details
Posted 2025-08-28

Full Time Class A Driver

Naperville, IL

Job Description Centerline is your one access point to limitless truck driving opportunities. Our job is to connect you with safe, rewarding work at top companies while maintaining your flexibilit…

View Details
Posted 2025-11-21

School Psychologist

Ampersand Therapy
Joliet, IL

School Psychologist – 2025–2026 School Year Ampersand Therapy is hiring a School Psychologist for the remainder of the 2025–2026 school year in Joliet, IL! We’re a therapist and women-founded comp…

View Details
Posted 2025-12-17

Au Pair

GreatAuPair LLC
Clarendon Hills, IL

Get hired for Adam's aupair Job in Clarendon Hills, IL. Chicago Suburbs Family Seeks AuPair. Find aupair care work in Clarendon Hills.

View Details
Posted 2025-11-12

Live-In Caregivers!

Always Best Care Senior Services - Naperville
Lisle, IL

Job Description Job Description Job Description     RELIABLE & EXPIERENCED LIVE-IN Caregivers who are looking shifts, either three days or four days, weekdays or weekends! NAPERVILLE, LISLE, AU…

View Details
Posted 2025-12-29