SUMMARY:

• 19 years in all levels of Oracle Database Support, from front line to Advanced Resolution, to Bug Diagnostics and Escalations (BDE). 22 years total at Oracle.
• Founding and active member of the Oracle BOL (Business Online Team), which later became Oracle Cloud.
• Managed several hundred DBA - teams through their toughest crises.
• Experience with Amazon Web Services.
• Under tremendous time pressure, brought over 1,000 damaged Oracle production databases over 100 platforms into Oracle’s test center, patched their damaged data dictionaries, fixed corrupt blocks and sent them back to customers where every second counted.
• Will successfully complete migrations where months of preparation and experimenting is available.
• Solved over 400 highly escalated cases with a 100% success rate .
• Most of those cases were mishandled by certified Oracle professionals, Oracle’s database developers and other Oracle Senior Support reps.
• Conducted a technical audit for the system architecture for most cases.
• Wrote several hundred reports that customer and Oracle executives relied upon.
• Oracle EBS implementation, by analyzing the failures that took place for the exec and legal teams.
• Stopped the monetary losses at $13 million in 2011, while being there for only 4 months, and stabilized the system. Departed the project when recommendations were not followed, and their damages in 2012 and 2013 multiplied to $116 million in 2012 and $233 million in 2013.
• Upon seeing the evidence, the biggest defendant settled by paying an undisclosed sum. The other defendants insisted to have the case in arbitration ( ).
• Exceeded Oracle Support’s desired customer satisfaction level by 15 points. Received 95% customer satisfaction rating from over 30 customer surveys.
• Diagnosed many problems at Oracle in a few days, sometimes within hours, where up to 45 engineers, DBA’s and developers had failed to find a solution for up to 6 months.
• As a salesrep, successfully achieved the $1 million / year quota when Oracle revenues doubled from $500 million to $1 billion. Did so with 2 sales-territory cuts in the year.
• Delivered for Oracle Dataguard and other topics in India. 20 year experience working with onshore and offshore teams.
• Mentored and trained over 100 Oracle Support engineers on a daily, hands on basis. Taught them when and how to read Oracle’s trace files, and when to avoid them.
• Wrote the Oracle Data Dictionary view definitions for EXPort / IMPort and the cluster objects for Oracle’s catalog.sql, which is shipped with every product.
• For 17 years, scored and produced running races, triathlons and cross country ski races, in the San Francisco Bay Area, Lake Tahoe, Los Angeles and Hawaii. Worked with local and federal government officials, live TV, sponsors and the public.
• Wrote the feature article for Oracle Magazine on database recovery.

TECHNICAL INVENTORY AND TOOLSET:

Database Management: Oracle 12c/11g/10g/9i/8i/7/6/5

Oracle e-Business Suite: R11 / R12

Peoplesoft: 9.0

Hardware Systems: Sun, IBM RS/6000, HP 9000, IBM PC, x86, x86 64, I64

Operating Systems: UNIX (Solaris 9, 10, AIX 3.2, 5.3, HP-UX11), Windows NT Windows 2000, Windows 2003, Linux Redhat 2.1, 3.x, 4.x, 5.x (32bit, 64bit), HP/UX, AIX, VMS.

Programming Languages: SQL, PL/SQL, PASCAL, C, Fortran Unix shell, html.

Cloud: IBM Softlayer, Oracle Cloud, AWS-EC2.

System Management Tools: Oracle Grid control, TOAD, TOM (The online Monitor)DBCA, TKPROF, RMAN, ASM, RAC, Import/Export, SQL loaderSQL*Net, AWR, Tuning packs, Data Guard, Data-Pump.

Performance Tuning Tools: SQL Tuning Advisor, SQL Profiles, Explain Plan, AWR reports

Event 10053 and 10046 Tracing.:

Development Tools: SQL*DEVELOPER, PL/SQL, SQL*PLUS

Enterprise Security: Imperva SecureSphere

