Senior Database Administrator

gtlaw; Chicago (IL); Remote; USD 123,000 - 136,000; Full time

Benefits offered by this job

Discretionary bonus

Health insurance with optional HSA

Short/Long term disability

Dental insurance

Vision care

Life insurance

401K

Vacation and sick time

Employee assistance program

Job summary

Greenberg Traurig, a global law firm, seeks a Senior Database Administrator to architect, administer and optimize enterprise SQL Server databases, ensuring security, reliability, and scalability. You will collaborate with application owners and IT teams to support operations and provide data access guidance.

The role supports flexible office locations or remote work, reporting to the Director of Network Systems.

Qualifications

• Bachelor's degree or equivalent work experience.
• Minimum 8–10 years' experience in design, development, administration, and maintenance of enterprise MS SQL Server databases.
• Experience configuring, operating and maintaining Microsoft SQL Server, on‑prem and cloud environments.
• Experience in database design, standards, capacity planning, disaster recovery, accessibility, scalability and documentation for SQL Server.
• Development of complex queries, SSIS packages and SSRS reports.

Responsibilities

• Maintains enterprise SQL database operations including updates and patches.
• Maintains database security and compliance with company, industry and government standards (GDPR, HIPAA).
• Reviews architecture and optimizes all enterprise database systems.
• Architects and implements new database systems.
• Monitors database performance and performs tuning for optimal performance.
• Troubleshoots enterprise database servers and related systems.
• Plans testing and implementation of DR and backup processes to ensure continuous operation.
• Creates custom queries, data-driven SSRS subscriptions, migration scripts, and executes other tasks.

Skills

SQL Server

Database security

Architecture design

Performance tuning

PowerShell

Troubleshooting

Documentation

Communication skills

Learning new tech

Automation

Education

Bachelor's degree or equivalent

Tools

SSIS

SSRS

Microsoft SQL Server

SSMS

Job description

Greenberg Traurig (GT), a global law firm with locations across the world in 15 countries, has an exciting employment opportunity for you. We offer competitive compensation and an excellent benefits package, along with the opportunity to work within an innovative and collaborative environment.

Join our Technology Team as a Senior Database Administrator l ocated in various offices.

This role can be based in various offices, on a remote basis. This role reports to the Director of Network Systems.

Position Summary

The Senior Database Administrator (DBA) is responsible for architecting, administering and optimizing all enterprise SQL Server databases, ensuring security, reliability, and scalability. The DBA collaborates with application owners and IT teams to support business operations and provides technical guidance to users accessing enterprise data.

Key Responsibilities

• Maintains all enterprise SQL database operations including SQL server updates and patches
• Maintains database security and compliance with company, industry and government standards (GDPR, HIPAA, etc.)
• Reviews current architecture and updates and optimizes all the firm's enterprise database systems
• Architects and implements new database systems
• Proactively monitors database performance and performs database tuning for optimal performance
• Troubleshoots enterprise database servers and related systems
• Supports system audits and provides documentation as required
• Plans testing and implementation of DR and backup processes to ensure continuous operation
• Creates custom queries, data-driven SSRS subscriptions, migration scripts, and executes other tasks as needed

Qualifications

Skills & Competencies

• Sound understanding of SQL Server technology features and limitations
• In-depth, advanced knowledge of SQL Server database structures, security, storage solutions, virtualization, replication, and clustering
• Ability to create performance projections based upon hardware, OS, databases design, query structures and interactions between external systems with the database servers
• Ability to evaluate and recommend technological changes in the database environment to support business objectives
• Proficiency in automation and scripting (e.g., PowerShell)
• Strong analytical and troubleshooting skills
• Excellent verbal and written communication skills, with an ability to effectively communicate technical details to persons without technical experience
• Excellent organizational and interpersonal skills
• Excellent attention to detail and problem-solving skills
• Ability to accurately follow documented procedures and a strong aptitude for learning new technologies as they are incorporated into the computing environment

Education & Prior Experience

• Bachelor's degree or equivalent work experience
• Minimum 8 to 10 years' experience in design, development, administration, and maintenance of enterprise-level MS SQL Server database systems
• Demonstrable experience configuring, operating and maintaining Microsoft SQL Server, both on-prem and cloud environments
• Demonstrable experience in database design, creating standards and processes, capacity planning, disaster recovery planning, accessibility, scalability and documentation for SQL Server
• Demonstrable experience in development of complex queries, SSIS Packages and SSRS reports

The expected pay range for this position is:

$123,371 - $136,060 Per year

Actual pay will be adjusted based on experience, location, and other job-related factors permitted by law.

• discretionary bonus
• health insurance with an optional HSA
• short term disability
• long term disability
• dental insurance
• vision care
• life insurance
• Healthcare and Dependent Care Flexible Spending Accounts
• 401K
• vacation
• sick time
• employee assistance program
• voluntary accident insurance
• voluntary life
• voluntary disability
• voluntary critical illness and cancer insurance
• pet insurance
• Commuter and Transit programs may also be available in certain markets.

GT is an EEO employer with an inclusive workplace committed to merit-based consideration and review without regard to an individual's race, sex, or other protected characteristics and to the principles of non-discrimination on any protected basis.