Oracle APPS DBAOracle Techno Functional Consultant Vinay VV070107 by klutzfu58

VIEWS: 45 PAGES: 6

									                  Oracle APPS DBA/Oracle Techno Functional Consultant

Vinay
VV070107

SUMMARY

  ·     9+ years of IT experience in Oracle Database Administration, Oracle
        Applications, Analysis, Design, Server Optimization Techniques,
        Production environment and Applications Support.
  ·     Excellent experience in Administration of Oracle Databases for Oracle
        Applications (eBusiness suite).
  ·     Very    Good    at   UNIX     Administration,     Scripting    &   Technical
        Documentation.
  ·     3+ years experience as Oracle 9i Certified DBA, Oracle APPS DBA
        Oracle Techno Functional Consultant, System Analyst.
  ·     Worked on Oracle APPS versions 11i as Oracle APPS DBA.
  ·     Install Patch 2520155 which brings RapidInstall to version 11.5.7.33.
  ·     Worked on Tuning Performance and is area of specialization.
  ·     Expertise in Oracle Servers (9i, 8i, 8, 7.3) installation, administration.
  ·     Major strengths are problem solving stills along with extensive experience on
        Oracle Windows and many other flavors of UNIX operating systems.
  ·     Expertise in writing Challenging Codes using SQL, PL/SQL and UNIX Shell
        Scripts.
  ·     Expertise in making reports through D2K.
  ·     Well versed in Backup and recovery strategy implementation and
        troubleshooting.
  ·     Sound knowledge of Design and Development of commercial application
        using Client/Server Technologies and Data Warehouse.
  ·     Experienced in Oracle 9i administration.
  ·     Experienced in Business Objects basic Administration.

SKILLS

      Databases            Oracle 10G, Oracle Database 10g Express Edition,
                           9i, 8i, 8, 7.3., 10.1.0.2.0

      Application          Tomcat 4.0.
      Servers

      Reporting Tool       Business Objects

      GUI                  Developer 2000

      Languages            JAVA, EJB, SQL, PL/SQL, Perl, Unix Shell Scripts


      ERP                  Oracle APPS 11i,11.5.10, 11.5.7.33.


      OS                   WINDOWS, UNIX (Red Hat 3.0, Windows NT)
EDUCATION

   •   Bachelor of Engineering in Engineering and Technology.
   •   WebMaster Post Graduate Diploma.

PROFESSIONAL CERTIFICATIONS

       •     Tunings and Performance.
       •     Introduction to Oracle SQL/PLSQL.
       •     Backup & Recovery.

PROFESSIONAL EXPERIENCE

Axiom Sources, MD
Oracle APPS DBA
Nov 2007 – Till Date

Responsibilities:

       ·   Installing patches on Oracle 11.5.7.33.
       ·   Create the installation Filesystems.
       ·   Install Patch 2520155 which brings RapidInstall to version
           11.5.7.33.
       ·   Create tables, views, and other database objects.
       ·   ALTER DATABASE: open, mount, back up, or change character set.
       ·   Administration and maintenance of Oracle 9i database on LINUX.
       ·   Setting Up Linux with FireWire-based Shared Storage for Oracle
           Database 11.5.7 RAC.
       ·   Constant DBC file check and monitoring.
       ·   Writing PL/SQL stored procedures & triggers as required for
           Security, monitoring, audit & alert.
       ·   Data modeling the application and create final Physical /Logical
           Database design/data design for the application for the production
           server.
       ·   OEM, RMAN setup, Oracle upgrade (Applying Patches) on
           Production & Development servers.
       ·   Preparing the backup strategy for Production, development & UAT
           database by using RMAN, Cold & Logical backup.
       ·   Tuning the Oracle APPS Reports and to provide the tuning tips to
           Oracle APPS reports developers.
       ·   Setup/ Troubleshooting the Oracle Replications.
       ·   Run queries and SQL scripts.
       ·   Administration and maintenance of Oracle 8i & Oracle 9i database on
           Sun Solaris OS for web based application.

Environment:

     Oracle 8i, 9i, Oracle 10g, Oracle APPS 11i, Linux, Oracle OEM/OMS,
Designer 2000, Business, Tomcat.

PANASONIC
Oracle APPS DBA/Oracle Functional & Technical Consultant
Oct 2005 – Oct 2007
Description:

       Worked, as an Oracle ERP Manager at PANASONIC. Databases used were
