SUMMARY:

• Over 15 years of IT Experience including 12+ years as Oracle Apps DBA (E - Business Suite) and Oracle DBA; proficient in Oracle 9i/10g/11g/12c Software installation, upgrade, Migrations, Database Capacity Planning, Automated Backup Implementation, Oracle 12c/11g/10g/9i on Unix and Windows NT platform and Oracle Financial Application 11i, 11.5.9, R12.1 and 12.2.9 Including RAC, Data Guard, Enterprise Manager Grid Control 12c.
• Highly motivated goal oriented team player with interpersonal skills
• Experience of working in 24x7 Production Environment.
• Experience in delivering complex EBS R12 implementation, upgrade. and migration projects.
• Involved in Oracle Data Guard implementation for EBS R12.
• Expert in 11i/R12 Apps Cloning, Implemented new techniques for Apps Refreshes.
• Extensive experience in applying patching, Upgrades and framework.
• Created and maintained documentation for Oracle standard operating procedures (SOP), IQs and templates.
• Involved in Oracle E-Business Suite commercial and federal 11.x,11i (from 11.5.1 to 11.5.10.2), R12.1.3 and 12.2.9 performing DBA duties, implementations and upgrades Database and application performance tuning.
• Experience in Oracle Enterprise Manager (OEM), Erwin.
• Worked mostly with but not limited to Production servers along with development and testing servers.
• Expertise in installation and configuration of Oracle Financial and large databases on Linux Operation System.
• Usage of Datapump of oracle 10g & 11g for exporting and importing logical data of the databases.
• Taking Hot and Cold backups using RMAN, along with Online and Offline backups and recovery
• Significant experience in using the RMAN and Flashback technologies for backup and recovery purposes.
• Proficient in use of Oracle Tools such as AD Utilities, SQL*Plus, SQL*Loader, SQL*Net and Enterprise Manager and utilize data warehouse planning and management knowledge.
• Involved in multiple projects that required installing, upgrading and quarterly patching with the help of Opatch utility for the databases assigned under my applications.
• Experienced in taking cumulative and Incremental backups.
• Extensive experience in handled data migrations with the aid of expdp, impdp and RMAN utilities.
• Dealt with performance issues in previous projects, which involved managing the size of table spaces, redo log files and archived redo log files according to the production environment.
• Successfully delivered resolution ideas for critical database conflicts involving user roles and privileges, database network connectivity etc.
• Strong experience in creating user, roles, privileges, accounts and profiles in the database .
• Authoritative grasp on Oracle database architecture.
• Experienced in upgrading Oracle databases from from 10g to 11g and 11g to 12c.
• Experienced in upgrading Oracle Financial Applications 10.7 to 11.5.10, 11i to 11.5.9. and 12.1.3 to 12.2.9.
• Technical knowledge of AP, AR, GL, HR, PO, INV, iProcurement, OPM and Purchasing.
• Experienced in effectively troubleshooting issues concerning network problems, instance startups, taking backups and recovering database files etc.
• Worked with PL/SQL procedures, cursors, functions, triggers, varrays.
• Excellent communication skills, a good team player and punctual in meeting project deadlines.
• Worked on multi platforms AIX, HP-UNIX, Sun Solaris, Windows.
• Manage RAC environment for Day to Day Database administration, Performance Tuning.
• Experience with BMC Patrol.

TECHNICAL SKILLS:

Hardware Platform: SUN Sparc Series, HP9000, IBM, Pentium Servers and various PC.

Operating systems: Red Hat Linux, Unix (SUN Sparc Solaris 2.6/2.7/2.8,9, HP-UX 9.x, AIX 4.3, 5.1, 5.2, 5.3)

Windows XP/2000/NT/98:

Languages: SQL, PL/SQL, UNIX shell programming.

ERP Modules: HR, Inventory, Payable, Receivable, GL, Purchasing, iProcurement and CRM.

RDBMS: Oracle 9i, 10g, 11g Servers, SQL Server.

Tools: / Utilities ER Win, RMAN, BMC Patrol, OEM, Export/Import utility, expdp/impdp, SQL Developer, SQL *, ADI, MS Office, WINSCP/PUTTY(UNIX), VMware Tools. Loader, ADI, PCP, Alerts,MS Office, TKPROF,WINSCP/PUTTY(UNIX),VMware Tools

Software: Oracle Web Server, Oracle form Server, Oracle report, EMC.

PROFESSIONAL EXPENIENCE:

Confidential, Indianapolis

Oracle Apps DBA

Responsibilities:

