Database Administrator

3 - 7 years

0 Lacs

Posted:23 hours ago| Platform: Shine logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

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.,

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

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.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Morningstar logo
Morningstar

Financial Services

Chicago IL

RecommendedJobs for You

Chennai, Tamil Nadu, India

Pune, Maharashtra, India

Chennai, Tamil Nadu, India