Citizen
Full Time
Direct Hire
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 11th May 2022
Roles & Responsibility :
- Installation and Configuration of SQL Server Instance.
- Upgrading the Servers and applying the Service Packs and Hot fixes.
- Handling Production, UAT & Dev servers for SQL 200520082012201420162017.
- Monitoring day to day tickets, assigning then to resolve per SLA.
- Creating logins and user as per application team request.
- Providing Security by giving access permission to users at various levels.
- As per user request working on database refreshment.
- Identifying, Analyzing and Resolving performance issues of the server.
- Monitoring SQL Server performance by finding deadlocks and blocking
- Monitoring the performance of the servers as per checklist.
- Planning & Performing Backups and Restoring of the databases.
- Experience in Point-in-Time DB Recovery and Page Corruptions.
- Scheduling and maintaining maintenance plan, job and alerts.
- Reviewing SQL server and SQL Server Agent Error Logs.
- Creating Indexes to improve performance for DevApp team request
SQL Server Skills :
- Installing, Configuring SQL Servers and applying SP's.
- Installations like Slipstream, SYSPREP, Unattended and INI based.
- Creating Logins, Users and managing Roles & User permissions.
- Ensuring periodical Backups and knowledge on all SQL Native Backups.
- System Databases Recovery like Master, Model & MSDB.
- Creating and maintaining scheduled jobs, maintenance plans.
- DB level HADR such as Log Shipping, Mirroring, Always On AG.
- Instance level HADR Active-ActiveActive-Passive clustering and applying hot fixes and SP's using Rolling Upgrade.
- Side by Side Migration and In-Place upgrade of SQL Server.
- Informing application teams about resolving BlockingDeadlock issues.
- Performing maintenance tasks like Clustered Index, Non-Clustered Index and identifyingfixing Fragmentation by Re-OrgRebuild.
- Experienced in DBCC, DMV commands to improve the performance and knowledge on DDL, DML, DRL, DCL, TCL and Store procedures.
- Hands on Experience in applying Service packs on SQL Servers and applied Service on cluster instance.
- Worked and fixed on MSI and MSP file missing issues while applying service packs