EMPLOYMENT HISTORY:

Enterprise Information Security Engineer - Database Security

Confidential, Monterey Park, CA

Responsibilities:

• In order to secure Oracle 11g and 12c, MSSQL and DB2 databases, conducted a feasibility study for the User Rights Management for Databases (URMD), using Imperva’s SecureSphere. Studied the capabilities and limitations of URMD.
• Produced official assessments for Oracle, DB2 and MSSQL databases, and worked with DBA’s to eliminate attack vulnerabilities for their production databases.
• Created security and audit policies (DAM - Data Activity Monitoring) to monitor for legitimate privilege abuse, the granting of excessive privileges and other security violating activities.
• Figured out how to issue direct SQL select statements from Imperva to access any table in databases that access is granted on.
• Figured out how to use Imperva login authentication against to Active Directories after a bank merger created 2 username lists.
• Faced the conundrum of asking DBA’s to apply patches right away, while at the same time knowing that a lot of database failures happen after DBA’s apply patches right away in enterprise computing.

Production Oracle EBS DBA

Confidential, Burbank, CA

Responsibilities:

• One of the 2 production DBA’s left unexpectedly, and the other was scheduled to go on vacation.
• Was hired quickly to assure system availability when she was out.
• After quickly learning the system setups, covered her vacation with no failures.
• Successfully cloned the EBS production to a sandbox for both the APPS and DB tiers.
• Monitored the systems with OEM - Oracle Enterprise Manager
• Successfully performed routine tasks of running scripts produced by developers in UAT and PROD, on both database releases 11.1.0.7 and 12c.
• Diagnosed a crippling production performance problem, and presented the very inexpensive solution.
• Concluded the short project with the Senior Director’s promise to be a .

Technical Advisor

Confidential, Pompton Lakes, NJ

Responsibilities:

• Studied the feasibility of porting their product to Linux, EXADATA, and the Oracle install base with the developers.
• Studied the product and produced reports for the CEO and Board of Directors on its benefits to customers. Participated in many meetings that the CEO held with venture capital firms.
• Installed Oracle Database 12c on Ubuntu Linux 15.04
• Reviewed all aspects of the company’s activities, from sales, marketing, technology, including reviewing all the technical documents to learn the internals of the product, and make corrections.
• Started to establish their presence in California and the West Coast.
• Conducted several live demonstrations of the product to the Los Angeles SQL Server User group at UCLA, made Confidential a sponsor of their website, and after conducting another demonstration, got the interest of Confidential ’s top developer to bring the Confidential solution into their data centers.

Oracle Performance DBA

Confidential, Burbank, CA

Responsibilities:

• Was hired during the interview to diagnose the poor performance of a critical, production Oracle E-Business Suite custom job, going on for several months. It had been running gradually slower, as merger related data came into the Oracle database.
• Resisted pressure from the Aramark IT staff and set aside all trace files, OEM, Grid Control, SQL Tuning Advisor and Explain Plan. Proved in a week that the Oracle query optimizer was not the suspect.
• In 3 weeks proved that excessive looping in the PL/SQL code had to be eliminated. Recommendations were accepted by IT Director and developers, who immediately started code redesign efforts.
• Delivered to development for better optimizer practices.
• Learned that they have no debugging in their custom code and are relying on Oracle’s Database Engine to diagnose it. Proved to all, that Oracle’s debugging won’t help trace their own application. Management and team accepted the recommendations.
• By quickly delivering a reliable diagnosis, the 6-month assignment was concluded in a month.

Oracle Database Administrator

Confidential, Pasadena, CA

Responsibilities:

