SQL DBA

UmamaheshwarV

Mobile:+91-798*******

Mail :adkilx@r.postjobfree.com

Career Objective

To seek a responsible and challenging position as Database Administrator in an organization where my knowledge and experience can be shared and enrich.

Professional Summary

Having12Yearsof experience (9+Years as a SQL Server Database Administrator/Build Engineer).

Extensive SQL Server DBA experience in support on a 24x7 production in Critical domains like Telecom.

Installation, Configuration of SQL Server 2008, 2008R2 and 2012 on Local and Remote Systems.

Migrated SQL Server from one server to another, Applying Patches and Hot fixes.

Performing new server (IIS & Database servers) builds as per client standards.

Experience in deployment and support of MS Azure Cloud Services, Virtual Machines, Storage and Active Directory. Experience with monitoring, troubleshooting related issues on Azure.

Implementing and administration backup/restore, disaster recovery and space monitoring plans for production servers.

Clear understanding of Log Shipping, Mirroring and Alwayson.

Performed database refreshon dev/test environment from production and also have imported/exported individual tables between the databases.

Experience in managing users, logins and granting appropriate permissions/roles accordingly.

Created and managed Database maintenance plans and jobs as per client request.

Managing IIS and NLB on Windows Servers.

Experience on server migration (SQL & IIS servers) from one data center to another data center.Experience on build deployment

Experience on performance tuning.

Education

Master of Business Administration (MBA), from Kakatiya University.

Bachelor of Computer Applications (BCA), from Kakatiya University.

Certification

Microsoft certification:

ImplementingMicrosoft Azure Infrastructure Solutions (70-533)

Technical Expertise

Operating systems :Windows XP, 2003/2008 & Linux.

Databases : MS SQL Server 2005, 2008, 2012,2014, 2017 &Mysql.

Languages : C,SQL.

Packages : MS Office

Web Server : IIS

Professional Experience

Working as a Senior DBA in VALUE LABS, Hyderabad. (20th July 2017 to Present)

Worked as a Senior DBA/Build engineer in Tech Mahindra Limited, Hyderabad

(June’14 to July 2017, Total 3Years 1month).

Worked for Netxcell Limited, Hyderabad one of the VAS Service Provider in INDIA as a Sr. Engineer – Technical Operations, since July-2007 to August 2013.

(Total years in Netxcell:6Years and 1month, Relevant Experience (DBA): 3 Years

And3.1years as a Support Engineer).

Project#1

Employer : Value Labs.

Project :GFK

Duration : July 2017 to Present

Role : Database Administrator

Team Size : 1

Description:

The GfK is Germany’s largest market research institute and the fourth largest market research organization in the world. The project is about maintain one of the large application called ATLAS.

Responsibilities:

Database backups and restoration, storage space maintenance and job scheduling.

Database refresh activities (backfill from Production to non-production environments)

Involved in Performance Tuning.

Monitoring the Disk Space on all environments SQL server instances.

Handling access and permission requests/issues.

Involved in Migration of the critical databases.

Worked on tickets which are created by end users.

Daily standup calls with end users as well as dev team.

Pre and post smoke test of every deployments in all environments (UAT & Prod).

Project#2

Title : Product Key Activation Services.

Client : Microsoft India Pvt Ltd.

Employer : Tech Mahindra Ltd.

Project :MPSIT

Duration : June 2014 to July 2017

Role : Database Administrator

Team Size :12

Description:The project is about to support five major applications which hold the secure data of Microsoft which includes start to end of application data flow starting from web server, till the data reaches for Reporting. To make the applications 100% availability configured High availability techniques’ for business critical MS SQL Servers are Always ON, Clustering, Mirroring, Log shipping and Replication and also scheduling regular backups & jobs.Majority of work is done on SQL Server 2008R2/2012 and Windows Server 2003/2008 and most of the job responsibilities are similar to that of a Database& Windows Server Administrator. Server IIS & DB servers migrations from one data center to another data center, new servers procurements. Builds, sprints & hot fixes deployments in IIS and SQL servers using tools. Azure server’s deployments and experience on cloud services.

Responsibilities:

Supporting various databases and server level support on various database issues like backups, storage space maintenance and job scheduling.

Creating Jobs and associating jobs with Stored Procedures.

Maintaining & Configuring Mirroring, Log-shipping & Replication.

Monitoring the Disk Space on the Microsoft Internal and External Servers based on Windows Server 2008.

Handling access and permission requests/issues for SQL Server or Applications.

Managing IIS and NLB on Windows Servers.

Worked on tickets which are created by end users.

Attending bridge calls with end users as well as engineering team.

Pre and post smoke test of every deployments in all environments (UAT & Prod).

EFL & EBL ip’s creation for IIS servers.

Certificates and service accounts maintenance and renewals as per the schedule.

Project: #3

Title : NXL Voice Platform.

Client : Idea, Airtel,Aircel,Uninor&Docomo.

Employer : Netxcell Ltd.

Project :OBD,IVR

Duration : July-2007 to August 2013

Team Size :4

Role : DBA& Support Engineer

Description:

Netxcell VAS platform which is specially designed for mobile operators and System Integrators to be able to launch any new service/application quickly in order to gain a competitive advantage. The integrated platform is capable of offering various voice and video services to customers reliably and economically.

1. Auto Dialing Systems: Auto Dialing System can automatically dial telephone numbers to communicate any two points in the telephone, mobile phone and pager networks. Once the call has been established (through the telephone exchange) the auto dialer will announce verbal messages or transmit digital data to the called party. Here, the services are being provided to Idea for GSM phones with different Interactive Services where we maintain database and the various applications associated with it. There will be dynamic change of applications and call flow of the applications would be designed accordingly. Maintenance and troubleshooting of servers and the E1 lines should be done.

2. Interactive Voice Response Systems: IVR product is an interactive technology that allows a computer to detect voice and keypad inputs. In telecommunications, IVR allows customers to access a company’s database via a telephone touchtone keypad or by speech recognition, after which they can service their own enquiries by following the instructions. IVR systems can respond with pre-recorded or dynamically generated audio to further direct users on how to proceed.

Responsibilities:

Handling CR’s for Login/User creations and appropriate permissions

Installing,configuring and administering SQL server 2005 and 2008.

Designing Databases and estimation of future requirements.

Adding users in the database and granting permissions as per request.

Scheduling Jobs/maintenance plans as to automate SQL Server.

Prepared and implemented backup strategies.

Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on diskand restore the databases and transaction log on production/development servers as per requirement.

Creating Maintenance plans and jobs for automation of the daily repetitive task on production servers.

Involved inmigrating the existing 2005 databases to SQL Server 2008 (Side by Side).

Monitoring scheduled jobs on a daily basis.

Automating the database maintenance plan with SQL Server Agent.

Checking the SQL Server logs and event viewer for errors and problems.

Monitoring the Disk Space of all the Servers.

Changing the DB/Log File locations

Involved in Log shipping,Mirroring & Replication.

Providing 24X7 services for client expectations/deliverables.

I hereby declare that the information furnished above is true to the best of my knowledge.

UMAMAHESHWAR.V

Contact this candidate