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
- Good 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
- Good knowledge on Security Management like Auditing,

📌 Walk-in || MSSQL | DBA | 24/7 (Pune)
🏢 Hexaware Technologies
📍 Pune