Resume of Oracle Applications DBA/Developer

Title
Oracle Applications DBA/Developer

Primary Skills
Oracle Application and Database Administration experience on variety of Database versions

Location
US-NJ-Metuchen

Posted
Sep-10-07



Successful and Experienced IT Professional seeking challenging position in Oracle Administration.

JOB SUMMARY

* More than 6 years of Oracle Application and Database Administration experience on variety of Database versions 7,8i,9i,10g on unix (Solaris, HP-UX, AIX), Linux, Windows NT 4.0/2000 with HRMS, (HR, Payroll), Financials(AP,AR,GL,FA), Order Management, Compensation, modules using Apps (11.5.8, 11.5.9, 11.5.10), Oracle Application Server 9iAS, Developer 2000 6i (Forms 6i and Reports 6i, Net8, Sql*Plus, PL/SQL, Stored Procedures, DB Triggers etc.

* Experience in Oracle Applications 11i Installations, configuration, Cloning, Security, Patching, Upgrades, Maintenance using AD and other utilities.

* Extensive use of 10G Oracle Enterprise Manager (OEM) and Oracle Applications Manager (OAM) for Performance, Administration and Maintenance of Databases and e-Business Components.

* Experience in setting up SOX controls on the ERP system from technical perspective.

* Managed DSS (Decision Support System) and OLTP (On Line Transaction Processing system) full life cycle projects with about 10 databases at one time, biggest database around 800 GBytes (800GB) supporting both production developments on Unix and Windows NT/Windows 2000.

* Oracle Server Installations/Upgrades, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Security Administration, Data Architecting, normalization/de-normalization, Data Warehousing, Multithread Servers, Distributed Databases for Oracle 8i/9i Databases, table partitioning and Oracle Standby Server.

* Expert in packages Oracle Enterprise Manager, TOAD, SQL Navigator, RMAN, Apache, HTML, RMAN, Schema Manager. Working in environments constituting iAS, Oracle Self Service Web Applications, XML, Discoverer (3.x, 4i).

* Specialization in Administration of Oracle Database, Data Warehouse, Reporting tools, Data Modeling and Data Architecture.

* Representing the DBA group on Projects from planning Stage to the Go-Live stage, meeting expectations and deadlines.

* Highly efficient and experienced working in huge environments across multiple team (Development, Functional and Business) and at the same time, maintaining a satisfactory relationship.

* Working pro-actively with Unix Support, Web Group and Migrations Team to make sure all operating system and migrations issue are addressed in a timely passion.

* Proactively engaged in research and investigation of new features for database and the application level.

SKILLS

RDBMS: Oracle 10g, 9i, 8i, MS Access
RDBMS Tools: Oracle Enterprise Manager (OEM), SQL*Loader, Oracle Schema Manager, RMAN, Space Manager, Net 8, SQL Trace, TKPROF, Stats Pack, TOAD, SQL Navigator
Applications: Oracle 10.7, 11.0.3, 11.5.8, 11.5.9, 11.5.10, 11.5.10.2 9iAS, Forms6i, Oracle Application Manager, Oracle Webserver
Operating System: Sun Solaris, HP-UX, Windows NT4.0/2000, Citrix, Veritas Clusters
Hardware: Sun Sparc E6500, HP9000, Compaq, EMC
Languages: SQL*Plus, PL/SQL, C, Pro*C, Cron Processes, Unix Shell Scripting, csh, ksh, HTML, XML
Software Tools: Apache, IAS, 9iAS, Oracle Portal, Oracle Internet Directory, Developer 2000 (Forms6i, Report6i), TOAD

PROJECT EXPERIENCE

Oracle Applications DBA/Oracle DBA August 2006 - Present
Xerox, Wilsonville OR

Project: Installation, Setup, Implementation and maintenance of Oracle Application 11.5.10 including 9iAs 1.0.2.2, Oracle 9i, 8.0.6, Oracle Enterprise Manager, RMAN, Code migration & management, Cloning Oracle Applications. Production Support of Financial System, Migration of Oracle Application production from Single node to multinode architecture
Software: Oracle Application 11i (11.5.10), Oracle (8.0.6/9i, 10g), Unix Shell Scripting, Form 6i, CRON jobs, TOAD, Quest Spotlight, ADI (Application Desktop Interface)
Hardware: Sun 4800, Sun 3960 (T3 drives)
OS Sun Solaris 2.9
Environment: Sun Solaris 2.9, 10 oracle Financial Instances including development, test, patch and production.
DB Size: 700+ GB, Users: 450

? Managing 100+ databases.
? Providing Production support (24*7) and troubleshooting user (remedy) tickets in Production, Test and Development instances.
? Upgraded Oracle Applications from 11.5.8 to 11.5.10
? More than 6+ Database migrations from Oracle 8i to 9i and 10g.
? Experienced with Shared Appl Top
? Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data.
? Expertise in Concurrent managers and monitoring of the concurrent manager operations.
? Highly experienced in Investigating performance issues for Oracle Applications(Concurrent Program/Reports)
? Troubleshooting Apps components like Forms, Apache and Concurrent Managers.
? Recompiling and maintenance of forms, report with Adadmin and from command line.
? Exposure to Oracle Application tools and ad ulitlities like adpatch, adadmin, adconfig, adctrl etc. for the management and maintenance of Applications.
? Application user creation / responsibilities assignment, applying minipacks, maintenance pack, family pack and one-off patches.
? Managing Workflow and its components through OAM.
? Highly experience in Clone of Oracle application environment using Rapid clone and adconfig.
? Copy/clone of RDBMS oracle home
? Database Refresh/clone doing complete/incomplete recovery using cold and hot backups.
? Scheduling and studying Statspack/AWR report and taking corrective action.
? Implemented Dataguard for production system incase of a disaster recovery.
? Managing and maintening hot, cold and RMAN backups for disaster recovery and making sure the mean-time to recover is as low as possible.
? Installation and maintenance of the intelligent agent on multiple servers for leveraging the monitoring ability of Oracle Enterprise Manager.
? Knowledge of Dataguard/Standby database.
? Upgraded the OMS from 10.2.0.* to 10.2.0.3.
? Upgraded the Agent from 10.2.0.* to 10.2.0.3.
? Configuring OEM to monitor targets.
? Handling data mirror and its services/components
? Applied RDBMS, CPU/Quarterly patches using Opatch.
? Experience in Oracle RDBMS software installations.
? Solve Locking issues at Database/ Apps level.
? Set up auditing and study the audit trail tables.
? Monitoring and troubleshooting top cpu/memory consuming processes
? Performance Tuning, Memory (SGA) Tuning, etc
? Maintaining Hit ratios of Oracle Database for optimal performance
? Identifying top sqls/sessions and tunning.
? Monitor alert logs, OEM and system alerts, acting on the results.
? Tracing Concurrent requests, forms, database session.
? Managing Tablespaces and Datafiles
? Gather stats using DBMS stats and FND stats to improve performance.
? Setting up profiles for users.
? Configuring listeners with password.
? Created a number of database instances for development, testing and production.
? Created and managed the Database objects and schemas
? Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
? Configure new Printers at Apps level.
? Configuring Java on a 8.1.7 database.


Oracle Applications DBA/Oracle DBA August 2003 - July 2006
Dell Financial Services, Austin TX

Project: Installation, Setup, Implementation and maintenance of Oracle Application 11.0.3, 11.5.9, 11.5.8 including 9iAs 1.0.2.2.x, Oracle 9i, 8i, 8.0.6 Oracle Enterprise Manager, RMAN, enabling Multilanguage support, autoconfig, Cloning Oracle Applications. Production support, single node to multimode migration, installation and configuration of Oracle Discoverer 4.1.48, Installation and maintainance of datawarehouse databases running on oracle 9i.

Software: Oracle Application 11i (11.5.9, 11, 5, 8), Oracle (8.0.6/8i, 9i), Unix Shell Scripting, Perl, SQL Scripting, Form 6i, CRON jobs, TOAD
Hardware: Sun 4800, Sun 3960 (T3 drives)
OS Sun Solaris 2.8, Windows NT/2000
Environment: Windows NT/2000, Sun Solaris 2.8, 8 Oracle Financial Instances including development, test, patch and production, datawarehouse instances running on 9i databases using Informatica (ETL).

DB Size: 500+ GB , Users: 700

Responsibilities:
? Complete cycle of implementing, setup and support of Oracle application 11i.
? Patching Oracle application. Including applying maintenance patch for AR modules.
? Creating users, assigning responsibilities, Managing Concurrent processing, data auditing.
? Using AD utilities viz. adadmin, adpatch, adctrl etc to manage Oracle Application.
? Installation of Oracle Application 11i (11.5.9, 11.5.8).
? Managing Workflow and its components.
? Configuring Oracle Application Manager.
? Configured AUTOCONFIG for handling customizations.
? Implementing customized AUTOCONFIG for custom variables and custom folders.
? Configuring ORACLE Process, Parameters & Multithreading.
? Moving development and testing codes to various instances and testing them.
? Optimising resource utilization in the existing servers.
? Cloning Oracle Applications with rapid clone for development and testing and incorporating customizations. Using autoconfig to configure Oracle Applications.
? Setting up user to login to apps. Jinitiator Install and configurations.
? Tuning Oracle server along with Operating System to obtain optimal performance.
? Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
? Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
? Backup & Restore on-line and off-line backup planning, procedure, exp/imp, restores process.
? Tuning performance monitoring and tuning, Optimization, Parameters, Tuning Issues, Bitmap indexes, Hash Joins.
? Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.
? Cloning databases.
? Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security
? Taking Hot and Cold Backups, Exports, FTP etc.
? Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
? Applying minipacks
? Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).
? Writing Unix shell scripts for backup and recovery, Import and export procedure.
? Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
? Defragmentation of database using export import.
? Removing row chaining, row migratation for better performance.



