SUMMARY:

• More than seventeen years of experience in Oracle Database Designing, managing and administering multiple databases on Unix & Windows platforms.
• I have extremely good skills in requirements gathering, analysis, data modeling, design and development of commercial systems under RDBMS environment and Client Server Architecture.
• My expertise involves in installing, administrating, configuring, maintaining, tuning, upgrade and support of e - Business Suite 11i and R12. I also have experience in leading, mentoring and supporting developers and database administrators.

TECHNICAL SKILLS:

Hardware Platforms: HP-9000 series, Linux, Sun Sparc Station, Gateway ALRs

Operating Systems: HP-UX 11 & 10.20, Solaris 2.5, AIX, Windows 2003/2K/2008/2012

Languages: SQL, PL/SQL, Unix Shell scripting

Software & Utilities: 12c, 11g Grid, RMAN, 13c/12c OEM, 12c Fusion Middleware, SQL*Forms rel 4.5, Pro*C, SQL*Loader, Qwest Tools - I/Watch, SQL*LAB, Instance Monitor, Space Manager, Precise tools, Q-Diagnostics, Toad, Oracle Discoverer, Warehouse Builder, OLAP, Perl, SQL*Loader, TKPROF, Export/Import, Utlbstat & Utlestat, Statspack, AWR, Erwin

Networking: TCP/IP, SQL*Net

RDBMS: Oracle 12c, 11g, 10g, 9i, 8.x and 7.3, SQL Server 2000, Data Warehousing, ETL,Oracle Applications R12, 11.x and 11.0.3

PROFESSIONAL EXPERIENCE:

Sr. Oracle Apps

Confidential,Kollmorgen,VA

Responsibilities:

• Supporting eBusiness instances including - Production, acceptance, test and development.
• Implement RMAN and automate clone process.
• Involved in customer integration.
• Cloning, patching & troubleshooting.
• Configuring Workflow, Printers and resolving issues.
• Tuning Sql-Pl/Sqls, database, Concurrent managers and tech stack ( middle tier)
• Supported DMZ architecture for i-modules - iSupplier, iSupport, including customization.
• Support modules like General Ledger, Oracle Payables, Receivables, Inventory, Fixed Assets and Purchasing Modules; iSupport, iExpense.
• Installed and configured 12c Fusion Middleware.

Sr. Oracle Apps

Confidential,PA

• Supporting eBusiness instances including - Production, acceptance, test and development.
• Cross-platform upgrade of 11.5.8 on 9i on Solaris to 11.5.10.2, 11gR2 on Linux.
• Support R12 production instance.
• Upgraded 12.1.1 to 12.1.3.
• Installed, configured and supported R12 ASCP instances
• Involved in customer integration.
• Cloning, patching & troubleshooting.
• Configuring Workflow, Printers and resolving issues.
• Tuning Sql-Pl/Sqls, database, Concurrent managers and tech stack ( middle tier)
• Supported DMZ architecture for i-modules - iSupplier, iSupport
• Support modules like General Ledger, Oracle Payables, Receivables, Inventory, Fixed Assets and Purchasing Modules; iSupport, iExpense.
• Support ADI, Disvoverer.
• Upgraded Discoverer from 4i to 11.1
• Installed OBIEE. Support data warehouse, GRCM.
• RMAN setup and support.
• Support RAC instances.
• Standby database support using data guard.

Sr. Oracle Apps

Confidential,MittalSteel,Weirton,WV

• Supporting eBusiness instances including - Production, acceptance, test and development.
• Supported ADI, Workflow configuration and administration, applying patches using adpatch.
• Supported AR, AP, GL, OTL, OE, HR modules.
• Supported custom built based applications.
• Developed scripts to automate the cloning process.
• Configured Hot and Cold backups for production instances
• Upgraded 9i to 10g
• Migration of 8.1.7.4 Database from US7ASCII to UTF.
• Wrote script for automation of cloning processes from prod to non-prod.
• Applied patches on apps and DB level
• Involved in Printer setups, monitoring concurrent managers, Apache tuning and configurations.
• Tuning, maintaining 10g, 9i Oracle non-apps databases using statspack and Explain plan.
• Installed and configured 10g Grid control & 10gAS.

Oracle Apps

Confidential,Pittsburgh,PA

• Support e-Business suite 11.5.10 (Financial and HR modules) on Sun Solaris Platform.
• Installation, Cloning (Rapidclone), Patching of Oracle apps instances utilizing adpatch, autoconfig, admin etc.
• Configured multi-tier architecture using load balancing.
• Assist in the logical and physical designing of databases.
• Participating in 24x7 On-call production support.
• Developed Procedures, Packages, Functions, triggers and Materialized views using new functionality of 9i.
• Configure ADI, apply Vertex patches, tuning Apache server, monitor concurrent managers
• Performance tuning of Batch jobs and SQL queries, using Statspack, Explain plan, bstat/estat
• Planning Backup and Disaster recovery strategies.
• Maintenance and configuration of Oracle 11.5.10, Oracle 9i/8i, iAS, Forms server, Report server and Apache server.
• Tar Management and On-call support for 24x7 environments.
• Installation SQL server, creating database, administrating security aspects, Creating and scheduling DTS packages, schedule backups and restore databases to Pittsburgh data center.
• Configured replication and scheduled replication jobs
• Monitored scheduled jobs and provided troubleshooting efforts to fix broken jobs.
• Installed and configured Analysis services (OLAP)
• Refreshed cubes

Confidential,Chesapeake,VA

Sr. Oracle Apps

• Physical and Logical design of the database.
• Capacity planning of the tablespaces and deciding the layout of the datafiles.
• Supported database ranging from 200 GB to 500 GB.
• Provided On-call 24x7 support for production databases.
• Migrated the databases from Oracle 8i to Oracle 9i.
• Installed and Configured of Oracle 8i database on HP-UX and Win 2000 servers.
• Planned backup & tested disaster recovery scenarios.
• Fine tuned databases and SQL queries.
• Monitored the performance of databases using the OEM and Quest tools

Confidential,Reston,VA

Sr. Oracle Apps

Responsibilities:

• Designed and developed batch jobs for extraction, transformation and loading (ETL) of data from OLTP to Data Warehouse.
• Capacity planning of Oracle databases.
• Migrated the databases from Oracle 8.0 to Oracle 8.1.7
• Installed and Configured of Oracle 8i database on HP-UX and Win 2000 servers.
• Planned backup & tested disaster recovery scenarios.
• Fine tuned databases and SQL queries.
• Monitored the performance of databases using the OEM tools

Confidential

Oracle DAB/Developer

• Installed and Configured of Oracle 8.0 database on HP-UX and Win NT 4.0.
• Designed databases (Both Logical and Physical design).
• Created the Database, Tablespaces and Database Objects. Set privileges, user logins and defined Security strategy.
• Prepared program specifications, developed procedures, functions, packages & triggers.
• Provided guidelines for naming convention for Datafiles, Redo log files, Tablespaces, Rollback segments.
• Prepared Standards and Guidelines document for development.
• Conducted several in-house training sessions in Oracle, SQL and PL/SQL and Oracle Database Administration.
• SQL tuning of queries and batch jobs.
• Implemented backup and Recovery strategies for STG.
• Prepared program specifications.
• Developed Template Forms using Forms 4.5 containing common procedures and libraries.
• Developed Forms & Reports for Dealer Module.
• Testing of final code.
• Developed scripts for hot and cold backups and tested recovery scenarios.