Apply Now

Sr. SQL & DMS Administrator

Chicago, IL, US • Posted 3 days ago • Updated 15 minutes ago

Full Time

On-site

USD $109,599.00 - 166,996.00 per year

Fitment

Dice Job Match Score™

🔗 Matching skills to job...

Job Details

Skills

Optimization
Problem Solving
Conflict Resolution
Privacy
Backup
Recovery
High Availability
Disaster Recovery
Stored Procedures
Capacity Management
Benchmarking
Root Cause Analysis
Application Support
System Integration
Auditing
Provisioning
Meta-data Management
Taxonomy
Lifecycle Management
Authentication
Access Control
DMS
Microsoft Outlook
Management
Patch Management
Scalability
IT Management
SQL
Migration
Mentorship
Training
Software Support
Documentation
Collaboration
Information Security
Data Security
Regulatory Compliance
Information Technology
Computer Science
Microsoft SQL Server
Transact-SQL
Database
Microsoft Operating Systems
Microsoft Windows Server
Active Directory
Document Management
Analytical Skill
Organizational Skills
Attention To Detail
Communication
Microsoft Windows
iManage
Cloud Computing
SQL Azure
Microsoft Office
Windows PowerShell
Scripting
Law
Legal

Optimization
Problem Solving
Conflict Resolution
Privacy
Backup
Recovery
High Availability
Disaster Recovery
Stored Procedures
Capacity Management
Benchmarking
Root Cause Analysis
Application Support
System Integration
Auditing
Provisioning
Meta-data Management
Taxonomy
Lifecycle Management
Authentication
Access Control
DMS
Microsoft Outlook
Management
Patch Management
Scalability
IT Management
SQL
Migration
Mentorship
Training
Software Support
Documentation
Collaboration
Information Security
Data Security
Regulatory Compliance
Information Technology
Computer Science
Microsoft SQL Server
Transact-SQL
Database
Microsoft Operating Systems
Microsoft Windows Server
Active Directory
Document Management
Analytical Skill
Organizational Skills
Attention To Detail
Communication
Microsoft Windows
iManage
Cloud Computing
SQL Azure
Microsoft Office
Windows PowerShell
Scripting
Law
Legal

Summary

Overview

McGuireWoods LLP is seeking an experienced and highly skilled Senior Microsoft SQL Server & iManage Work Administrator to join our IT team. This role is responsible for the design, administration, and optimization of the firm's SQL Server and iManage Work on-premises environments-mission-critical platforms supporting attorneys and legal professionals firmwide.

The ideal candidate will possess deep technical expertise in SQL Server and iManage administration, demonstrate strong problem-solving and automation capabilities, and serve as a subject matter expert for data and document management systems. This position will work collaboratively across IT, Information Security, and Application Support teams to ensure stability, scalability, and security of key systems.

McGuireWoods, one of the world's leading law firms, has provided legal solutions to corporate, individual and nonprofit clients since 1834. Along with excellent benefits, McGuireWoods offers most employees a hybrid remote option allowing flexibility and work-life balance. Our Applicant Disclosures describe your rights. Our Privacy Statement describes how we will process and safeguard your personal data.

Responsibilities

Microsoft SQL Server Administration:

Administer, monitor, and optimize SQL Server instances supporting core legal and business applications.
Design and implement database backup, recovery, high availability (HA), and disaster recovery (DR) strategies.
Develop and tune complex T-SQL queries, stored procedures, and jobs to improve performance and reliability.
Conduct capacity planning, performance benchmarking, and root-cause analysis for database-related issues.
Collaborate with development and application support teams to design efficient data models and optimize application integration.
Ensure compliance with security policies, auditing requirements, and industry best practices.

iManage Work DMS On-Prem Administration:

Lead the administration and maintenance of the firm's iManage Work 10 on-premises environment.
Manage user provisioning, workspace creation, templates, metadata, and taxonomy to align with firm standards and practice group needs.
Oversee ongoing workspace lifecycle management, including creation, modification, archival, and compliance alignment.
Establish, maintain, and enforce authentication and access controls for the iManage DMS in accordance with security best practices and firm policies.
Troubleshoot and resolve complex issues related to indexing, synchronization, and performance.
Configure and maintain integrations with Active Directory, Outlook, and other legal applications.
Oversee upgrades, patch management, and system enhancements in coordination with stakeholders.
Evaluate and recommend improvements for system automation, resilience, and scalability.

