NAGARJUNA

SQL Server DBA 539-***-**** aczb8l@r.postjobfree.com

Professional Summary:

•Over 7+ years of IT experience in SQL Server Database Administration and SQL Server development.

• Experience in installation, configuration, upgrade and maintenance of different versions of SQL Servers (2016, 2014, 2012, 2008R2/2008/2005) in both OLTP and OLAP lower regions, Clustered/Geo Clustered/AlwaysON and Stand Alone Environments.

• Implemented High Availability & Disaster Recovery techniques like AlwaysON Availability groups, Clustering (Both Active-Active and Active Passive), Database Mirroring, Transactional Replication and Log Shipping.

• Upgraded SQL Server databases from SQL Server 2000/2005 to SQL Server 2008R2/2012.

• Hands on experience in working with MSSQL SERVER 2005, 2008 and 2008R2 features and extensive knowledge on SQL 2012/2014 new features.

• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and Database Maintenance.

• Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.

• Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.

• Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.

• Experience in Physical and logical data modeling using ERWIN & VISIO.

•Extensive Knowledge on Raid levels, Flash Storage and use of XtremeIO Technology.

• Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement.

• Experience in developing and tuning SQL Server Integration Services (SSIS) packages and SSRS reports.

•Configuring and maintaining Report Manager and Report Server for reporting services.

• Handled numerous Change Management requests on production servers and Supported 24 X 7 Production on Call.

• Documenting procedures in run books.

Technical Proficiency:

•ETL Tools MS SSIS and DTS, TSQL, SQL Server bulk insert and BCP utilities

tools IIS, SSIS, DTS, Lite Speed, Spotlight, Visual Studio 2003/2005, Team Foundation Server (TFS), Visio 2003, Enterprise manager, query analyser, Perfmon, SQL Profiler, Idera, Foglight, Red gate.

Work Experience:

ADP – Roseland, NJ November 2015 to Present

SQL Server DBA

Responsibilities:

•Installed SQL Server 2016/2014/2012 on Windows Clustered and standalone environments with latest service packs.

•Upgraded SQL server databases from 2008/2008R2 to 2012 and 2014.

•Experience in working and troubleshooting 2TB Very Large databases (VLDB) in OLTP Environment.

•Configured AlwaysON availability groups in SQL server 2012/2014.

•Configured Replication and Database mirroring.

•Extensively worked with SQL Profiler, Activity monitor, Perfmon, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory CPU and I/O issues.

•Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.

•Involved in the SDLC Process and used Agile for all our projects and was involved in Design and Deploying the SQL Code to Stage, Demo and Production.

•Supported 1400 back-end including some very Large Databases across over 155 Production SQL Server instances covering SQL Server 2008R2 through SQL Server 2014.

•Analyze long running slow queries and tune the same to optimize application and system performance.

•Reorg/Rebuilding the indexes at regular intervals for better performance.

•Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

•To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.

•Identified the Deprecated Data types from 2000 and 2005 and changed them to migrate the SQL server 2012.

•Coordinated with the Storage Team to Migrated the SQL Storage from Disks to Flash and used XtremeIO to Compress.

•Team Foundation Server was used to Track the Code and the Project Progress and was used to deploy the right version of Code.

•Configuring TEMP DB on files and file groups and capacity planning of databases.

•Configuring and deploying SSIS packages and SSRS reports.

•Supported 24 X 7 Production On call.

Environment: SQL Server 2014, 2012, 2008R2, 2005, Windows 2012, 2008, 2003 Server, Agile, SSIS, SSRS, XtremeIO, Visio.

Fujitsu – Youngsville, NC March 2013 to October 2015

SQL Server DBA

Responsibilities:

•Managed and Administrated the SQL Server 2012/2008R2/2008/2005 production and Non-production servers.

•Installation of SQL Server 2012/2008R2 on Windows Server Clustered environment.

•Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.

•Configured and deployed SSIS Packages from Test to Production Environments.

•Configured Backups, optimization jobs and involved in restoring database to point in time in case of issues, troubleshooting long running queries, locks, deadlocks and performance issues.

•Used Red gate to Checkin and checkout SQL Code and used the Versions provided by the Change Management team to Deploy to QA, Stage, Demo and Production Environments.

•Coordinated with the Storage team to use the correct Raid Levels for the Disks that are allocated to SQL

•Used Data Quality Services (DQS) to Build Knowledge base and create Data Quality Projects.

•Supported Very Large Databases with Maintenance, Capacity Planning and HA and DR.

•Setting up and Monitored transactional replication, Database mirroring.

•Monitored Log shipping/ Transactional Replication and troubleshooting errors.

•Followed Scrum Methodology for our SDLC Process.

•Created SSIS packages using ETL tools to migrate data from different source.

•Perform SQL Server service pack upgrades.

•Managed Security using SQL Logins, Roles and Security Modes for various users.

•Supported 24 X 7 Production On call.

Environment: SQL Server 2005/2008/2012 Windows 2012, 2008, 2003 Server.

Exxon Mobil - Dallas, TX February 2011 to January 2013

SQL Server DBA

Responsibilities:

•Installing and Maintaining SQL server 2008/2008R.

•Upgrading SQL server databases from SQL 2000/2005 to SQL2008R2.

•Recovering the databases from backup in disasters.

•Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

•Migrated SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS packages.

•Implemented new features in SQL 2008 like Policy based Management, Table Compression & backup compression, SQL Server Auditing, Resource Governor and MERGE statement in T-SQL.

•Designed and implemented comprehensive Backup plan and disaster recovery strategies Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

•Used Red Gate tool to compares and synchronize SQL Database Schemas.

•Working with customers on Application rollouts and server migrations.

•Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers.

•Troubleshoot performance problems and fine-tuning of databases.

•Help Design and Support Very Large Databases.

•Involved in normalization of the Database in OLTP.

Environment: SQL Server 2005, SQL Server 2008, Windows 2003/2000 Server, SQL LiteSpeed 4.5.

Navayuga Infotech - Hyderabad, India October 2009 to January 2011

SQL Server Developer/DBA

Responsibilities:

•Installed, configured and maintained SQL server 2005 and 2008 servers.

•Implemented Log shipping on SQL server 20005 as a High availability solution.

•Gathering of User Requirement and System Specification.

•Created Triggers to enforce data and referential integrity.

•Developed optimized queries in SQL.

•Created Backup & Recovery strategies as part of Maintenance plan.

•Managed and resolved design issues during development.

•Created Stored Procedure, User-defined Functions to take care of back end validations when transferring data to Production Server.

•Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database Optimization.

•Administering MS SQL Server by Creating Logins and assigning appropriate roles.

Environment: SQL Server 2005/2008, ERWIN Data Modeler, Windows 2000, Windows 2003 Advanced Server.

Certificates:

•Microsoft® SQL Server™ 2008 - Implementation and Maintenance (070-432)

•Optimizing and Maintaining a Database Administration Solution by Using Microsoft® SQL Server™ 2008(070-450)

Contact this candidate