Manager Oracle
Resume:
VASANTHAKUMAR RENGASWAMY
************@*****.***
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