SUMMARY

• 9+ years of experience as Microsoft SQL Server Database Administrator.
• Experience in handling SQL server 2005/2008/2012/2014 and 2016 production databases.
• Expertise in installation Client and Server, configuration, Backup & Recovery, application support, Resource Management, User & Security Management.
• Experience in maintaining and automating SQL server.
• Experience in monitoring and troubleshooting SQL server.
• Extensive Knowledge in creating and scheduling several SSIS/DTS packages.
• Implemented High Availability & Disaster Recovery techniques like Always ON Availability Groups, SQL Clustering (Both Active - Active and Active--Passive) on windows failover cluster.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Migrated databases and upgraded the versions from SQL Server 2005 to 2008, 2005 to 2012, 2008R2 to 2012 and 2012 to 2014.
• Experience in Implementing Database maintenance plans using SQL Agent or through Custom SQL Scripts for database backups\Restores, index maintenance plans and etc.
• Worked on Citrix environments to connect the servers.
• Configured SQL Mail for Automated Job Status Notifications and Managing Operators.
• Experience in providing Logging, Error Handling by using Event Handler, and Custom Logging for SSIS Packages.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and Database Engine Tuning Advisor Creating maintenance plans and troubleshooting SQL Server Agent scheduled jobs like backup, integrity, optimization, and log shipping jobs regularly.
• Configured Transparent Data Encryption for securing databases and backups to ensure Data Security.
• Extensive hands on experience on multiple third-party tools such as Delphix for very large database restore, Vormetric Encryption for Data Security at file level, Lite Speed and Idera for Database backups.
• Worked on Delphix and Attunity tools which are used to reporting purpose.
• Experience in DBCC Commands, BCP Data transformation services (DTS), SSIS.
• Worked with application developers to support, maintain and upgrade web based applications with SQL Server database backend.
• Worked with storage and network administrators to plan and estimate drive space and storage needs throughout the environment.
• Experience in configuration Replication & Trouble shooting.
• Experience in configuration Log shipping & Trouble shooting.
• Preparing all relevant documents for client like Site documentation, Backup policy,
• System study for each server, Security policy and Monthly and Quarterly Statement Report.
• Server and Database hardening for new servers.
• Knowledge on Amazon Web Services(AWS).
• An enthusiastic team player with good communication skills and quick learner.

TECHNICAL SKILLS

Databases: MS SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016

Database Tools: SQL Server Query Analyzer, Import and Export Utility of SQL Server, Client and Server Network Utility, Performance Monitor and SQL Server Profiler, DTS, SSIS, AlwaysON, Azure SQL, AWS

Third Party Tools: Lite Speed, Legato, Red - gate, SQL Sentry, XML, CSS

Operating Systems: Windows 2008, 2012R2, 2016 Server, Virtualization (Hyper V, vBlock, VMware).

Packages: Delphix, Idera, Vormetric, Attunity

Microsoft Technology: ASP.NET, C#.NET, VB.NET, CRYSTAL REPORTS

Hardware: Knowledge of Installation OS and other software.

PROFESSIONAL EXPERIENCE

Confidential

MS SQL Database Administrator

Responsibilities:

• Monitoring SQL Server Jobs, SQL Server Logs, Dead locks/Blocking
• Working on the Service Now Tickets created or Splunk Alerts with SEV1 and SEV2.
• DB refresh requests coming through tickets are handled using Delphix tool
• Handling Disk space, log space issues using Splunk Alerts, Enterprise monitoring tool on Production Servers
• Handling the Change Management Deployments Related to SSIS Packages and SSRS reports Servers.
• Setting up Linked Servers across the environments based on the Requests
• Using DBCC commands to troubleshoot issues related to database consistency
• Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Involved in Planning for Upgrades and Migration of major systems from SQL Server 2005 to SQL Server 2008 R2 and from SQL Server 2008 R2 to 2012\2014\2016.
• Extensively worked on Profiler, PerfMon, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Leading the Database Operations team in setup, support, and management of corporate databases and database servers that directly impact the revenue generation of the firm.
• Administering database privileges and security within corporate standard operating procedures.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression & backup compression, SQL Server Auditing, Resource Governor and Transparent Data Encryption.
• Experience in configuration of report server and report manager scheduling in SQL Server Reporting Services (SSRS).
• New features are implemented in SQL Server 2012\2014 like Always on Enhancements, Buffer Pool Extension, In-Memory OLTP Engine, Backup Encryption and SQL Server Data Tools for Business Intelligence.
• Monitored server level blocks/deadlocks and maintained all the OLTP Servers with maximum database availability, reliability and investigated and resolved any database /performance related issues with minimal downtime and maximum reliability.
• Developed SSIS and SSRS packages in SQL Server using Business Intelligence Studio and created jobs to schedule the SSIS and SSAS packages in SQL Scheduler.
• Creating Database Users, SQL Logins and Server Roles
• Assigning permissions to Roles and adding users to the appropriate Roles
• Creating and scheduling SQL Job.
• Creating, Managing Users and their permissions as per the requirement.
• Knowledgeable on Azure SQL Database environments

