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