RAVI REDDY

Email: acsets@r.postjobfree.com

Phone: 832-***-****

SQL Administrator

Around 8+ Years of experience in SQL Server Administration, Development, and Database Design in Production, Test and Development environments with MS SQL Server 2014, 2012, 2008R2, 2008, 2005, 2000 environments.

Experience in Database Administration and Developer for very large and complex databases in SQL Server 2014, 2012, SQL Server 2008 R2, 2008 and 2005.

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

Expertise in T-SQL writing stored procedures, triggers and functions.

Expert in developing T-SQL (DDL, DML, DCL) statements.

Administering SQL Server High Availability and Disaster Recovery strategies.

Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.

Expertise in analyzing the execution plan and index management for better query optimization.

Expertise in using DBCC trace flags handling blocking and dead lock situations and handling the Isolation Levels and Concurrency Effects, detect CPU, I/O, Memory bottlenecks

Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG(Always on Availability Group).

Experience in using DMV and dynamic management functions for finding out long running queries.

Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.

Experience in Disaster Recovery Planning and Security Management operations.

Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

Having hands on experience in DR processes including Log-Shipping and Database Mirroring.

Worked on configuring SQL Server with minimum privileged access.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.

Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.

Implemented Always-ON (AAG) on SQL Server 2012 SP2.

Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

Having Experience on Data center servers and handling 1.4 TB databases.

Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.

Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.

Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

Strong experience in mentoring team members and writing documentation.

24 X 7 Production Database on Call Support

Technical Education

Bachelors in Electronics and Communication Engineering, Jawaharlal Nehru University, India

Technical Expertise

Databases:

MS SQL Server 2014,2012, 2008, MS SQL Server 2005

Programming:

Visual Basic 6, Visual Basic 5, C, C++ & SQL

DBA:

database administration of MS SQL Server 2014 2012,2008, 2005

Operating System:

Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Tools:

Backup Utility, Red Gate, Lite-speed, Visio

Network Topologies:

TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Professional Experience

Argus Information & Advisory Services, LLC,

New York City, NY MAR 14 - Till date

SQL Server DBA

Responsibilities:

Installed and configured SQL Server 2014 Instances and Management tools using SQL Server Setup.

Extensively worked on setting up Always on Availability Groups on a Multi-subnet failover network.

Worked along with the Windows team to configure Windows Failover Cluster on which the Always-On setup was done.

Migrated 2005 SQL Databases in to 2014 SQL databases using Side-by-side Migration process.

Worked on Migration of DTS to SSIS packages. Solving Memory Problems related with SSIS Packages.

Installed SQL SERVER 2008/2008r2/2012 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64 bit system and Hyper –V in PROD/TEST/DEV from scratch.

Used SSIS packages to move data from development to QA and QA to Production.

Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, production support and Project review with client.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.

Installed, configured and maintained transactional Replication Server.

Configured Different RAID Levels

Checking Database Health by using DBCC Commands and DMV.

Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.

Created alerts and notifications for system errors, insufficient resources, and fatal database errors.

Created Triggers to enforce data and referential integrity.

Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.

Performance Tuning, Analysis and optimizing for SQL Server Application by using performance monitor. Assist the SQL Developers in SQL tuning.

Environment: MS SQL Server 2005/2008R2/2014, Windows 2008/2012, SSRS, SSIS, SSAS, TSM/TDP.

HCA Health Care,

Nashville, TN AUG 13-FEB 14

SQL Server DBA

Responsibilities

Installed and administrated SSRS 2008/2008r2/2012 on Windows Server 2008 r2 64 bit SSRS 2008/2008r2/2012 on Windows Server 2008 r2 64 bit.

Installed Service packs and hot fixes on to clustered and stand alone environment.

Implemented new SQL Server 2012 technique ALWAYS ON for High Availability.

Up gradation of SQL server versions and applying patches and hot fixes.

Migrated SQL Server 2000 /2005/2008 databases to SQL Server 2012.

Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor

Configured Linked servers between different servers.

Implemented T-SQL features like Data Partitioning, Error handling and Snapshot Isolation.

Used native tools Profiler, Perfmon and Activity Monitor.

Implemented SQL Logins, Roles and Authentication modes as a part of Security in SQL Server and SSRS.

