Sql Server Management

Rama K. Voleti

**** ********** *****, *****, **, 75024

214-***-**** **********@*****.***

SR. ORACLE DBA SR. SQL SERVER DBA DATABASE ARCHITECT Multifaceted Database Administrator with progressive +20-year career that includes repeated success in administering major relational database management systems (RDBMS): Oracle, SQL Server, and Sybase. Out-of-the box and quick thinker with sharp eye for details and skill in managing database and IT infrastructure projects, including backup, storage, and operating system improvements. High achiever who excels in developing utmost efficient enterprise-wide solutions for a global customer base.

Areas of Expertise:

Database Design & Testing Data Security & Integrity Database Performance Tuning

DBA Team Building & Leadership Database Efficiency Monitoring Process & Quality Improvement

Disaster Recovery & Backup Logical & Physical Data Modeling Technical Documentation TECHNICAL SKILLS

Certifications: Certified Oracle Database Administrator and Certified SQL Server database administrator (MCP) Databases: Oracle (11g,10g,9i,8i,7.3.x), MS SQL Server (2000,2005,2008,2008r2,2012), Sybase System

(11.5,15.1)

Tools & Packages: Oracle Enterprise Manager (Grid Control), Oracle Data Guard, DB Artisan, SQL Developer, TOAD, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL server reporting services (SSRS), SQL Safe ( Idera ), HP Service Guard, HP Data protector, HP OpenView,Tivoli Storage Manager, OnCommand Insight, ERWin Modeling software, SQL Backtrack, SQL*PLUS, ISQL, CT-Lib, Db-Lib, Sybase Replication Server

Operating Systems: HP-UX, Linux, Windows NT, 2000,2005, 2008 & 2012, Solaris, AIX Languages: C++, C, JAVA, PL/SQL, T-SQL, HTML

Shell Scripts: Korn and C Shell, PowerShell, TIBCO’s InConcert Workflow, Network Data Mover Version Control: MS Visual Source Safe, CVS, PVCS

Additional: RightNow FAQ, Primus Clarify, Convera’s RetrievalWare Search Engine, RogueWave Tools, PowerBuilder, ColdFusion, BEA’s WebLogic Server 5.x, Apache, IIS, iPlanet 4.x PROFESSIONAL EXPERIENCE

VALERO ENERGY CORPORATION, San Antonio, TX 2003 – 2015 Lead Database Administrator

Hired to build DBA team from scratch and lead enterprise-wide administration of Oracle, MS SQL Server, and Sybase databases used by various refining and corporate applications. Propelled smooth daily operational activity of database environment for entire IS department (customers). Provided 24/7 support for HQ and remote sites; managed +300 SQL server and +120 Oracle instances; and rendered third-level support for all SAP systems. Challenged to shift DBAs concentration from primarily a firefighting function to an application developer support role. Impact: Streamlined entire database operations, resulting in a more reliable, stable, and secure environment providing optimal performance to highly satisfied customers.

Minimized database issues, thus heightening end users satisfaction with application performance and slashing number of helpdesk and after-hour support calls from 20/day to 2 4/month.

Met corporate mandate to secure database environment by working closely with IT auditors to obtain certification and compliance with all audit requirements.

Developed disaster recovery plan and tested DR scenarios, improving database recoverability/MTTR, customer satisfaction, and cost savings by using tape instead of disk storage. RAMA K. VOLETI PAGE 2

214-***-**** **********@*****.***

VALERO ENERGY CORPORATION, continued

Proactively resolved all Oracle and SQL server database issues by standardizing and streamlining database monitoring and incident management systems, which also increased management’s visibility and ensured no unauthorized changes.

Reduce total cost of ownership (TCO) of every database by reducing licensing fees and associated yearly maintenance expenses, improving ROI, and reducing DBA staff turnover.

Formulated effective strategies to reduce time spent on integration and separation of IT systems during acquisitions and divestures.

Upon merge of Backup and Storage administrative teams with DBA team streamlined operations, which sped up storage provisioning requests; reduced server outages due to storage issues; and boosted efficiency of backup operations. NORTEL NETWORKS, Richardson, TX 1999 – 2003

Sr. Database Engineer

Brought in as database SME to provide DBA functions, develop database related code, and support/guide developers. Designed logical and physical data models, administering Oracle databases for various home-grown applications: case management and knowledge management tools. Contributed to integration and implementation of eCRM and knowledge management tools across enterprise.

Impact: Provided expertise for design, implementation, and administration of very large Oracle databases used by multiple applications and 7000 users across 60 countries.

Maximized team’s effectiveness by providing DBA expertise for application analysts and support staff.

Developed disaster recovery plan to backup and replicate Oracle databases.

Designed and developed system interfaces, including for billing and Interactive Voice Response (IVR) administration.

Took on additional responsibilities outside of job scope, thus eliminating need to hire application server administrator. WORLDCOM INC., Tulsa, OK 1993 – 1999

Database Administrator (1995–1999)

Selected as one of the first members to startup a DBA team as WorldCom entered the local telecom service business. Provided technical leadership for DBA team, supporting local services’ databases with Oracle and Sybase DBA functions. Planned for future data storage demands as well as designed and implemented primary database structures. Impact: Built DBA team from the ground up to provide quality DBA functionality to rest of IT organization.

Improved database performance and Y2K compliance by reviewing Oracle/Sybase SQL, stored procedures, and triggers.

Optimized Oracle production databases by segregating various files and thus improving execution of complex table joins.

Evaluated monitoring, backup, and recovery tools; selected SQLBacktrack and DBProVision from Platinum technologies. Sr. Application Developer Analyst (1993 1995)

Hired to develop applications using client/server technology to migrate data to Sybase databases from several legacy systems, such as AS400 and mainframe. Developed code using C++, Powerbuilder, and Sybase as backend database. Impact: Migrated legacy systems to client/server model, completing various projects on time.

• Designed and developed replication system to transfer order entry transactions from Sybase database.

• Designed, developed, and implemented new order provisioning and external interfacing systems. EDUCATION

MS, Computer Science STATE UNIVERSITY OF NEW YORK, New Paltz, NY BS, Mechanical Engineering MANIPAL INSTITUTE OF TECHNOLOGY, Manipal, India

Contact this candidate