Addison Group · 1 day ago
Senior SQL Database Administrator
Des Plaines, IL
Full-time
Hybrid
Senior Level
$60/hr - $65/hrAddison Group is seeking a Senior SQL Database Administrator to manage and optimize a hybrid environment spanning on-premises SQL Server and Azure SQL platforms. This role involves administering SQL Server environments, performance tuning, and collaborating with various teams to ensure data integrity and system performance.
Information TechnologyRecruitingStaffing Agency
Responsibilities
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
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
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
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
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
Apply cumulative updates using documented runbooks
Lead SQL version upgrades, migrations, refreshes, and consolidations
Collaborate with infrastructure teams on capacity planning and resource expansion
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
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
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
Qualification
Required
SQL Server 2008–2022
Azure SQL Database & Managed Instance
Analysis Services
Query Store
Extended Events
sp_BlitzFirst
sp_WhoIsActive
Plan Explorer
SSIS
SSRS
Azure Data Factory (ADF)
Microsoft Integration Runtime
T-SQL
PowerShell
Transparent Data Encryption (TDE)
Data masking
Certificates and key management
SQL Agent job management
Index maintenance (IndexOptimize)
Capacity planning and resource monitoring
Jira/ADO, CAB/change processes, incident response
Preferred
Experience supporting clinical, registry, or large-scale regulated datasets
Azure cost optimization experience
Modernization or cloud migration projects
Strong documentation and automation mindset
Benefits
Medical
Dental
Vision
401(k)
Company
Addison Group
Addison Group specializes in filling company’s contract, contract-to-hire, or direct hire positions with professional candidates.
Founded in 1999
1001-5000 employees
H1B Sponsorship
Addison Group has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2021 (1)
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
Odyssey Investment Partners
2022-01-04Acquired
2016-12-19Private Equity
Leadership Team
Thomas B. Moran
CEO
Recent News
Company data provided by crunchbase