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

Job description

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