SUMMARY

• Having around 11+ years of IT experience in Database Administration on SQL Server 2016, 2014, 2012, SQL Server 2008R2, SQL Server 2008, and SQL Server 2005 for very large and complex databases on OLAP and OLTP environments .
• Expertise in Trouble shooting Performance issues
• Experience in analyzing Various Bottlenecks like locks, Blocking, Dead locks, Tempdb contention, High memory, High CPU, High I/O,
• Strong Knowledge on Indexing and Tuning the Environment according to Indexing maintenance Strategy
• Experience in Using Performance monitor tools like SQL profiler, Perfmon, Dynamic management views
• Expertise in implementing the best practices for better performance and best Administration.
• Implemented Microsoft recommendations on Production servers based on the Microsoft RAAS report
• Expertise in analyzing the cluster based issues.
• Implemented Strong Security Policy on Production Servers to restrict un authorize access of SQL SERVERS
• Up gradation and Migration:
• Expertise on Migration of SQL SERVERS from lower version to Higher versions, using In place migration and side by side migration
• Experience in migration of SQL Server databases to Azure cloud and AWS Cloud using Data migration service (DMS)
• Experience in Implementing HADR Solutions in Azure bases SQL Servers
• Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities and DMV’s
• Experience in SQL Azure Administration
• Experience in Intra database migrations like from Oracle,MY SQL, DB2, Posgress to SQL Server and vice versa
• Strong knowledge on Internals and architecture of SQL SERVER
• Periodically Monitors the Storage available on data files and log files Drives
• Implemented Monitored all types of High Availability and Disaster recovery Models, Based on the Application Requirement like
• Performed Data migration Using Import &Export Wizard of SQL SERVER.
• Expertise in End to End installation and Configuration of SQL Server on Windows Fail over Cluster
• Experience in Installation, Configuration, Maintenance and Administration of Cluster and Standalone environments
• Experience on Multi node Active/Active, Active/Passive Clusters
• Configured and scheduled the Maintenance plans, SQL SERVER Jobs based on database behavior like Full, Differential, and Log Backups, and Updating Statics,
• Regularly Monitors Back jobs, windows logs, SQL logs Maintenance plan History
• Experience in managing and making software deployments/changes in real time production environments
• Involved in the writing T - SQL and hands on experience in writing Stored Procedures, Triggers, and Functions.
• In-depth knowledge of T-SQL with the experience in constructing the triggers, tables, functions, procedures etc.
• Configured Monitoring rules and alerts For MS SCOM to avoid un necessary alerts and tuning the Gold Category Production Servers with the help of SCOM
• Working knowledge on Sentry One, SPOTLIGHT, and LITESPEED.
• Experience in SSIS Packages creation on Various ETL Transformations.
• Experience in SSRS Reporting services
• Good knowledge in MY SQL Administration
• Experience with international rollouts and Application support processes, and Ability to work in a Global Team Independently on 24x7x365 Days Basis
• Good Experience on ITIL Process
• Good experience in Agile scrum modeling
• Working Knowledge on Various Domains like Banking, Healthcare, Engineering, Oil and Gas
• Having good Exposure & Experience in End to End Transition from Client
• Collaborate with application/database developers, quality assurance and operations/support staff
• Ability to work on multiple projects at one time with minimal supervision and ensure high quality, timely delivery.
• Strong focus on getting the job done
• Flexible to update with new technical skills based on demand
• Trained to New Joiners On Technology & with Current Assignments/Projects
• Good Track Record in Achieving SLA for Tickets with High priority(P1,P2)
• Handle RCAs and providing resolutions
• Mentoring Team & Providing help / Technical suggestions to team and business

TECHNICAL SKILLS

RDBMS: MS SQL SERVER 2016,2014,2012,2005, SQL SERVER 2008,SQL SERVER2008R2,, ORACLE10g

Operating Systems: Windows server 2003, Windows server 2008, Windows server 2008R2

BI Technologies: SSIS

Programming Languages: T-SQL, OOPS concepts on C#, Java, C++

Windows Server components: Fail over clustering, Active directory, basic networking concepts

Monitoring Tools: Sentry One, Microsoft SCOM, Spotlight, SQL Diagnostic manager, Failover cluster manager

SQL Server Tools: SQL Profiler, DTA,SSMS,SQL Configuration manager, BPA(Microsoft)

