Database Administrator

As a Database Administrator at Morningstar India Pvt Ltd, your role will involve assisting in supporting and monitoring Morningstar's Production Databases. You will be responsible for creating and managing multiple databases, monitoring and troubleshooting problems, maintaining data integrity and security, and developing strategies for managing back-ups, restoration, and replication. Additionally, you will support software developers with database operations, manage database environments, and create detailed documentation of database infrastructure. Key Responsibilities: - Create and manage multiple databases and capacity planning - Monitor, maintain database system and troubleshoot problems - Maintain data integrity and security - Develop strategies for back-ups, restoration, and replication - Create and manage constraints and indexes - Support software developers with database operations - Proactive housekeeping/archiving and shrinking of databases - Manage production, QA, Stage, and development database environments - Create detailed documentation of database infrastructure - Coordinate and communicate effectively with stakeholders Qualifications Required: - Bachelors or Master's degree in computer science or equivalent - 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 - Experienced in SQL Server Integration Services (SSIS) and 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 - Ability to develop procedure documents and maintain detailed database related documents - Innovative approach to work and ability to upgrade systems efficiently - Able to organize work efficiently and work well under stress Nice to Have: - Expertise in MySQL/PostgreSQL/MongoDB with Linux environment - Familiarity with compliance guidelines like SOC II, FINRA, and best practices like ITIL - Expertise on cloud platforms like AWS, Azure would be an added advantage Morningstar is an equal opportunity employer. They offer a hybrid work environment that allows collaboration in-person each week, with a range of benefits available to enhance flexibility. Tools and resources are provided to engage meaningfully with global colleagues. As a Database Administrator at Morningstar India Pvt Ltd, your role will involve assisting in supporting and monitoring Morningstar's Production Databases. You will be responsible for creating and managing multiple databases, monitoring and troubleshooting problems, maintaining data integrity and security, and developing strategies for managing back-ups, restoration, and replication. Additionally, you will support software developers with database operations, manage database environments, and create detailed documentation of database infrastructure. Key Responsibilities: - Create and manage multiple databases and capacity planning - Monitor, maintain database system and troubleshoot problems - Maintain data integrity and security - Develop strategies for back-ups, restoration, and replication - Create and manage constraints and indexes - Support software developers with database operations - Proactive housekeeping/archiving and shrinking of databases - Manage production, QA, Stage, and development database environments - Create detailed documentation of database infrastructure - Coordinate and communicate effectively with stakeholders Qualifications Required: - Bachelors or Master's degree in computer science or equivalent - 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 - Experienced in SQL Server Integration Services (SSIS) and 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 - Ability to develop procedure documents and maintain detailed database related documents - Innovative approach to work and ability to upgrade systems efficiently - Able to organize work efficiently and work well under stress Nice to Have: - Expertise in MySQL/PostgreSQL/MongoDB with Linux environment - Familiarity with compliance guidelines like SOC II, FINRA, and best practices like ITIL - Expertise on cloud platforms like AWS, Azure would be an added advantage Morningstar is an equal opportunity employer. They offer a hybrid work environment that allows collaboration in-person each week, with a range of benefits available to enhance flexibility. Tools and resources are provided to engage meaningfully with global colleagues.