At Morningstar, we believe in building great products in-house in a highly collaborative, agile environment where we focus on technical excellence, the user experience, and continuous improvement. Our technologists represent a range of skills and experience levels, but they all view their work as a craft and push technology’s boundaries to find new and better ways to serve investors.

Database Administrator at Morningstar

 Our Team:

Technology drives our business. Our team is made up of talented software engineers, infrastructure engineers, leaders and UX professionals. We care about technology as a craft and a differentiator. We bring our global products to market with a mix of software, cloud, data centers, infrastructure, design and grit. 

Our Product Groups:

Individual Investor – building products like Morningstar.com and mobile apps for individuals like yourself

Institutional Investor – developing some of our flagship products like Morningstar Direct for institutional investors and our Advisor products for financial advisors

Workplace – this is where we build and provide our hosted digital advice platform for Retirement plans, 401K’s, etc. (what some call robo-advisors)

Data – this is the heart of Morningstar where all data is sourced, collected, transformed, calculated and distributed across the world

The Role:

At Morningstar, helping investors is what brings us together and drives our work. We are looking for Database Administrators and Data Engineers who specialize in relational data and SQL Server to join our team, grow with us, introduce us to new ideas and develop products that empower our users. You will have influence for ensuring process and quality adherence through peer reviews, best practices and reliability of systems. You will act as the software guardian, owning non-functional requirements, reliability, performance of our databases while addressing technical debt. Every day, you’ll work with team members across disciplines developing products for investors. You’ll interact daily with our product managers to understand our domain and create technical solutions that push us forward. We want to work with other engineers who bring knowledge and excitement about our opportunities. These positions are based in our Chicago office.

Responsibilities

  • Installation and configuration of new SQL Servers and databases, in all environments from Dev through Production
  • Be responsible for the health and performance management (hardware, configuration, and/or architecture/index/query changes)
  • Deployment of SSIS packages, managing replication, configuration of SQL Server monitoring
  • Work closely with Site Reliability Engineers for trouble-shooting and escalation
  • Work closely with the software engineering teams
  • Help the business define its Data Recovery Point Objectives (DRPOs)
  • Ensure all database servers are backed up and verified in ways that meets the business’ DRPOs
  • Enhancing data-related release processes and Data Lifecycle Management from manual to automated (including and integrating with third-party tools where required)
  • Maintaining documentation on the products database environment
  • Solve investors’ problems with technology and data
  • Be passionate about quality, process, programming, and investing in general, seeing opportunities for improvement, seizing them, and then sharing your findings with others.
  • Familiarity or desire to become an AWS expert

Additional Job Duties to Stand Out from the Crowd:

  • Ensure new database code is excellent in readability, reliability, and performance through code reviews and consultation with developers
  • Find most resource-intensive queries on the server, along with suggested ways to improve performance on each
  • Design indexes for existing applications, choosing when to add or remove indexes
  • Advise others on efficient database designs (tables, datatypes, stored procedures, functions, etc…)

Requirements

  • A driven curiosity about our data and a proactive nature to get things done
  • Strong need to communicate clearly, consistently, and proactively, in person and in writing
  • Focus on balancing internal and external customer desires with delivering results the right way, in the right timeframe
  • Desire to work as a team with daily stand-ups and regular retrospectives to discuss what went well and what can improve
  • 2+ years of experience as a Database Administrator with MS SQL Server 2014+
  • 1+ years on-call troubleshooting experience with at least one production SQL Server
  • Expertise with RDBMS concepts including stored procedures, tables, views etc.
  • Experience with performance tuning and query optimization
  • Automation experience with Powershell, Python, or other scripting language
  • Understanding of ETL best practices
  • Finding DMV queries to answer questions about server-level performance
  • Effective use of third-party tools for monitoring and administration (e.g., Solarwinds DPA/Ignite, SentryOne SQL Sentry, RedGate SQL Toolbelt, Ozar’s Tools, etc…)
  • Tuning of T-SQL queries to improve performance
  • Writing and improving SQL Server T-SQL queries for at least a year
  • Using Profiler traces and other tools to find the most frequently run queries
  • Knowledge of ORMs, including LINQ, Entity Framework, NHibernate
  • Experience with Agile methodology and tools like JIRA.

Morningstar is an equal opportunity employer.

 

Find more startup and tech jobs in Chicago
Loading...
Apply Now
Why work with us
We’re an ambitious group, driven by our passion to make investing better. Imagining the next big thing is in our blood—it’s transformed us from a company with just a few employees in 1984 to a leading independent investment research company with a worldwide presence today.
Culture
There are no corner offices in our Chicago headquarters. In fact, there are no offices at all. At Morningstar, our open environment reflects our belief that anyone at any level can voice their ideas and take part in making them happen. You’ll see little of the typical corporate hierarchy here, with no rigid structures or barriers between people or teams. Morningstar employees enjoy a fluid work environment where they are given both the resources and opportunities to pursue a fulfilling career.
Perks & Benefits
Compensation at Morningstar is more than a salary. It’s about making positive contributions to both life and work. We give our diverse workforce the choice and flexibility they need to maintain their health, retirement plans, time, and professional growth.
Morningstar offers medical, dental, and vision coverage to employees and their families. Our philosophy is to provide access to excellent health care while maintaining low out-of-pocket costs.
Morningstar provides three tools to help employees maintain work-life balance—vacation, sabbatical, and leave. There’s no “use it or lose it” vacation policy at Morningstar. Employees take the time they need with their manager’s approval.
On top of the major benefits, we believe in preserving the little things that make a workplace friendlier. Some of these perks include: Casual dress every day, Open, egalitarian environment, Free beverages, Free bagels every Wednesday, Social events year-round, At-cost subscriptions to products for family members and friends, Employee discounts at selected merchants and retailers.

Oh no!

You're fresh out of job post slots.

Upgrade your planmanage current jobs

Create an account

Let startups find you

Create a profile and upload your resume today.

Saved Jobs
Job Saved
Find your saved jobs by scrolling over this star

Oh no!

You're fresh out of job post slots.