Confidential

Senior Database Administrator

Responsibilities:

• Design and implementing backup policy.
• Creating jobs for carrying out daily activities.
• Handling various migration projects and server builds.
• Implementation of security / SQL Server Hardening.
• Create & migrate DTS Packages.
• Restoration of databases as per request.
• Installation and configuration of MS SQL Server 2005, 2008 & 2012.
• Implementation of log shipping on Production databases.
• Monitoring and tuning SQL Server performance with multiple tools including
• Performance Monitor, SQL Profiler, and Index Tuning Wizard to achieve better
• Performance, accessibility and efficiency.
• Transferring data using Import & Export Utility.
• Checking Backup Contingency of critical databases on monthly basis.
• Log File truncation after a certain period.
• Security Policy implementation.
• Used Profiler for performance Monitoring.
• Creation of Maintenance plan for system & User database Backup.
• Basic Monitoring of Oracle Databases.
• Performing Health checkup, database size in Oracle on Daily basis.
• Responsible for resolving escalated troubleshooting requirements.
• Responsible for guiding junior administrators in trouble shooting non-routine and complex troubleshooting requirements.
• As a senior member, is responsible for ensuring SLA is met and there are no complaints from customer. Technically sound, Contributes to KM and practice building. Prepares the Change management plan and gets sign-off. Conducts planned regular and random Technical audits. Suggest improvement plans. Implement and share best practices. Implement automation of regular admin activities.

Confidential

MS SQL Database Administrator

Responsibilities:

• SQL server daily health check.
• Handling 250-300 Database production servers with maximum database of size 400GB.
• Verify backups and error logs on the servers and troubleshoot on any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Implemented Log-Shipping as high availability solution using both Enterprise SQL Server 2008 editions.
• Using profiler for tracing down SQL server activities.
• Also, refreshing Database as per the requirements of the clients.
• Database maintenance plan creation and troubleshooting.
• Re-Indexing.
• Respond to trouble tickets assigned to me and fix any database issues promptly
• Installation of SQL server 2008.
• Monitoring and configuration of Replication & Trouble shooting.
• Monitoring and configuration of Log shipping & Trouble shooting.
• Monitoring and configuration of Mirroring & Trouble shooting.
• Installing patches and other SQL related tools
• Dropping The Databases as per client Requirement
• Grant SQL Privileges to users.
• Performance tuning.
• Preparing all relevant documents for client like Site documentation, Backup policy, System study for each server, Security policy and Monthly and Quarterly Statement Report.
• Database hardening for new servers.
• Monitoring the cluster servers.
• Creating Linked Servers from sql server to server and sql server to oracle.
• Creation of Logins, Roles and granting rights.

Confidential

Database Administrator

Responsibilities:

• SQL server daily health check.
• Handling 150-200 Database production servers with maximum database of size 200 GB.
• Verify backups and error logs on the servers and troubleshoot on any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Using profiler for tracing down SQL server activities.
• Managing Cluster MSSQL Server on Client Side.
• Also, refreshing Database as per the requirements of the clients.
• Database maintenance plan creation and troubleshooting.
• Database archival.
• Respond to trouble tickets assigned to me and fix any database issues promptly
• Installation of SQL server 2008.
• Monitoring and configuration of Replication & Trouble shooting.
• Installing patches and other SQL related tools.
• Performance tuning.