oracle 9.2.0.5.0. Operating System is Red Hat Linux.

Responsibilities:

       ·   Administration and maintenance of Oracle 9i database on LINUX.
       ·   OCFS RPMs (drivers, tools) for RHEL3.
       ·   Production DBA support for Oracle 9i.
       ·   Configuring Oracle 10g 10.1.0.2.0.
       ·   Created Cloning procedures and preparing documentation.
       ·   Backups & Recovery for Production, development & UAT database.
       ·   Expertise in making reports through D2K.
       ·   Created and deployed Shell and SQL scripts.
       ·   Purged workflow tables.
       ·   Monitored the performance of production systems.
       ·   Interface with clients on application related issues and provide solutions.
       ·   Optimized for heavily accessed Business Reports for faster response.
       ·    Applied Critical Patch Updates.
       ·    Performed Statspack / Performance Analysis.
       ·   Designed, Developing mapping in Development which will transfer
           the data from production database to data warehouse.
       ·   Plan, develop and test scripts to create the production database,
           application schema and procedures.
       ·   Created and implemented daily batch update process.
       ·   Created and maintained domain model for the application.
       ·   Oracle Database installation properly configured, Tuned, patched,
           and tested, and rolled that exact installation out to other hosts.
       ·   Data modeling the application and create final physical /Logical
           database design/data design for the application for the production server.
       ·   Performance monitoring and tuning of database.
       ·   Written PL/SQL stored procedures & triggers as required for
           Security, monitoring, audit & alert. Also handled and solved any
           database related issues with the application developer. SQL Tuning.
       ·   Change Data Capture (CDC) implementation & problem solving (as this
           is new feature in 9i) & has implemented on production database for data
           warehouse.
       ·   Extensive implementation of replication using Materialized views and
           refresh of materialized views after daily updates.
       ·   Written UNIX shell scripts/Perl scripts to automate jobs.

Achievements in Panasonic:

       ·   1st Paper of ISM IN Malaysia – June 2006 conducted by MEI and got the
           certificate from MEI OF ISM PROFESSIONAL.
       ·   2nd Paper of ISM in Singapore – Dec 2006 conducted by MEI and got the
           certificate from MEI of ISM AUDITOR.
       ·   3rd Paper of ISM in Singapore – Feb conducted by MEI and got the
           certificate from MEI of ISM AUDITOR TEAM LEADER.
       ·   Promotion in Panasonic form Manager – I to Manager – II in April 2007.
Environment:

   Oracle 9i, Red hat AS3.0, Windows 2000, Windows NT, Oracle
OEM/OMS.

LG
Oracle Technical & Functional Consultant/Oracle APPS DBA
Oct 2003 - Oct 2005
Employer- Mbitt

Description:

      Worked, as an Oracle Database Administrator and Oracle Techno
Functional for the client LG, is one of the leading electronics manufacturing
company. Supported the production/development environment and setting up
production server. Databases are on Oracle 9.2.0.5.0.

Responsibilities:

       ·   Administration and maintenance of Oracle 9i, Oracle 8i database on
           Linux & Windows NT.
       ·   Tune the code of database, which includes the SQL tuning tips to
           programmers.
       ·   Created and deployed shell and SQL scripts.
       ·   Purged workflow tables.
       ·   Monitor the performance of production systems.
       ·   Interface with clients on application related issues and provide solutions.
       ·   Optimized for heavily accessed Business Reports for faster response.
       ·    Applied Critical Patch Updates.
       ·    Performed Statspack / Performance Analysis.
       ·   Expertise in making reports through D2K.
       ·   Explore 9i & its new features.
       ·   Installed patches on Oracle 11.5.7.
       ·   Prepared the backup strategy for Production, development & UAT
           database by using RMAN, Cold & Logical backup.
       ·   Backups & Recovery for Production, development & UAT database.
       ·   Developed small applications like Change control, Report Process etc
           as per requirement.
       ·   OEM, RMAN setup, Oracle upgrade (Applying Patches) on
           Production & Development servers.
       ·   Performance monitoring and tuning of database.
       ·   Written PL/SQL stored procedures & triggers as required for
           Security, monitoring, audit & alert. Also handled and solved any
           database related issues with the application developer. SQL Tuning.
       ·   User and Security Management through Roles, profiles and synonyms.
       ·   Worked as Informatica Administrator as well as developed some
           mappings.
       ·   Design/Implementation of Background jobs for Materialized views
           refresh & for time consuming tasks.
       ·   OEM Reports setup & created reports which show the production
           system health, that includes capacity planner reports, Database growth
           reports, Archive generated, Web logic load (using Read only tables),
           commits etc.
Environment:

      Oracle 9i, Oracle APPS 11i, Windows 2000, Oracle OEM/OMS,
Designer 2000, Business, Tomcat.

VCustomer
Oracle Technical Consultant
Dec 2001 – Sep 2003
Employer-Enterprise Technologies Solution

Description:

      Worked, as Oracle Technical Consultant for the company ETS, is one of the
ERP Solution provider. Supported the Oracle Applications Release 11i & in-
house development/production environment.

Responsibilities:

       ·   Tuning the Oracle APPS reports & to provide the tuning tips to Oracle
           APPS reports developers.
       ·   Remedy architectural layout
       ·   Setup/ Troubleshooting the Oracle Replications.
       ·   Installing patches on Oracle 11.5.7.
       ·   Administration and maintenance of Oracle 8i & Oracle 9i database on
           Sun Solaris OS for web based application.
       ·   Expertise in making reports through D2K.
       ·   Development and Test Environment(s), Reporting Instance.
       ·   System Backup/Restore procedures.
       ·   Database and Application Cloning.
       ·   Patch application with and with out Ring Master.
       ·   24 X 7 database support for Application and database Server.
       ·   Database Server Trend Analysis, Developed, designed.
       ·   Standardized and modified Reports.
       ·   Installation and support for Oracle Forms 9i, Discoverer 9i,
           Designer 9i.
       ·   Resolved Technical issues , Running patches, Patch policy management
           and testing, Technical Support and up keeping the environment and
           implementing best practices, Tuning Application Tier, Database Tier,
           tracking growth of database etc.

Environment:

    Oracle 8i/9i, Oracle APPS 11i, Windows 2000, Apache Web Server,
Window NT.

Ballarpur Industries Ltd.
Oracle Technical Consultant
Aug 2000 – Nov 2001
Employer - Enterprise Technologies Solution
Description:

      Worked, as Oracle Technical Consultant for the company ETS, is one of the
ERP Solution provider. Supported the Oracle Applications Release 11i & in-
house development/production environment.
Responsibilities:

       ·   Tuning the Oracle APPS reports & to provide the tuning tips to Oracle
           APPS reports developers.
       ·   Application Server Patch.
       ·   Database Patch – Next scheduled downtime.
       ·   11.5.7 – 11.5.9 Rapid Install.
       ·   Setup/ Troubleshooting the Oracle Replications.
       ·   Oracle Forms and SCM Integration.
       ·   Administration and maintenance of Oracle 8i & Oracle 9i database on
           Sun Solaris OS for web based application.
       ·   Expertise in making reports through D2K.
       ·   I was developed the reports through PL/SQL code.
       ·   Written PL/SQL stored procedures for adding new functionality to the
           application.
       ·   Plan/Create Go-Live plan.
       ·   Development and Test Environment(s), Reporting Instance.
       ·   System Backup/Restore procedures.
       ·   Database and Application Cloning.
       ·   Patch application with and with out Ring Master.
       ·   Database Server Trend Analysis, Developed, designed.
       ·   Standardized and modified Reports.
       ·   Installation and support for Oracle Forms 9i, Discoverer 9i,
           Designer 9i.
       ·   Resolved Technical issues , Running patches, Patch policy management
           and testing, Technical Support and up keeping the environment and
           implementing best practices, Tuning Application Tier, Database Tier,
           tracking growth of database etc.

Environment:

   Oracle 9i, Java, Designer 2000, XML.

ICRA Limited
Senior Java Analyst
July 1999 - July 2000
Employer - ICRA Limited

Description:

       Worked, as Senior Java Analyst for the company ICRA Limited, is one of the
Rating Company. Supported/Developed the in Java Language for in-house
Development/production environment.

Responsibilities:

       ·   Setup/ Troubleshooting Existing Application.
       ·   Administration and maintenance of WEB BASED APPLICATION.
       ·   Expertise in making JSP Pages for the Existing Application.
       ·   Expertise in making the Applets through Java Language.
       ·   Plan/Create Go-Live plan.

Environment:
   Oracle 8i, Java, Designer 2000, XML, JSP.

								
To top