Name: P. SampathKumar

Mobile: +* (***) *** - ****

E-Mail: adx23h@r.postjobfree.com

Professional Summary:

Having 10+ Years of experience as Microsoft Certified SQL Server Database Administrator, Azure Infrastructure Solutions and exploring new versions, using current version features wherever applicable during client consultations in banking and health care domains.

Around 4 Years of experience on as Azure IAAS & PAAS services with total of 10 years of experience in IT industry

Technical Highlights

SQL Server DBA Skills:

SQL Server Installation for Standalone &Failover Cluster instances, configuration and maintenance of various MS SQL Server versions 2005/2008/2008R2/2012/2014/2017/2019 in On-Premise

Hands-on experience in applying Service Packs, CU's &hot fixes in SQL standalone/clustered and Always-On.

Experience on planning and performing the DR tests of various environments.

Hands on experience in implementing the high availability techniques like Log shipping, Mirroring and Fail-over Clustering, Always-On.

Export & import the data Transfer from access, Excel, Access, flat files to SQL Database.

Monitor Scheduled Jobs, Live Production Environment and other automation Jobs.

Expert in rebuilding System databases and recovering Corrupted/Suspected User databases.

Performing DB maintenance activates like re-indexing, DBCC CHECKDB & Update Statistics.

Maintaining system event logs like SQL Server logs, Application logs, system logs, Cluster logs and analysing the error.

Replication Monitoring (Maintenance of Agents and Publisher, Subscribers and Distributors)

Administering the MS SQL Server by creating logins with appropriate roles, dropping and unlocking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Involved in tuning the database and improving server performance.

Experienced in figuring out the performance bottlenecks at database and server level by monitoring CPU usage, I\O statistics, Memory usage with DMVs, DBCCs, SQL activity monitor, Performance monitor, SQL profiler and extended events.

Configuring, automating DBA maintenance and monitoring tasks like Standard DBA maintenance jobs (Backups, Index optimize and Integrity checks), Alert and DB mail configuration for report on Service availability, Capacity Management, Backup availability, SQL Server level abnormalities from error log and taking appropriate action to maintain the health of DB and SQL Server.

Moving the System and user databases from one location to another location

Experience in Installation and Configuration of Microsoft BI technologies like SSIS and SSRS.

Expert in TEMPDB configuration, troubleshooting and version store full & TEMPDB contention issues.

Good working knowledge on Incident Management, Problem Management and Change Management.

Experience in Scheduling and maintaining Jobs, Tasks, Alerts and Maintenance Plans. Working on administrative with SSAS, SSIS and SSRS.

Knowledge on how to use ChatGPT.

Providing 24x7 Off-Shore Production On-Call Support for timely resolution on high severity incidents & Change Requests.

Azure (IAAS) :

Experience in creating Azure Virtual Machines on Windows platform.

Broad experience in building and configuring Azure IaaS and PaaS service (i.e. VNETs, NSGs, SQL databases, Key Vault)

Experience in migrating on-premises databases to Azure and configured VNETs and subnets as per the project requirement also performed Patching, Imaging, and Deployments in Azure

Experience in creating Azure Virtual Machine Images (including SQL Server installation)

Configuring Azure Site Recovery (ASR) using Vault Services and performed VM Backups and configured DR site recovery.

Working exposure to different types of Storage available (Blob, File)

Creating/Configuring/Scaling Storage & Understanding on Premium/Standard Storage accounts.

Creating Blob Storage for storing files, SQL Server Backups images.

Experience in Azure Networking (VNets, Subnets, VNet Peering, Private-Public IPs, Load Balancers)

Managed Virtual Machine Backup and Recovery from a Recovery Services Vault using Azure Portal

Managing Firewall (NSG) rules to VMs and following security norms of Organization.

Azure SQL (PAAS):

Creating/configuring Azure SQL Databases (PaaS/DBaaS)

Creating Server/Database firewall rules in Azure SQL Databases

Creating Database users & granting/revoking access on user databases.

Having knowledge on Azure Elastic Pool Databases and Elastic Jobs.

Exporting/Importing BACPAC between Azure SQL and On-premises databases.

Migrating On-Prem Databases to Azure SQL Databases.

Knowledge in Performing migration using DMA (Database Migration Assistant) DMS (Data Migration Services) Azure Service.

Professional Work Experience

Working as SQL server database Administrator ERP Analysts Inc in USA.

Worked as SQL Server DBA for The Royal Bank of Scotland (RBS)

Worked as SQL Server DBA for Wipro Technologies

Highest Education

Master of Computer Applications (MCA-Post Graduate) in 2009 from Acharya Nagarjuna University.

Bachelor of Science (Degree) in 2006 from Acharya Nagarjuna University.

Certifications

Certified in Azure Fundamentals (Az-900), Certification Number: 993717239

Technical Knowledge

