Walk-in || MSSQL | DBA | 24/7

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