Sr Database Admin

9/2014 – 1/2017

.SQL server Installation, Patching and up gradation.
•Database creation, database refreshes, alert monitoring and Backup script creations.
•Database migration from SQL 2008R2 to SQL Server 2012
•Have configured replication and mirroring as per customer requirement.
• Checking the database data files and log files is located specific drive and observe the available free space.
•Database refreshes from production backup to Test and Development environments.
•Managing Installation of SQL server 2008 R2 cluster and applying the latest service packs.
•Configuring database mail for SQL server alerts.
•Installation of SQL server 2008 R2 and applying the latest service packs.
•Setting up and troubleshooting issue in Replication.
•Experience in setting up two node Active-Active and Active-Passive clustering
•Patching all the DB Servers to the Latest Service Pack levels periodically to be Compliant with the Microsoft Support.
•Experience in setting up two node Active-Passive clustering
•Responsible for trouble shooting failed jobs and Replication Related issues etc.
•Managing user creation and providing permission as per user’s requirements.
•Set up linked servers and troubleshooting any issues related to ODBC connectivity.
•Checking Alerts and resolve issues to take appropriate action as need.
•Configuration and troubleshooting issue in Database mirroring.
•Building databases with Transactional Replication.
•Worked on the Time finder.
•Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning
•Managing Security of the Database.
•Fixing Orphaned users.
•Monitoring the Scheduled jobs.
•Implementation of SQL Logins, Roles and Authentication Modes.
•Rebuilding the indexes at regular intervals for better performance.
•Managing space for data files and log files.
•As a part of the DBA team providing 24x7 production support to the clients.

Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL-Server (MS SQL)