Sql Server Manager

Vamshikrishna P * P a g e

VAMSHIKRISHNA P

**** * ******* ***** ********, AZ, 85286 Cell: 505-***-****, ******.****@*****.*** EDUCATION:

Wright State University OH, USA

Master of Science (MS) (May 2015)

Scient Institute of Engineering& Technology Hyderabad, India Bachelor of Technology (B. TECH) (May 2013)

TECHNICAL SKILLS:

Operating Systems: Windows Server 2012, 2008, 2003

Databases: MS SQL Server 2014/2012/2008R2/2008

GUI Tools: SSMS, SQL AZURE, SSIS, SSRS

ETL Tools: SQL Server Integration Services (SSIS), Visual studio 2010, 2013, SSRS

Languages: T-SQL, PL SQL, Basic R language

Third Party Tools: Red Gate, SQL Compare, Lite speed, Avamar, Excel, Microsoft Word, Outlook, PowerPoint

Ticketing Tools: HPSM, Team Track, DBA Support, Service Now and Service Desk. PROJECT EXPERIENCE:

Go daddy, Tempe, AZ March 2016 – March 2017

SQL SERVER DBA

DATA CENTER MIGRATION: Primary objective of the GOOM project is to migrate the whole datacenter from the old data center to two new data centers (two different regions). As a team, we worked on migrating 180 clusters’ and 300 standalone boxes, as a DBA I am not only limited to building and migrating the SQL servers, besides that I used to support production issues, raise the change request (when needed), manage all the databases, and support the other team members. RESPONSIBILITIES:

Administration of Install, Upgrade, Migration of SQL Server 2008 R2 & SQL Server 2012 to SQL Server 2012/2014.

Implemented High Availability solutions such as Mirroring, Log shipping, Always on and clustering.

Take part in Troubleshooting High availability scenarios involving Clustering, Database Mirroring, Log Shipping, Always on and Replication.

Designed and implemented the comprehensive Backup plan and disaster recovery strategies for OLTP databases.

Developed DTS Packages to transfer the data between SQL Server database and files.

Controlled and monitored user access to the database, backed up and recovered the database, maintained system security and monitored/optimized database performance for Data warehouse and OLTP applications.

Managed all aspects of the junior team including day-to-day supervision, performance evaluation, and assignment to IT Projects and Production Support functions.

Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Extensively worked on 24 X 7 Production Database on Call Support and involved in troubleshooting SQL Server issues in various levels.

CVS Health, Scottsdale, AZ June 2015 – Feb 2016

SQL SERVER DBA

Build Team DBA: As a part of SQL build team, we used to configure the SQL servers and work with the application team & vendors to load the required data into SQL servers using the third-party applications. Once the SQL servers are in production as a build team DBA we used to support those SQL servers for certain period and handover them to SQL run team. RESPONSIBILITIES:

Installed and configured Microsoft Windows Clustering and SQL Server Clustering on Windows 2012 Server.

Configure and supported replication and log shipping in both SQL 2008 and 2012 on OLTP databases.

The regular monitor of servers, which includes backup job monitoring, Disk space monitoring, Services monitoring, and block monitoring and troubleshoot using SEM (SQL Enterprise Manager).

Performed many database upgrades using import/export wizard.

Designed database Mirroring (synchronous & Asynchronous) as the disaster recovery solution and Log Shipping, Replication, Always On, clustering as the high availability solution.

Proactively monitored the database health through automated scripts for checking the database growth, probing the alert log files, monitoring the rollback segments and temporary space usage.

Responsible for troubleshooting all SQL Server databases issues on production, QA, and testing environments. Vamshikrishna P 2 P a g e

Configuring SQL Server Integration Services (SSIS) & SQL Server Integration Services (SSRS) and granting required access.

Extensively worked on 24X7 Production support and involved in troubleshooting SQL servers at various levels.

Extensively worked on creating the packages using the data tool and liable for Index fragmentation.

Participated in the on-call schedule to respond to SQL Server alerts and potential production database issues. Commit point, VA (Intern) Aug 2014 – Dec 2014

SQL Server DBA\Developer

As Intern DBA worked on SQL installation, learned about software Development Life Cycle (SDLC), trained in basic works such as Backup, Restore, Scheduling Maintenance plans, running jobs, Opening tickets for Modifying data on databases. Responsibilities:

Installed SQL Server 2008R2/2012 on windows 2003/2008 on the standalone environment.

Migrated SQL server jobs using the Visual studio and SSIS Packages.

Migrated DTS packages to SSIS packages.

Moved the entire phase from the Staging to the Production.

Experience in working with the Backups and Restore.

Configured Database Mail for SQL Servers for the Positive Mail Notification.

Created Maintenance Plans that helped in effective disk utilization and index maintenance.

Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.

Job Monitoring to ensure all jobs run successfully every night.

Reporting on a weekly basis to the project manager. Minix Technologies, Hyderabad, INDIA May 2013 – Dec 2013 SQL Server DBA\Developer

Responsibilities:

Installed, Configured, and Managed SQL Server 2008 & 2012 in development, test environment.

Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security Policies for various categories of User Support.

Scheduled full, differential and transactional log backups for user created databases in production environments.

Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail.

Created and maintained various databases on production/development servers.

Configured Log shipping from Production to Disaster Recovery server.

Involved in assisting SR SQL DBAs for setting up High Availability and Disaster recovery solutions.

Prepared documented processes for installations, clustering, availability group setup, and patching.

Created, Scheduled and monitored SQL jobs, making sure jobs run successfully every night.

Built & deployed SSIS Packages to SSIS package store and MSDB database.

Reporting status of work to team lead on weekly Basis. CERTIFICATION:

Microsoft Certified Solution Associate(MCSA): Administrating Microsoft SQL DBA (2012/2014) LINKEDIN:

https://www.linkedin.com/in/vamshi-p-44866b108

Graduate Projects:

1. Designed Alive Human Detection Robot which involves PIR 2.Image sensor Processing for automatic turn on\off lights 3.Implemented FPGA architecture for developing NANO circuits. 4. Designed web application for student Login’s and accessing accounts.

Contact this candidate