VASANTHAKUMAR RENGASWAMY

626-***-****

aczoyl@r.postjobfree.com

https://www.linkedin.com/in/vasanthakumarrengaswamy

US Citizen : Clearance obtainable

Location : Ashburn, VA

Objective

To add value in Database management, operations management, project Management, client management, Resource management, vendor relationship management and budget planning.

Strengths

Expertise in working with Oracle, DB2UDB,MySql and Sql Server databases

Demonstrated leadership abilities and effective communication and presentation skills.

Recognized by senior management as customer-oriented professional with proven negotiation skills.

Expertise with SCRUM, AGILE, ITIL and SAS methodologies and proficient with governance and regulatory compliance

Ability to meet and exceed high personal and business goals /objectives.

Credentials

Oracle Certified Professional (OCP)

B.S. in Electronics and Communication from Bharathiyar University in India

Professional Summary

Sr.Oracle Consultant ( Client :Navy Research Lab) : (Jan 2017- Current)

Lead the efforts to Architect the Oracle Database infrastructure (11g and 12c)

Tracking project dependencies outside of the project team's control and escalating issues as necessary.

Implement Oracle Database backups and Monitoring ( Scripts and 12c OEM)

Documented Best practices and standard operating procedures for On-call and Backup & Recovery

Created methodologies for governance and compliance

Implemented database security by creating user roles and privileges.

Installed Quest software products like Spotlight on oracle, schema manager and TOAD for efficient database monitoring and effecting the database operations

Sr. Database Consultant (Client : Kaiser Permanante ) : (Jan 2008 – Jan 2017)

Lead the efforts to evaluate and implement hardware platforms for consolidating databases on multiple SMP servers ( Grid & Cloud )

Tracking project dependencies outside of the project team's control and escalating issues as necessary.

Facilitating cross-group and cross-functional communications for issues resolution and updates

Facilitated, coached, and guided the teams on the values and practices of Agile and Scrum.

Coordinated activities of multiple Scrum Teams.

Collecting and analyzing project metrics data and working with the Scrum Master, Product Owner and Scrum Team to identify and incorporate corrective actions when needed.

Capacity planning for database systems ( p series and x86 platforms)

Created database benchmark criteria and published reports

Evaluated and recommended tools for increasing productivity

Implemented multi-node RAC database systems (10g,11gR1/R2 and 12c)

Implemented Golden Gate for database replication.

Designed and implemented Oracle Application databases for Mission critical and Life Critical applications.

Helped with performance tuning of complex OLAP/DSS & OLTP database applications.

Implemented databases for Demantra and Hyperion Applications

Installed and configured 10g and 11g OAS on Linux

Documented Best practices and standard operating procedures for On-call and Backup & Recovery

Created methodologies for governance and compliance

Implemented Oracle Enterprise Manager Monitoring for Oracle databases

Tuned database performance and SQL query performance.

Generated daily, weekly and monthly reports for management.

Implemented Virtualization solutions for Dev and Test databases using VMware.

Upgrade of database from 8i/9i/10g to 11.1.0.7, 11.2.0.x and 12c ( AIX/Linux/Windows)

Applied periodic PSU patches for Non-RAC and RAC databases on Linux and AIX

Implement backup strategies for OLTP and DW databases

Provide 24/7 on-call support for databases as required

Ticketmaster ( West Hollywood, CA ) ( Sep 2006 –Jan 2008 )

Databases design using ERwin

Install and maintain large Oracle and Mysql database environments

Lead Implementation efforts and mentor Junior DBA's

Worked with a team of developers to create an online java applications with an Oracle database as the backend

Capacity planning for database systems ( Oracle and Mysql on Linux )

Upgrade of Oracle ( from 8.1.7 to 9i and 10g)

Support On going Project Development efforts

On call Support of all database systems

Implementing High Availability solutions (Data Guard and RAC on Linux )

Implement RMAN Backup and restore Strategy for Oracle databases

Performance tuning of Oracle and MySql server databases ( In house and vendor supplied)

Perl scripting for Database refresh and data movement.

Troubleshooting JDBC connectivity in RA and Non-RAC environment

Implemented Shareplex replication for mission critical databases

Applying Patches for Oracle databases

Implemented Oracle Streams for data replication

Refresh of huge databases across different database environments.

Sql tuning for Oracle and MySql databases

Pacific Power ( Portland, OR ) ( Jan 2002 – Aug 2006)

Databases design using ERwin

Install and maintain large Oracle and DB2 UDB database environments on Linux and AIX

Capacity planning for database systems ( DB2 UDB EEE and Oracle )

Upgrade of Oracle ( from 8.1.7 to 9i and 10g) and DB2 UDB ( from 7.2 to 8)

Support On going Project Development efforts

Troubleshoot client connectivity issues for Oracle and DB2 UDB

On call Support of all database systems

Install, Upgrade and maintenance of Sql server databases

Implementing High Availability solutions (Data Guard and RAC Linux/AIX)

Implement RMAN Backup and restore Strategy for Oracle databases

Create and implement maintenance plans for Sql server databases

Implement BCV split-mirror backups (EMC) for DB2 UDB EEE databases

Performance tuning of Oracle,DB2 UDB and Sql server databases ( In house and vendor supplied)

Scripting for Database refresh of huge databases

Implemented Shareplex replication for mission critical databases

Applying Patches for Oracle and Sql server and Fixpacks for DB2 UDB

Implemented Foglight proactive monitoring for databases

Refresh of huge databases across different database environments.

