Sql Azure

VENUGOPAL AITIPAMULA

SQL DBA (On-premise and Azure)

****.*****@*****.***

Ph No: +91-939*******

OBJECTIVE

IT professional with 2 year’s hands-on experience in managing large-scale databases in production support environment on windows platform. A database administrator with a proven track record of technical skills, who has the ability to work on multiple highly visible projects, is a creative problem solver, and has an aptitude for learning.

CORE RESPONSIBILITIES

Installing and configuring SQL Server 2008/2008R2/2012/2014/2016 and 2017, applying service packs and cumulative updates.

Migrating the SQL Server databases and instances from lower version to higher version.

Troubleshooting the backup failures and recovering databases from the point of crash.

Performing Database refresh tasks from Dev-Staging/Pre-prod to Dev/UAT to Pre-prod servers.

Fixing the orphan users and allow the users to access the databases.

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

Recovering the databases to point in time with respect to the customer’s requirement.

Creating logins and assigning privileges like Roles/Securable to the users on databases.

Creating and configuring the jobs with the complex multiple steps in it by automating them through the SQL Agent schedules.

Configuring Database mail and creating operators and alerts for the SQL Agent Job failures.

Creating and maintaining the indexes on the tables and performing Re-build/Re-organizing indexing to improve the performance.

Troubleshooting blockings, deadlocks and fixing them by adding permanent fixes.

Running the maintenance activities like update-statistics and DBCC CHECKDB at the time of performance issues.

Configuring Log shipping between two servers and troubleshooting at the time of synchronization issues. Performing role swapping and failover depending on the situation.

Configuring Database Mirroring between two partners in any of the three modes (High Availability, High Safety and High Performance) and ensuring the synchronization between partners.

Configuring HADR (Always-ON) in SQL Server 2016/2017 and configuring Listeners to HADR.

Adding and Joining New Availability Databases to existing HADR Availability Group.

Proven ability as a quick learner of new skills and technologies.

AZURE EXPERIENCE

Creation of Virtual Machines, Storage account creations, Virtual Networks and Deploying SQL Server and

configuration of Always On (Azure IaaS).

Good knowledge on Azure migration service like Azure Migrate, Recovery site vault and DMS

Good knowledge about SQL server general purpose and Business critical licenses.

Backup Azure SQL DBs in Azure and Automation of SQL DB backups

PROFESSIONAL EXPERIENCES

Working as a SQL DBA with IBM India Pvt Ltd., HYDERABAD from FEB- 2019 to Till-date

TECHNICAL EXPERIENCES

Database : SQL Server 2005, 2008,2008 R2,2012,2016 and 2017

Operating Systems : Windows XP/7, Windows Server 2008, 2008 R2,2012

SQL Server Versions :SQL Server 2008, 2008R2 and 2012

SQL server tools :SQL Server Management Studio, SQL Profiler, Performance Monitor, SQLCMD, Database Tuning Wizard, Microsoft Clustering Services (MSCS), SQL Server Upgrade Advisor, DTA, DMV's and DBCC Commands

DR Configuration :Log Shipping, Mirroring, Clustering,

Operating Systems :Windows Server 2003, 2008 R2 and 2012

Ticketing Tools :Servicenow

Other Essential Software :Microsoft Office Word, Excel

EDUCATION

MCA (2016–2019): Completed MCA from university college of Engineering, Osmania University in the year 2019 with an aggregate of 70.00.

B.com (2013-2016): Completed B.com in the year 2016 from Osmania University with an aggregate of 78.00.

Inter (2011- 2013): Degree in MEC from Sri Medhavi Junior college with an aggregate of 82.00.

SSC (2010-11): Degree in SSC from Krishnaveni Talent School, Hyderabad with an aggregate of 87.00.

PROJECTS SUMMARY

Client#1 : Eaton Corp

Duration : Feb 2019 to till date

Role : SQL DBA (L1 and L2 support)

DESCRIPTION

Eaton Corporation plc is an American Irish-domiciled multinational power management company with 2018 sales of $21.6 billion, founded in the United States with corporate headquarters in Dublin, Ireland, and operational headquarters in Beachwood, Ohio.

Client#2 : Genuine Parts Company, USA.

Duration : Feb 2019 to till date

Role : SQL DBA (L1 and L2 support)

DESCRIPTION

Genuine Parts Company is a service organization engaged in the distribution of automotive replacement parts, industrial replacement parts, office products and electrical/electronic materials. GPC serves numerous customers from more than 2,600 operations around the world and has approximately 39,000 employees

ROLES & RESPONSIBILITIES

Performing SQL server daily health check and preparing a report based on it.

Installation, configuration and upgrading of SQL Server2008/2008 R2.

Backup scheduling and restoring of databases.

Implement and maintain database security (create and maintain users and roles, assign privileges).

Database creation as per Build sheet and also per settings specified by the requester.

Managing Hard disk Space Utilization and monitoring them and removal of older backups to free up space.

Manage the SQL Server user accounts, Objects and Security Issues.

Creating and configuring the jobs with the complex multiple steps in it by automating them through the SQL Agent schedules.

Configuring Database mail and creating operators and alerts for the SQL Agent Job failures.

Creating and maintaining the indexes on the tables and performing Re-build/Re-organizing indexing to improve the performance.

Troubleshooting blockings, deadlocks and fixing them by adding permanent fixes.

Migration of the databases from SQL server 2008 to SQL Server 2012.

Disaster recovery of the databases and performing DR checks every 3-6 months.

Troubleshooting the blocking and deadlock issues and Disk space issues.

Monitoring of server performance by profiler during peak periods of server utilization (as per performance tickets if any raised).

Adding the linked servers as per the application/Development team requests.

Configuring Log shipping and ensuring the synchronization between the Primary and secondary server.

Configuring Mirroring and ensuring the synchronization between Principle and Mirror partner databases.

Configuring and implementing SQL Server Clustering and troubleshooting at the time of failover issues.

Applying service packs on SQL Server clustering instances.

Adding a disk to the existing SQL Server Clustering services.

Configuring HADR (Always-ON) in SQL Server 2016/2017 and configuring Listeners to HADR.

Adding and Joining New Availability Databases to existing HADR Availability Group.

Creating Multiple Availability groups and Listeners and troubleshooting when any synchronization issues in HADR.

Troubleshooting slow running queries.

Venugopal A

Contact this candidate