Project Manager Oracle

Marvin A. Hecht, Oracle Applications DBA

**** ***** ** ******

San Mateo, CA 94403

408-***-**** Mobile

650-***-**** Home

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

Citizenship: US

Summary

Responsible, quality- and detail-oriented Database Administrator and IT professional. Currently serving as the Oracle 11i Apps DBA/ Architect, Oracle DBA (10g/ 11g), and Unix Sysadmin at Echelon. Previously, I was DBA for Oracle OnDemand and Oracle’s Usability labs. I am enthusiastic and highly motivated.

Overview / Areas of Expertise

• Oracle 11gR2 / 10gR2, 9iR2, including RMAN, cloning, opatch, upgrades

• Oracle 11i Applications DBA (11.5.10.2) especially patching, apps administration, upgrades

• Solaris 10 for SPARC and Red Hat Enterprise Linux 4 (RHEL)

Technical Skills - Oracle

• 11 years overall of Oracle skills: Oracle 8i/ 9i 1/ 0g 11g / Oracle 11i apps DBA (11.5.10.2)

• 7 years production Apps DBA/ core DBA experience (3 at Oracle, 4 at Echelon)

• Agile PLM 9.2.2.3 DBA / Administrator – helped Echelon convert from Windows to Linux

• Expert in installation, patching (Metalink, Adpatch), upgrades, configuration & troubleshooting

• Regular use of sql*loader, and sqlplus, some use of PL/SQL, triggers, and performance tuning

• Solid knowledge of Application Server 9iAS & 10gAS, Apache / J2EE, Jserv / JSPs and Dev6i

• Have programmed basic forms in WebDB, Portal, Htmldb, JDev, some shell script writing.

• Working knowledge of Enterprise Manager, Oracle RAC, Dataguard, Oracle VM, streams

Technical Skills – System Administration and Others

• 14 years system administration with Unix and its variants ( Linux/ Solaris, some HP-UX/ AIX)

• 18 years Windows 95/98/2000/NT/XP & Mac troubleshooting (hardware & software)

• 16 years data analysis & statistical / research skills -- MS Excel, SPSS, SYSTAT, SAS (including from my time in Academia)

• Production DBA for SQL Server 4 years, working knowledge MySQL, PHP, LAMP (Linux / Apache / MySQL / PHP)

• Excellent relationship / communication skills, with strong enthusiasm / drive.

IT Certifications

• Oracle 10g Oracle Certified Professional (OCP) (December, 2006)

• Oracle 10g Certified Professional (OCA) (October 2005)

• Oracle 11i Applications Database Administrator Certified Professional (March, 2007)

• Red Hat Certified Technician (RHCT) Linux Certification (September, 2003)

• Microsoft SQL Server 2005 (MCTS) Certified Professional (September, 2008)

• ITIL Foundation Certificate in IT Service Management (January, 2007)

Work History

Enterprise Applications Architect & Lead Database Administrator. 3/2007 - present.

Echelon Corporation, San Jose, CA. Echelon makes energy control networks, including smart meters.

• In charge of and responsible for the uptime of Echelon's production ERP system, using on Oracle Applications 11i (11.5.10.2) on 11g (11.2.0.1). Includes troubleshooting, maintenance, backup and recovery, architecting new systems, patching, performance tuning, and Solaris 10 (SPARC) system administration. We have t5220, t2000, and v880 sun servers and a pair of 2500FC fiber arrays, and I architected the setup, and I currently manage them.

• Just went live (mid-May) on a project to apply the 11i extended support baseline functional & recommended patches – 350+ applications patches. I wrote the 57-page project plan, and I was the lead DBA who led the 60-hour execution time, and trained my colleagues in Oracle patching.

• In summer of 2010, completed a major upgrade of the RDBMS from 9iR2 to 11gR2with accompanying CPU & Apps techstack patching-- which fulfilled all the technical parts of the 11i extended support baseline patching, and prepares us for R12. 300 page project plan.

• One year ago, developed and executed a108-page plan to patch up to ATG RUP 6 with XML Publisher, latest CPU patches, and Database patchset upgrade. Also responsible for some Windows severs running Oracle Essbase and SQL server. 100 page project plan.