Oracle DBA
Intouch Solutions Pvt. Ltd.
New Delhi, India March 2002 - June 2003


Project: Installation, Setup, Maintenance and Upgrade of Oracle Server 8i, Oracle Enterprise Manager, Space Manager, RMAN, CITRIX
Hardware: HP9000
Operating System: HP-UX 11.0
Environment: Windows NT/2000, HP-UX 11.0, Veritas, Quick IO
Software: Oracle 8i, Pro*C, C, Unix Shell Scripting, Perl, SQL Scripting, Forms 4.5, UNIX CRON jobs, Oracle Application Object Library (AOL), TOAD
Database Size: Up to Size # 250 GB, Users- 175

Responsibilities

? Software Development and Testing.
? Installation, Upgrade and Configuration of Oracle 8i.
? Installing and configuring Recovery Manager (RMAN).
? Extensive Performance Tuning, Memory (SGA) Tuning, Tuning Concurrent Managers, etc.
? Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.
? Applying patches both Server side and Client side.
? Setting up new environments (Development, Production etc)
? Designed standby database model for disaster recovery.
? Taking Hot and Cold Backups, Exports etc.
? Setting up and Installing Oracle Web Application Server
? Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
? Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
? Data Modelling, Database Design and Creation of Data Warehouse.
? Unix Shell scripting in csh, ksh for automating startup/shutdown of databases.
? Monitor disk usage and expand and/or move datafiles as needed.
? Disaster Recovery drills.
? Identify run away sessions occupying more cpu.
? Create/Refresh and upgrade databases.
? Kill processes due to locks.
? Compile invalid objects and create database links.
? Gather Statstics at database/schema level.
? Apply Databases CPU patches.
? Monitor backups.


