*Vinny Rao*
*vinnyrao....@gmail.com <vinnyrao....@gmail.com>* / *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 "it
req" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to it-req+unsubscr...@googlegroups.com.
To post to this group, send email to it-req@googlegroups.com.
Visit this group at https://groups.google.com/group/it-req.
For more options, visit https://groups.google.com/d/optout.
