Database Administrator

| Chicago | Hybrid
Sorry, this job was removed at 9:15 a.m. (CST) on Tuesday, July 3, 2018
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

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
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Technology we use

  • Engineering
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RubyLanguages
    • ScalaLanguages
    • SqlLanguages
    • D3JSLibraries
    • ReactLibraries
    • ASP.NETFrameworks
    • Backbone.jsFrameworks
    • Ember.jsFrameworks
    • ExpressFrameworks
    • FlaskFrameworks
    • Node.jsFrameworks
    • PlayFrameworks
    • SpringFrameworks
    • MariaDBDatabases
    • MemcachedDatabases
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • PostgreSQLDatabases

Location

22 W. Washington , Chicago, IL 60602

An Insider's view of Morningstar

What does your typical day look like?

Every day is a little different. Our team is focused on POC (Proof of Concepts). My work involves problem-solving, development and software design. I work on the Data collections team, currently most of this involves, on a high level, automating the process currently used to collect data from raw sources through Machine Learning.

Upasna

Software Engineer, Data Collections - AI R&D

How does the company support your career growth?

We believe in promoting from within, based on previous impact to the team. Whenever possible, we will stretch our employees to take on expanded roles that aligns with the career progression they are interested in.

Jeff

Head of Technology and Product

What are Morningstar Perks + Benefits

Morningstar Benefits Overview

At Morningstar, your contributions have meaning and can drive change. Across our 27 offices worldwide, we’ve invested in fostering a community where talented, driven people can grow. Our entrepreneurial spirit and uncompromising ethics guide everything we do. It’s all in the name of empowering investors. Morningstar is proud to offer a comprehensive benefits package to eligible, full-time employees in the United States who work a minimum of 30 hours per week. Our benefits are designed to invest in your -- and your family's well-being, including investments in your health and financial future.

Culture
Volunteer in local community
Morningstar encourages our colleagues to become involved in their communities, by providing paid time off for volunteer activities.
Partners with nonprofits
Open door policy
OKR operational model
Team based strategic planning
Open office floor plan
Flexible work schedule
Morningstar provides employees with a flexible work schedule that includes Summer hours, Work from home, Flexible start and end times.
Remote work program
The safety of our employees is very important to us. We have been operating remotely due to COVID-19.
Diversity
Dedicated diversity and inclusion staff
Mandated unconscious bias training
Morningstar encourages unconscious bias training for all employees, especially managers and hiring personal. We believe that by raising awareness of bias we can decrease its effects.
Diversity manifesto
Diversity employee resource groups
Hiring practices that promote diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Morningstar offers two Flexible Spending Accounts (FSA)— one for healthcare expenses and one for dependent care expenses. You may enroll in both $ determine the contribution amount.
Disability insurance
Dental insurance
Our dental plan covers 100% of preventive services, 80% of basic services, and 50% of major services.
Vision insurance
With Morningstar's vision benefits you can get an annual eye exam with an in-network provider with just a $10 copay.
Health insurance
Morningstar continues to offer the choice of two medical plans—the Savings Plan and the Classic Plan. Both are administered by Blue Cross and Blue Shield of Illinois (BCBS).
Life insurance
Morningstar offers 4 tiers of life insurance that offer varying benefits. Basic Life insurance is equal to 1 times an employee's annual salary.
Wellness programs
Mental health benefits
Our insurance covers 80% on in-network mental health services. Our Employee Assistance Program provides no-cost, confidential, 24-hour counseling on a wide variety of issues.
Financial & Retirement
401(K)
Take advantage of a number of Morningstar tools to help you manage your 401(k) account and your finances, including Morningstar Retirement Manager, available to you at no cost.
401(K) matching
Morningstar provides employees with a 401(k) matching plan managed. We match $0.75 for every dollar contributed, up to a maximum of 7% of employee pay contributed to the plan each pay period.
Company equity
Morningstar’s global employee equity benefit, Shared Ownership, enables you to take a portion of your bonus payout and exchange it for RSUs, with Morningstar providing an additional 50% match.
Employee stock purchase plan
Colleagues who exceed their performance goals substantially may be eligible for Impact RSU Awards as an additional reward on top of their cash bonus/commission award.
Performance bonus
Charitable contribution matching
Morningstar's Matching GIfts program will match your charitable giving up to the local currency equivalent of $500 USD per calendar year.
Child Care & Parental Leave Benefits
Childcare benefits
Morningstar offers the option of in-home child and elder care, in addition to the existing day care center back-up care benefit.
Generous parental leave
Morningstar has a global minimum of 6 weeks paid time-off to bond with new family members. This benefit applies to all individuals equally, including birth mothers, fathers, adoptive parents.
Family medical leave
Eligible employees may take up to 12 weeks of job-protected, unpaid leave per year for certain specified reasons, and up to a total of 26 workweeks of leave to care for a family member.
Adoption Assistance
We reimburse up to 80% for eligible adoption expenses, up to $4,000 per adoption, in addition to a minimum of 6 weeks paid time off.
Return-to-work program post parental leave
Company sponsored family events
Morningstar sponsors family oriented events Annually.
Vacation & Time Off Benefits
Unlimited vacation policy
Generous PTO
Paid volunteer time
Our employees receive 2 days per year of paid volunteer time.
Sabbatical
Paid holidays
Paid sick days
Office Perks
Commuter benefits
Company-sponsored outings
Some meals provided
Company-sponsored happy hours
Onsite office parking
Recreational clubs
Fitness stipend
Professional Development Benefits
Job training & conferences
Tuition reimbursement
Lunch and learns
Promote from within
Mentorship program
Continuing education stipend
Continuing education available during work hours
Online course subscriptions available
Customized development tracks
Paid industry certifications

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 Morningstar

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about MorningstarFind similar jobs like this