3.0 - 7.0 years

0 Lacs

navi mumbai, maharashtra

On-site

As a Database Administrator at our organization, your primary responsibility will be to create and manage multiple databases, ensuring optimal performance and capacity planning. You will be tasked with monitoring and tuning database performance using tools such as Query Store, DMVs, and SQL Profiler. It will be crucial for you to maintain data integrity and security by managing roles and permissions of database users. Additionally, you will utilize SQL Profiler for database tuning, generating traces, execution plans, identifying performance bottlenecks, deadlocks/contention, and resolving them. You will also play a key role in developing strategies and implementing solutions for managing backups, restoration, and replication. Creating and managing constraints and indexes, as well as supporting software developers with database operations including the development of complex SQL, tuning of DML, and the creation of stored procedures, will be part of your daily tasks. Proactive housekeeping/archiving and shrinking of databases will also be within your scope of work. In this role, you will manage production, QA, Stage, and development database environments. Creating detailed documentation, including diagrams of database infrastructure, will be essential. It is important for you to learn relevant business processes, understand the data flow, criticality, and dependencies, and effectively coordinate and communicate with all stakeholders, including internal teams and clients. To qualify for this position, you should hold a Bachelor's or Master's degree in computer science or equivalent and have a total of 3-5+ years of experience in MSSQL Database administration using SQL Server 2014/2016/2017/2019/2022 versions. Experience in SQL Server Clustering and HA technologies, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS) is required. Expertise in cloud platforms such as AWS, Azure, etc., sound knowledge of RDBMS concepts, database architecture, and SQL/T-SQL are essential. You should be proficient with SQL Server Profiler for monitoring and troubleshooting database activity and performance, with the ability to develop procedure documents and maintain detailed database-related documents. An innovative approach to work, constantly seeking to upgrade systems to more efficient technologies, and the ability to organize work efficiently under stress, changing priorities, and time constraints are valuable skills for this role. Additionally, experience with MySQL/PostgreSQL/MongoDB in a Linux environment, including Backup, replication configuration for DR purposes, and familiarity with compliance guidelines like SOC II, FINRA, and best practices like ITIL, Change/Incident Management would be advantageous. Morningstar is an Equal Opportunity employer. Our hybrid work environment offers the opportunity to work remotely and collaborate in-person each week. We believe that we are most effective when we intentionally come together regularly, at least three days each week. We provide a range of benefits to enhance flexibility as needs change, ensuring that no matter where you are, you have the tools and resources to engage meaningfully with your global colleagues.,

Posted 1 day ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.