*Vinny Rao*
*[email protected] <[email protected]>* / *919 (655)-4576*
*Summary:*
· Seven plus years of experience in Information Technology as Oracle
Database Administrator and knowledge in Systems Analysis and Design,
Development and Documentation at various levels.
· 6.0 + Years of professional experience in different aspects of
Oracle Apps Database Administrator/System Administrator of ERP (Oracle
Applications 11.5.10.2/9/8) on 8.x/ 9.x production database.
· A logical, analytical thinker with exceptional database skills
possesses rich experience of 6+ years as an Oracle database developer.
· Experience of working on Oracle 9i/10/g/11g/12c server
infrastructures.
· Experience in administering, tuning and monitoring database using
Toad, OEM.
- Strong interpersonal, time management and organizational skills.
Proven team player with strong ability to multitask
- Skilled in managing and creating the new databases with the help of
Oracle 8i.
- Proficient in SQL Tuning in an Oracle Environment.
- Expertise in Oracle RAC & ASM Administration/Installation.
- Expert in Oracle Forms and Reports Development.
- Debugging with procedures, Function, Triggers, Packages and other
PL/SQL objects
- 24x7 on-call Production support for database activities.
- Administration of the database including performance monitoring and
tuning.
- Development of web based interfaces for Oracle databases and web
applications.
- Involved in the design of physical database schema, data modeling, and
performance tuning.
- Populating a database with new information or transfer existing data
into it.
- Creating backup copies of data.
- Knowledge of OEM, Diagnostic, Tuning, Configuration and Change
Management Packs.
- Ability to quickly understand complex problems and devise effective
solutions
- Ability to multi task & prioritize under ever changing & challenging
workloads.
*Technical Skills:*
*Databases:* Oracle 9i/10g/11g/12c
(RAC/OPS), MS-SQL, MySQL, DB2, MS Access
*Operating Systems:* UNIX, Linux, Solaris, IBM AIX,
*Programming Language:* PL/SQL, UNIX Shell script
*RAC and Database Tools:* SRVCTL, CRSCTL, CRS_STAT, OEM, grid
control, Toad, DBA Studio
*ETL Tools:* Informatica, Erwin
*Version Control Tools:* Tortoise SVN, Visual Source safe
*Netware:* Putty, Winscp, Scp
*High Availability:* Data guard, RAC, Golden Gate.
*PROFESSIONAL EXPERIENCE:*
* Client Name: CIGNA, Raleigh, NC
July 2015 to till date*
*Role: Oracle DBA *
*Project: Maintenance and support for oracle 11g/12g databases*
*Responsibilities:*
· Maintenance of production database and development database which
includes tablespace space management, user creation, privileges, roles etc.
· Automated hot backups using a combination of incremental,
differential and full RMAN backups
· Supporting more than 40 instances
· Installation of 11g/12g databases and upgrading 11g databases to
12g database.(RAC and standalone).
· Oracle webLogic 11g/12c installation and support.
· Look into new alert log entries and checking for any errors.
· Verifying all instances are up and running.
· Checking tablespace usage
· Maintaining archive data on appropriate storage devices.
· Create or clone the Oracle Instance and Databases on ASM. Perform
database cloning and re-location activities.
· Write script to monitor the database with shell and PL/SQL code or
SQL code such as procedure, function and package.
· Debugging, troubleshooting Oracle PL/SQL packages, stored
procedures and functions.
*Environment*: Oracle Server 10g/11g, SQL Server, HP –UNIX, AIX, Sun OS,
Clarify, SPIN.
*Client Name: UBS, Jersey City, New
Jersey June
2014- May 2015
*
*Role: Oracle DBA*
*Project: Maintenance and support for oracle 10g/11g/databases*
*Responsibilities:*
· Installing 9i database.
· Extensively worked on Real Application Cluster (RAC)
· Creating stand by database.
· Maintenance of production database and development database which
includes tablespace space management, user creation, privileges, roles etc.
- Upgrading the Database from lower version to higher version.
· Debugging, troubleshooting Oracle PL/SQL packages, stored
procedures and functions.
· Automated hot backups using a combination of incremental,
differential and full RMAN backups.
· Export/Import of oracle databases.
· Tuning SQL queries.
· On call support 24x7.
*Environment:* Oracle Server 9i/10g, SQL Server, HP –UNIX
*Client Name*: *Citizen Bank, Rhode
Island *Nov
2012 – April 2014
*Role*: *Oracle database developer*
*Project*: *Maintenance and support of oracle databases*.
*Responsibilities:*
· Created Oracle 9i databases for 2 large departments, from planning
and testing through production.
· Implemented backup and recovery procedures of databases in Sun
Solaris and Red Hat Linux environment: implemented backup and recovery
procedures and IT department manual.
· Managed database remodeling and interface development during
migration from MS Access to MS SQL server and from MS SQL to Oracle 9i.
· Enhanced MS-Access databases by improving user interface,
introducing multiple-user access, and increasing security and stability.
· Involved in all phases of database development, from needs
assessment to QA/QC, design, and support.
· Maintaining archive data on appropriate storage devices.
· Analyzing and validating database objects.
· Used Oracle Data guard tool for creating the standby database.
· Automated the process of oracle backup.
· On call support 24x7.
*Environment:* Oracle Server 9i/10g, SQL Server, HP –UNIX.
*Client Name: Bessemer Trust, New Jersey
Jan 2010 – Sept 2011*
*Role: Oracle database Administrator*
*Project: Payroll management system*
*Responsibilities:*
· Interacted with the Technical Design team and contributed in
impact analysis and creation of the Technical specifications.
· Consistently delivered work assignments within given timeframe,
with high quality and zero defect work which was highly appreciated by the
client
· Physical Database Backup and recovery (Hot and Cold Backups) and
Logical Backup.
· Database Links, Creating and Managing Table spaces and Data files,
Creating and Rebuilding Indexes, Managing Database Security.
· Performance information and monitoring/interpreting alert log and
trace files.
· Use of SQL diagnostic and tuning tools like AUTOTRACE (AWR/ADDM
Reports).
· Attend daily change requests for production database.
· Working knowledge of RAC.
· Autosys (Jobs Running).
· Participated constructively to help and enable team members with
their challenges
· Involved in end-user training and creating user manual document
· Provided technical assistance to the testing team to understand
and setup the testing scenarios and to execute technical intervention test
cases.
* Environment:* Oracle 9i, Forms 4.5, Windows NT, HP – UNIX
*Client Name: NetCracker Technology solutions Private Limited ,
India July 2008 – Oct 2009*
* Role: Oracle database administrator*
*Project: Performing administrative tasks in building and maintaining the
oracle databases.*
*Responsibilities:*
· Responsible to ensure the quality release the deliverables to
production environment.
· Performed analysis of various database objects.
· Worked with oracle support regarding various real time break fix
scenarios
· Responsible for preparation of estimation of work and ensure the
quality and release the deliverables to IAT, UAT and Production environment.
· Worked on refreshes, upgrades, migrations, deployments, backups
and point in time restores.
· Creation of databases and decommissions old DBs. Schema creations
and modifications to schema objects.
· Worked on OS and PSU patching and real time DB recoveries.
· Working on daily administrative tasks, database monitoring tasks,
diagnosing database problems and fixing them.
· Created DB links for accessing data from remote databases.
· Adding tns entries/resolving tns issues.
· Scheduled minor jobs that helped in day to day maintenance.
· Supported databases on various OS environments like Linux,
Solaris, and aix.
*Environment:* Oracle 8i, SQL, PL/SQL, SQL Loader
*Client Name: Global Benefit Group,
India July
2007 – May 2008*
*Role: Informatica developer*
*Responsibilities:*
· Extracted Data from Different Sources by using Informatica Power
Center.
· Extensively used Informatica client tools Source Analyzer,
Warehouse designer, Mapping designer and Mapplet Designer.
· Extracted data from different sources of databases. Created
staging area to cleanse the data and validated the data.
· Designed and developed complex Aggregate, expression, filter,
join, Router, Lookup and Update transformation rules.
· Developed schedules to automate the update processes and
Informatica sessions and batches.
· Analyzed, designed, constructed and implemented the ETL jobs using
Informatica.
· Developed mappings/Transformations/mapplets by using mapping
designer, transformation developer and mapplet designer in Informatica
Power Center.
· Developed Shell scripts to setup runtime environment, and to run
stored procedures, packages to populate the data in staging tables.
· Created Users, user groups, database connections and managed user
privileges using supervisor.
*Environment*: Informatica Power Center 7.1.1, Oracle 8i, MS SQL Server
2000, SQL, PL/SQL, SQL*Loader, UNIX Shell Script.
*Education Qualifications:*
Bachelors in Technology, JNTU, India, 2007.
--
You received this message because you are subscribed to the Google Groups
"oraapps" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/oraapps.
For more options, visit https://groups.google.com/d/optout.
