Database Developer

| Chicago

Design and document logical and physical database models to cater to a variety of business requirements.  Develop advanced T-SQL code for implementing application business logic using stored procedures, views, and functions. Collaborate with other Database Administrators and Applications/ Business teams to support enterprise applications; develop data warehouse objects and processes for supporting business intelligence, including ETL, fact/dimension tables.  Design and implement reports and dashboards utilizing SSRS as required; assist in the migration of several databases and associated SSIS routines to a new set of SQL Servers. Create standards for SQL Server database administration that supports the use of optimal database server resources and performance.  Implement automated database maintenance plans and backup routines using standard methodologies.  Monitor database/ application growth and server resources to ensure optimum performance and availability. Routinely evaluate/ implement improved methods or processes for administering and maintaining databases and servers.

 

Job Requirements:

  • Bachelor’s degree in MIS, Computer Science, or a related field.
  • 3 years of experience in design, development, and maintenance of Microsoft SQL Server Databases.
  • 3 years of experience with SQL server 2008 R2 and later TSQL, database design, and schema principles.
  • 3 years of experience using MS SQL Server Management Studio.
  • 3 years of experience using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) packages. 
  • 3 years of experience with database performance analysis and indexing principles.
  • 2 years of experience using source control tools such as GIT or SVN. 
  • 1 year of experience with cloud platforms such as AWS or Azure.

 

Morningstar is an equal opportunity employer.

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

Culture
Volunteer in local community
Friends outside of work
Eat lunch together
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Employee Stock Purchase Plan
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Flexible Work Schedule
Family Medical Leave
Adoption Assistance
Company sponsored family events
Acme co. sponsors family oriented events Annually.
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Volunteer Time
Sabbatical
Paid Holidays
Perks & Discounts
Casual Dress
Commuter Benefits
Happy Hours
Parking
Recreational Clubs
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Promote from within
Mentorship program
Our mentorship program includes 1-to-1 program, Career mentoring, Leadership mentoring.
Continuing Education stipend
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 Morningstar66 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Content
Content
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
new
Content
new
Chicago
Finance
new
Chicago
Operations
new
Chicago
new
Operations
new
Chicago
Operations
new
Chicago
new
Data + Analytics
new
Chicago
Design + UX
new
Chicago
Sales
new
Chicago
Design + UX
new
Chicago
new
Operations
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Finance
new
Chicago
Marketing
new
Chicago
new
Product
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago
HR
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Design + UX
new
Chicago
Finance
new
Chicago
Marketing
new
Chicago
Design + UX
new
Chicago
Operations
new
Chicago