The SQL Server Database Administrator (DBA) is responsible for the design, implementation, maintenance, and optimization of Microsoft SQL Server databases. The role involves ensuring the availability, security, performance, and integrity of databases, as well as collaborating with development teams and other IT professionals to deliver efficient database solutions.
Responsibilities
• Should have MSSQL DBA experience managing On-prem and cloud Azure MI PAAS, IAAS SQL server databases
• Experience supporting database performance, evaluating and resolving processing and programming problems
• Analyze, solve, and correct issues in real time
• Provide suggestions for solutions
• Good experience on High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Provide 24x7 support for critical production systems
• Microsoft Azure cloud day to day administration.
• Upgrade and Migration of databases from SQL Server 2008/2008r2/2012/2014/2016/2019/2022.
• Experience in working with programmers and assisting in optimizing databases for operational and performance efficiency
• Installation and configuration of SQL server 2016/2017/2019 in cluster and standalone setting.
• Support business applications, ensuring system availability, security, performance and reliability.
• ETL application support, SSIS package administration/deployment/troubleshooting
• SQL server pathing on single instance and cluster environments.
• Expert level skills in Backup and restore database operations and executing SSIS packages
• Monitoring SQL server performance using SQL Profiler, INDEX tuning wizard and performance monitor.
• Replication, Always on availability groups and clustering
• Experience working in Active/Passive. Active/active cluster environment.
• Implementation of SQL Server security and Object permissions like maintaining creation o
📌 ESaaS - DBA - Sys Admin (Pune)
🏢 Zensar
📍 Pune
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.