Backup Tools: Lite speed

ITL Tools/ Agile Scrum: HP Service manager(HPSM),JIRA, Sprint Dashboards

PROFESSIONAL EXPERIENCE

Confidential

Lead Database administrator

Environment: SQL server 2016, 2014, 2012, 2008R2, 2008, 2005 and Azure SQL Server,Sentry One, Litespeed

Responsibilities:

• Support around 700 Physical servers and VMware virtual servers.
• Migration of Database from Native on premises to Azure cloud.
• Working with Azure based SQL Servers.
• Setting up windows failover cluster and installing, managing SQL Server on Failover cluster mode
• Setting up and managing Always ON High availably and DR solutions
• Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
• Handling Data Refreshes from Prod to QA and to Development and handing Implementation Plans from the Development and Business teams deploying on Servers as per the requirements.
• Performing ETL Transformations using SSIS.
• Database migrations across different DB platforms like From Oracle, My SQL, DB2,Posgress to SQL Server and vice versa. Using SSIS
• Creating reports using SSRS
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Configuring & Administrating Log Shipping, Database Mirroring, Replication, Disaster Recovery Plan, Index Tuning, Backup Jobs and Deploying DTS & SSIS packages.
• Implementing TDE (Transparent data encryption ) to encrypt databases
• Writing T-SQL Code to create stored procedures, triggers, functions etc.
• Responsible to take care of reporting. To full fill this responsibility written T-SQL procedures, functions, triggers and Views. As per process/Application requirement, have developed procedures for report purpose
• AD management like User, Group creation
• Working with Monitoring tools like MS SCOM, SQL Sentry, Spotlight and SQL DM.
• Working with Backup tools like lite speed, SQL Safe etc.
• Having good Exposure & Experience in End to End Transition from Client
• Work as a Shift Lead, Managing Ticket Queues & assign the task to Team Member on basis of Risk Level and also help them to Team member for resolving the issues
• Implementing Agile Scrum and ITIL models

Confidential

Senior Database administrator

Environment: SQL server 2014, 2012, 2008R2, 2008, 2005, MS SCOM, SQL Safe, SQL DM, Spotlight

Responsibilities:

• Support on 24/7 environment in MS SQL Server 2014, 2012, 2008R2, 2008 and2005.
• Worked on administering SQL Server hosted on VMWare virtual servers
• Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
• Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Handling Data Refreshes from Prod to QA and to Development and handing Implementation Plans from the Development and Business teams deploying on Servers as per the requirements.
• Worked on T-SQL Code to create stored procedures, Functions, Triggers etc.
• Planning and implementing HADR solutions like Always ON HADR, Database mirroring, log shipping.
• Implemented SQL Server Replication with Peer-Peer, transaction, merge replication topology
• Implemented TDE (Transparent data encryption)
• Worked on SSIS for various data transformations
• Crated SSRS Reports
• Implementing agile process and scrum mastering.
• Done Data migration tasks as part of architectural projects and design tasks
• Individual contributor for few application databases.

Confidential

Senior Database administrator

Environment: SQL server 2012, 2008R2, 2008, 2005, 2000, Server,Sentry One, Litespeed

Responsibilities:

• Worked as 24X7 production support with a rotation basis.
• Supporting 800 GB of database Installation & Configuration of SQL Server 2008 on Remote systems.
• Up gradation/Migration of SQL Server 2005 databases to SQL Server 2008.
• Created VMware based virtual machines to install SQL Server and configured Always ON HADR, Failover clustering on VMware based virtual machines
• Maintaining the Security of the Database, assigning responsibilities as part of Security.
• Configured log shipping from production system to stand by servers.
• Configured Database Mirroring.
• Configured Transactional Replication between the production servers
• Managing Transaction log and Data file size growth and shirking of databases.
• Implemented Disaster Recovery procedures for production servers.
• Worked on writing T-SQL Code to implement custom stored procedures, triggers and functions etc..
• Rebuilding the indexes at regular intervals for better performance.
• Implemented data encryption using transparent data encryption (TDE).
• Worked on SSIS ETL migrations to move tables and other objects across different database servers.
• Resolved and tweaked memory pressures caused during product release
• Worked with customers on Application rollouts and server migrations
• Created Index for the large tables.