PROFESSIONAL SUMMARY:

• 14+ years of IT Experience as Oracle DBA and Oracle Apps developer
• Implemented Oracle Exadata quarter rack in production and standby site
• Tune Oracle database and Exadata for 11g R2
• Expertise in Implementation and managing of High Availability solutions likeOracleRAC, Data Guard
• Performed numerous Application and Database tuning assignments on Oracle Applications, legacy, custom and third party systems.
• Performed physical/logical design, development, installation, configuration Table Partitioning.
• Administration of teh Oracle Databases. Backup strategies, Design, Optimization and Monitoring.
• Migrated Single Instance database to Multi - node 11g RAC environment for high availability and load balancing.
• Design teh backup strategy using RMAN and manual backup.
• Performed database performance tuning activities using tools like AWR/ADDM reports, TKPROF, Active Session History Reports and SQL tuning advisors
• Developed customized Reports, Alerts and PL/SQL packages to meet custom business requirements.
• Responsible for supporting 1000+ customizations in Oracle Application 12.1.3. Teh customized objects include Reports, PL/SQL, Forms, Alerts, and Workflow etc.
• Data conversion from legacy systems into Oracle Application.
• Installed and patched R12.1.2 instances, which include multi-languages.
• Installed new modules like Oracle HRMS, Oracle Quoting, Oracle MWA
• Installed and configured Oracle Business Intelligence Enterprise Edition (OBIEE) for reporting.
• Displayed a high order of dedication, commitment and professional excellence, which made way for a smooth, timely & quality delivery of several projects.
• Extensively worked on Performance Tuning /Optimization of various reports, SQL’s etc.
• Provided 24*7 support of multiple databases and systems single handily
• Thorough know-how of application user setup, defining responsibilities values sets, flex fields and request groups, registering applications, menus, forms, reports, concurrent programs and providing support to apps users for any technical and functional issues.
• Strong technical background and excellent interpersonal skills wif an ability to interact wif individuals at all levels
• Shown Excellent Problem Solving Analytical Skills and Technical Skills by quickly understanding and resolving customer issues in Oracle databases, Oracle EBS, Oracle Exadata, Oracle Discoverer and OBIEE

TECHNICAL SKILLS:

Database: Oracle 8i, 9i, 10g, 11g, 12c and Oracle EXADATA

Oracle Applications: 11.5.9, 11.5.10.2, 12.1.3

Application Server: Oracle Application server 10g, WebLogic Server

Modules: Order Management, Inventory, Purchasing, System Administration, CRM (Sales Offline).

Oracle Apps Dev. Tools: Oracle BI discoverer, Oracle Portal, SQL, PL SQL, SQL Loader, HTML, Java Scripts, OBIEE

OS & Hardware: WINDOWS, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Oracle DBA

Responsibilities:

• Implemented Oracle Grid and Oracle Database 11gR2 and 12c
• Troubleshooting multiple Performance and tuning issue related to Database and SQL
• Implemented OEM 12c wif load balancing
• Uninstall Oracle standard components like XDB, SYSMAN, CTXSYS
• Optimized Oracle databases and queries using OEM, SQL trace
• Implemented Listener poison fix on 11gR2 RAC and non-RAC
• Data Guard setup using Data Broker

Environnent: Oracle Database 11gR2 and 12c, Linux

Confidential, Manchester, NH

Oracle Application DBA

Responsibilities:

• Implemented Oracle HR module and migrated data from legacy to Oracle HR
• Upgraded Oracle Application 11.5.9 to Oracle Application 11.5.10.2
• Upgraded Oracle database 9i to Oracle database 10g
• Implemented Oracle Exadata and migrated database from 10gR2 to 11gR2
• Installed and configured OBIEE for reporting
• Patching of Oracle Exadata machine
• Implemented Oracle standby site using Oracle data Guard
• Implemented Oracle Warehouse module for easy and fast shipping operations
• Installed Spanish and Simplified Chinese languages in Oracle EBS to support Confidential . sister companies
• Regularly Cloning production environment to test environment for better testing process
• Apply latest ATG and RUP patches for all Oracle module to keep Oracle EBS up-to-date
• Installation of Loftware labeling tool for Oracle WMS application labeling printing
• Perform Oracle Application system administrative tasks like User creation, Responsibility creation and changes, Concurrent manager administration etc.
• Support and Maintenance of Oracle BI discoverer and portal
• Meeting users' access requirements and resolving their problems.
• Setup an Oracle disaster recovery site for point in time recovery
• Migrated database and EBS application from HP-UX to Linux

