Oh Snap!
This job is no longer active - but you can still view the details below.

Database Administrator

| Chicago

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

  • Responsible for planning and designing SQL Server specifications, understanding database definition, structure, and long-range requirements.
  • Define, track, and maintain standard baselines and configuration sets of all managed and/or monitored database instances and servers and implement industry best practices with regards to the following:
    • Resource allocation and monitoring
    • Performance problem identification and resolution assistance
    • Clustering, replication, log shipping, mirroring and Always On Availability Groups
    • Data security and recovery
    • Data and database health practices
    • Patch management, and System capacity planning.
  • Develop and maintain storage strategies, establishing system documentation and database recovery processing.
  • Identify and initiate resolutions to user problems associated with database performance and database capacity, utilizing best practices to maximize up time and server utilization.
  • Support web application development, with a focus on helping the team interact with the database in the most efficient and productive way possible
  • Review and deploy the database components for new versions of web applications/products to test and production environments using release management practices.
  • Partner with DBA team to provide support in non-business hours, bi-weekly on-call rotation for support
  • Responsible for DR tests on regular basis
  • Help with Data Center migration and migrating on premise db servers to public cloud
  • Support open-source db platforms like mysql, postgres, Amazon Aurora, Redshift

 

Requirements

  • A bachelor`s degree in computer science or related field with a specialization in relational database management systems.
  • 5 or more years of experience in database administration using SQL Server 2005, 2008, 2008R2, 2012, 2014 and 2016 technologies.
  • Strong performance tuning skills in a very large database environment
  • Ability to trace (using Profiler or Extended Events) and analyze results, then to recommend options for problem resolution
  • Proficient with Transact-SQL (T-SQL)
  • Experience with SQL Server DTS, SSIS and SSRS components
  • Expertise with maintaining SQL servers using NetApp SAN and in Virtual environment
  • Experience with database encryption and backup/recovery methodologies
  • Experience in SQL Server High Availability technologies like Mirroring, Replication, Log Shipping and  SQL Server 2012/2014/2016 Always On Availability Groups
  • Experience with other db technologies like MySQL, Netezza, Postgres or mongo dB, Amazon Aurora, Redshift, Dynamo db is a plus.
  • Experience with public cloud platforms like AWS, RDS, SQL Azure etc.
  • Must have superior problem-solving skills with extremely high levels of initiative and assertiveness.
  • Must have very strong interpersonal, oral and written communication skills with the ability to deal effectively with customers, peers and management.
  • Must be able to organize work efficiently and work well under stress, changing priorities, and time constraints
  • Familiar with compliance guidelines like SOC II, FINRA, is a plus.
  • Familiar with ITIL practices like Change Management, Incident Management etc. is a plus.

Morningstar is an equal opportunity employer.

001_MstarInc Morningstar Inc. Legal Entity

Read Full Job Description

Technology we use

  • Engineering
    • .NETLanguages
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • ScalaLanguages
    • D3JSLibraries
    • ReactLibraries
    • AngularJSFrameworks
    • Backbone.jsFrameworks
    • Ember.jsFrameworks
    • ExpressFrameworks
    • FlaskFrameworks
    • Node.jsFrameworks
    • PlayFrameworks
    • SpringFrameworks
    • Maria DBDatabases
    • MemcachedDatabases
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • PostgreSQLDatabases

Location

22 W. Washington , Chicago, IL 60602

What are Morningstar Perks + Benefits

Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Volunteer Time
Sabbatical
Perks & Discounts
Casual Dress
Commuter Benefits
Happy Hours
Parking
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement

Additional 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.

More Jobs at Morningstar66 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
Internships
Marketing
Operations
Product
Project Mgmt
Sales
Content
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Finance
new
Chicago
Project Mgmt
new
Chicago
Product
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Finance
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Finance
new
Chicago
Internships
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Finance
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Project Mgmt
new
Chicago
Product
new
Chicago
Sales
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Design + UX
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Sales
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Marketing
new
Chicago
Sales
new
Chicago
Finance
new
Chicago