SUMMARY

• Over 15 years of Information Technology experience with hands - on experience in Oracle E-Business Suite and Oracle Database (10g/11g/12c/18c) Administration providing 24x7 support for both Production and Development on various Platforms like Sun Solaris, HP-UX, IBM-AIX, Linux.
• Over 10 years as Oracle Application Administrator - Proficient in Database and Applications Administration activities such asinstallation, Upgrades, Version up, Cloning, Refreshes, Migrations, applying patches,SR support,configurations, developments, security implementations, Backup and Recovery, Performed backups and tested crash recoveries, disaster recovery system, Performance tuning, and UNIX shell scripting.
• Performed Support and maintainmulti-node e-Business Suite environment with Shared File System, managing and administering Concurrent Managers, Concurrent Programs, Request Sets, Request Groups, Workflows, and troubleshooting Workflow Mailer/Notification issues
• Oracle Real Applications Clusters (RAC) to maintain a clustered database to provide performance, scalability with Oracle Automatic Storage Management (ASM) and Oracle Cluster Ready Services (CRS)
• Oracle Recovery Manager (RMAN) and Data Guard for backup and disaster recovery.
• Experienced in Oracle Data pump (Import/Export), Oracle Streams, Golden Gate, WebLogic
• Involved in implementation and support of Oracle Financial which includes AR, AP, GL, CE, PO, OE and FA.
• Solid experience with Oracle RDBMS (10g,11g,12c,18c) running on Unix including installation, administration, troubleshooting and performance tuning.
• Involved in Oracle Application Installations and upgrades various versions (11i 11.5.10, R12.1.3, R12.2.5).
• Over 7 years as Oracle Database/Application Performance Engineer- Proficient in performance tuning usingSQL Trace / TKPROF / Explain Plan/Stat pack,ASH/AWR reports, ADDM, SQL Tuning advisor, Active Session History, SQL Performance Analyzer, Optimizer Hints and SQL Profile.
• Oracle Application Manager (OAM) and Oracle Enterprise Manager (OEM) Grid Control for proactive monitoring and performance tuning/optimization of Oracle EBS systems.
• Performed Reorganization of Tables, create/rebuild Indexes, Table Archiving/purging, checking HWM and Fragmentation, Gather the stats, optimize SQL queries, Automatic Undo Management, Grid Monitoring,adding partitions, and analyzing tables.
• Extensive Performance tuning knowledge around hints and optimizers, evaluating explain plans, indexes, different types of index scans, analyzing execution paths and recommending tuning options.
• Over 10 year of Oracle database application development experience withSQL and PL/SQLprogramming
• Hands-on experience with Oracle Forms/Reports, SQL, PL/SQL, Open Interfaces, APIs, setting up AOL Application object library, Oracle Application Administration tasks, legacy conversions, Applications customizations, Interface development, customization of existing systems, Functional and Technical Analysis and testing of new development.
• Proficient in writing stored Procedures, Packages, Triggers, Functions, Cursors using SQL & PL/SQL and Customized and developed concurrent programs, Forms and Reports.
• Experience in Distributed Multi-tier Application Development, Database Design, Data processing, Data Warehouse and Support mainly with Oracle technology on different platforms. understanding of data modeling, schema design, Data Migration and ETL processes
• Unix shell scripting for automation of day-to-day tasks like Database Health Check, cloning, patching, generating dynamic scripts to rebuilding large tables like Demantra tables.
• Over 5 years of Leadership Skills -
• Maintain an effective relationship with customers, team members and management.
• Interact with clients to understand their business operations, gathering their business requirements, Preparing SOX Compliances,project management activities including project planning, scheduling, phasing, coordinating, presentations, and workshop sessions.
• Extensive experience with both Waterfall and Agile project management methodology. understanding of ERP processes and modules in Financials, Supply Chain and Human Resources
• Worked with Oracle Support to report showstopper problems and got it resolved in time by applying a right Patch set or getting work-around.

TECHNICAL SKILLS

Hardware: IBM, PCs, Sun Sparc Server, Sun Ultra 5, VMware, VirtualBox

Operating Systems: UNIX (Sun Solaris 2.6, HP-UX10.1, IBM -AIX)Red Hat Linux, Oracle Enterprise Linux, Windows NT, MS-DOS

RDBMS: Oracle 10g/11gR2/12c/18c INGRES 6.x, (SQL, PL/SQL, SQL*PLUS)

ERP: Oracle E-Business Suite (11.5.10, R12.1.3, R12.2.5)

Applications Server: Oracle IAS (10g,11g), Apache Server, Oracle Web Logic, Fusion Middleware, appWorx

