Database Administrator
Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 backups 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 Masters degree in computer science or equivalent and a total of 35 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/TSQL.
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
Morningstars hybrid work environment gives you the opportunity to work remotely and collaborate inperson each week. Weve found that were at our best when were 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 youll have tools and resources to engage meaningfully with your global colleagues.
I10MstarIndiaPvtLtd Morningstar India Private Ltd. (Delhi) Legal EntityRequired Experience:
Unclear Seniority
Employment Type
Full-Time
