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
- Good 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
- Positive 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, Logins & Users. Managing security by creating logins and users with necessary permission to maintain

Functional Role:

- Proactively analyzing the ticket trend and reducing the count by permanently resolving it
- Good analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player
- Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure
- Coordinating and facilitating change review meetings and helping in the management of incidents according to SLAs
- Managed all risks, issues, and actions logs
- Prepared and submit management daily/weekly/monthly/Adhoc reports
- Analyzing technology requirements and developing functional specifications
- Presenting and implementing technological alternatives to streamline functions and improve productivity

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