Upgraded SQL server from SQL 2000/2005/2008 to 2008R2/2012/2014 using In-place and side by side migration techniques.

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

Setup and configures alerts using the IDERA SQL Diagnostic Manager and IDERA Defragmenter for Index maintenance.

Worked in an environment with Change management process (Service-now tool) in place for all kind of production and non-production changes.

Developed and deployed OLAP cubes for reporting purposes using SSAS.

Met SLA’s, fine tuning the SSRS and long running ETL queries.

Resolved bottlenecks and provided Root Cause Analysis for DB related issues.

Supported Windows Team SAN Migration by moving the User Databases.

Developed stored procedures and triggers for data porting for very large databases.

Used 3rd party tools like Lite-Speed, Fog light and DB comparer.

Monitoring servers by checking Error Logs and Windows Logs.

Managing schema objects, such as tables, indexes, and views.

Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM

Performed data base Backups (Full/Differential/Transaction Log Backups into Disk) and restoring on requirement.

Used DMV’s and DMF’s for the performance of data collection and monitoring.

Configured and Maintained High Availability and disaster recovery Setups (Always On, Transactional Replication, 2 node and 3 node clustering, Mirroring, Log Shipping)

Worked with SQL Server 2012 in place and side by side upgrade from SQL server 2008.

Worked on Project for setting up DB mirroring and troubleshooting.

Successfully implemented the Capacity planning for different servers.

Creating and Maintaining Database Maintenance Plans.

Installed and configured SQL Server clustered databases.

Modifying Stored Procedures and complex T-SQL Queries to improve query execution process.

Installed and Configured SSRS and Deploying SSIS packages.

Performed BCP failover exercises for Log shipping and mirroring.

Maintaining the database consistency with DBCC at regular intervals

Resolving performance issues using DMVs (Dynamic Management View).

Developed and deployed OLAP cubes for reporting purposes using SSAS.

Performed Query optimization and achieved Performance by tuning SQL queries using Profiler and Execution Plans.

Environment: MS SQL Server 2000/2005/2008/2012/2014, Windows 2000/ 2003/ 2008/ 2011/ 2012 servers, Outlook Express, .NET, MS Access, ETL, Visual Studio, BIDS, Power Shell, Performance Monitor, T-SQL, Clustering .

Guggenheim Partners

Houston, Texas

SQL Server DBA JAN 12 – AUG 13

Responsibilities:

Installed SQL SERVER 2008/2008r2 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64 bit system in PROD/TEST/DEV on Hyper –V.

Implemented Transactional Replication for SSRS reports.

Designed and Automated the SSRS report deployment using Microsoft Utilities.

Designed tables for the application Users, Roles and Groups, Application Audit and Triggers.

Setup Change Data Capture, designed tables to generate data snapshots from the PAST.

Installed, Administered SSRS and setup data driven subscriptions.

Generated reports from SSRS (SQL server reporting services) and SSAS.

Setup the DB Mail and Alerts on PROD database servers to send out the Notifications.

Migrated and maintained data using various utilities like DTS, SSIS, Import and Export, Attach/Detach Data Migration tools.

Used Team City for code deployment Automation and JIRA for source control.

Implemented Transactional Log shipping and mirroring for database high availability.

Regularly installed service packs and hot-fixes for both clustered and standalone environment.

Used MS System Center Operations Manager (SCOM) SQL MANAGEMENT PACK 2012 to setup the server and database Alerts.

Fine tune long running SQL Queries from Application and SSRS.

Used native tools Database tuning advisor, Profiler, Perfmonce and Activity monitor.

Developed T-SQL Scripts to scrub PROD data for TEST Environments.

Updated and Maintained Passwords for the SQL Server Service Accounts and Application Accounts before Expiration.

Developed SSRS Reports to pull the application/user data for the security team.

Regularly deployed the reports and configured the subscriptions for automated email delivery of the reports.

Developed SSIS package to build the content data for the application.

Designed Backup strategy for OLTP system and Setup Backups for point in time recovery.

Used the DMVs and DMFs for the performance data collection and monitoring.

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

Expertise in creating and supporting OLAP Cubes.

