Database Administrator

Responsibilities

• Create and manage multiple databases and capacity planning.

• Monitor and tune database performance using tools like Query Store, DMVs, and SQL Profiler.

• Maintain data integrity and security (manage roles, permission of database users).

• Use tools like SQL profiler for database tuning, should be able to generate traces, execution plans, identify performance bottleneck, deadlocks/contention and resolve them

• Develop strategies and implement solutions for managing back-ups, restoration and replication.

• Create and manage constraints and indexes.

• Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.

• Proactive housekeeping/archiving and shrinking of databases.

• Manage production, QA, Stage and development database environments.

• Create detailed documentation including diagrams of database infrastructure.

• Learn relevant business processes and understand the data flow, criticality and dependencies.

• Effectively coordinate and communicate with all the stakeholders (internal teams and clients).

Requirements

• Bachelors or Master’s degree in computer science or equivalent and a total of 3-5+ years’ experience in MSSQL Database administration using SQL Server 2014/2016/2017/2019/2022 versions.

• Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster, AlwaysOn and various replication technologies would be an advantage.

• Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

• Expertise on cloud platform like AWS, Azure etc.

• Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.

• Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.

• Ability to develop procedure documents and maintain detailed database related documents.

• Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies.

• Able to organize work efficiently and work well under stress, changing priorities, and time constraints

Nice to Have

• Expertise on MySQL/PostgreSQL/MongoDB with Linux environment including Backup, replication Configuration for DR purpose.

• Familiarity with compliance guidelines like SOC II, FINRA and best practices like ITIL, Change/Incident Management

Morningstar is an Equal Opportunity employer

Morningstar’s hybrid work environment gives you the opportunity to work remotely and collaborate in-person each week. We’ve found that we’re at our best when we’re purposely together on a regular basis, at least three days each week. A range of other benefits are also available to enhance flexibility as needs change. No matter where you are, you’ll have tools and resources to engage meaningfully with your global colleagues.