Senior Software Engineer at Morningstar

| Chicago
!Sorry, this job was removed at 4:12 p.m. (CST) on Thursday, January 23, 2020

The Team:

The Managed Portfolios Technical Operations team works primarily to support Morningstar’s Turnkey Asset Management Platform (TAMP) which is used by thousands of investment advisors.  The team provides solutions to technical issues involving the TAMP website and associated processes which load data, create investment advisor pdf reports, research client issues, and support our Trading systems.  The Tech Ops team's goal is to resolve issues quickly, to learn the root cause of issues and document them, and to create/improve systems to either prevent future recurrences of the same issues, or to provide tools so that Ops Team members can provide resolutions directly. 

 

Responsibilities:

  • Provide excellent customer service by responding to and efficiently resolving client/service desk issues involving data inconsistency, working closely with Client Service/Operations team.
  • 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:
  • Provide excellent pro-active, real-time monitoring of database, detecting any issues and making sure they are fixed or escalated.
  • Work with Development teams to assist in testing and deployment of new software/updates.
  • Diagnose and correct errors for example in data integrity or application configuration.
  • Creating and updating documentation.
  • Database 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
  • Maintain/develop/enhance Support Tools using C# .Net and other MS technologies
  • Perform ad hoc data queries to support customer and business needs
  • Responsible for DR tests on regular basis

 

Requirements:

  • A bachelor`s degree in computer science or related field with a specialization in relational database management systems.
  • Five or more years of experience in database administration using SQL Server 2005, 2008, 2008R2, 2012, and 2014 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 Always On Availability Groups
  • Experience with other DB technologies like MySQL, Amazon RDS, Postgres or mongodb is a plus.
  • 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.
  • 3 years of experience with C# .Net
  • Must be able to organize work efficiently and work well under stress, changing priorities, and time constraints
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 Morningstar68 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Internships
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Developer
new
Chicago
Data + Analytics
new
Chicago
Marketing
new
Chicago
Marketing
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Design + UX
new
Chicago
Sales
new
Chicago
Design + UX
new
Chicago
Finance
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Sales
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Internships
new
Chicago
Finance
new
Chicago
Marketing
new
Chicago
Product
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago
Marketing
new
Chicago
Design + UX
new
Chicago
HR
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Data + Analytics
new
Chicago
Design + UX
new
Chicago
Finance
new
Chicago
Marketing
new
Chicago
Design + UX
new
Chicago
Operations
new
Chicago