Resume of Oracle Apps DBA

Title
Oracle Apps DBA

Primary Skills
Oracle Applications DBA

Location
US-IL-Chicago (will consider relocating)

Posted
Feb-22-08



EXPERIENCE SUMMARY:
Ø Specialized in Oracle Databases (Versions 11g, 10g, 9i), Oracle Apps Database Administration (R12, 11.5.10, 11.5.9, 11.5.8, 11.5.7) and Fusion Middleware (10g AS).
Ø Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning, Refreshing Databases on Oracle Applications
Ø Strong experience in supporting development, unit test, system test, Integration test, certification test, production databases under almost all flavors of UNIX (Oracle Enterprise Linux, Red Hat, Sun Solaris, IBM AIX) and Windows
Ø Implemented Oracle Applications R12 (single and multi node) and upgraded 11.5.10 CU2 to R12
Ø Worked on high availability environment implementations (R12 Apps +10g RAC DB, R12 Apps+11g RAC, 11i Apps+11g RAC DB) -- all are 3 node implementations
Ø Implemented shared appltier application systems and configured BigIP to load balance mid-tiers (R12 shared appltier, 11i shared appltier)
Ø Implemented Parallel Concurrent Processing to load balance CP tier
Ø Integrated Oracle Applications R12/11i with OID/SSO
Ø Implemented both servlet and socket mode connection configurations on forms tier
Ø Configured applications on SSL secure mode
Ø Experienced in Space Management, Memory Tuning and Application Tuning
Ø Cloned Oracle applications R12, 11i and Databases
Ø Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin, Jinitiator and database)
Ø Performed NLS implementation (Hebrew pseudo language)
Ø Applied oracle apps tech stack patches (10.1.2, 10.1.3, iAS, 8.0.6 MT tech stacks + 9.2.0, 10.2.0, 11.1.0.6 DB tier tech stacks), 10g/11g RAC fix patches using opatch
Ø Applied product specific fix patches, family packs, maintenance packs -- all types of patches -adpatching
Ø Integrated DEMANTRA applications with Oracle Apps R12
Ø Integrated Oracle Apps R12 with BPEL
Ø Recovered block corrupted 11g database
Ø Well versed with UNIX shell scripting, PL/SQL and Java Coding
Ø Involved in data model design and database development including PL/SQL stored procedures, functions. Having Strong Oracle Development background besides DBA skills
Ø Good at intellectual knowledge base creation-documentation during the project implementation phase and maintenance phase
Ø Hard working, well in analytical and logical problem solving and excellent communication skills. Worked efficiently as an individual as well as in team environment

TECHNICAL SKILLS:

Operating Systems : Oracle Enterprise Linux 3/4/5,Red hat Linux 2.1/3.0/4.0/5.0, Sun Solaris 5.6/5.9,
Unix IBM AIX,
Languages : SQL, PL/SQL, Java, XML, J2EE
Scripting : UNIX Shell Scripting, Java Scripting
Databases : 9i, 10g, 11g
Tools : PL/SQL Developer, Jdeveloper, TOAD, OEM, OAM, SQL*Plus, SQL*Net, SQL*Loader,
Export/Import, MS Project 2003
Middleware : Fusion Middleware -10g AS (OC4J clustering, EM, web cache, OID/SSO, Discoverer,
OHS), 9iAS (Jserv, OHS)
ERP : Oracle E-Business Suite R12, 11.5.10, 11.5.9, 11.5.8, 11.5.7

EDUCATION:
Ø Master of Business Administration (Systems)
Ø Bachelor of Engineering (Computer Science)
Ø Oracle 9i Certified DBA Associate
Ø Oracle PL/SQL Developer Certified Associate

PROFESSIONAL EXPERIENCES:

Oracle Corporation September 2005 --Till Date