Environnent: Oracle Application 11.5.10.2, Oracle Applications Release 12.1.3, Oracle 11gr2, Oracle 10gr2, Oracle EXADATA, Oracle Application Server 10g, Oracle BI Discoverer, OBIEE, Windows, HP-UX, Linux

Confidential

Oracle Applications DBA

Responsibilities:

• Responsible to maintaining Oracle Applications, monitoring database performance, apply necessary patches to keep system up 24*7
• Installed, configured and administered Oracle Application 11i
• Cloning using Rapidclone, Autoconfig and adclone utility
• Very well versed in Rapid Install, AdPatch, Adadmin, adsplice, adlicmgr and Adctrl utilities for Oracle Applications.
• Very well experienced in using Oracle Server Utilities like SVRMGR, Export, Import, and SQL Loader
• Mapping out teh 'conceptual design' for a planned database in outline.
• Considering both 'back end' organization of data and 'front end' accessibility for end users.
• Uses tuning tools to improve teh database performance
• Perform Oracle Application system administrative tasks like User creation, Responsibility creation and changes, Concurrent manager administration etc.
• Installed New module like HRMS, Quoting, MWA on existing Oracle Application 11.5.9
• Ensuring dat storage, archiving, backup and recovery procedures are functioning correctly.

Environnent: Oracle 9i, Oracle 10g, SQL, Oracle Applications 11.5.7, Oracle Application Server 10g, Oracle BI Discoverer, HP-UX, Linux

Confidential, Milpitas, CA

Onsite Coordinator/Technical Team Lead/Programmer/DBA

Responsibilities:

• Responsible for supporting customized object across all modules, which includes reports, forms, alerts, interfaces, workflows, shell scripts etc.
• Responsible for monitoring and resolving all teh performance related issue related to database and Doing hot backups
• Periodically monitoring Database metrics through SQL queries
• Database User creation and maintenance, storage monitoring
• Analysis of teh issue, try to reproduce it, fix teh issue, create test script, test teh fix and deliver teh patch for teh fix
• Development of Alerts based on client requirement.
• Performance tuning of alerts, reports and PLSQL Using SQL hints.
• Writing Oracle (9i) Packages, Procedures, Functions and Triggers using Oracle's PL/SQL Structures to enforce business rules and/or relationships uncovered in teh data model.
• Creating tables, indexes, views and triggers.
• Creation of Bug and Patch using Oracle standard process (ARU, Adpatch)
• System Administrator tasks in Oracle Application
• Code Compliance Review for new enhancement
• Requirement Gathering and Analysis.
• Estimation of tasks and scheduling.
• Task prioritization and delegation to team members.
• Task monitoring and status reporting of teh allocated tasks.
• Resolving technical queries of team members.
• Eliciting functional queries to Business

Environnent: Oracle 9i, SQL, Oracle Applications 11.5.7, Windows 2000, UNIX

Confidential

Oracle Database Administrator

Responsibilities:

• Setup, installed, configured Oracle 9i database on Linux server as per requirements
• Migrated data from Oracle 8i to Oracle 9i Using export and import utility
• SQL statement analysis and tuning
• Storage analysis and allocation
• Online index rebuilds and storage recovery
• Automated teh database backup using shell script
• Developed a script in PL/SQL, which acquires data from database using different queries related to processes like DBWR, LGWR, ARCH, as well as memories like System Global Area, Roll Back Segments, and Memory Structures.
• Developed triggers, store procedures, functions, shell script to support existing system.

Environnent: Oracle 9i, J-developer 10g, Windows 2000, UNIX, Linux.

Confidential

Oracle Database Administrator

Responsibilities:

• Setup, installed, configured Oracle 8i database on Window Server as per requirements
• Migrated data from legacy to Oracle using flat files (SQL Loader).
• Scheduled daily cold backup.
• Created SQL reports using PL/SQL
• Addressed teh issue of net80 and performance of teh database
• Faculty in teh subjects of Basic Electronics, Basic Electrical Engineering, Linear Electronics, Network Analysis and Electronics & Communication from 1st to 5th semester.
• Prepared and graded exams, conducted labs and evaluated projects for undergraduates.
• Chief Time Table Coordinator of teh entire institute, responsible for Inventory Control of teh Dept., contributor to teh ISO- Coordination activity of teh Dept.

Environnent: Oracle 9i, Windows 2000, UNIX