SQL Database Administrator

| Chicago
At Relativity, we make software to help users organize data, discover the truth, and act on it. Our e-discovery platform is used by more than 13,000 organizations around the world to manage large volumes of data and quickly identify key issues during litigation, internal investigations, and compliance projects.
Here you can own your career in a community of values-driven people who help our customers around the world solve complex data challenges. If this sounds like the place for you, check out the details of this position below.
We are seeking a Production Database Administrator with a deep demonstrated knowledge of MS SQL administrative tasks and the ability to consult on design, development, and automation improvements. This individual should have a passion for maintaining MS SQL databases that meet or exceed production SLAs for availability and performance. The right candidate will ideally have past hands-on experience administering MS SQL databases running in a public cloud environment, such as MS Azure.

Role Responsibilities

  • Design, build and/or maintain OLTP systems and data warehouse solutions using Microsoft SQL Server (Azure PaaS, Azure Managed Instance, and On-premise) and Snowflake Data Warehouse
  • Provide support 24/7/365 for any troubleshooting or corrective actions related to incidents impacting availability within the production environments
  • Take proactive measures to monitor, trend, and tune database(s) to optimize performance as workloads change, including tasks such as database design, index creation, database optimization and performance tuning
  • Ensure high availability, backup and recovery of production databases, data marts, and data warehouse that meet or exceed BCDR objectives for RPO and RTO
  • Create, implement, and maintain SQL DB Health Checks, and have a demonstrated ability to automate SQL health reporting/event notification, and corrective actions.
  • Configure SQL Server monitoring utilities to minimize false alarms and have a demonstrated ability to monitor/trend SQL environments to determine and implement enhanced monitoring thresholds to prevent incidents and reduce mean time to recovery (MTTR).
  • When performance issues arise, determine the most effective way to increase performance including scaling up or out, server configuration changes, index/query changes, etc.
  • Identify code defects and enhancements and develop a detailed root cause analysis that can be leveraged by the product management and development teams to improve application availability and decrease the total cost of ownership.
  • Perform all database management responsibilities in Microsoft Azure for production and non-production workloads.

Minimum Qualifications

  • Bachelor’s degree in Computer Science, Information Systems, or related discipline
  • Experience working in a 24/7 environment and on-call support
  • 5 years’ experience working as a Microsoft SQL DBA leveraging versions 2008r2 or later
  • Experience with configuration and troubleshooting of high availability, clustered, and always on availability groups
  • Demonstrated experience solving performance tuning challenges within a data analytics environment: ETL load times, SQL query times, etc.
  • Experience in database development projects (design complex T-SQL scripts, stored procedures, views) and ETL processes

Preferred Qualifications

  • Familiar with basic Azure IaaS and PaaS capabilities, and experience with designing and building MS SQL databases within Azure
  • Hands-on experience with Microsoft SQL Server Integration Services (SSIS)
  • Hands-on experience architecting, administering, and tuning data analytics solutions in Snowflake
  • Familiarity with Snowflake utilities – SnowSQL, Snowpipe
  • Familiarity with Informatica Cloud Data Integration, or similar PaaS ETL solutions
  • #LI-MC1

Relativity has over 160,000 users in 40+ countries from organizations including the U.S. Department of Justice, more than 70 Fortune 100 companies, and all of the Am Law 200. Relativity's cloud solution, RelativityOne, offers all the functionality of Relativity in a secure and comprehensive SaaS product. Our company has also been named one of Chicago's Top Workplaces by the Chicago Tribune for seven consecutive years.
If you’re ready to grow with us, we’d love to hear from you.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.

Read Full Job Description

Technology we use

  • Engineering
    • .NETLanguages
    • C#Languages
    • JavaLanguages
    • ScalaLanguages
    • AzureLanguages
    • ChefLanguages
    • PowershellLanguages
    • JenkinsLanguages
    • Node.jsFrameworks
    • MySQLDatabases

Location

We’re a community of passionate, life-long learners tackling challenging problems. We care about each other and about our community.

An Insider's view of Relativity

How does your team reward individual success?

Rewarding success is one of my favorite parts of my role. Formally through annual bonus plans, thank you notes in our HR system and of course through promotions. I also like to submit nominations to be recognized at company meetings and spotlights in department newsletters. We move fast at Relativity it’s nice to slow down and just say thanks!

Jessica

Operations Manager, Customer Success and Support

How do you collaborate with other teams in the company?

On the Certification team, I develop exams and study content for our end users. To ensure that our exams are valid, I work with almost every team embracing their expertise and industry knowledge into the development process. It takes continuous interdepartmental collaboration to keep exam content accurate as the Relativity platform evolves.

Sean

Certification Specialist

How has your career grown since starting at the company?

As an Application Support Specialist, I have increased my technical knowledge in SQL database management, Network Administration, and Server Infrastructure. Prior to coming to Relativity, I had zero knowledge of e-Discovery, and now provide On-site training to our clients teaching them about the various e-Discovery tools Relativity has to offer.

Kamal

Application Specialist II

How do you empower your team to be more creative?

We have a semi-annual Hackathon where our engineers get to work on their own feature ideas for 3 days. The ideas that emerge have blown our minds and eventually become part of the product. In addition to design sessions that each team has, we also regularly have Relativity talks. These talks are a great way for engineers to share their experience.

Cindy

Manager, Software Engineering

What are some social events your company does?

Our annual user conference, Relativity Fest, is such a tremendous opportunity to get one on one face time with our partners. Fest draws 2,000 platform users and practitioners from all different facets of the industry and being able to connect with them and hear their stories is extremely powerful.

Michael

Platform Account Manager

What are Relativity Perks + Benefits

Relativity Benefits Overview

We have a great selection of benefits from very competitive insurance plans to fun office perks!

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Bonuses are based on a combination of how the company performs as well as how the individual performs.
Child Care & Parental Leave Benefits
Generous Parental Leave
Vacation & Time Off Benefits
Generous PTO
Everyone starts with 18 days of PTO, plus 11 paid holidays every year. Our office is also closed between Christmas and New Years, which does not take away from your PTO balance.
Paid Holidays
Perks & Discounts
Casual Dress
Commuter Benefits
Tax-free transportation opportunities.
Company Outings
We have our annual Summer Jam (picnic that includes friends and family), our User Conference - RelativityFest, and a holiday party each year.
Game Room
Our Cafe houses ping-pong, foosball, and a variety of arcade games - including Killer Queen (a multi-player game that is one of few in the country).
Stocked Kitchen
We have tea, coffee (including fancy espresso machines), a variety of LaCroix, soda, and many other things. We also have fresh fruit delivered twice a week in our pantry areas.
Some Meals Provided
Meals are often provided during morning or afternoon training sessions. There is also always plenty of leftover food from such meetings that employees can dive into after the attendees are finished.
Happy Hours
Different for each team, but always a great time!
Recreational Clubs
RelWOW (Relativity Women of the Workplace), Several Intramural Sports Teams (kickball, softball, volleyball, etc.), Vertikal (climbing group), Working Moms Group, Queeries, and several more.
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
All full-time employees (non-contract) receive $3,000/year to pursue professional development opportunities.
Diversity Program

Additional Perks + Benefits

We also offer a Divvy bike share discount, have Fooda discounts in the office, and offer DRYV Laundry Service for those who have workout clothes that need washing!

More Jobs at Relativity66 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
HR
Internships
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Internships
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Marketing
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Product
new
Chicago
Project Mgmt
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
HR
new
Chicago
Sales
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago