Overview
On Site
USD 131,000.00 - 143,500.00 per year
Full Time
Skills
Teamwork
Legal
Innovation
Global Operations
Development Testing
Project Coordination
Database Administration
Data Integration
Performance Tuning
Database
Reliability Engineering
Regulatory Compliance
IT Service Management
Change Control
Knowledge Sharing
Documentation
Collaboration
Storage
Network
Computer Science
Microsoft SQL Server
Replication
Log Shipping
Database Mirroring
Transact-SQL
Debugging
Stored Procedures
Microsoft SSIS
Database Design
Modeling
Red Gate
Windows PowerShell
Scripting
Failover
Microsoft SSRS
Reporting
Conflict Resolution
Problem Solving
Analytical Skill
Communication
Management
Health Care
Training And Development
Recruiting
Training
Promotions
Evaluation
Military
SAP BASIS
Law
Augmented Reality
Job Details
About Kirkland & Ellis
At Kirkland & Ellis, we don't just meet the standard for legal excellence - we set it. Our culture is built on teamwork, ingenuity and an unwavering commitment to continuous growth. We tackle the most sophisticated legal challenges with bold ideas and innovative solutions, powered by the exceptional experience and ambition of our 7,000+ people, including 4,000+ attorneys, across 22 offices worldwide. Our dedicated professionals share our lawyers' commitment to excellence and show up each day to do meaningful work that helps drive global business, investment and innovation forward.
What You'll Do
Are you an experienced database professional ready to take ownership of complex environments and drive performance at scale? As a Database Administrator II, you'll play a critical role in deploying, maintaining, and optimizing databases across the firm's Microsoft SQL Server platform. You'll join a firmwide team that delivers advanced Level 3 support, investigates system challenges, and ensures our data infrastructure is secure, reliable, and high-performing.
In this role, you'll collaborate with developers, project managers, vendors, and engineers to support a wide variety of business applications while working hands-on with the latest SQL Server technologies. This is a highly impactful position where your expertise in database administration and problem-solving will directly support the firm's global operations.
Database Administration - Support, administer, and maintain development, test, and production environments across multiple SQL Server editions.
Project Support - Partner with project managers, developers, vendors, and engineers to provide DBA expertise for database deployments and upgrades.
Data Integration & Reporting - Create and maintain SQL Server Integration Services (SSIS) packages and manage security and deployment for SQL Server Reporting Services (SSRS) reports.
Performance Optimization - Troubleshoot and resolve server and database performance issues, implementing tuning strategies to improve system reliability.
Security & Compliance - Administer SQL Server security, safeguard sensitive data, and adhere to firmwide IT service delivery, governance, and change control standards.
Documentation & Knowledge Sharing - Develop and maintain configuration, troubleshooting, and integration documentation for supported systems.
Collaboration & Support - Work closely with server, storage, and network engineers to resolve issues and minimize downtime; rotate on-call responsibilities to provide 24/7 operational support.
What You'll Bring
Education & Experience - Bachelor's degree in computer science or related field, or equivalent experience, plus 5+ years of Microsoft SQL Server administration.
Technical Expertise - Hands-on experience with SQL Server 2014, 2016, 2017, and 2019, including installation, configuration, replication, log shipping, and database mirroring.
Programming & Development - Proficiency in Transact-SQL with the ability to write, debug, and maintain scripts, stored procedures, functions, and views; experience developing SSIS packages and optimizing SSRS reports.
Database Design - Solid understanding of normalized database design and modeling.
Optional Skills - Familiarity with tools such as Idera, RedGate, and SentryOne; PowerShell scripting; Always On availability groups; failover clusters; and SSRS report development.
Core Strengths - Strong problem-solving, analytical, and communication skills with the ability to thrive in a fast-paced environment, manage competing priorities, and build positive working relationships.
Compensation
The base salary range below represents the low and high end of the salary range for this position in Chicago. This range may differ based on your geographic location and cost of living considerations. At Kirkland & Ellis, we consider compensation more than just a base salary. We offer an exceptional range of flexible benefits including comprehensive healthcare, paid time off, and retirement. We also offer personal support and tailored learning and development opportunities all designed to help you realize your full potential both in life and at work.
Compensation Range:
Chicago: $131,000 - $143,500
How to Apply
Thank you for your interest in Kirkland & Ellis LLP. To complete an application and submit your resume, please click "Apply Now."
Don't meet every job requirement? That's okay! If you're excited about this role but your experience doesn't perfectly fit every qualification, we encourage you to apply anyway. You may be just the right person for this role or others at Kirkland.
Equal Employment Opportunity
All employment decisions, including the recruiting, hiring, placement, training availability, promotion, compensation, evaluation, disciplinary actions, and termination of employment (if necessary) are made without regard to the employee's race, color, creed, religion, sex, pregnancy or childbirth, personal appearance, family responsibilities, sexual orientation or preference, gender identity, political affiliation, source of income, place of residence, national or ethnic origin, ancestry, age, marital status, military veteran status, unfavorable discharge from military service, physical or mental disability, or on any other basis prohibited by applicable law. #LI-Hybrid #LI-AR1
At Kirkland & Ellis, we don't just meet the standard for legal excellence - we set it. Our culture is built on teamwork, ingenuity and an unwavering commitment to continuous growth. We tackle the most sophisticated legal challenges with bold ideas and innovative solutions, powered by the exceptional experience and ambition of our 7,000+ people, including 4,000+ attorneys, across 22 offices worldwide. Our dedicated professionals share our lawyers' commitment to excellence and show up each day to do meaningful work that helps drive global business, investment and innovation forward.
What You'll Do
Are you an experienced database professional ready to take ownership of complex environments and drive performance at scale? As a Database Administrator II, you'll play a critical role in deploying, maintaining, and optimizing databases across the firm's Microsoft SQL Server platform. You'll join a firmwide team that delivers advanced Level 3 support, investigates system challenges, and ensures our data infrastructure is secure, reliable, and high-performing.
In this role, you'll collaborate with developers, project managers, vendors, and engineers to support a wide variety of business applications while working hands-on with the latest SQL Server technologies. This is a highly impactful position where your expertise in database administration and problem-solving will directly support the firm's global operations.
Database Administration - Support, administer, and maintain development, test, and production environments across multiple SQL Server editions.
Project Support - Partner with project managers, developers, vendors, and engineers to provide DBA expertise for database deployments and upgrades.
Data Integration & Reporting - Create and maintain SQL Server Integration Services (SSIS) packages and manage security and deployment for SQL Server Reporting Services (SSRS) reports.
Performance Optimization - Troubleshoot and resolve server and database performance issues, implementing tuning strategies to improve system reliability.
Security & Compliance - Administer SQL Server security, safeguard sensitive data, and adhere to firmwide IT service delivery, governance, and change control standards.
Documentation & Knowledge Sharing - Develop and maintain configuration, troubleshooting, and integration documentation for supported systems.
Collaboration & Support - Work closely with server, storage, and network engineers to resolve issues and minimize downtime; rotate on-call responsibilities to provide 24/7 operational support.
What You'll Bring
Education & Experience - Bachelor's degree in computer science or related field, or equivalent experience, plus 5+ years of Microsoft SQL Server administration.
Technical Expertise - Hands-on experience with SQL Server 2014, 2016, 2017, and 2019, including installation, configuration, replication, log shipping, and database mirroring.
Programming & Development - Proficiency in Transact-SQL with the ability to write, debug, and maintain scripts, stored procedures, functions, and views; experience developing SSIS packages and optimizing SSRS reports.
Database Design - Solid understanding of normalized database design and modeling.
Optional Skills - Familiarity with tools such as Idera, RedGate, and SentryOne; PowerShell scripting; Always On availability groups; failover clusters; and SSRS report development.
Core Strengths - Strong problem-solving, analytical, and communication skills with the ability to thrive in a fast-paced environment, manage competing priorities, and build positive working relationships.
Compensation
The base salary range below represents the low and high end of the salary range for this position in Chicago. This range may differ based on your geographic location and cost of living considerations. At Kirkland & Ellis, we consider compensation more than just a base salary. We offer an exceptional range of flexible benefits including comprehensive healthcare, paid time off, and retirement. We also offer personal support and tailored learning and development opportunities all designed to help you realize your full potential both in life and at work.
Compensation Range:
Chicago: $131,000 - $143,500
How to Apply
Thank you for your interest in Kirkland & Ellis LLP. To complete an application and submit your resume, please click "Apply Now."
Don't meet every job requirement? That's okay! If you're excited about this role but your experience doesn't perfectly fit every qualification, we encourage you to apply anyway. You may be just the right person for this role or others at Kirkland.
Equal Employment Opportunity
All employment decisions, including the recruiting, hiring, placement, training availability, promotion, compensation, evaluation, disciplinary actions, and termination of employment (if necessary) are made without regard to the employee's race, color, creed, religion, sex, pregnancy or childbirth, personal appearance, family responsibilities, sexual orientation or preference, gender identity, political affiliation, source of income, place of residence, national or ethnic origin, ancestry, age, marital status, military veteran status, unfavorable discharge from military service, physical or mental disability, or on any other basis prohibited by applicable law. #LI-Hybrid #LI-AR1
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.