Venkata Datla

240-***-****

ac27cv@r.postjobfree.com

Summary

Over 9 Years of IT experience as a SQL Server Database Administrator, Provide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2005, 2008, 2012, 2014 and 2016 environments

Installed, upgraded and administered SQL Servers 2008, 2008R2, 2012, 2014, 2016 in virtual and physical environments and patched periodic Service Packs (SPs) and cumulative updates

Implemented and managed SQL Server High availability and Disaster Recovery solutions like Mirroring, Log shipping, Replication, Windows Failover clustering and Always-On Availabiity Groups (AAG)

Hands on experience in database migration from SQL server 2005/2008/2008R2 to SQL2012/2014/2016 by using side-by-side and Inplace upgrade process

Experience in configuring & working on active-active, active-passive & Multi-subnet cluster environment for HA

Optimized T-SQL query performance using SQL Profiler, Execution Plans, Index analysis, tuning advisor, extended events, DMVS and DBCC

Monitoring day to day activities like maintenance plans, schedule jobs and database health check

Ensure stable operation, performance and availability of production MS SQL Server environments through proactive monitoring, maintenance, and management

Ensure native database back up processes and schedules meet defined Recovery Point Objectives (RPO) and that backups are routinely tested to ensure consistency and the ability to meet Recovery Time Objectives (RTO)

Participate in on-call rotation and after hours or weekend work for disaster recovery testing, production support, and code deployments

Implemented data security features of Transparent Data Encryption(TDE), Columnlevel encryption, table partition

Experience in creating objects like Tables, Views, Normalization, Indexes, Batches, Stored Procedures, Functions, Cursors, Triggers, Common table expression (CTE) and other SQL joins and query writing using T- SQL statements

Exposure on Storage Area Networks (SAN) and utilizing SanDisk space in a Windows Environment

Experience in ETL and reporting tools. Basic understanding of the Data Warehousing SDLC of ETL, reporting and BI tools

Served as the key point of contact/Liaison between on-site and offshore resources working from client location

Basic Knowledge on Cloud Technology such as AWS, Azure

Basic understanding on installation and configure MapReduce, HIVE and the HDFS; implemented Cloudera Distributed Hadoop cluster on CentOS

TECHNICALSKILLS

Operating Systems:

Windows NT/2003/2008/2010/2012, Unix, Centos

Databases:

MS SQL Server 2005/2008/2008R2/2012/2014/2016

Database Tools:

SQL Server Management Studio, SQL decryptor, Visual studio, SQL profiler, Extended events, SQL Query Analyzer, Index Analyzer, Performance monitor, Data Migration Asistant

Third Party Tools

Idera, Spotlight, Red gate, servicenow, Remedy, Litespeed, Netbackup

Languages:

T-SQL, PowerShell

Education:

Bachelor of Engineering, IME, INDIA

Certification:

MCTS:70-462 Administering Microsoft SQL Server 2012/2014 Databases

PROFESSIONAL EXPERIENCE

Wellsfargo Financial Services Apr 2016 – Till date

North Brunswick, NJ

SQL Server DBA

Wells Fargo & Company is an American international banking and financial services holding company headquartered in San Francisco, California. It is the world's second-largest bank by market capitalization and the third largest bank in the U.S. by assets.

Environment:

MS SQL Server 2008/2008 R2/2012/2014/2016

Extensively used third party tools IDERA and SQL Decryptor

Responsibilities:

Responsible for supporting & troubleshooting issues with databases using 2008R2/2012/2014/2016 enterprise edition

Install, configure, upgrade, and maintain database instances from SQL 2008/2012 to 2014/2016 on clustered and standalone servers of Non Prod & Prod servers

Scheduling and implementing patching activities i.e. Service packs and

Cumulative upgrades as per baseline standards at Wellsfargo

Contributed to implementation of HA/DR solutions for database servers of SQL 2012/2014/2016, including Failover Clusters, mirroring and Always On Availability Groups

Manage application and user access to SQL Server environments

Deploy and test maintenance jobs, and change scripts in both test and production environments

Performance tuning on long running queries and stored procedures, using SQL Profiler, server side traces, Database Tuning Advisor, and query execution plans

Daily production DBA tasks, including monitoring SQL Server logs, SQL Agent job execution, and transaction log file sizes, backup/restore

Configure and refine IDERA monitoring tool and alerts

Used DBCC and DMV commands for day-to-day troubleshooting tasks

Participate in AlwaysOn Availability Group failover testing of High Availability and Disaster Recovery environments during DR test

Responsible for deploying code changes, code review and code releases in all environments with respect to release deadlines

Manitowoc Corporation Nov 2012 – Mar 2016

Chambersburg, PA

SQL Server DBA

Manitowoc is recognized as one of the premier innovators and providers of crawler cranes, tower cranes, and mobile cranes for the heavy construction industry, which are complemented by a slate of industry-leading aftermarket product support services.

Environment:

MS SQL Server 2008/2008 R2/2012

Extensively used third party tool spotlight

Responsibilities:

Manage and administer SQL server 2008/2008R2/2012 servers Involved in Administration, Performance Analysis and 24X7 Production Support for Large (VLDB) and Complex Databases

Managed over 25 SQL Servers including Production and Test servers

Installed and configured SQL Server 2008/2008R2/2012/2014 on clustered and non-clustered environments

Migrate databases from SQL 2008 & 2008R2 to SQL 2012/2014

Contributed to implementation of HA/DR solutions for database servers of SQL 2012/2014/2016, including Failover Clusters, mirroring and Always On Availability Groups

Deployment of databases, jobs from pre-production to production

Create and schedule maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans

Worked with database tuning advisor, SQL server profiler, Performance counters for Performance tuning

Used DBCC and DMV commands for day-to-day troubleshooting tasks

Meggit Training Systems Jan 2012 – Oct 2012

Atlanta, GA

SQL Server DBA

Meggitt Training Systems is the leading supplier of integrated live fire and simulation weapons training systems supporting military, defense and security forces, federal and international law enforcement agencies, large metropolitan training academies, thousands of police departments, ammunition and firearms manufacturers and commercial shooting range owners.

Environment:

SQL Server 2008/2008 R2

Responsibilities:

Installed and configured SQL Server 2008/2008 R2 on Prod and Non-Prod environments

Upgradations of sql server versions and applying patches and hot fixes

Configured HADR techniques like Mirroring, log shipping and transaction replication

Troubleshoot Performance issues on production environments using Performance counters, SQL Profiler to find the resource bottlenecks

Resolved locking and blocking issues

Refresh non-prod environments with production data on regular basis

Used Index tuning wizard to optimize query performance

Reorganizing or Rebuilding Indexes based on the Index fragmentation

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

Carrier Corporation, Jul 2008 – Dec 2011 Tyler-TX & Indianapolis-IN SQL Server DBA

Carrier is a world leader in high-technology heating, air-conditioning and refrigeration solutions.

Environment:

SQL Server 2005/2008 & 2008R2

Extensively used third party tool Redgate

Responsibilities:

Migrated SQL server 2000 databases into SQL server 2005 and SQL server 2008 databases by side by side upgrade process

Setting up and Monitored database logshipping, mirroring on Production and non production environments

Migrate DTS packages into SSIS packages

Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks

Monitoring SQL server performance using profiler to find the performance, deadlocks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing

Implementation of SQL Principle, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users

Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks

Contact this candidate