Customer Service Oracle

MIHEKO OUCHI 310-***-****; ******@*******.***

SUMMARY

• Extensive experience in development & administration of relational database.

• Design, implementation, performance tuning and support of very large databases

TECHNICAL SKILLS

Databases: Oracle 11g, 10g, 9i, 8i, 7, SQLServer 2008, 2000, UDB, Adabas

Databases tools & Utilities: OEM Grid Control, RMAN, Data Guard, BMC Patrol, Toad, AWR, Explain Plan,

SqlPlus, SqlLoader, Exp/Imp, DataPump, SQLBacktrack, Oracle Designer/Developer

Operating Systems: RedHat-Linux, Sun Solaris, HP-UX, IBM-AIX, Windows 2003/2000/NT, Oracle ASM

Programming Languages: SQL, Pl/Sql, Shell scripting, Natural, Pl1

ProgrammingTools Applications: Exceed, Reflection, Weblogic, Webphere, Erwin

Ticketing Tools: Remedy, Vantive, HP Open View, Jira

PROFESSIONAL EXPERIENCE

eBay-StubHub (San Francisco) Jan 2014 to present

Consultant DBA

• Improved performance and tuned-up data warehouse and analytics databases using AWR, SQLtuning, SQL access

explain plan. Worked with developers troubleshooting long running analytics reports.

Environment: Oracle 11g, Solaris, OEM 12, Toad

Wells Fargo (San Francisco)

Consultant DBA Jul 2013 to Dec 2013

Provided database infrastructure support, planned and implemented databases migration, patches and release changes.

•

• Performed Oracle database upgrades to Oracle 11R2

• Tune up and troubleshoot pre-production databases.

Environment: Oracle 11g, Solaris

MobiTV (San Francisco)

Consultant DBA Jan 2013 to Apr 2013

• Evaluated database setup and built new databases for a server consolidation project.

• Provided support for production databases and created standby database (DataGuard) to guarantee availability.

• Supported interface Oracle with Hadoop to load data

Environment: Oracle 10g, 11g, Linux, Hadoop

Kaiser Permanente (Los Angeles)

Consultant DBA Nov 2009 to Oct 2012

• Developed database solutions to assist security and Sox regulation compliance remediation. Developed Pl/Sql stored procedures

to capture non-compliant users.

• Provided support to Claims, Clarity and Pharmacy databases, monitored and improved performance of Oracle RAC databases

version 10g and 11R2 running on Linux.

• Implemented RMAN backup and recover strategy on large database with many Terabytes such as KP Claims .

• Data warehouse DBA responsible to implement Kaiser Master Member Datamart on Oracle converting from Teradata.

• Improved Data Warehouse applications performance, with data architecture and sql tuning for better utilization of Oracle 10g and

11g optimizer.

• Consolidated Kaiser’s 5 regions Master Member databases into one using partitioning by region. Participated on data modeling

effort for a consolidated Enterprise Member database

Environment: Oracle 10g, 11g, RAC, AIX, Linux

Toyota Corp (Los Angeles) April 2007 to Sep 2009

Senior DBA

• Responsible for Oracle 10g upgrade standards specification and Data Center migration for Electronic Payment application

which is the main website for Toyota Financial Services and contained replicated data from Toyota Motors database. (Oracle v9)

• Supported Document Management System Car Lease and Retail data purge that required coordination with many databases

affected with purge procedure.

• Instructed Production DBA for database changes and provided required scripts

• Constructed database architecture based on Business requirements and Developers specifications

• Installed/used OEM 10g to monitor and work with QA team on database performance and tuning.

• Implemented Backup/Restore procedure using RMAN and Veritas clusters on very large database, wrote shell scripts to control

database local and remote failover.

• Supported SqlServer Online Credit Application database migration to a new Data Center.

Environment: Oracle 10g, SQL Server 2000, Sun Solaris, Windows 2003, OEM 10g, Weblogic, HP Open View

Kaiser Permanente (Los Angeles) August 1998 to March 2007

Senior DBA

• Responsible for design, configuration, development, implementation and maintenance of Oracle relational database

infrastructure for Customer and Clinical applications.

• Built data structure and data modeling following business specification using Erwin, such as Kaiser Meta-Data.

• Monitored and tuned database performance.

• Set up and implemented backup/recovery and security routines.

• Upgraded Oracle 8 databases to Oracle 10g databases in a national project.

• Supported Call Center database using Vantive application (500 GB size) conversion to Oracle CRM application used

by 400 customer service departments nationwide.

• Specified Oracle database setup standards and documentations to be used as reference guide during installation or upgrade.

• Defined standard operating procedures with backup/restore specifications.

• Setup rules for database alert and notification on BMC Patrol in order to automate monitoring activities.

• Led information sharing sessions to enhance the DBAs technical skills, and to introduce new productivity tools such as BMC

Patrol, Oracle grid control.

• Performed level three incident and problem resolution to support the QA and Production Management Technical staff.

Environment: Oracle 8i to 10g, RAC, SQL Server 2000/2005, Sun/AIX, Windows 2003, CRM, Websphere, BMC Patrol and

SQL backtrack, EMC storage, PlSql, Java, Erwin

Oracle Database Consultant Aug 1995 to Aug 1998

(Los Angeles)

Responsible for developer’s training and database administrator’s support on Oracle technology.

Following are some of companies worked as Oracle consultant.

Bax Global Jun1997 to Jun 1998

Environment: Windows NT, Oracle 7.3 and 8, Designer 2000, Erwin. Oracle Enterprise Manager

Alpha Management Solutions – DBA Jun 1996 to May 1997

Environment Windows Nt, Oracle 7.3, Developer 2000, SQLServer.

City of Los Angeles – DBA Aug 1995 to May 1996

Environment: SUN SOLARIS, UNIX, ORACLE 7.2, EASYCASE, PL/SQL

EDUCATION Master in Business Administration (MBA) – USP (University of Sao Paulo)

BA in Business Administration

CERTIFICATION Oracle 11g OCP

Contact this candidate