Database Administrator

Morning Star — Mumbai

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 i

View on HireSetu