Senior SQL Database Administrator
Rosemont, IL
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