• Installation, Administration, and maintaining Production Apps R12 instances.
• Patching using adop and Administration.
• Cloning of 11i/R12 Applications on multi node.
• Administration by using AD Utilities.
• Managing concurrent managers- ensure system is running smooth, monitoring throughput, watch for long runners.
• Analysis and Application of quarterly CPU Patches in TEST, DEV, and PROD instances.
• Setup new Data Guard Environments, Manage and Monitoring and troubleshooting to resolve the issues.
• Scheduled daily/weekly Application backups through cron jobs.
• Upgrade Oracle Applications from R12.1.3 to R12.2.9 and database 11.2.0.4 to 19.0.0.0.

Confidential, NJ

Oracle Apps DBA

Responsibilities:

• Installed and configured R12 application in a multi node environment with application Load Balancing.
• Performed test upgrade of Oracle Applications from R12.1.3 to R12.2.6.
• Created and maintained documentation for Apps DBA and Data Guard standard operating procedures (SOP), IQs and templates.
• Created processes and tools to ensure consistent application, evaluation and use of architecture best practice.
• Perform DBA task such as Database Administration on Oracle 9i,10g, 11g and 12c environments,
• Performance tuning, Schema creation, maintenance, and trouble shooting.
• Resolves database performance issues, database capacity issues, backup, and other distributed data issues.
• Setup and manage RAC environments for our customers, Monitor, recommend and implement changes to database applications ensuring satisfactory end-user response time with reliable database connectivity. Implement physical database changes, and performance reports.
• Maintain Oracle SQL and Unix shell scripts, debugging and tuning.
• Ability to pro-actively understand and manage end user/customer expectations
• Provide best practice on new technology and implementations.
• Provides expertise and makes recommendations for physical database design, testing, performance tuning, and implementation of DB.
• Performance issues (track and trend overall database performance and database area, index, and drive performance).
• Great experience applying patches and performing DB Migrations.
• Plan and Design Backup/Recovery solution using Shell scripting and RMAN. E nsure that the database software infrastructure is in place and up to date to support other infrastructure components (e.g., operating system and hardware) and application development.

Confidential, IL

Oracle Apps DBA

Responsibilities:

• Participated as Oracle Apps consultant and led a project team.
• Worked closely with client team to discuss the solution architecture and to discussed future growth requirements.
• Experience on patch analysis of application patches including rollup patch, maintenance patch, and one-off patch.
• Resolve the issue of concurrent requests, TAR support, Apache and Forms issues.
• Upgrade Oracle Applications 10.7 to 11.5.10, 11i to 11.5.9 - migrate from windows to linux.
• Migrated all Oracle 9i and 10g databases to 11gr2. Platforms include Windows, Linux, AIX, Solaris and Hp-UX sitanium. Setup RMAN solutions for all Oracle Databases - created rman repository, wrote scripts for backup, integrated rman with OEM and GRID, provided best practices, optimizations and data guard and cloning techniques - restore and recovery. Recommend best practices for partitioning, scalability and monitoring.
• Performed tasks in administration of databases including capacity planning, instance creation, performance tuning, storage management, backup and recovery and general troubleshooting.
• Configured shell scripts for job/process automation.

Confidential, Humble, Texas

Oracle Apps DBA

Responsibilities:

• Performed Multi Node installation and Administration of EBS R12.1.1.
• Oracle EBS Database Administrator was responsible for numerous implementations and upgrades.
• Setup RMAN solutions for all Oracle Databases - created rman repository, wrote scripts for backup, integrated rman with OEM and GRID, provided best practices, optimizations and data guard and cloning techniques - restore and recovery.
• Recommend best practices for partitioning, scalability and monitoring.
• Served as Technical for Oracle 10g iAS environment consisting of Oracle core technologies including Oracle Portal, Oracle Application Server 10.1.2.3 and 10.1.3.

Confidential, Dearborn, MI

Oracle DBA

Responsibilities:

• Upgrading database to Oracle 11.2.0.2 from Oracle 10.2.0.2. Creating, configuring both standalone & RAC databases.
• Installation, configuration of grid including ASM to provide shared storage to RAC databases.
• ASM administration including creating disk group, adding, dropping disks.
• Worked in 24x7 production environment and provide on-call and day-to-day support.
• Backup and recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via shell scripting.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Helped team to use existing infrastructure to achieve Maximum benefit to reduce cost and maximum performance.
• Changes were made dynamically whenever possible to fulfill high-availability requirements.
• Enforced need of regular data purging processes from production, design and fail-over purposes.
• Installation of RAC and Managing RAC Environment efficiently.
• Proficient in RAC Performance Tuning. Implementing and maintaining security (create and maintain users, role and assign privileges).
• Database tuning, application Tuning & performance monitoring.
• Fine tuning Initialization parameters, I/O, Memory.
• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible.
• Reorganized tables and indexes within databases when needed.
• Monitored the production Oracle alert logs for database errors.
• Monitored system resource availability and responded to system memory and data issues.