Resume

VIVEK VEMULA +1-773-***-****

SQL Database Administrator ac0pku@r.postjobfree.com

MySQL DBA SkypeID: vivekvemula

PROFESSIONAL SUMMARY:

6+ years of experience as SQL Database Administration and Development for very large and complex databases in SQL Server 2016/2014/2012/2008R2/2005/2000 on cluster and standalone environments, databases ranging from GB’S to TB’S in size.

Microsoft certified Professional in Administering Microsoft SQL Server 2012 Databases.

Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2005, 2008R2, 2012, 2014 and 2016 version.

Extensive Experience in Upgrading to SQL Server 2005/2008R2/2012/2014/2016 (In place Up gradation and Side by side Up gradation) based on application compatibility and fixing the orphan users.

Extensive Experience in Migrating huge databases from SQL server 2005 to 2008R2 and 2008R2 to 2012 and higher versions based on application compatibility.

Administration and Maintenance of more than 600 huge and complex client databases in SQL server 2000, 2005, 2008R2, 2012, 2014 and 2016 versions.

Experience in working on Very Large Databases (VLDB) over 5 TB for OLTP.

Experience in implementing SQL Server security and Object permissions like creation of users, granting permissions and assigning roles to users.

Experience in following the ITIL process using the ticketing tool Service Central/Now.

Strong experience on identifying the logins with super privileges and controlling the access as per the requirement and mitigating the risks for unauthorized activities.

Strong experience on understanding and creating the server level and data base level roles as per business requirement.

Experience in Configuring and Scheduling SQL Server agent Jobs, Alerts, operators, Maintenance plans, Database Mail Configuration and facets.

Extensive experience with Monitoring, Performance Tuning and analyzing DB performance issues.

Managing SQL server using PowerShell scripts.

Performed Administrative tasks in SQL Server using PowerShell.

Experience in Azure SQL servers and their maintenance.

Responsible for performance tuning of stored procedures using SQL Profiler and Database Tuning wizard.

Good experience with implementing High Availability of database servers using Replication, Log Shipping, Database Mirroring, failover clustering and Always ON.

Strong experience on designing and implementing the backup and disaster recovery strategies as per RPO and RTO values.

Experience on configuring and maintaining automation strategies like Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index optimization and index maintenance like index rebuild, index reorganize based on fragmentation.

Experience in T-SQL Programming like stored procedures, functions and triggers.

Experience on third party backup tool i.e. commvault.

Provided 24/7 database maintenance and production support.

Strong experience on indexing strategies, Creating and tuning the indexes based on the workloads.

Strong experience on identifying and troubleshooting the database health, integrity checks and fixing them.

Strong working knowledge with system databases like Master, Model, Temp, MSDB and maintaining them for the smooth execution.

Experience on recovering the corrupted master database files.

Experience on configuring and maintaining automation strategies like Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index optimization and index maintenance like index rebuild, index reorganization based on fragmentation.

Experience on installing SQL Server Integration and Reporting Services (SSIS & SSRS) and configuration on both standalone and Clustered Environments.

Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment

Strong experience in ETL Application using SSIS with various source like flat files, excel.

3 years of Experience in Installation, Configuration, Maintenance and Administration of MySQL (5.1 to 5.6) and MongoDB Linux server

Responded to database problems and issues relating to applications and systems in MySQL.

Maintained system documentation relating to application architecture and technical platforms in MySQL.

Experience in configuring Replication in MySQL and resolving the related issues.

Extensive experience in creating user and assigning permissions in MySQL.

Good interpersonal skills, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.

Professional summary:

Employer : Tata Consultancy Services (TCS)

Client : Advanced Micro Devices (AMD), Austin, Texas

Databases : SQL Server 2000, 2005, 2008 R2, 2012, 2014 and 2016, Windows, SQL

Profiler, SQL agent, Database Migrations, Availability Group, DB

Mirroring, Service Central Ticketing tool, MS SQL Server Reporting

Services (SSRS), MySQL Replication, MySQL DBA

Role : IT Analyst à SQL DBA & MySQL DBA

Duration : August 06th 2014 to May 08th 2017

Roles and Responsibilities:

Administration of large databases in SQL Server 2005 and 2008 R2, 2012 and 2014.

Routine DBA jobs like Backups and Restores.

