Support and monitor Morningstar's production SQL Server databases, install and deploy databases/servers, perform capacity planning, tuning, backups/restoration/replication, manage roles/permissions, develop procedures and documentation, coordinate with stakeholders, and maintain HA/DR and environment standards across production, QA, stage, and development.
Database Administrator at Morningstar India Pvt Ltd
Location: Vashi, Navi Mumbai
Shift: UK Shift
Morningstar India Pvt Ltd is seeking a MSSQL Database Administrator to work within the Database Operation team.
The Area: The Data Technology department is responsible for setting enterprise database standards and policies that are designed to protect the data confidentiality, data integrity and data availability of Morningstar information. The Database Operation team offers guidance and technical expertise in establishing database standards infrastructure standards, Architect solution (HA/DR), Develop detailed database infrastructure design, install/deploy databases, monitoring, Server inventory.
The Role: The Database Administrator will assist in supporting and monitoring Morningstar's Production Databases. This individual will help installing/deploying new databases as well servers as per the Morningstar's product team requirement. This individual will help in standardize Database Administration including the operating model, practices, procedures, and technologies. This position is based in our Mumbai location.
Responsibilities- Create and manage multiple databases and capacity planning- Monitor, maintain database system and troubleshoot problems that may arise- 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 2012/2014/2016/2017/2019 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).- 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- Expertise on cloud platform like AWS, Azure etc. would be added advantage
Morningstar is an equal opportunity employer.
Morningstar's hybrid work environment gives you the opportunity to collaborate in-person each week as we've found that we're at our best when we're purposely together on a regular basis. In most of our locations, our hybrid work model is four days in-office 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.
I10_MstarIndiaPvtLtd Morningstar India Private Ltd. (Delhi) Legal Entity
Location: Vashi, Navi Mumbai
Shift: UK Shift
Morningstar India Pvt Ltd is seeking a MSSQL Database Administrator to work within the Database Operation team.
The Area: The Data Technology department is responsible for setting enterprise database standards and policies that are designed to protect the data confidentiality, data integrity and data availability of Morningstar information. The Database Operation team offers guidance and technical expertise in establishing database standards infrastructure standards, Architect solution (HA/DR), Develop detailed database infrastructure design, install/deploy databases, monitoring, Server inventory.
The Role: The Database Administrator will assist in supporting and monitoring Morningstar's Production Databases. This individual will help installing/deploying new databases as well servers as per the Morningstar's product team requirement. This individual will help in standardize Database Administration including the operating model, practices, procedures, and technologies. This position is based in our Mumbai location.
Responsibilities- Create and manage multiple databases and capacity planning- Monitor, maintain database system and troubleshoot problems that may arise- 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 2012/2014/2016/2017/2019 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).- 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- Expertise on cloud platform like AWS, Azure etc. would be added advantage
Morningstar is an equal opportunity employer.
Morningstar's hybrid work environment gives you the opportunity to collaborate in-person each week as we've found that we're at our best when we're purposely together on a regular basis. In most of our locations, our hybrid work model is four days in-office 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.
I10_MstarIndiaPvtLtd Morningstar India Private Ltd. (Delhi) Legal Entity
Morningstar Navi Mumbai, Maharashtra, IND Office
14th Floor, Platinum Techno Park, Pranavanandji Marg, Sector 30, Vashi, Navi Mumbai, Maharashtra, India, 400703
Similar Jobs at Morningstar
Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Lead a stream-aligned engineering team to migrate datasets to a new pipeline. Provide strategic and hands-on technical leadership in Java and React.js, enforce microservices principles, coordinate architecture and delivery, remove impediments, manage stakeholders, and foster high-performance, autonomous teams practicing Agile and engineering best practices.
Top Skills:
AWSAzureGCPGithub CopilotJ2EeJavaMicroservicesMs SqlMySQLOracleReact
Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
The Senior Software Engineer will develop and maintain AI agents and applications, modernize platforms, and enhance product experiences using various AI tools, while following Agile methodologies.
Top Skills:
AWSAws BedrockClaude CodeGithub CopilotHarnessJenkinsMicrosoft Copilot StudioNoSQLPythonSQL
Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
The Senior Product Owner will manage the Retirement Manager application, overseeing projects, guiding product development, and enhancing customer experience through data-driven decisions and team collaboration.
Top Skills:
Agile Development Framework
What you need to know about the Mumbai Tech Scene
From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.