Oracle DBA
Hero Ites, Gurgaon, India July 2001 - March 2002

Project Areas: Financial Systems and Payroll, HR
Environment: HP-9000, ORACLE 7.0, ksh, csh, PL/SQL, SQL*PLUS, Forms 2.3, Reports
Responsibilities:
? Tuning Oracle server along with Operating System to obtain optimal performance.
? Devised tuning strategies & scheduled for optimal performance.
? Tune Oracle memory (Shared Pool, Library Cache, Data Buffer Cache).
? Tuning Application & SQL using Explain Plan, SQL Trace utility & TKPROF.
? Maintain & Tune Redo Logs & Archiving for DSS & OLTP Systems.
? Study Oracle Parameters and tune it appropriately to obtain and high performance Oracle Database.
? Developed E-R and data flow diagrams.
? Performed Data Modeling and architecture of the data warehouse.
? Developed several stored procedures.
? Creation of database, tables, users, roles in Oracle7.0.
? Development of reports in Pro*C and ReportWriter 2.0 Security administration i.e. managing privileges and roles
? Backups and Recovery i.e. exports/imports, hot archive log backups, cold offline backups, etc
? Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints
? Space Management which includes table space creation, adding new datafiles,
? Creating rollback segments, etc. Shell Scripting in csh and ksh
? Managing Very Large database management, Partitioning, Data warehousing requirements, Index and Cluster Partitioning, RAID.
? User management, Privileges, Roles, Auditing, Profiling, Authentication
? Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
? Maintaining Day-to-Day Activities & Data Base Maintenance.

Certifications
See above


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

View all resumes in US-NJ-Metuchen »
View all resumes in US-NJ »

View other Oracle Applications DBA/Developer resumes, Database Administrator resumes