• Took over the Imperva production monitoring for Confidential National Pricing System, after a smooth transition.
• Served as a Sarbanes-Oxley DBA (SOX).
• DBA SWAT team member to get Confidential ’s 4 TB database, Onelink, running on Oracle ASM, RAC (Real Application Clusters) and Peoplesoft.
• Bi-weekly refreshed test databases from production, after getting a refresher on RMAN.
• In 1-hour solved a highly escalated production ETL performance problem that up to 15 DBA’s and Oracle Support could not solve over 2 months, after tracing it any way they could. Did not look at a single line from Oracle trace output to do so.
• Mentored the Confidential ETL / EPM team on a daily basis to make sure jobs ran OK. Advised management and team members on best uses of Oracle features. Monitored the database server when they used the ASCENTIAL tool to run their jobs on Confidential ’s Data Warehouse.
• In 1 hour diagnosed a chronic ERP production database outage that Oracle Support and the other DBA’s could not solve in over 9 days. Did not look at a single line of Oracle trace output to do so.
• Presented changes to over 40 CAB meetings (Change Approval Board), after few failures in the beginning, passed the majority with no need for corrections.

Database Forensics and Litigation Leverage Builder

Confidential, Glendale, CA

Responsibilities:

• A company called Southwest Traders in Los Angeles used to have $450 million / year in revenue.
• Reviewed 465 Oracle Service Requests and several thousand emails to see who was responsible for the failures.
• Stopped the cause of a major system freeze on first visit to the Southwest Traders HQ.
• By June 2011 established enough liability where Southwest Traders wrote a letter to DAZ and succeeded to demand concessions.
• Interviewed and hired a new IT director who resigned and later on was sued for $400 million.
• Saved the jobs of 800 people.
• Stopped the damages so successfully that in 2011, the Southwest Traders damages were only $13 million, but after a dispute on strategy, the attorney Arthur Charchian went his way, and their damages in 2012 mushroomed to $116 million, and in 2013: $233 million.
• Trained the IT team on better database practices after the previous IT director left.
• Produced reports to the CEO and his legal team on best practices.
• Replaced the 22-hour RMAN backup procedure with a 45 second option by taking volume snapshots.
• Maintained 4 pre-production E-Business Suite (EBS) and GRC databases, while preparing the production machine to go live on January 3, 2011
• Timely cloned the entire apps and db environments on a weekly basis.
• Applied patches
• Installed and configured the production environment on a new machine going production
• Performed the daily tasks supporting the production team
• Conducted root cause analysis (RCA) for failures and produced reports.

Oracle Database Support Engineer

Confidential, Redwood City, CA

Responsibilities:

• Database Installation, silent installation and embedding oracle base software into the product on multiple platforms.
• 14 year experience as the key technical solution builder for the most severe failures in customer databases, business units, Oracle escalation contacts, developers, CIO’s, CTO’s. Freed frozen databases, patched damaged data dictionaries, identified and recovered lost data, recovered at least 200 down production systems, assisted with post-recovery migrations and rebuilds, and saved tables with corrupt blocks.
• Reviewed and supported many configurations including Oracle Real Application Clusters (RAC) on ASM & Clusterware.
• Delivered to a class of 20 in India on Dataguard. Presented many other classes on successful problem solving, block corruption and introduced an approach which became mandatory globally for all support engineers on how to throw away 99% of Oracle’s massive trace output to use the 1% that is going to help solve the problem.
• Frontline customer support of Fortune 1000 customers’ production systems.
• Actively participated in the V6 and V7 beta programs
• Wrote the Oracle Data Dictionary view definitions for EXPort / IMPort and the cluster views for Oracle’s catalog.sql, shipped with every tape and run with every installation.
• Performance planning and solution implementation to handle high-speed and high volume data.
• Automated database administration/data management tasks.

Sales Consultant

Confidential, Palo Alto, CA 2

Responsibilities:

• Built Tom Siebel’s (CEO) personal demo starting with the product when it was in alpha stage.
• He used it to get $10 million in venture capital.
• Was given a headcount of 12. In the 1990 recession got the work done with 9.
• Provided prototypes and satisfied the demo and prototype requests of 65 sales reps and 25 telemarketing reps to install the product and help customers with proof of concept.