Lead implementation efforts and mentor Junior DBA's

Sql tuning for Oracle and UDB databases

As a consultant for Collective Technologies (April, 1999 – Jan 2002) at:

Worked as a DBA team lead for a group of four DBA’s

Installed and configured an Oracle 8i server on Solaris 2.8, HP-Unix and Red Hat Linux

Created Data Marts and Date Warehouse Dimensions, facts and Cubes

Ensured 24x7 database availability, using Oracle standby database

Implemented Advanced and Snapshot Replication using Quest Shareplex

Installed and configured Oracle RMAN using veritas netbackup for database backups.

Installed and Upgraded Oracle Applications 10.7 to 11i. The following modules were fully installed: ALR, AX, AK, GL, RG, QA, ICX, AZ, AP, AR, OE, PA, INV, BOM, WIP, PJM, EC, PO

Maintained the APPL TOP, performed Reorgs,Concurrent managers and implemented Multi-Org

Religiously applied Application Patches apart from monitoring and tuning the App

Administered, Monitored and troubleshooted DB issues for the People soft HRMS 7.0

Installed and configured Business objects.

Created and maintained the Consteller HUB repository on Oracle and DB2.

Planned the storage capacity for the database servers by forecasting data growth

Partitioned the data warehouse tables for better performance, high availability and maintainability

Designed and implemented the Disk layout using veritas file system and EMC storage manager

Designed and built test, development, and production databases, as well as other schema objects.

Established centralized SQL*Net connectivity in a TCP/IP network environment.

Implemented proactive database monitoring using Quest Foglight.

Tuned and optimized database performance .

Ensured database security, and provided production support.

Installed and Configured Oracle Intermedia

Implemented data communication between databases by creating database links and by using Oracle utilities, including import, export, and SQL*Loader.

Implemented database security by creating user roles and privileges.

Installed Quest software products like Spotlight on oracle, schema manager and TOAD for efficient database monitoring and effecting the database operations

As a Database Administrator at Broadreach Consulting, USA from February 1999 to July 1999:

Created the databases and other database objects according to system specifications.

Migrated data from a mainframe to an Oracle environment.

Created and maintained user accounts, including specifying roles and privileges.

Engaged with Vendors like Oracle, Dell and Sun Microsystems

Designed and implemented backup and recovery strategies for the database environment.

Assisted the developers and users with designing and implementing certain aspects of data modeling and data conversion.

Participated in performance tuning and monitoring on both the application and server sides.

Implemented data communication between databases by creating database links and by using Oracle utilities, including import, export and SQL*Loader.

As a Database Administrator at Singapore Reinsurance in Singapore, from May 1998 to January 1999:

Designed database tables, views, synonyms, and schema objects in Oracle.

Created database backup shell scripts, maintained user privileges, and created new user accounts.

Performed Oracle database tuning and optimizing.

Audited, recovered, maintained, and resolved problems with the data.

Converted the existing legacy system to a client-server environment.

Implemented data communication between databases by creating database links and by using Oracle utilities, including import, export and SQL*Loader.

As an Analyst at MBF Finance in Malaysia, from August 1997 to May 1998:

Assisted with the back-end administration of Oracle databases.

Maintained schema objects, and backed up the database at regular intervals.

Audited, implemented, maintained, and resolved problems with the data.

Coded GUI modules using PowerBuilder, and worked with the development team on functionality issues.

Debugged and tested the modules, and migrated the completed modules from the development to the production environment.

Wrote reports using Oracle Report Writer.

Implemented database security by creating user roles and privileges.

Wrote PL/SQL packages, procedures, and functions.

Implemented data communication between databases by creating database links and by using Oracle utilities, including import, export and SQL*Loader.

Coded batch applications and link lists using C and C++.

As an Analyst at Resonant systems in India, from June 1996 to July 1997:

Assisted with the back-end administration of Oracle databases.

Maintained schema objects, and backed up the database at regular intervals.

Implemented database security by creating user roles and privileges.

Wrote PL/SQL packages, procedures, and functions.

Implemented data communication between databases by creating database links and by using Oracle utilities, including import, export and SQL*Loader.

Audited, implemented, maintained, and resolved problems with the data.

Coded GUI modules using PowerBuilder, Visual Basic, and Oracle Developer 2000, and worked with the development team on functionality issues.

Debugged and tested the modules, and migrated the completed modules from the development to the production environment.

Wrote reports using Oracle Report Writer.

Coded batch applications and link lists using C and C++.

Created schema objects in MS-Access for backend administration of the projects involving Visual Basic.

SKILL SUMMARY

Operating Systems

System Applications

Languages

Databases

Project management Tools

Advanced Database

Linux

Demantra

Visual Basic

Oracle

VISIO

RMAN Backup and Recovery

Solaris

ERwin

C

DB2 LUW

MS-Project

Data Modeling

AIX

Peoplesoft HRMS

C++

Sql Server

MS-Office

Golden gate

HP -UX

Seibel 2000

PowerBuilder

My sql

SCRUM

Performance Tuning

VMS

Veritas Netbackup

Shell scripts

AGILE

Real Application Clusters (RAC)

Windows

EMC storage manager

Visual Basic

ITIL

Data Guard

Informatica

Java

ASM Storage Management

Business Objects

HTML

Oracle Enterprise Manager(OEM)

COGNOS reports

XML

HTML DB

Consteller HUB

Grid Control

Veritas Filesystem

Data Junction

OAS

Oracle Reports

Contact this candidate