Skill` Type

Skill Name

Database

SQL Server 2005/2008/2008R2/2012/2014/2016/2017/2019/2022

Operating Systems

Windows 2003, 2008 R2, 2012, 2016,2019 Servers.

Performance Monitoring Tools

SQL Server Profiler, Perfmon

Cloud Solutions

Microsoft Azure IAAS & PAAS

Ticketing tools

BMC Remedy, Service Now

Backup Tools

Veritas NetBackup Tool

Work Experience

Project Name

DSC

Responsibility

SQL Server DBA and Cloud DBA

Team Size

15

Client(s)

Daytona State College (DSC)

Role

SQL DBA and Cloud DBA(Support)

Duration

May -2021 to Till Date

Location

Florida, FL

Responsibilities:

Installed, configured, and Administered SQL Server databases in Standalone and Clustered physical and virtual environment.

Hands-on experience in applying Service Packs, CU's &hot fixes in SQL standalone/clustered and Always-On.

Collaborated closely with application owners and developers on SQL Server upgrades (Service Pack, hotfix patch upgrade etc.) and weekly production releases

Experience on planning and performing the DR tests of various environments.

Managed Logins and Users, adding logins, roles, and groups to the MS SQL Server and maintaining proper security procedures.

Designed and Implemented backup and recovery strategies as per RPO and RTO indicated in company’s SLA.

Implemented and Managed Performance Tuning Tasks with Developers in Optimizing the Long Run Queries.

Involved in troubleshooting system issues and disk space issues, scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.

Handled nightly Database Refresh in Prod and QA-Test environment for testing of new Deployments and Build.

Implemented Policy Based Management, Backup Compression and Transparent Data Encryption (TDE).

Handled in creating Azure Virtual Machines on Windows platform.

Involved in migrating on-premises databases to Azure and configured VNETs and subnets as per the project requirement

Managing Firewall (NSG) rules to VMs and following security norms of Organization.

Involved in creation of load balancer as part of AG configuration in Azure.

Created/configured Azure SQL Databases in Azure Portal.

Performed migration using DMA (Database Migration Assistant) DMS (Data Migration Services) and Azure Data Studio.

Transfer the logins from On-premise to Azure MI using Azure Data studio.

Performed Health checks and Monitored performance of the Production Servers.

Raising the change records as per application criticality and implementing the change once approved by all teams.

Provided 24/7 Production Support and resolved all tickets related to SQL Server Database.

Project Name

The Royal Bank of Scotland (RBS)

Responsibility

SQL Server DBA

Team Size

20

Client(s)

The Royal Bank of Scotland Group

Role

SQL DBA (Support)

Duration

October -2015 to April 2021

Description:

The Royal Bank of Scotland Group plc (also known as RBS Group) is a British banking and insurance holding company, based in Edinburgh, Scotland. The group operates a wide variety of banking brands offering personal and business banking, private banking, insurance and corporate finance through its offices located in Europe, North America and Asia. In the UK and Ireland.

Responsibilities:

Installation, Administration and Maintenance of SQL Server Instances. (Installing SQL Server)

Setup Test, Development Staging and Production Environments. (Installing SQL Server)

Create Users and assign permissions based on the level of database access the user would need. (Security)

Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc. (Security and General Administration)

Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent)

Once created the database Backups, monitor those backups are being performed regularly. (SQL Server Agent)

From time to time recover the databases to a specific point of time, as per the requests. (Database Backups and Recovery)

Setup High-Availability as part Disaster Recovery Strategy for the Databases. (, Database Mirroring, Log Shipping and Replication)

Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking your email alert (if there is one configured))

Monitoring and Performance tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc.)

Documenting major changes to the SQL Servers. (General)

Migration of the SQL SERVER from one version to another version.

Debugging and Deploying the SSIS packages and designing the database for the new requirements.

Creating stored procedures, functions, views, indexes, triggers etc., Developing new SQL jobs to load / extract the data, SSIS, SSRS, SSAS.

Supporting existing SQL jobs & Applications.

Coordinate and Communicate with the Clients. Implementing “Best Practices” and plan for continuous improvement of processes. Maintaining project related documents. Preparing delivery reports & change impact documents

Project Name

AkzoNobel

Responsibility

SQL Server DBA

Team Size

10

Client(s)

AkzoNobel, Netherlands

Role

SQL DBA (Support)

Duration

August-2012 to September-2015

Description:

Akzo Nobel N.V., trading as AkzoNobel, is a Dutch multinational, active in the fields of decorative paints, performance coatings and specialty chemicals. Headquartered in Amsterdam, the company has activities in more than 80 countries, and employs approximately 50,000 people.

Responsibilities:

SQL Server 2005,2008 and 2008R2 installations, configuration and security settings for standalone servers.

Implement database administration/ maintenance plans with database backup and restorations.

Creating and maintaining scheduled jobs, Maintenance plans, database native backups.

Maintaining/Creating logins/users and giving permission to them as per request.

Creating and maintaining scheduled jobs and implementing automation for other tasks.

Handling blocking/locking issues and troubleshooting accordingly.

Having knowledge on moving user databases from one drive to another drive.

Experience on performing database refresh (Restore Database from one server to another).

Reviewing SQL Server and SQL Server Agent Error Logs.

Troubleshooting performance, connectivity issues on production databases.

Establishing availability baselines and set thresholds for monitoring and alerting.

Working on file moment activities as per request with application teams.

Creating snapshots as per requirement of Application team

Monitoring the Disk spaces on all the servers.

Configuring / maintaining high availability SQL Server solutions that include Log shipping, Mirroring.

Raising the change records as per application criticality and implementing the change once approved by all teams.

Process:

Creating CR’s for every client\Customer-raised request and from users/application team.

Keeping the track of all critical databases & server related information in Excel sheet.

Maintaining Run Book as a constant practice and updating it continuously.

Monitoring, Reviewing & approving change records with 100% SLA.

Always maintains 100% non-complaint to follow the ITIL processes.

I implemented new processes to collect customer feedback for every activity and entire team is following same.

-SampathKumar

Contact this candidate