Oracle Project Manager

Laura Nogaj

Email: *********@********.***

Address: **** **** ******** **

City: Ormond Beach

State: FL

Zip: 32176

Country: USA

Phone: 407-***-****

Skill Level: Experienced

Salary Range: $120,000

Primary Skills/Experience:

See Resume

Educational Background:

See Resume

Job History / Details:

Profile

Oracle Database Administrator/Performance Analyst with proven skills, education, and accomplishments in the following areas:

System Performance Tuning with emphasis on improving system response times from the end user perspective by optimizing SQL, Oracle mid-tier, database server, and UNIX software.

Database Management and Administration experience installing, configuring, and supporting Oracle Applications E-Business Suite and database server in high-volume, high-transaction and high-availability environments for many FORTUNE companies.

Technical Architecture Configuration and Deployment applying operational knowledge of reliable high-performance applications, designing and optimizing hardware, and data architectures while adhering to budget and organizational standards.

Professional Experience

Walt Disney World - Orlando, FL

RCG Global Services, Technical Consultant (Aug 2012 - Nov 2012)

Tune Business Objects Reports SQL code that (after being ported from DB2 to Oracle) failed to meet established SLAs. Using the Oracle Server DB diagnostic utilities as well as having access to a fully loaded performance test environment, tuned reports to meet or exceeded DB2 timings.

Benchmarked new Release 2.4 SALES application. Specifically tuned "PIN Load" process by trouble-shooting database gc buffer busy and log file sync wait events. Decreased and eliminated wait times through recommending application developers decrease number of COMMITs in their application code as well as fine tune index definitions on the application's interim staging table. Transactions/SEC (TPS)increased from ~80 to ~130.

Facilitated communication between the Application Development and DBA teams.

Office Depot - Boca Raton, FL

SDI International, Corp., Lead Oracle Database Administrator (Jan 2012 - Aug 2012)

Troubleshoot, diagnose, and repair (tune) production Oracle 11i ERP (including all third-party integrations points) application and database server performance problems by: 1.) identifying changed SQL execution plans and implementing SQL baselines, 2.) optimizing 11gR2 SQL execution plans through re-writing application SQL and PL/SQL code, adding indexes, and/or hints, 3.) archiving and purging data, and 4.) reorganizing table, index, partitions, and tablespaces. Database server configuration included a seven-node, 11gR2 RAC cluster, utilizing Oracle Partitioning.

Worked as part of the DBA project team to physically decrease production OLTP database size from >30TB to ~15TB through the use of SEGMENT on-line redefinition (DBMS_REDEFINITION) as well as DATAPUMP (expdp/impdp) to/from ASM and/or over DB Links.

Performed the migration and upgrade of client's Informatica Oracle Applications historical database server from 10gR2 Single Instance to 11gR2 RAC.

Reconfigured, re-implemented, and re-deployed Informatica Data Archive and Purge projects moving ~2 billion rows of Oracle Applications 11.5.10 Sales Order production data off tier-one storage and onto tier-two storage (~750GB of data). Tune archive/purge jobs by multi-threading JDBC Thin Client connections and tuning Oracle Parallel DML (INSERTs/DELETEs).

Documented and transitioned the Sales Order archive/purge procedures and provided POC to the client for the configuration, implementation, and deployment of Informatica Data Archive and Purge projects in an effort to move 11.5.10 GL Journals-Actuals data. Again, the estimate provided from the POC was to move ~2 billion rows off tier-one storage to tier-two (~750GB of data).

Troubleshoot, diagnose, and repair performance problems of Informatica Seamless Data Access Oracle Server views that combine OLTP and Historical Sales Order and GL data so that historical data remains available to users as needed.

American CyberSystems, Lead Oracle Database Administrator (Jan 2010 - Nov 2010)

Troubleshoot, diagnose, and recommend repairs for user complaints that ETL, Oracle Applications Forms and Batch Processing is slow and/or performance is degrading.

Key Accomplishments:

Support production High Volume Order Processing (HVOP) and AutoInvoice on a seven-node Oracle 10g RAC Cluster; each node has 32 CPUs utilizing Parallel Concurrent Processing and Manual Workload Partitioning supporting a database growth that is currently 20 Gigabytes per day.

Rectify performance issues that arise during month-end General Ledger and sub-ledger close for one of Oracle Corporation's largest Retail Firms. Tables utilizing Oracle Applications Partitioning Strategy as well as row counts include: RA_CUST_TRX_LINE_GL_DIST_ALL: 1.8 billion, RA_CUSTOMER_TRX_LINES_ALL: 1.55 billion, AR_DISTRIBUTIONS_ALL: 1.5 billion, AR_RECEIVABLE_APPLICATIONS_ALL: 1 billion, GL_IMPORT_REFERENCES: 4 billion, OE_ORDER_LINES_ALL: 500 million, MTL_ITEM_CATEGORIES: 350 million, MTL_SYSTEM_ITEMS_B: 115 million, etc. Total Production database size: 14TB.

Engineer performance tuning solutions for development staff responsible for customizing Oracle Applications Standard Financial, CRM, iReceivables, Order Entry, etc. modules leveraging the use of Oracle Forms and Reports, SQL and PL/SQL, OAFramework, and ADF sdks as well as supporting the Apps as an "endpoint" in the deployment of Oracle's SOA architecture (OID, BPEL, etc.) applications. SQL tuning techniques include: utilizing: HINTs; SQL Profiles; Stored Outlines; Custom INDEX Creation, by examining INDEX fragmentation and stale TABLE/INDEX statistics; by reverse engineering Entity Relationship Diagrams (ERDs) and making recommendations for rewriting SQL and PL/SQL code; deploying TABLE PARTITIONing/MATERIALIZED VIEW strategies combined with the usage of LOCAL, GLOBAL, and NORMAL INDEXes.

Sapphire Technologies, Lead Oracle Database Administrator (Apr 20008 - May 2008)

Troubleshoot, diagnose, and recommend repairs for user complaint that Microsoft Internet Explorer v6.x crashes when accessing an Oracle Form from a Citrix Smart Desktop Client session.

Key Accomplishments:

Upgraded the client's Oracle Forms and Oracle Discoverer environments to utilize SUN Native JRE v1.6.x rather than Oracle JInitiator 1.3.x.

Sapphire Technologies, Lead Oracle Database Administrator (Sep 2006 - Nov 2007)

Performed lead applications dba work supporting an Oracle Applications 11.5.10.2 multi-node implementation using Oracle 10g Application Server, Oracle 10g Real Application Clusters, and Automatic Storage Management.

Key Accomplishments:

Maintained and supported Oracle Discoverer technology stack and End-User Layer (EUL) 10g standalone BI implementation for use with Oracle Applications 11i.

Configured Oracle Applications as a "partner" application utilizing Oracle Single Sign-On and Oracle Internet Directory for user provisioning and password management.

Implemented Native PL/SQL compilation.

Deployed Concurrent Manager Parallel Concurrent Processing and Failover utilizing Manual Workload Partitioning in a RAC environment.

Wells Fargo Bank - HOME

Strategic Staffing Solution, Info Security Engineer 6 (Nov 2010 - Dec 2011)

Troubleshoot, diagnose, repair, and support the bank's production Oracle General Ledger and sub-ledger OLTP and data warehouse applications. Also, support the cross-platform database migration and upgrade of the GL applications from HP-UX Superdome and Oracle 9i/10gR2 to Sun Solaris M-Series and Oracle 11gR2. Ensure program runtimes meet or exceed established 9i/10g baselines.

Key Accomplishments:

Performed database audit of Peoplesoft on Oracle 10g which included reviewing and making recommendations for tuning: 1.) database initialization parameters, 2.) system, dictionary, and object statistics, 3.) AWR workload repository parameters, 4.) SYSADM schema index usage and fragmentation, and 5.) top ten worst performing SQL.

Tuned new and existing Peoplesoft production SQL code by: 1.) identifying changed SQL execution plans and implementing SQL baselines and profiles and/or changing object statistics gathering methods (e.g., removing column histograms), 2.) improving existing SQL execution plans through re-writing application SQL and PL/SQL code, adding indexes, and hints.

Benchmarked and tuned Oracle Applications 11i General Ledger batch cycle off-the-shelf and custom concurrent program SQL code as new features of the 11gR2 Cost-Based Optimizer along with CBO related database initialization parameters adversely impacted some SQL Execution Plans. Implemented benchmark tuning recommendations as steps of the migration/upgrade cutover weekend including patching the Oracle Applications Posting C code (GLPPOS) which the bank had not touched since 2000. Tables utilize Oracle Applications Partitioning Strategy. Specific row counts include: GL_JE_HEADERS: 7.8 million, GL_JE_LINES: 5.5 billion, GL_IMPORT_REFERENCES: 5.5 billion, GL_BALANCES: 1 billion, GL_DAILY_BALANCES: 400 million, etc. Total Production database size: 4TB.

Tested/implemented changing CBO costing method to CPU based rather than the 9i I/O based through the gathering of NOWORKLOAD system statistics during migration/cutover weekend (FYD application). Tested/implemented effects of lowering object statistics sampling sizes. Tested/implemented ASYNC I/O.

Rectified performance issues that arise during month-end General Ledger close for downstream data warehouse applications (FYD) that also underwent platform migration and database upgrade (9i to 11gR2). This includes reverse engineering and tuning Dynamic PL/SQL code that performs monthly table partition maintenance. Application utilizes Oracle Partitioning/Sub-Partitioning as well as BITMAP/FUNCTION-BASED BITMAP INDEXing strategies. Benchmark/recommend changing altered 9i CBO database initialization parameters to 11gR2 defaults.

Reviewed/tested/made recommendations for implementing 11g's New Automatic Memory Management taking into account the implementation of DISM verses ISM and its implications regarding swap configuration.

Mentor and document the performance tuning methods and tools required for Wells Fargo architects, developers, and DBAs to properly diagnose and tune Oracle database end-user complaints about degrading database application performance. This included instruction on how to interpret Oracle's dynamic performance views (V$) as well as interpretation and use of SQL code HINTS */, DBMS_STATS, DBMS_WORKLOAD_REPOSITORY, DBMS_XPLAN, DBMS_SETEV (to capture 10046 and 10053 traces), DBMS_SPACE, DBMS_SQLTUNE, and lastly, how

to mine the data contained in the DBA_HIST_* fixed performance views in an effort to evaluate SQL code statistics.

Obtained Oracle Education training in 11g Performance Tuning, 11g SQL Tuning, and 11g Oracle GRID Infrastructure.

TAC Worldwide, Senior Project Manager (Apr 2009 - Oct 2009)

Provide Oracle database and E-Business Suite application support and performance tuning for client's 11.5.10.2 sub-ledger modules (AP, FA, PO, INV, WMS, and CUSTOM).

Key Accomplishments:

Performance tuned the monthly Fixed Assets Depreciation Request Set by tuning Journal Entry and Tax Reserve Ledger Report SQL execution plan utilizing a "stored outline" and Profile Option: Initialization SQL Statement - Custom. Brought the report runtime down from never completing to completing in less than an hour.

Monitored Oracle Applications sub-ledger concurrent programs and documented/quantified specific SQL tuning recommendations to decrease runtime performance. Worked Oracle SRs to patch standard code and worked with Wachovia development staff to tune custom SQL.

Oracle Corporation - Redwood Shores, CA

Managing Principal Consultant (Oct 1998 - Jun 2004)

Furnished system architecture and performance tuning consulting services to Oracle's FORTUNE customers as Oracle Consulting Services projects became "at-risk." Engagements were typically post-production, high-exposure, Oracle application software installations and customization deployments that required the technical skills to rapidly identify and correct problems/bugs at all levels of the technical architecture stack.

Key Accomplishments:

Managed a team of five advanced-degreed technical professionals ensuring bill utilization levels in excess of 82% (including myself).

Hiring manager responsible for actively pursuing candidates for interviewing and hiring in order to increase consulting services headcount by 20% for the Southeast System Performance Group.

Collaborated on the "Oracle Apps on RAC" Consulting Solution Offering which was available for purchase through the Oracle Store. This offering was a lump-sum consulting engagement contract and provided the customer with two senior consultants for eight weeks who would configure a "proof-of-concept" (POC) environment using hardware provided by the customer. This program was the pre-cursor for today's implementations of Real Application Clusters with Oracle E-Business Suite and Automatic Storage Management.

Conducted technical POC of Oracle 9i Streams Advanced Queuing configuration on two, four-node, 9i RAC clusters for major, Silicon Valley, SEARCH customer. Worked directly with Oracle Development to ferret out bugs/make improvements to the Oracle Server's future 10g software release.

Performance tuned E-Business Suite Standard Open Interfaces: Auto Invoice, Payables Open Interface, Payables Approval, Transaction Import, Distribute Usage, Distribute Labor, Generate Draft Revenue, Generate Draft Invoices, Interface Expense to PA, Interface Labor to GL, and Journal Import for Oracle Corporation's largest Project Accounting customer.

Tuned Oracle Applications Advanced Supply Chain Planning module's Data Collection and Planning concurrent program SQL code and met client performance expectations of less than five hours end-to-end total runtime for a 250,000 item Enterprise Plan run. Work performed was for Oracle's largest ASCP customer, and aircraft engine manufacturer, whose end item bill-of-materials (BOM) comprised over 1,000,000 items.

Developed custom budgeting application using Oracle's Dynamic PL/SQL and DBMS_JOBS package for a major, Charlotte based, banking customer.

Rectified Oracle Financials month-end close problems on E10K for Oracle Corporation's very first Wall Street Financials Firm.

Broward County, Water and Wastewater Division - Pompano Beach, FL

Information Systems Analyst (Jan 1995 - Sep 1997)

Provided high-level solution architecture direction and input to the division director. Consolidated the division's administrative and operations standalone applications into a redundant, star topology, LAN/WAN architecture configuration. Administered the office automation budget valued at $100K/year.

Education

Florida International University - Miami, FL

Master of Science, Management Information Systems Aug 2010

Florida Atlantic University - Boca Raton, FL

Bachelor of Business Administration, Management Dec 1998

Contact this candidate