Developer Tools: Oracle Developer, Discoverer, Designer, Forms, Reports, BI publisher, Actuate, Workflow, Webadi, SQL loader, Apex

Monitoring: Oracle Enterprise Manager (OEM), Oracle Application Manager (OAM), Oculus, AOL

Replication: Shareplex, Oracle Streams, Data Guard, Golden gate, GGSCI

Performance: Explain Plan, Stat pack, Exp/Imp Data pump, RMAN, SQL Trace, TKPROF, AWR, ADDM, ASH, SQL Performance Analyzer, SQL tuning advisor, SQL Access Advisor

Other Utilities: PL/SQL Developer, SQL Developer, SQL programmer, SQL Monitor, SQL navigator, TOAD

Management Tools: JIRA, PVCS, VSS, Clear Case, Clear Quest, Object Cycle, HP quality center, Service Now, Service Desk, Bitbucket, Sprint

Languages: Pro*C, C, C++, Java, Java script, Perl, Shell script, HTML, SQL, PL/SQL

MS PC applications: MS Project, MS Word, MS Excel, MS Web server (ASP)

PROFESSIONAL EXPERIENCE

Confidential, Broomfield, CO

Oracle Database/Application Performance Engineer

Responsibilities:

• Perform day- to-day system administration tasks and DBA activities using oracle utilities and tools.
• Provide technical leadership to optimize large multi-tier system, Mentoring and Training offshore engineers.
• Provide in-depth performance tuning support during various stages using SQL Trace/TKPROF/Explain plan/AWR Reports, SQL-Tuning advisor, Active session History, oracle Hints and creation of new indexes to improve performance of SQL statements.
• Performance analysis and tuning, index maintenance and monitoring fragmentation and tablespace growth.
• Rebuild tables and Indexes, optimize queries, and perform PL/SQL code profiling.
• Developed and implement policies and procedures for ensuring the security and integrity of the database.
• Identify application bottlenecks and assist engineers with improving application performance and reducing latency.
• Define a strategy for proactively monitoring performance of production database environments.
• Proactively identify future Memory/Tablespace requirements, performance tuning issues and Time/CPU consuming SQL Queries.
• Perform root cause analysis on failures and resolve performance tuning related issues and queries.
• Monitoring performance of production database environments and support to resolve production issues.
• Resolve performance related JIRA and CA tickets for production and non-production issues.
• Analyze oracle EBS Concurrent program request log, ASH report for top long running/aborted concurrent programs and provide solutions.
• Extensively worked with Forms, reports, PL/SQL packages, functions, procedures, triggers, & performance tuning
• Automated rebuilding large tables with dynamic PL/SQL scripts, Packages, and procedures.
• Demantra Table weekly/monthly Maintenance like Verify fragmentation of DM tables, Chained percentage, cluster Factor, generate dynamic scripts for rebuild tables and Gather stats, purge older records as per request. Create report before and after Reorg and resolve performance issues related to DM tables.
• Hand on experience in Oracle EBS, Purchasing, i-Procurement, i-Expenses, Payables, Cash Management and General Ledger, Order Management, Inventory and Planning,Supply Chain Management, Sales Workbench, Data Warehouse.

Confidential, Dallas, TX

Oracle Application Developer/Administrator

Responsibilities:

• Handling day-to-day System Administration tasks and DBA activities using Oracle utilities and tools.
• Implementation and version up of Oracle Application, Database Refresh, Applications Cloning, Migrating Databases and applications, Merging Application Multi-node to single node, Platform Migration Using Transportable Database, Perform SQL tuning and database performance Turning, Install and configure Application Server (9iAS/10gAS), Configure and Troubleshoot problems with Apache, JVM and Jserv processes.
• Worked on oracle Import/Export utility, Stats packs report, AWR report, ADDM advisors, auto trace and execution plan, RMAN backup/restores, Oracle 11g Data pump, OAR, Data Guard, Oracle Streams, OEM Grid Control, RAC, ASM, Performing Flashback, Share plex and Golden gate, disaster recovery system.
• Installed and configured Oracle Software/patches and create 3-way advanced replication, Oracle Streams, Golden gate on Linux, HP- UX, AIX environments.
• Developed Unix shell scripts and SQL scripts to carry out routine health check of databases.
• Writing stored Procedures, Packages, Triggers, Functions, Cursors using SQL & PL/SQL and Customized and developed concurrent programs, Forms and Reports.
• Worked with Oracle Support to report showstopper problems and got it resolved in time by applying a right Patch set or getting work-around.
• Setting up AOL, maintaining concurrent manager, Registration/Migration of Programs, executables, forms and reports, creation of users, responsibilities, menus, values set, document sets, request sets, functions, report groups and printer types/styles/drivers in Oracle Applications.