Worked on Database Engine Tuning.

Expertise in Server Management issues like administration, Backup/Restore, Space Management (auto growth/shrink, file groups), Attach/Detach.

Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Managing SQL server using PowerShell scripts.

Installation and configuration of SQL server 2005, 2008R2, 2012, 2014 and 2016.

Upgrading SQL Server 2005 to SQL Server 2008R2 or 2012/2014 (In-Place upgrade / Side by side upgrade)

Expertise in implementing Database Mirroring and failover cluster on SQL Server 2005, 2008 and 2012 for high availability.

Making use of ticketing tool Service Now to monitor the incident and requests received from the client or user and solving them following the ITIL process.

Developing MS SQL Server Databases as per the client requirements.

Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases

Ran DBCC and fixed data corruption in application databases.

Implementation of Backup and Recovery strategies

Working on Disk free space and Log files full issues

Experience on configuring and maintaining automation strategies like Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index optimization and index maintenance like index rebuild, index reorganization based on fragmentation.

Experience on refreshing the database from production to dev, QA, staging environments, fixing the orphan users

Configuring SQL Server Agent-Events, Jobs, Alerts, maintenance plans and Operators

Providing Support on Weekends and attending weekly calls/meetings

Configuring and managing High Availability solutions (Clustering, Mirroring, Log shipping, Replication (Transactional)) and Always ON

Solving problems related to database Performance issues.

Working closely with Architects, Lead and Project Manager for the applications assessment to all the Data Masking Team on Proxy server and proving support on the databases and applications

Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build

Monitoring the Log Space for successful execution of all the specified jobs.

Providing support to SAP application databases which carry huge database sizes.

Professional summary:

Employer : Automatic Data Processing

Project : Automotive dealers Inc.

Client : ADP Dealer Services, USA

Environment : SQL Server 2000/2005/2008 R2 and 2012 Enterprise, Query Analyzer, T-SQL, DB migrations

Databases : SQL Server 2000, 2005, 2008 R2 and 2012

Role : Senior Technical Associate – SQL Database Administrator

Duration : May 23rd 2011 to 28th June 2014

Roles and Responsibilities:

Administration of large and complex databases in SQL Server 2000, 2005, 2008R2 and 2012.

Installation and configuration of SQL server 2008R2 and 2012 databases.

Designed and Developing MS SQL Server Databases.

Debugging and Writing Stored Procedures.

Maintenance and Planning of SQL Jobs.

Performance Tuning, Query Optimization

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies.

Created Logins and Roles with appropriate permissions.

Created and Maintained Database Maintenance Plans.

Experience on T-SQL Programming

Implementation of Backup and Recovery strategies as per RTO and RPO.

Worked on Disk free space issues.

Responsible for performance tuning of stored procedures using SQL Profiler and Database Tuning wizard.

Worked on Log files full issues.

Configured SQL Server Agent-Events, Jobs, Alerts and Operators.

Provided Support on Weekends and attending weekly calls/meetings.

Configured and managed High Availability solutions (Clustering, database Mirroring, Log shipping, Replication (Transactional/Merge))

Solved problems related to database Performance issues.

Monitored the Log Space for successful execution of all the specified jobs.

Developed internal tools using VB.Net and C# with SQL server 2008R2 as backend.

Qualifications:

2013-2015 : Master of Science in Information Technology from Sikkim Manipal

University

2008-2011 : Technical Diploma in Software Engineering track from National

Institute of Information technology (NIIT)

2007-2010 : Bachelor’s Degree in Life Science from Aurora Degree College

(Osmania affiliated)

Achievements And Strengths

Awarded with Employee of the year 2015 from AMD client partner in TCS.

Got Certificate of appreciation from the AMD client partners within six months of joining TCS.

Awarded Titan of the month once, Star of the month five times and Associate of the Quarter once from the time of inception in ADP.

Developed five internal tools using C# and VB Dot Net technologies with SQL server 2000/2005/2008R2 as backend.

Got 2 GIFT Awards (Give it a fresh thought) for the innovative ideas which I posted and implemented in ADP.

E-Recognition award for Quality work in solving application issues, providing support for our client databases.

I hereby, declare that the information provided above is true and genuine to the best of my knowledge.

Vivek Vemula

Contact this candidate