Vinny Rao
vinnyrao.dba@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 "CVMSCRM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cvmscrm+unsubscribe@googlegroups.com.
To post to this group, send email to cvmscrm@googlegroups.com.
Visit this group at https://groups.google.com/group/cvmscrm.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment