Name: P. SampathKumar
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