Database Developer

| Chicago

As a Database Developer with strong background in Microsoft database technologies you will work as part of Corporate Systems technology team and you will be responsible for designing and developing optimal database solutions that cater to a variety of application and business requirements. This position will provide the opportunity to work on a wide variety of projects, where you can apply your existing knowledge to solve business problems.. The ideal candidate is a diligent, hardworking individual with strong Microsoft SQL  background, who is able to learn new systems and processes rapidly, who can work with little supervision.

Responsibilities

  • 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.
  • Creates 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

Requirements

  • Bachelor's Degree in MIS or Computer Science related field.
  • 3+ of experience in design, development, and maintenance of Microsoft SQL Server databases.
  • 3+ years of experience with SQL Server 2008 R2 & Later TSQL, Database Design, & Schema Principles
  • Experience using MS SQL Server Management Studio is required
  • Experience using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) packages is required
  • Strong organizational, analytical, and communication skills, both oral and written, are required.
  • Experience with database performance analysis & indexing principles
  • Familiarity with source control concepts and tools
  • Experience with cloud platforms such as AWS, Azure is a plus.
  • Experience with data visualization platform such as Tableau is a plus.
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
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 Morningstar76 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
Internships
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Content
Finance
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago
Product
new
Chicago
Data + Analytics
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Product
new
Chicago
Operations
new
Chicago
Product
new
Chicago
Marketing
new
Chicago
Operations
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Finance
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Product
new
Chicago
Operations
new
Chicago
Project Mgmt
new
Chicago
Design + UX
new
Chicago
Operations
new
Chicago
Internships
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Finance
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Finance
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Design + UX
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Sales
new
Chicago
Design + UX
new
Chicago
Operations
new
Chicago
Finance
new
Chicago