SUMMARY:

• 19 years in all levels of Oracle Database Support, from front line to Advanced Resolution, to Bug Diagnostics and Escalations .
• 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 Confidential .
• 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 will make things much easier.
• 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.
• Saved Southwest Traders of Temecula, a $450 million / year company with 800 employees from going under, due to a disastrous Oracle EBS implementation.
• Upon seeing the evidence, the biggest defendant settled by paying an undisclosed sum.
• The other defendants insisted to have the case in arbitration
• Southwest Traders threw Oracle out in 2012 and went back to their legacy system.
• Exceeded Oracle Support’s desired customer satisfaction level by 15 points.
• Received a 95% customer satisfaction rating from over 30 customer surveys.
• Did so with 2 sales-territory cuts in the year.
• Delivered training for Oracle Dataguard and other topics.
• 20 year experience working with onshore and offshore teams.
• Mentored and trained over 100 Oracle Support engineers hands on.
• 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 was shipped with every product.
• 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: Confidential SecureSphere

ACTIVITY HISTORY:

Confidential, West Covina, CA

Responsibilities:

• My answer to all those interviewers who concluded that after turning 55 I was incapable of learning anything new.
• I took the tax preparer course, passed the tests in 3 weeks, and am helping many single parents get the fair tax, earned income credits and child tax credits by doing their tax returns.
• Oracle’s query optimizers have nothing over these single mothers who somehow manage to keep a household together year salary, working at Confidential every day, while trying to keep their kids away from drugs and gangs.
• I still have access to Oracle environments in AWS and Oracle Cloud.
• For a little bit of money every month, I can easily keep my skills sharp for the right Oracle employer.

Confidential, Los Angeles, CA

Responsibilities:

• I saved the jobs of 800 people.
• The attorney who brought me into the case, Confidential, placed me under a very restrictive Confidential, so severe, that I could not even mention the activity on my resume.
• The opposing side was threatening to bring Oracle experts to destroy my credibility and 100% success rate.
• I prepared my team for the attack and the opposing side retreated after our 6 hour settlement meeting.
• Before giving his verdict, Confidential, after hearing all the evidence, including the praise for me from witnesses on the opposing side
• With the restrictive Confidential weakened because of the lawsuit, and with my newly acquired webmaster skills.

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.
• Studied the capabilities and limitations of Confidential .
• 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 Confidential to access any table in databases that access is granted on.
• Figured out how to use Confidential 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, 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 reference.

Technical Advisor

Confidential, 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 suggestions.
• 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 Confidential, 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, 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 Confidential IT staff and set aside all Oracle 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 the IT Director and developers, who immediately started code redesign efforts.
• Delivered training 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.
• Because the assignment was cut short, the recruiter lost money, but took me out to an appreciation lunch, after hearing the praise from the IT Director.
• While also looking for the correct fit for work at different times, studied how some high profile Oracle projects failed, including federal and state healthcare exchanges for the Affordable Care Act. Presented analysis to federal and state investigators and officials in all 3 branches of government.
• Forensically analyzed the root cause of the failures, to figure out if the failure is because of the database, application design or project management.
• Presented reports to both state and federal investigators, upon which actions were taken.

Oracle Database Administrator

Confidential, Pasadena, CA

Responsibilities:

• DBA SWAT team member to get Confidential 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.
• 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.
• Presented changes to over 40 CAB meetings (Change Approval Board), after few failures in the beginning, passed the majority with no need for corrections.