Senior SQL Database Administrator

Rosemont, IL


Apply Save

Type: Contract

Category: Administrative

Reference ID: 10064572

Shortcut: http://addisongroup.gosnaphop.com/bWGuwd


Job Title: Senior SQL Database Administrator (Hybrid 70% On-Prem & 30% Azure)

Location: Rosemont, IL 

Compensation: $60-$65 / hour – W2 Candidates only

Benefits: This position is eligible for medical, dental, vision, and 401(k). 


Overview

We are seeking a Senior SQL Database Administrator to manage and optimize a hybrid environment spanning on-premises SQL Server and Azure SQL platforms. This role supports enterprise applications, reporting systems, and large-scale

clinical/registry datasets.

The ideal candidate is hands-on, technically strong, and comfortable working across administration, performance tuning, modernization initiatives, upgrades, and cross-functional collaboration with development, BI, infrastructure, and

security teams.


Key Responsibilities

Database Administration & Platform Management

* Administer SQL Server environments across DEV, QA, UAT, SUP, and PROD

* Support SQL Server versions 2016–2022, Azure SQL Database, Managed Instance, and Analysis Services

* Implement and maintain security controls including backups/restores, TDE encryption, certificates, data masking, and access management

* Monitor system health (CPU, memory, storage) and troubleshoot outages and job failures


Performance Tuning & Optimization

* Diagnose and resolve slow queries, blocking, deadlocks, and timeouts

* Utilize Query Store, Extended Events, sp_BlitzFirst, sp_WhoIsActive, and execution plans

* Optimize indexing strategies, stored procedures, and workload scheduling

* Partner with developers to improve query performance and deployment quality


Deployment & Release Support

* Support after-hours/midnight releases and production change execution

* Execute and validate deployment scripts and DACPAC releases

* Ensure schema consistency across environments

* Reduce technical debt by decommissioning unused databases and optimizing Azure costs


Data Integration, ETL & Reporting

* Maintain and troubleshoot SSIS packages, staging tables, incremental loads, and linked servers

* Support SSRS configurations, data gateways, CRM data sources, and report publishing

* Collaborate with BI teams on data flow stability and reporting performance


Data Governance, Security & Compliance

* Validate PHI/PII masking in non-production environments

* Maintain compliance with internal governance and security policies

* Partner with data management and BI teams to safeguard sensitive data

* Contribute to governance documentation and annual planning initiatives


Upgrades, Patching & Infrastructure

* Apply cumulative updates using documented runbooks

* Lead SQL version upgrades, migrations, refreshes, and consolidations

* Collaborate with infrastructure teams on capacity planning and resource expansion


Troubleshooting & Incident Response

* Investigate outages, recovery issues, blocked jobs, and optimization failures

* Diagnose SQL service, storage, network, and concurrency issues

* Provide root cause analysis and document remediation actions


Cross-Team Collaboration

* Partner with DevOps, BI, Infrastructure, Security, and application teams

* Support users across enterprise platforms and custom applications

* Participate in workshops and present environment health updates


Documentation & Automation

* Maintain inventories of SQL Servers, Azure SQL DBs, ADF factories, VMs, and

metadata

* Develop automation for monitoring, alerts, and ticket creation (Jira/ADO)

* Document deployment steps, upgrades, tuning actions, and change logs


Required Skills & Experience

Databases

* SQL Server 2008–2022

* Azure SQL Database & Managed Instance

* Analysis Services


Performance & Monitoring

* Query Store

* Extended Events

* sp_BlitzFirst

* sp_WhoIsActive

* Plan Explorer


ETL & Reporting

* SSIS

* SSRS

* Azure Data Factory (ADF)

* Microsoft Integration Runtime


Scripting & Automation

* T-SQL

* PowerShell


Security & Governance

* Transparent Data Encryption (TDE)

* Data masking

* Certificates and key management


Operations & Processes

* SQL Agent job management

* Index maintenance (IndexOptimize)

* Capacity planning and resource monitoring

* Jira/ADO, CAB/change processes, incident response



Nice to Have

* Experience supporting clinical, registry, or large-scale regulated datasets

* Azure cost optimization experience

* Modernization or cloud migration projects

* Strong documentation and automation mindset


Addison Group is an Equal Opportunity Employer. Addison Group provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. Addison Group complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. Reasonable accommodation is available for qualified individuals with disabilities, upon request.