Supplemental Functions:

Serve as a technical lead for iManage and SQL-related projects, upgrades, and migrations.
Mentor technical resources and multiple technology departments and provide training to IT software support teams.
Develop and maintain detailed documentation of procedures, configurations, and standards.
Participate in after-hours maintenance windows and provide escalation support as needed.
Collaborate with Information Security to implement data protection and compliance initiatives.
Perform additional duties as assigned.

Qualifications

Required:

Bachelor's degree in Information Technology, Computer Science, or related field, or equivalent work experience.
5+ years of experience working with Microsoft SQL Server (2016 or later preferred).
Familiarity with T-SQL and general database concepts.
Basic understanding of Windows Server and Active Directory environments.
Experience with iManage Work 10 (on-prem) or other document management systems.
Interest in legal technology and willingness to grow within a large law firm environment.
Strong analytical and troubleshooting skills.
Excellent organizational skills and attention to detail.
Ability to handle confidential data with discretion and integrity.
Clear and professional communication with both technical and non-technical staff.
Team-oriented mindset with a willingness to learn and adapt.
Willingness to work on-call after hours as needed for maintenance and upgrade tasks.

Preferred:

Experience with iManage Work for Windows and related components.
Familiarity with iManage RAVN Indexer, iManage Threat Manager, Litera Filetrail, IntApp Walls.
Exposure to cloud and hybrid technologies (e.g., iManage Cloud, Azure SQL, or Microsoft 365 integrations) preferred.
Exposure to PowerShell scripting or automation tools.
Prior experience working in a law firm or legal technology environment.

Have more questions? Connect with a recruiter directly. #LI-ER1

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10125518
Position Id: 1af83d89d54e41cbb731dfaca5db5c72
Posted 3 days ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

SQL Server DBA

Chicago, Illinois

•

Today

Location(s) Chicago, Illinois, Downers Grove, Illinois Details Kemper is one of the nation's leading specialized insurers. Our success is a direct reflection of the talented and diverse people who make a positive difference in the lives of our customers every day. We believe a high-performing culture, valuable opportunities for personal development and professional challenge, and a healthy work-life balance can be highly motivating and productive. Kemper's products and services are making a re

Full-time

USD 111,000.00 - 186,700.00 per year

Database Administrator

Waukegan, Illinois

•

Today

Uline, Inc. Job Location: 2105 S. Lakeside Drive, Waukegan, IL 60085 Job Title: Database Administrator Job Duties: Uline, Inc. seeks a Database Administrator in Waukegan, Illinois to perform database administration. Design databases, tables, stored procedures, views, triggers, and other database objects. Design and develop ETL (Extract, Transform & Load) solutions. Optimize database performance through indexing, query optimization, database design. Participate in periodic High Availability /

Full-time

USD 133,973.00 - 133,973.00 per year

Senior SQL DBA

Park City, Illinois

•

Today

Job Description We are seeking a highly seasoned Senior SQL DBA to take ownership of an environment consisting of approximately 30 SQL servers. The ideal candidate will provide essential maintenance, perform a comprehensive health assessment, and establish best practices. You will act as the primary SQL authority, supporting an internal team of systems engineers and data integrators. Key Responsibilities: Assess the overall SQL environment and advise the team on what practices to keep

Easy Apply

Contract, Third Party

Depends on Experience

Senior Database Administrator

No location provided

•

Today

Overview Company Overview: Allied Universal , North America's leading security and facility services company, offers rewarding careers that provide you a sense of purpose. While working in a dynamic, welcoming, and collaborative workplace, you will be part of a team that contributes to a culture that positively impacts the communities and customers we serve. Job Description Allied Universal is hiring a Senior Database Administrator. The Senior Database Administrator is responsible for the de

Full-time

USD 110,000.00 - 120,000.00 per year

Search all similar jobs

More jobs at McGuireWoods LLP in Chicago, IL