Sql Server Manager

Name: Adithya Srirambhatla

Email: *******.************@*****.***

Cell: +1-937-***-****

Objective:

A self-starting, innovative, construction, and result oriented professional, seeking opportunity to work as a SQL Server DBA\Developer. I am looking for a position in a growing Company, where I would find a unique opportunity to provide, invest, and prove my skills and expertise as a SQL Server Database Administrator\Developer.

Professional Summary

Having 3 years of experience in SQL Server Database Administrator and Development in SQL 2014/2012/2008R2/2008.

Experience with SQL Server 2014/2012/2008 R2 installation, configuration and administration.

Planning and implementation of database backup/restore and disaster recovery.

Experienced in both in place and side by side migration.

Experience in Creating Jobs and Sending Alerts using SQL Mail.

Hands on experience and good knowledge of high availability SQL Server solutions, including SQL Server Log shipping, Mirroring and SQL Server clustering (Active/Active and Active/Passive).

Expertise in Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.

Monitored and modified Performance using execution plans with query hints and Index tuning.

Developing SQL scripts for maintaining administration tasks.

Writing Stored Procedures, Functions and triggers based on the requirement.

Hands on experience in all fields of developing skills.

Knowledge on Microsoft SQL Server Reporting Service (SSRS) with report designer, report manager and report server.

Involved in 24/7 Production Databases on Call Support. Excellent Analytical, problem solving and communication skills.

Technical Skills

Databases

MS-SQL Server 2000/2005/2008/2012/2014.

Languages

C, C+, T-SQL, XML.

SQL Server Tools

Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyzer, Export & Import.

Professional Experience

Client: GoDaddy, Tempe, AZ Date: 05/2016 – Till Date.

Role: SQL Server DBA\Developer

GoDaddy is a publicly traded Internet domain registrar and web hosting company. As of January 2016, GoDaddy was said to have had more than 61 million domain names under management, making it the world's largest ICANN-accredited registrar. As of December 2014, GoDaddy served approximately 13 million customers and had 4,908 employees worldwide. The company is known for its celebrity spokespeople, Super Bowl ads and as being an online provider for small businesses.

Responsibilities:

Migration of databases from SQL Server 2008 to SQL Server 2014.

Installed SQL Server 2014 and configured Always on With Primary and secondary Replicas, Read only databases, listener and with Application Intent.

Installed and Configured SQL 2014 Clustered Environment (Active/ Passive) with availability groups.

Designed Alwayson architecture between two different Cluster Environments.

Experience in Windows server failover Cluster (WSFC) Issues.

Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.

Migrated large Databases of Size 6TB from 2008 to 2014 and troubleshooting the issues around it.

Worked extensively on SQL Server 2008 and 2014 Transactional Replication.

Hands on Experience in DR process including Log shipping and mirroring.

Experience in Patching the SQL server 2008\2014 and windows server 2008, 2012R2 Enterprise Edition by applying Service Packs and Hot Fixes.

Experience in Database Design activities including Data Files and File group organization and capacity Planning

Monitored and modified Performance using execution plans with query hints and Index tuning.

Installed SQL Server 2014 on windows 2012R2 and migrated SSIS packages.

Transferring SQL Jobs using Integration Service project.

Performed Database Maintenance plans, updated Database Statistics.

Working on Client/Server tools like SSMS, SQL Server Enterprise Manager Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY.

Setting up monitoring alerts and dashboards in addition using of SQL built-in dashboards.

Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers, Temporary Tables and maintained Referential Integrity using T-SQL as needed.

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

Experience in writing complex SQL queries involving multiple tables inner and outer joins.

Export and import data to and from database into Excel sheet

Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).

Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.

Created Dynamic SSIS packages, to load Stage tables from text files.

Created DTS packages to migrate data.

Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.

Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

Created DB master key, symmetric keys, asymmetric keys, certificates for encryption.

Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Environment: SQL Server 2014/2012/2008R2/2008, SQL Server Management Studio, SQL Query Analyzer, SQL Server Agent, SQL Service Manager, SSIS, PowerShell, Visual Studio, Microsoft Visio, Excel.

Client: Western Union, San Francisco CA Date: 05/2015 – 05/2016

Role: SQL Server DBA\Developer.

The Western Union Company (WU) is a leader in global payment services. Western Union provides consumers and businesses with fast, reliable and convenient ways to send and receive money around the world, to send payments and to purchase money orders. This Service provides financial institutions to send and receive money transfers through the western union agent network locations. It has around 520, 000 agent locations in more than 200 countries.

Responsibilities:

Migration of databases from SQL Server 2008R2 to SQL Server 2012 and SQL Server 2014

Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups. Restore them whenever necessary; creating backup strategies and scheduling them for execution.

Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.

Generated Script files of the databases whenever changes are made to stored procedures or views.

Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes

Worked on Team foundation server (TFS) to store the data script as a Repository for developers use.

Monitored and modified Performance using execution plans with query hints and Index tuning.

T-SQL Programing – writing new stored procedures, updating & enhancing the existing code.

Build and Maintain SQL Scripts and Complex Queries for data analysis and extraction.

Expertise in Scheduling Database tasks – Jobs, Alerts, Emails, Notification.

Monitoring and Troubleshooting SQL Cluster, Mirroring, Log Shipping.

Experience in Configuring and Maintaining Database Snapshots.

Environment: Windows 2003/2008, MS-SQL Server 20142012/2008r2, T-SQL, SSIS, Report Builder, Lite Speed, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering.

Ranbaxy Pharmaceuticals, India Date: 05/2013 – 12/2013

Role: Jr.SQL Server DBA

Ranbaxy Laboratories Limited is India’s largest pharmaceutical Company, manufacturing and marketing world class generics, branded generic pharmaceuticals and active pharmaceutical ingredients. It is ranked amongst the top ten generic companies worldwide. The project involved Database Administration Support (Development & Production), Software Installation, Database Performance Tuning & Maintenance, Database Backup and Recovery, Export/Import of Data, Replication, Creating and Implementing of various Installs and Database Auditing Analyzing.

Responsibilities:

Installed and Configured MS SQL Server 2008 R2, and responsible for configuration, tuning and provide support to all Production and development servers

Experience in Creating Jobs and Sending Alerts using SQL Mail.

Managing security, monitor server performance and activities.

Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.

Writing the Stored Procedures, checking the code for efficiency.

Daily Monitoring of the Database Performance and network issues.

Environment: SQL Server 2005/2008R2 Windows NT/2003,T-SQL, VERITAS Net Backup and Crystal Reports.

Education

Bachelors of Science

Kakatiya University India

Year: 2009-2013

Masters of science

Wright State University-Fairborn, OH

Year: 2014-2015

Contact this candidate