IND 005-010

  • Senior BI Developer

    Dallas, TX

    Title: Senior BI Developer Location: Dallas, TX Salary: $130k-$150k / year FTE exempt No sponsorship available Benefits: health insurance disability insurance life insurance retirement plans (like a 401(k)) paid time off (PTO) including vacation and si...

    Recommended

  • Data Engineer - Azure Databricks (minimum 1 day Hybrid in Maryland)

    Silver Spring, MD

    Position: Data Engineer (Databricks/Cloud Data Pipelines/Azure) Location: Mostly Remote but Hybrid – 20% Onsite in Montgomery County, MD - near Northern DC metro area) Contract-to-Hire (Candidates must be willing to convert to FTE after contract period...

    Recommended

  • Data & Application Developer

    Oklahoma City, OK

    Job Title: Data & Application Developer Location: Oklahoma City, OK (on-site) Salary Range: $100,000 - $200,000 / year depending on experience. Benefits: The position is eligible for medical, dental, vision, and 401(k). **Must be authorized to work in ...

    Recommended

  • Sr. Data Engineer

    Anywhere

    Job Title: Sr. Data Engineer Location: Phoenix, AZ Job Type: Full Time Compensation: $130,000 - $150,000 DOE Benefits: The position is eligible for medical, dental, vision, and life insurance coverage, & PTO Senior Data Engineer ROLE OVERVIEW The Senio...

    Recommended

  • Head of AI & Data Science

    Austin, TX

    Job Title: Head of AI & Data Science Location: Austin, TX - must be local and able to be onsite 3 days per week (Mon, Tues & Thurs) Duration: 6 month contract-to-hire Compensation: $150,000 - $160,000 / Annually Work schedule: Monday-Friday (8 AM-5PM C...

    Recommended

  • Senior Network Engineer and Cloud Architect

    District of Columbia

    Title: Senior Network Engineer and Cloud Architect Location: Remote - Must live in the Mid-Atlantic or NC, GA, or FL / 25–30% travel required Job Type: Full-Time | Exempt Salary: $140000 - $170000/ Year Benefits: This position is eligible for medical, ...

    Recommended

  • IT Support Engineer II

    Bee Cave, TX

    Job Title: IT Support Engineer II Location: Austin, TX Duration: Direct-hire Compensation: $80k - 90k / year Work schedule: Monday-Friday (8 AM-5PM CST) - onsite 3x per week Benefits: This position is eligible for medical, dental, vision and 401(k) The...

    Recommended

  • Senior Data Engineer

    Dallas Metro Area, Texas

    Title: Senior Data Engineer Location: Coppell, TX Salary Range: $120K-$140K We are looking to bring on a Senior Data Engineer to our team due to growth. What we need is someone who comes 8+ years of experience in the Data Engineering space who speciali...

    Recommended

  • QA Engineer

    Coppell, TX

    Title: QA Engineer Location: Coppell, TX Salary Range: $115K-$130K We are looking to bring on a QA Engineer due to new growth within our organization. This person will need to bring 6+ years of QA Engineering experience to make an immediate impact to t...

    Recommended

  • IT Specialist - Microsoft 365

    Norman, OK

    Job Title: Microsoft 365 Specialist Location: Norman, OK (on-site) Pay Rate Range: $65,000 - $100,000 / year depending on experience Benefits: The position is eligible for medical, dental, vision, and 401(k). **Onsite requirement - must be authorized t...

    Recommended

  • Data Analyst, Business Intelligence and Master Data Management

    Richardson, TX

    Title: Data Analyst, Business Intelligence Location: Dallas (Richardson), TX Salary: $100,000 – $120,000 (salaried, exempt) Summary Seeking a highly skilled and motivated Data Analyst, Business Intelligence and Master Data Management to join our team i...

    Recommended

  • Solutions & Data Architect

    Phoenix Metro Area, Arizona

    Job Title: Solutions & Data Architect Location: Phoenix, AZ Job Type: Full Time Compensation: $180,000 - $200,000 / year (dependent on experience) Benefits: The position is eligible for medical, dental, vision, and life insurance coverage, & PTO Positi...

    Recommended

  • Database Developer

    Oklahoma City, OK

    Role: Database Developer (SQL / SSIS) Location: Oklahoma City Pay Rate Range: $95,000 – $105,000 year DOE Benefits: The position is eligible for medical, dental, vision, and 401(k). Are you looking for a growth opportunity for a reputable company with ...

    Recommended

  • Varicent ICM Platform Engineer

    Anywhere

    Direct Hire | Varicent ICM Platform Engineer (Remote – U.S.) We’re actively partnering with a strong client to hire a Varicent ICM Platform Engineer on a direct-hire basis. This role is fully remote and open to candidates in all U.S. states except Cali...

    Recommended

  • Senior Business Data Analyst

    Fort Worth, TX

    Title: Senior Business Data Analyst Location: Fort Worth, TX Salary Range: $120-$140K; Bonus Included We are looking to bring on a Senior Business Data Analyst to our growing team. What we need is someone who comes from a Senior BDA, Senior Tech BA, Se...

    Recommended

  • Software Developer Engineer in Test - SDET

    Oklahoma City, OK

    We are partnering with a client to fill a direct hire SDET role in Oklahoma City. This position offers $93,000–$110,000 plus bonus, medical, dental, vision, 401K, etc. Must be willing to work onsite during training and three days a week onsite after tr...

    Recommended

  • Application Engineer - Oracle XStore

    Mattoon, IL

    Job Title: Application Engineer – Oracle ERP & POS Systems (XStore) Location: Hybrid – U.S. Based in the following states ONLY: NC, GA, KY, PA, OH, SC, VA, TN, MS, MD, IL, IN, AL, WV, FL, IN, MO Sponsorship: Not available at this time Job Type: Full Ti...

    Recommended

  • Senior Full Stack Developer

    Houston, TX

    Job Title: Senior Full Stack Developer Location: Houston, TX Pay: $70 - $90/hour Benefit Information: This position may be eligible for Medical, Dental, Vision and 401(k). Hybrid Schedule In-Office, 3 days onsite, 2 days remote Responsibilities: Develo...

    Recommended

  • Microsoft 365 Administrator

    District of Columbia

    Job Title: Microsoft 365 Administrator Job Location: Washington, DC Target Pay Rate: $40-$50hr Primary Duties and Responsibilities: 1. Configure and maintain the D365 F&O and Commerce system, including security roles, user permissions, and system setti...

    Recommended

  • SAP Security and GRC Admin

    Dallas Metro Area, Texas

    SAP Security and GRC Admin Direct Hire - Must be authorized to work in the United States now and in the future without assistance Pay: 130-155K plus bonus and stock, 100% medical insurance for family, dental, vision, 401K match, PTO. Open to candidate ...

    Recommended

  • AWS DevOps Engineer - Remote see states

    Anywhere

    Title: AWS DevOps Engineer Location: Must be located in Illinois - Some travel to Downstate location Salary: $120-125K + Bonus Job Type: Full-Time | Exempt Benefits: This position is eligible for medical, dental, vision, 401(k), and PTO. No sponsorship...

    Recommended

  • Sr. Fullstack Developer- .NET, C#, REST APIs, SQL, Azure

    Houston, TX

    Senior Full Stack Developer ( – U.S. Based) Location: IL, CO, TX, MN, NY, CA, MO, D.C., MD, VA, CT, NJ Compensation: Up to $175,000 base salary + discretionary bonus Department: Technology & Innovation Job Type: Full-Time | Exempt Benefits: Eligible fo...

    Recommended

  • Senior Power BI Engineer

    Coppell, TX

    Title: Senior Power BI Engineer Location: Coppell, TX Salary Range: $125K-$140K We are looking to bring on a Senior Power BI Engineer to our team due to growth. What we need is someone who comes 8+ years of experience owning all things Power BI and han...

    Recommended

  • Sr Systems Architect

    Houston Metro Area, Texas

    Senior System Architect Location: Houston TX Pay Rate: $150,000-$175,000 BASIC PURPOSE OF POSITION: The senior system Architect will be responsible for designing and overseeing the implementation of complex system architectures in both on-premises and ...

    Recommended

  • Senior Manager of Enterprise Architecture

    Naperville, IL

    Job Title: Senior Manager of Enterprise Architecture Location: Lisle, IL - HYBRID Compensation: $175,000 - $220,000 / Annually Benefits: This position is eligible for medical, dental, vision, and 401(k). What You Will Do As the Senior Manager of Archit...

    Recommended

  • Senior Procurement Manager - Data Center, Technology Hardware

    Chicago, IL

    Title: Senior Procurement Manager - IT Data Center and IT Technology Hardware Location: Chicago, IL onsite Salary: $170,000 – 190,000 + Bonus Job Type: Full-Time | Exempt Benefits: Eligible for medical, dental, vision, 401(k), and PTO Sponsorship: Not ...

    Recommended

  • Marketing Insights Analyst

    Fort Worth, TX

    Title: Marketing Insights Analyst Location: Fort Worth, TX Salary Range: $70K-$90K; Bonus Included We are looking bring on a Marketing Insights Analyst to our team due to growth. This person will be collaborating with all other teams of the Marketing (...

    Recommended

  • Cloud Solution SME (US Citizen - Onsite in Washington DC)

    Washington, DC

    Job Title: Cloud Solution SME (US Citizen - Onsite in Washington DC) Location: Onsite – Washington, DC (5 days/week) Contract-to-Hire (Candidates must be willing to convert to FTE after contract period) Target Pay Rate During Contract: $80.00 - $90.00 ...

    Recommended

  • Lead Full Stack Engineer - Typescript, JavaScript, React, Node.js

    Remote CST, TN

    Title: Lead Full Stack Engineer - Typescript, JavaScript, React, Node.js Location: REMOTE - US only in EST, CST or MST Time Zones - Must have location on resume Salary: $145000 – $160000 / Year (based on experience) Job Type: Full-Time | Exempt Benefit...

    Recommended

  • Junior Full Stack Developer

    McLean, VA

    Job Title: Junior Full Stack Developer Location: DC, Maryland, or Virginia Employment Type: 85-95k/year About the Role: We are seeking a motivated Junior Full Stack Developer to join our dynamic team. In this role, you will be responsible for developin...

    Recommended