Role & responsibilities

JD for MSSQL track

Operational Role:
Experience in installation and configuration of MS SQL Server 2012/2014/2016/2017/2019/2022 versions, upgrades, maintenance plans etc.
Experience in applying necessary SQL Server service packs and CUs / Hot fixes / Security updates
Preparing DR strategies and implementing DR practice tests for mission critical databases to build DR availability confidence
Positive knowledge on maintaining databases in Azure
Experience in identifying blockings, deadlocks, index fragmentation, High CPU usage queries.
Good knowledge of using DMVs and DBCC commands for troubleshooting.
Experience in Configuring Transactional Replication setup, maintenance, and troubleshooting
Experience in HA concepts likes clustering, database mirroring, Log shipping, Replication and AlwaysOn
Performing database refreshes between various DB environments
Capacity management which includes planning and recommend the application owners to archive the historical data / data file movement to improve the storage capacity




Standardize SQL Server environment by designing guidelines for SQL Server installation, configuration, storage specifications, CPU, Memory, account, and security to follow best practices and standards
Performance and Tuning, Query optimization using SQL profiler, DTA, Perfmon, DMVs, DBCC and SSMS Proactive health checks
Experience in Business Intelligence components like SSIS, SSRS and SSAS
Responsibility for the success of Migration of databases, SSRS & SSAS
Valuable technical knowledge on BI Components
knowledge on PowerShell scripting & T-SQL scripting
Good knowledge on Stored procedure, Triggers, functions & joins
Enhancement, Troubleshooting & Maintaining the existing SSRS Reporting
Gook knowledge on ITIL processes like Incident, Service Request, Change and Problem management
Knowledge on Backup and Restoration through Veritas backup tool
Valuable knowledge on Security Management like Auditing,

📌 Walk In Mssql Dba 24/7 Pune
🏢 Hexaware Technologies
📍 Pune