Senior SQL Server Database Administrator

Intangible Assets

Vernon Hills, IL

JOB DETAILS
SALARY
$120,000–$140,000
SKILLS
Analysis Skills, Architectural Services, Best Practices, Change Management, Code Reviews, Communication Skills, Data Modeling, Data Quality, Database Architecture, Database Design, Database Programming, Database Replication, Database Technology, DevOps, Enterprise Applications, Enterprise Architecture, Git, Identify Issues, Leadership, Mentoring, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Operational Audit, Performance Analysis, Performance Tuning/Optimization, Power BI, Power Management, Query Optimization, Replication and Remote Mirroring, SQL (Structured Query Language), Scripting (Scripting Languages), Software Development, Source Code/Configuration Management (SCM), Stored Procedures, Transaction Processing/Management
LOCATION
Vernon Hills, IL
POSTED
1 day ago

We are seeking an experienced Senior SQL Server Database Administrator to ensure the reliability, performance, and scalability of our transactional database systems, including environments utilizing SQL Server replication. In this role, you will lead and mentor a small team of report developers, provide architectural guidance for SQL related development, and participate in the pull request and code review process for all database changes.

This is a high impact leadership position with the opportunity to influence long term data architecture, performance strategy, and governance. You will work closely with development, operations, and business stakeholders to ensure data integrity, availability, and optimal performance across the organization.

Key Responsibilities
  • Administer and maintain SQL Server environments to ensure reliability, performance, and data integrity
  • Manage and optimize transactional replication and other data distribution mechanisms
  • Lead performance tuning efforts including query optimization, indexing, and configuration improvements
  • Provide architectural guidance on database design, schema structure, and storage strategies
  • Mentor and oversee report developers supporting SQL based reporting and Power BI solutions
  • Review and approve SQL code changes within the pull request and source control workflow
  • Collaborate with software developers to ensure efficient database interaction within applications
  • Support data modeling for reporting, analytics, and operational systems
  • Monitor database performance and proactively identify optimization opportunities
  • Troubleshoot production issues related to data systems, reporting, or performance
  • Establish best practices for database development, change management, and deployments
  • Ensure data accuracy and governance across reporting systems
Minimum Requirements
  • 5+ years administering Microsoft SQL Server as a DBA
  • Strong experience with performance tuning, query optimization, indexing, and execution plans
  • Hands on experience with transactional replication or similar replication technologies
  • Advanced proficiency in T SQL, stored procedures, and database scripting
  • Experience leading or mentoring technical team members
  • Familiarity with source control and SQL related code review workflows
  • Strong analytical and troubleshooting skills
  • Effective communication skills with both technical and business teams
Preferred Qualifications
  • Experience supporting or managing Power BI environments
  • Experience with Azure DevOps, Git, and pull request workflows
  • Background designing scalable database architectures for enterprise applications
  • Familiarity with database monitoring and alerting tools
  • Experience implementing data governance or data quality practices

About the Company

I

Intangible Assets