Senior Database Administrator at Morningstar

| Chicago
Sorry, this job was removed at 4:14 p.m. (CST) on Thursday, June 3, 2021
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
  • Analyzes and defines the properties required by a database management system (RDBMS) that will meet the current and future needs of the company. Defines the physical and logical database structure for current and future application development.

  • 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 administration of databases, including set-up, backup processes, documentation updates, monitoring and maintenance. Understand and expand the architecture of the Microsoft solution.

  • Utilize experience in SQL server clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies.

  • Utilize experience in data center migration and migrating on premise DB servers to public cloud.

  • Utilize experience in performance tuning, query optimization, using performance monitor, SQL profiler and other related monitoring and troubleshooting tools.

  • Ability to detect and troubleshoot SQL server related CPU, memory, I/O, disk space and other resource contention.

  • Utilize knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.

  • SQL development- ability to write and troubleshoot SQL code and design (store procs, functions, tables, views, triggers, indexes, constraints)

  • Utilize experience with SSIS package creation and debugging skills

  • Solid acquaintance with windows server, security delegation, SPNs, storage components.

  • Utilize experience in oracle e-business suite administration, installation, maintenance and support.

  • Supporting EBS 12.2 application and 11g/12c/18c database.

  • Utilize experience with patching, cloning, taking backups (RMAN), handling archives and regular maintenance activities.

  • Resolve connection issues and configure TSNNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

  • Utilize experience with Linux/UNIXx, bash scripting, and PowerShell.

  • Utilize experience in applying oracle applications and database patches (pre-patch analysis, adpatch, Opatch) and schedule downtime for applying of patch.

  • Support open-source DB platforms like MySQL, postgres, Amazon Aurora, Redshift

  • Familiarity with and capable of enforcing technology management practices such as CI/CD (continuous integration/continuous delivery).

  • Working knowledge of network, server, and firewall technologies as they relate to SQL server

  • Familiar with ITIL practices like change management, incident management etc.

 

Requirements:

Bachelor’s degree or foreign equivalent in Computer Science, Computer Information Systems, Electronic Engineering or a related field and 5 years of experience.

 

This position also requires:

  • 5 years of experience as MSSQL production DBA including experience with design, implementation, backup and recovery, monitoring, and performance tuning.

  • 5 years of experience managing databases in virtual and cloud environments (AWS, Azure, Redshift, VMware, RDS, EC2)

  • 5 years of hands-on experience of install/configure/monitor/support SQL Server 2014/2016/2017/2019.

  • 5 years of hands-on experience of configure/support SQL Server AlwaysOn/Log Shipping/Replication features

  • 5 years of experience with Database encryption technologies.

  • 5 years of hands-on experience of install/configure/support SQL Server databases on AWS/Azure

  • 5 years of hands-on experience of SQL Server upgrades, database migrations & applying SQL security patches

  • 5 years of experience with Software Development Life Cycle (SDLC) tools

  • 5 years of experience using SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies.

  • 5 years of experience using ITIL practices like Change Management, Incident Management etc.

  • 5 years of experience on below 3rd party Database and application tools:

    • ETL/Data Warehouse Tools: SSIS/DTS, BCP, SSDT

    • Reporting: SSRS (SQL Server Reporting Services) - Enterprise Reporting

    • Third Party Tools: SolarWinds, DD Boost Backup tool, Red Gate

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
    • .NETLanguages
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RubyLanguages
    • ScalaLanguages
    • SqlLanguages
    • D3JSLibraries
    • ReactLibraries
    • AngularJSFrameworks
    • 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
Friends outside of work
Eat lunch together
Intracompany committees
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
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
Someone's primary function is managing the company’s diversity and inclusion initiatives
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 Benefits
Our dental plan covers 100% of preventive services, 80% of basic services, and 50% of major services.
Vision Benefits
With Morningstar's vision benefits you can get an annual eye exam with an in-network provider with just a $10 copay.
Health Insurance Benefits
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.
Retirement & Stock Options Benefits
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
Match charitable contributions
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
Child Care 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.
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.
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
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Some Meals Provided
Happy Hours
Parking
Recreational Clubs
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Continuing Education stipend
Time allotted for learning
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 Morningstar121 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Internships
Marketing
Operations
Product
Project Mgmt
Sales
Developer
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Internships
new
Chicago
Operations
new
Chicago
Marketing
new
Chicago
Design + UX
new
Chicago
Design + UX
new
Chicago
Data + Analytics
new
Chicago
Finance
new
Chicago
Project Mgmt
new
Chicago
Marketing
new
Chicago
Operations
new
Chicago
Project Mgmt
new
Chicago
Marketing
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Internships
new
Chicago
Operations
new
Chicago
Internships
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Sales
new
Chicago
Project Mgmt
new
Chicago
Data + Analytics
new
Chicago
Marketing
new
Chicago
Design + UX
new
Chicago
Finance
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Design + UX
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Chicago
Design + UX
new
Chicago
Developer
new
Chicago
Marketing
new
Chicago
Design + UX
new
Chicago
Developer
new
Chicago
Internships
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Marketing
new
Chicago