Senior Database Administrator Job at KonnectIT, Chicago, IL

QTErd0lMTUYydXRpOVpieVNzWXVHVlpyVEE9PQ==
  • KonnectIT
  • Chicago, IL

Job Description

Job Description

Job Description

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.

Job Tags

Similar Jobs

18 under

5 English teachers needed in Shenyang Job at 18 under

5 English teachers needed in ShenyangTravel at no cost. Relocation bonus available What should you know about our school: Founded...  ...2 - 15 years old in a fun, motivating, and entirely English speaking environment.The company is flourishing and expanding across... 

Stryker

2026 Summer Intern Regulatory Affairs California Job at Stryker

 ...important as developing life-changing medical technologies. As an intern, you won't just observe you'll contribute to meaningful...  ...to make healthcare better. Opportunities Available: As a Regulatory Affairs (RA) intern at Stryker, you will gain exposure to global regulatory... 

Gravity Well

Remote 3D Character Artist Job at Gravity Well

 ...artist with us. You will work closely under our Art Team leadership and multiple other disciplines in order to help meet the needs for animation and gameplay while balancing artistic goals. What You'll Do: Create stylized 3D characters, creatures and related props,... 

Advance Auto Parts

DIY Auto Parts Pro — Advanced Sales & Service Job at Advance Auto Parts

 ...automotive company in Rochester, NY is seeking a Retail Parts Pro to provide exceptional service and support advanced functions of the DIY business. The ideal candidate...  ...time role offers a competitive hourly wage and comprehensive benefits.#J-18808-Ljbffr Advance Auto Parts

Stability Healthcare

Local Contract Neuro Acute Epilepsy Monitoring RN (Telemetry) Job at Stability Healthcare

 ...Healthcare is looking for a Telemetry RN contract position in Phoenix, AZ. Telemetry nurses care for patients by using medical equipment to monitor blood pressure, heart rate, blood oxygen level, breathing rate, and other vital signs. Commonly, these patients have recently...