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
#J-18808-Ljbffr
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
#J-18808-Ljbffr