• In addition, responsible for DBA & Sysadmin support of the following Enterprise Systems: EDI, Agile (uses an Oracle Database), Business Objects, Remedy , including Microsoft SQL server.

• In 2009, architected the infrastructure for the implementation of (a) the migration of Oracle production from a Sun v880 with internal storage to a pair of T2000 machines with a SUN 2450FC array, (b) the upgrade of Oracle Agile 8 to Agile 9.2.2.3 upgrade, including migration from Dell Windows servers to Dell Linux servers, as well as simultaneous migration to 8i to 10g RDBMS, and installation and patching of both the Solaris 10 OS and the Sun Storage Array / Snapshot software.

• Responsible for Clarity (Budgeting App) which uses a SQL Server/ Oracle Essbase backend.

Senior Oracle Applications 11i DBA. 12/2004 – 3/2007.

Oracle Corporation, Redwood Shores, CA. Oracle OnDemand. (Hosting/Outsourcing Division).

• Served as an Apps DBA / Oracle DBA on prod, dev & test databases for 500 customers / 1500 databases

• Upgraded customers daily to current Apps components (11.5.10.2, 9iAS, Jinitiator, Disco 10g, 10g DB)

• Served on the mass-patch team, creating project plans for complex family packs for escalated customers.

• Acted as the lead for 5 upgrades where each plan was a complex 100-page technical document

• Researched and implemented an internal knowledge base for our team, used daily by over 100 engineers

• Initiated a plan to improve our “master doc”, saving an average 10% time

• On a daily basis handled patch execution, configuration / optimization, issue resolution / troubleshooting

• For 30 days after an upgrade, was responsible for handling any/all post-upgrade issues including managing the customer’s expectations, coordinating with development and project manager, coordinating with other teams e.g. the performance team, the configuration team, the monitoring team, the recovery team.

Senior Usability Lab Engineer (DBA, Sysadmin, Video Engineer). 12/2000 – 12/2004.

Oracle Corporation, Redwood Shores, CA. Oracle Usability and Interface Design Department.

• Installed, configured, cloned, patched, & upgraded 8i/9i/Apps 11i environments for usability tests on a daily basis, including work with developers to install and merge beta code into a vanilla Vision instance.

• Specific 11i installation experience includes: HRMS, iRecruitment, Email Center, Compensation Workbench, Oracle Sales Online, Oracle Marketing Online, Order Management, Oracle Quoting, Compensation Workbench, Contracts, Advanced Pricing, using 11.5.5 - 11.5.10 - both technical and functional setups

• Was responsible for the smooth functioning of labs, including 7am-7pm uptime of 8i/ 9i/ Apps 11i environments, Windows PCs, Linux, Solaris, Windows servers, & 1 24x7 database server on the extranet

• Served as the 8i DBA for an 1,700-record participant payment tracking database, and the system administrator for 10 critical servers, hosting departmental reports & UI content

• Managed the design & building of 3 high-tech labs for usability testing/ research.

Assistant Professor of Psychology. 8/1997- 11/2000.

Louisiana College, Pineville, LA.

• Ran an independent university Unix server which was more reliable than IT’s NT server.

• Self-taught Red Hat v. 5.1, SunOS, Apache, DNS, Sendmail

• Planned, designed, and built a multimedia & statistical computer lab.

• Supervised 15 senior projects in research & programming in SAS, SPSS.

• Published 9 academic research articles before leaving academia for the tech sector; one of these projects meta-analyzed 345 other studies and took 10 years to complete.

Education

• Harvard University. Post doctoral Fellow & Lab Manager of the Nonverbal Research Lab. (1995-1997). Dept of Psychology.

• Boston College. Ph.D. (1995). Social Psychology. (fast track combined MA/PhD). GPA: 4.0

• University of Waterloo. Honors A.B. (1990). Psychology. GPA: 3.2.

Interest / Hobbies

• Cars (Porsche) and car tuning., Audio-visual convergence, home theater, Satellite TV/ Tivo, Multimedia convergence, Apple (iPhone, Mac).

Contact this candidate