Position : Senior Database Administrator
Projects : 11g RAC with R12 RUP3, 10g RAC with R12 RUP2, 11g RAC with 11i ATG RUP6, 11.5.10 CU2
Upgrade to R12, NLS implementation, Integration of DEMANTRA with Oracle Apps R12/11i,
Maintenance of 11.5.10 CU2, CU1, vanilla 11.5.10, 11.5.9, 11.5.8, 11.5.7, BPEL integration
OS : Oracle Enterprise Linux 4.0/3.0,RHEL 3.0/4.0, MS Windows 2000 SP4
Softwares : 11g, 10g, 9i Databases, OAM, Unix Shell Scripting, Unix cron jobs, J2EE
Apps : Oracle Financials, Oracle HRMS, Oracle CRM, Oracle Manufacturing suite of products
Ebiz versions : R12, 11.5.10 CU2/CU1, 11.5.9, 11.5.8, 11.5.7
Backup : Net Apps Snapshot Backup, Hot backup, Cold Backup, Export -- Logical Backup

Responsibilities:

Ø Responsible for installing Oracle Applications R12/11i in single node & multimode
Ø Installing CRS stack and RAC Oracle Homes
Ø Performing Complex RAC setup with Shared appl-tier application system
Ø Load Balancing Mid-Tier web servers with BigIP Load balancer
Ø Load Balancing Concurrent Processing tier -- PCP
Ø Configuring environments in SSL mode
Ø Applying one-off fixes to Database Oracle Homes (both RAC and non-RAC) using Opatch utility
Ø Cloning Oracle Applications instances both R12 and 11i instances
Ø Applying Rollup Patches R12.0.1, R12.0.2, R12.0.3, ATG RUP5, ATG RUP6
Ø Developing Strategies for Oracle Application Upgrades from a lower version to higher version and performing the upgrades
Ø Upgrade of individual Oracle Applications product and product families by applying Mini-Packs and Family Packs
Ø NLS implementation - Adding additional languages (Hebrew, Arabic, Korean) in Oracle Applications
Ø Frequent Upgrades of techstack components and applying one-off fixes to 10.1.2 and 10.1.3 Oracle Homes (R12), 8.0.6/iAS Oracle Homes in 11i
Ø Upgrading Databases from 9i to 10g, 10g to 11g
Ø Upgrading 11.5.10 environment to 11.5.10 CU2
Ø Rebuilding Database indexes
Ø Recovering of database against block corruption/media corruption
Ø Applying R12 maintenance Pack -- Patch 4440000
Ø Applying patches using distributed AD
Ø Working Closely with System administrators, developers, technology Stack team and Server Tech team (ora-600, ora-7445 to resolve the bugs
Ø Creating documentation during project planning, project execution and project maintenance phases
Ø Monitoring users activity using sign-on audit reports
Ø Capacity Planning/Management (space/machine load/network)
Ø Resolving system errors, disk space problems
Ø Creating Project Plans for managing major E-Biz downtime
Ø Monitoring tablespace usages
Ø Customizing autoconfig templates according to the environment requirements
Ø Relinking applications executables
Ø Upgrading JDK versions from 1.4.2 to 1.5 and 1.6 and JRE/Jinitiator to 1.3.1.28
Ø Proactively tuning JVM for performance issues, creating JVM islands
Ø Tuning Concurrent Managers, Defining Work Shifts, configuring specialization rules, Defining primary & secondary nodes for PCP setup
Ø Using the AD utilities for maintaining the application systems (adpatch, adctrl, adadmin, adrelink, adsplice)
Ø Day to day troubleshooting of the environments (part of team maintains 220+ Apps instances - all version of Oracle Applications starting from 11.0.3 to R12 in all flavors of Unix, having all versions of databases- 8i/9i/10g/11g, size of which ranging from 20Gb to more than terabytes) which includes fixing all the issues coming in them and supporting the various components of Oracle Applications - Forms, Apache, Concurrent Manager, webtogo (Olite), Mobile Server, BPEL services, DB, Listener
Ø Cloning Oracle Applications
Ø Weekly Refreshing environments from source environments
Ø Cross Platform Migration of Environments from Solaris to Linux
Ø Developing Backup strategies (Snapshot, Hot, Cold) for weekend backups of important environments
Ø Extensive Unix Shell Scripting to automate maintenance and configuration of tech stack components, Cron jobs to automate the backups, monitoring Alerts
Ø Splicing one-off product using adsplicer
Ø Managing system configuration by using AutoConfig
Ø Securing Oracle Applications by periodically changing Apps and schema passwords
Ø Gathered database/Objects statistics using DBMS_UTILITY, DBMS_STATS, and FND_STATS packages and ANALYZE command
Ø Compiling forms/pll's, DB invalids, creating DB links
Ø Applying patches on both server side and client side
Ø Installation and configuration of webtogo (Olite both 9i and 10g) -- for Mobile field service
Ø Performing Mapviewer setup, Workflow configuration
Ø Performing BNE setup -- for PLM
Ø Pinning concurrent programs for APS team in PCP environments
Ø Deciding the naming conventions of data file, redo log files, tablespace, and segments
Ø Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity
Ø Tracing the alert.log file for “ORA” messages, Monitoring database to ensure smooth functioning of database
Ø Installing and configuring 9iAS
Ø Installing AS 10g for integrating Ebiz-suite R12 and 11i(both Infra Tier and Mid-Tier)
Ø Installing AS 10.1.3 in windows 2000 server for DEMANTRA application deployment
Ø Integrating Ebiz with DEMANTRA for APS team
Ø Setting Profile Options (site level, User level)
Ø Configuring forms in servlet, socket modes
Ø Installing BPEL and creating domain for Ebiz instance
Ø Responsible to ensure that the environments are stable and at acceptable performance.
Ø Responsible for regular interactions with the UNIX teams to troubleshoot OS/Hardware issues
Ø Customer support over phone, OWC, customer tracking system tool
Ø Checking backup status to ensure validity
Ø Cleaning the udump, cdump, bdump directories of large core files, user dumps
Ø Allocating system storage and planning future storage requirements
Ø Taking interviews for new hires of DBA's at Oracle and Creating Training Schedule Plans for the new hires in our team
Ø Data Modeling, Database Design and Creation for team's website and internal tools
Ø Developing Internal team Website and adding new features using JSP, XML, Java Beans, JS, HTML

GE Energy, GE Country wide (Consumer Finance) July 2004 to August 2005

Position : Software Engineer
Projects : Installation and Maintenance of 11.5.10 CU2
OS : RHEL 2.1/3.0, AIX 5.0/5.1
Softwares : 9i Database, OAM, Unix Shell Scripting, Unix cron jobs
Apps : Oracle Financials
Ebiz versions : 11.5.10 CU2
Backup : Hot backup, Cold Backup

Responsibilities:

Ø Replicated production Database of size 450G
Ø Created new databases in IBM AIX operating system, File System - Raw Devices
Ø Automated DBA activities by UNIX shell scripts
Ø Performed Oracle Apps 11.5.9 System administrator tasks
Ø Responsible for Creating Setting Up Users and Assigning Responsibility in various Operating Units
Ø Verifying Approval Hierarchy
Ø Setting System and User Profile Values
Ø Interacted with users and solving their issues
Ø 24x7 support on environments
Ø Worked with ITG/Kintana (ITG-IT Governance) Team for the Integration of Oracle Application 11.5.10 with Kintana
Ø Installed Oracle Applications 11.5.10 in Linux 2.1AS and 3.0 ES Operating systems
Ø Added Custom products to the E-Biz Suite
Ø Participated in OWC with Oracle Support and solved the issue
Ø Created tablespace for custom based user data tables and indexes
Ø Creation of Database Users and Registering in Oracle Apps
Ø Created of Database links and registered them in Oracle Apps
Ø Responsible for installation of Oracle Object*Migrator in Oracle E-business suite as a Custom based applications
Ø Created custom based application top CLM_TOP, Custom Based application top and
Ø Registered Concurrent programs and applications
Ø Worked along with Developers and Users/Database Owners to ensure smooth movement
Ø Created Control files and Importing data using SQL* Loader to Interface tables
Ø Managed system configuration using autoconfig
Ø Tablespace monitoring
Ø Checking backup status to ensure validity
Ø Applying Apps and DB Patches
Ø Cloning Oracle Applications 11.5.10
Ø Creating and configuring workflow accounts
Ø Giving training to other team members and create knowledge base/documents
Ø Monitoring the environments from OAM

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-IL-Chicago »
View all resumes in US-IL »

View other Oracle Apps DBA resumes, Database Administrator resumes