Developed stored procedures, functions, triggers in T-SQL and batch scripts.

Used Red Gate SQL Compare, Visual Studio 2012 for database object and schema compare.

Provided 24X7 support and team player during production outage.

Environment: Windows 2003/2008/2008R2, SQL 2000/2005/2008/2008R2, T-SQL, Replication, SSIS, SSRS, SSAS Database mirroring, MS clustering, Lite-Speed, MOM 2005/2007, SAN and Red Gate.

Fifth Third Bank,

Cincinnati, OH OCT 10 – DEC 11

SQL Server DBA

Responsibilities:

SQL Server 2008 R2/2008/2005 Database Administration.

Migrated databases from SQL Server 2000 to SQL Server 2005 and 2008 R2.

Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.

Installing, Configuring and Maintaining SQL Server 2008R2/2008/2005 (64 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.

Worked as Primary DBA for 50 Instances and 70 as Alternate DBA.

Experience working with CRM Application issues.

Installed and configured Microsoft SQL2 node Clustering (Active/Passive).

Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.

Deployed multi-campus backup environment based on EMC Data domain storage.

Installed and configured Storage Area Networks (SAN) in a heterogeneous environment.

Tuning queries which are running slow using Profiler and Statistics by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.

Successfully implemented the Capacity planning for different servers.

Experienced in configuring Power-shell environment for SQL support.

Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through Try- Catch statement, Common Table Expression (CTE).

Worked in Active/passive and Active/Active cluster environment and Installed and Configured more than 50 Clustered SQL Instances

Worked on Project for setting up DB mirroring and troubleshooting.

Worked on setting up Transactional Replication (push and pull) and Merge Replication and troubleshooting along with Slip stream installations and TDE.

Working on daily tasks include Backup failures, Login creations, Data refresh and Disk space issues.

Implementation of SQL failover cluster and setting up backup jobs and Checking Control Jobs.

Creating and Maintaining Database Maintenance Plans and Worked in migrating database to different collations

Implementing and Maintaining Server Level Auditing for auditing of Logins, Creating and Dropping Objects.

Checking the performance issues on servers as per request by using profiler, perfmon, DBCC and DMVs.

Monitoring servers by checking Error Logs, Windows Logs, Creating Logins and Roles with appropriate permissions.

Worked in Configurations of IIS (Internet Information Service) in ISP environment with access to SQL DBs

Installed and Configured SSRS and Deploying SSIS packages.

Analyzed execution plans, and tuned queries and databases for better optimal performance.

Fixing Missing Indexes and Excess indexes using Data Tuning Advisor.

Managed schema objects like Triggers, cursors, indexes, procedures.

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2008/2005, Windows 2003 Server, IIS 6.0, XML, MS Business Intelligence Development Studio, DB compare.

Bhaskara Info Services,

Hyderabad, India JUN 07 – OCT 10

SQL Server DBA

Responsibilities:

Installed configured SQL Server 2005.

Migrated databases from SQL Server 2000 to SQL Server 2005.

Worked on Client/Server tools like SQL Server enterprise manager and Query Analyzer to administrate the SQL server.

Created and managed schema objects such as Tables, Views, Indexes, Procedures, Triggers and maintaining referential integrity.

Taking Database full Backup, Transaction log backup & differential backup as per backup strategy daily Routine.

Monitoring of database size, disk space in all (Production, Model & Development) the environments.

Data migration (import & export - BCP) from Text to SQL Server.

Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.

Used Windows Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications

Configured SQL Mail.

Involved with MS SQL Server Log Shipping.

Responsible for General Database Administration, Query Performance tuning.

Monitor production Server Activity.

Creating and monitoring all maintenance jobs (backups, integrity, optimization, etc.) on all databases.

Worked with DTS packages to load the massaged data into Data warehousing system.

Tuned the SQL queries using SQL profiler. Involved in tuning the database.

Trouble shooting Problems by using SQL server profiler. Very proactively identifying the problems before user complaints.

Maintaining the Database consistency using DBCC commands at regular intervals.

Environment: Microsoft SQL Server 2005 Enterprise Edition on Windows Server Enterprise Edition, Management Studio, Query Analyzer, BCP, Profiler, T-SQL.

Contact this candidate