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

Video Production & Digital Asset Coordinator

SGS Consulting
Illinois

Job Responsibilities: ~Manage digital archiving and trafficking of assets with accurate metadata. ~Write scripts and assist in video production for customer, dealer, and internal audiences. ~Su…

View Details
Posted 2025-12-02

Truck Driver CDL A

The Cary Company
Addison, IL

Know Your Way Around Chicagoland? Love Being Home for Dinner? This Job is for You! We're looking for a skilled CDL-A driver to join our team in Addison, IL. You'll enjoy a consistent schedule with …

View Details
Posted 2025-12-12

Apartment Maintenance Technician (Bloomington, IL)

Monarch Investment
Bloomington, IL

Description Do you want to work for a company that will help you advance your career? If so, then look no further! Monarch Investment and Management Group is the company for you. Monarch Investment…

View Details
Posted 2025-12-05

Finance Transformation Intern

USG Corporation
Chicago, IL

Company Overview USG, through our subsidiaries and joint ventures, is a leading manufacturer of building materials and innovative solutions that was originally formed in 1902. We produce a wide ra…

View Details
Posted 2025-12-19

Veterinarian

Crest Hill Animal Hospital
Crest Hill, IL

Ready for a Change or Starting Your Career? Join Our Team at Crest Hill Animal Hospital ! Whether you're an  experienced veterinarian looking for a fresh opportunity or a  new graduate ready to ki…

View Details
Posted 2025-12-19

Assistant Manager

Smoothie King
Tinley Park, IL

Main Responsibilities of a Store Manager Responsible for every aspect of everyday supervision of store outlets Responsible for resources management Takes care of stock, staff, and sales mana…

View Details
Posted 2025-10-18

Engineering Manager, AI Systems (Remote from Illinois)

jobgether
Illinois

This position is posted by Jobgether on behalf of a partner company. We are currently looking for a Engineering Manager, AI Systems in Illinois . In this role, you will lead the evolution of a c…

View Details
Posted 2025-12-22

CDL Class A driver Job

FEDEX GROUND FEDEX GROUND
Bedford Park, IL

CDL Class A driver Job IC in Fedex Ground hiring new TEAM DRIVERS dedicated runs 4-5days out 2-3 days HOME EVERY WEEK! -driver must have double/triple endosment -FROM 0-6 months MINIMUM EXPERIENCE …

View Details
Posted 2025-12-24

Retail Assistant Store Manager

Skechers
Rockford, IL

WHY SKECHERS? We offer a casual and creative atmosphere where, for over 30 years, Skechers has been renowned for its lifestyle, performance, accessories, and apparel collections for the whol…

View Details
Posted 2025-12-29

Construction Project Estimator

Weaver Consultants Group
Springfield, IL

Responsiblities Review and analyze drawings, specifications, proposals, and other documents to accurately create a budget proposal to the client. Prioritize and organize deadlines for bidding r…

View Details
Posted 2025-12-20