SUMMARY

• An Oracle DBA with over seventeen years of hands on experience. I have worked in nearly all aspects of Oracle database administration, development and design.
• Most recently I was the Exadata Subject Matter Expert (SME) and production DBA for a large Southern California utility.
• I have built and maintained Oracle instances using ASM for storage and Oracle RAC for local high availability. I have also designed and maintained large data warehouses.
• The largest database I have experience working with is 25 Tb in size.

TECHNICAL SKILLS

Oracle: Releases 12.1, 11.2, 11.1, 10.2, 10.1, 9.2, 8.1.7.0, 8.1.6, 8.1.5, 8.0.5, 8.0.3

Oracle Tools and Languages: Exadata, Exalogic, ASM, Oracle RAC 11G, 10R2 RAC, OEM Grid Control, PL/SQL, SQL, SQL*Plus, SQL*Loader, User Defined Packages, Functions, Stored Procedures, Triggers, Oracle Data Pump, Java, JDBC

UNIX: K Shell Scripting, BASH, Crontab

Tools: TOAD, SQL - Navigator, DB Artisan, Quest Central, NetBeans 7.4

Operating Systems: Sun Solaris 5.10, IBM/AIX 6.1, 5.3, 4.3, Oracle Enterprise Linux 5.4, 5.1, 5.0, and 4.4, Suse Linux, Windows XP, Server 2003.

Vendor Packages: Siebel, Genesis, Itron

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Built 3 Oracle - 2 Node RAC Instances on the Oracle Database Appliance.
• Assisted Security Team in troubleshooting connection issues.
• Changed DNS settings on the Exadata Appliance, including compute nodes, ILOM’s, PDU’s and all storage cells.
• Created OEDA and checkip scripts for ExaData configurations.
• Executed Oracle Repository Creation Utility (RCU).
• Installed Cloud Control 12c Cloud Control Pack.
• Installed Cloud Control 12c agents on Exadata Servers.
• Installed Cloud Control 12c agents on the Oracle Database Appliance.
• Have created over 30 vServers on Oracle Exalogic X3-2.
• Have resized the swap area on over 30 vServers.
• Have installed Oracle Fusion Middleware SOA Software.
• Have installed Oracle Fusion Middleware BPM Software.
• Have installed Oracle Fusion Middleware Oracle Traffic Director Software.
• Have installed Oracle Fusion Middleware Software Oracle API Gateway.
• Have installed Oracle OBIEE Software.

Confidential - Rosemead, CA

Oracle DBA

Responsibilities:

• ExaData Technical Subject Matter Expert (SME) for Confidential .
• Built and implemented more than 20 instances in Exadata RAC Clusters.
• Created 15 - 4 Node RAC instances on the ExaData Database Server.
• Created 5 - 1 and 2 Node RAC instances on the ExaData Database Server.
• 24X7X365 Production DBA
• Designed and implemented the ExaData file system layout for each instance.
• Wrote all Linux ksh scripts for RMAN backup and recovery.
• Wrote all Linux ksh scripts to monitor the instances, file systems, processes and tablespaces for each ExaData instance.
• Responsible for implementing Linux Huge Pages on each ExaData compute node.
• Responsible for setting all Linux kernel parameters on all Exadata compute nodes.
• Responsible for creating the instance parameter standard settings for each instance on ExaData at SCE.
• Responsible for setting up the /dev/shm settings for memory utilization on each Exadata compute node.
• Wrote and implemented a Java based pilot application that process streaming data to insert the data into an Oracle database with JDBC Java drivers.
• Wrote all RMAN procedures to migrate Oracle instances to new hardware.
• Recovered multiple production databases using RMAN.
• Migrated in excess of 150 Oracle instances utilizing RMAN.
• Performed the first RMAN backup and recovery at SCE.
• Implemented instance caging to throttle CPU usage.
• Responsible for Resource Manager plan settings.
• Created and built 11 - 1 Tb Oracle Spatial databases on Linux Blades.
• Extensive use of AWR reports to diagnose performance issues.
• Responsible for all performance tuning of all Oracle instances in ExaData.
• Responsible for setting up NFS mounts for DataPump exports on ExaData.
• Created OEDA and checkup scripts for ExaData configuration.
• Extensive use of AWR reports to diagnose performance issues.
• Assisted in the development of the database data center disaster recovery plan.
• Have setup Golden Gate on both source and target servers for migrations.
• Utilized the Oracle Log Miner utility to recover SQL statements.
• Lead DBA for 25 Tb Smart Connect Instance, with 5.2 M meters.
• Responsible for all performance tuning in the Smart Connect instance.
• Responsible for all space additions to all tablespaces in Smart Connect instance.
• Responsible for diagnosing performance issues in production database applications.
• Responsible for implementing changes into production environment for all SCE production databases.
• Responsible for 225 Oracle instances during monthly on call rotation.
• Utilized a TPC benchmark tool to verify Oracle database performance on Linux blades versus an IBM P6.
• Used NID to re-name existing databases.
• Wrote the new database standards documents for SCE.

Confidential, Pasadena, CA

Oracle DBA

Responsibilities:

• Designed claims reporting database to replace current vendor.
• HIPAA compliant Oracle consultant with Confidential .
• Created views to extract Pharmacy Claims information.
• Created custom SQL statements to extract legacy data from existing vendor.
• Created DDL for partitioned tables.
• Created shell scripts to load and manipulate the data files.
• Utilized SQL merge statements to both insert and update data in a single statement.
• Wrote physical solutions design document.

Confidential, Orange County, CA

Oracle DBA

Responsibilities:

• Created an Oracle 11.1.0.6 database.
• Installed Oracle Enterprise Linux 5.3
• Configured Linux kernel parameters to optimize performance.
• Reverse engineered Kronos Time management database.
• The Kronos database was 875 tables in scope.
• The data that was extracted was used in support of a class action Confidential .
• Utilized SQL*Loader to load and populate the Kronos database.

Confidential - Beverly Hills, CA

Oracle DBA

Responsibilities:

• HIPAA compliant Oracle consultant while at Cedars-Sinai.
• Created Production 10.2.0.3 database for Appworx job scheduler
• Responsible for all AIX RMAN recoveries.
• Each backup was validated as correct for auditor review.
• Created 9.5 Tb. 10.2.0.3 ASM instance to support online data store.
• RMAN recovery of a 5 Tb. and 3.5 Tb. Database in the ASM instance.
• RMAN recovery of 1.2Tb RAC database to standalone ASM instance.
• Utilized DBNEWID utility to change DBID and Database Name.
• Created new RMAN recovery catalog, and the migration of all databases to the new catalog.
• Member of 24x7 production support team.
• Created, tested, and implemented RMAN backup and recovery scripts for the Peoplesoft stage database.
• Created the Stage Peoplesoft Oracle database, utilizing DBCA.
• Responsible for migration of all data from the production Peoplesoft database to the stage Peoplesoft database.
• Implemented change requests in all Peoplesoft environments.
• Exported production Peoplesoft schema statistics to support testing effort in the Pre-Prod database.
• Performed RMAN backup and recoveries of Kronos time management production database.
• Performed RFC’s in production database applications, including PeopleSoft and Kronos.
• Implemented service requests to support operation and maintenance of production systems.
• Setup groups and user defined metrics in OEM Grid Control.

Confidential, Camarillo, CA

Oracle DBA

Responsibilities:

• Used DBCA to create the production 10.2.0.3 RMAN database and recovery catalog.
• Created, tested, verified and implemented production RMAN backup and recovery solution.
• Wrote RMAN backup and recovery scripts for production Admin Portal database.
• Member of the 24 X 7 on call production DBA team.
• Created 6 node RAC cluster in Production using DBCA.
• Created 2 node RAC cluster in dev and stage environments using DBCA.
• Utilized Server Control (srvctl) Utility to create, drop or modify services for the RAC instances.
• Utilized Cluster Verification Utility (cluvfy) to troubleshoot RAC environment.
• Created 4 instances per node, in two 6 node Veritas cluster in Production.
• Created production Admin Portal 10.2.0.3 database utilizing DBCA on Windows 2003 Server.
• Designed and created the DDL for the new tables that will comprise the Event Services component.
• Tasked with making recommendations concerning the re-writing of SQL code that utilizes re-designed Event Services.
• Responsible for the index strategy for the Event Services component.
• Member of Database team responsible for corporate architecture for RAC clusters in new data centers.
• Used Oracle Export/Import Utility to migrate Production data to Dev to assist Dev teams to identify errors in client data.

Confidential - Los Angeles, CA

Oracle DBA

Responsibilities:

• Primary DBA for Production support of the go live of the nfl.com website.
• Responsible for all RMAN backup and recovery in Stage and Prod RAC Clusters.
• Utilized SRVCTL commands to start and stop instances in RAC cluster.
• Created the nfl.com database used to support nfl.com website.
• Created all DDL for the eight schemas that comprise the nfl.com database.
• Created DDL for redo log files in ASM Managed 2 and 3 Node RAC Clusters.
• Utilized asmcmd commands to create ASM mount points in Oracle 10R2 Cluster.
• Architected and implemented ASM Mount Points for all Stage and Production RAC clusters for data, index, undo and redo logs.
• Responsible for database architecture for all database files, table spaces, and redo logs for the nfl.com production database.
• Created DDL for the partitioned tables.
• Determined correct range partition keys.
• Redesigned all partitioned tables to identify the correct range iterator.
• Designed and created new Content schema in production.
• Responsible for data accuracy in newly designed Content schema.
• Tuned all SQL statements in Content schema.
• Responsible for all data migration from DEV to Production.
• Extensive use of Automatic Workload Repository (AWR) for SQL Statement performance tuning.
• Utilized Oracle SQL Tuning Advisor to address poor SQL performance.
• Assisted Application Teams in writing, testing and tuning SQL Queries.
• Optimized init.ora parameters based upon SQL statement analysis.
• Architected and implemented change control policy for code, application and data migration changes.
• Architected Oracle role based access to enforce user access security policies. .

Confidential - Los Angeles, CA

Oracle DBA

Responsibilities:

• Designed, architected, and tested the interface to extract legacy data from mainframe applications.
• Created a data dictionary of the legacy data that formed the basis of the legacy interface. This formed the framework for client sign-off for extracted data.
• Created, designed, and developed the testing procedures to validate legacy data for inclusion in the LAUSD reporting systems.
• Achieved full sign off on extracted data, and the data manipulation procedures from LAUSD.
• Wrote all logic to extract and manipulate legacy data.
• Used K shell scripts to execute extraction, transformation and loading procedures within a corporate scheduling tool.
• Implemented Oracle 10G Data Pump to load data.

Confidential - Torrance, CA

Oracle DBA

Responsibilities:

• Created initial RMAN instances and recovery catalogues.
• Wrote and tested production RMAN backup and recovery scripts
• Wrote K Shell scripts to execute RMAN backup and recoveries.
• Performed RMAN backup and recovery of Siebel instances in Stage.
• Assisted in the EMC BCV testing, to create a third mirror, and successfully backup the BCV mirror volume to tape.
• Member of the 24x7 on call support DBA team.
• Created 75 Oracle instances at TFS.
• All instances created on Solaris 5.9.
• Created Production, Stage and Dev Enterprise data warehouse.
• Primary DBA for Enterprise Data Warehouse (EDW).
• Created all DDL for all EDW instances.
• Responsible for schema changes in all EDW environments.
• Responsible for all object sizing and capacity utilization planning.
• Wrote all database architecture documentation for standardized database creation.
• Created standardized database creation scripts for database creation.
• Responsible for Oracle patch upgrades.
• Responsible for standardizing init.ora parameters for TFS policy.
• Created Statspack schemas to asses instance and SQL statement performance.
• Tuned SQL statements to implement 55 concurrent connections to load historical data into the Siebel schema.
• These connections resulted in loading 250,000 records per batch.
• Wrote K Shell scripts to load and manipulate data for the data warehouse.
• Extensive use of Import/Export to support data migration.
• Wrote K Shell scripts to load data in EDW.
• Extensive use of SQL*Loader to load data into EDW.
• Responsible for implantation of a SOX compliant database access policy.
• Worked closely with application teams to assess and recommend SQL tuning suggestions for increased performance.
• Created roles, and established user security policies and procedures.
• Established schema maintenance procedures that include index rebuilds, space reclamation and statistics for all tables and indexes.
• Implemented fine grained auditing for production EDW warehouse.
• Wrote, tested and deployed materialized views to aid in query performance.
• Responsible for creating and designing partitioned tables.
• Configured multiple memory pools (buffers) to increase performance.

Confidential - Burbank, CA

Oracle DBA

Responsibilities:

• Designed and created 4 data marts in the Enterprise Data Warehouse.
• Designed all fact and dimension tables in each schema.
• All schemas were created in a Star schema strategy.
• All schemas designed with lowest possible level of granularity.
• Created conformed dimensions for use in the data warehouse.
• Primary 24x7 production support for entire Data Warehouse, in excess of 2 TB.
• Responsible for all object sizing and capacity planning for the data warehouse.
• The data marts were for POS, On Hand Inventory, Adjustments and Returns and AC Nielsen data.
• Wrote and tested all ETL in PL/SQL code.
• Worked with the business units to develop the ETL rules.
• Received full sign off from business units for data accuracy and correctness.
• Wrote reports for business users.
• Created all ETL schemas for loading and transformation.
• Identified data deficiencies in source systems, and developed procedures to purge source system of inaccurate data.
• Wrote back out procedures to remove incorrect data loaded from source systems.
• Identified source systems for legacy data extraction.
• The POS data mart formed the basis for reporting of sales on newly released videos and DVD’s. These reports were sent to corporate headquarters daily.
• The POS data mart and the AC Nielsen data marts were used to forecast production of DVD’s based upon past sales as well as competitor sales of like products.
• Extensive use of Materialized Views, to enhance query performance.
• Utilized ERWIN to create Entity Relationship Diagrams, as well as data models.
• Utilized K shell scripts for execution of SQL Procedures and Packages in Enterprise job scheduler.
• Responsible for SQL tuning of Business Objects SQL statements, used to access the Data Warehouse.
• Responsible for Oracle code upgrade from 8i to 9.2.0.4
• Extensive use of V$ tables to identify poor SQL performance.
• Designed and wrote new planogram replenishment module.
• Wrote K shell scripts to FTP data to merchandisers, to be used in doing physical counts with hand held devices.
• Extensive use of Triggers to implement business logic
• Extensive use of SQL and PL/SQL in Oracle Packages and Procedures
• Responsible for archiving and removing “old” data from production database.

Confidential - Chicago, IL

Oracle DBA

Responsibilities:

• Designed and created Dev, Test and Production databases.
• Created all database objects in all schemas.
• Responsible for object sizing and capacity planning.
• Wrote and tested RMAN scripts for backup and recovery.
• Wrote all ETL in PL/SQL code.
• Created 8.1.6 database instance in both Windows NT 4 and Linux 6.1
• Achieved full sign off on ETL process, as well as data accuracy.
• Installed InterMedia Text modules for text searching of BLOB and CLOB datatypes.
• Created a data dictionary of all data points, which was signed off by business units.
• Used explain plan and tracing utilities to identify poor SQL.

Confidential - Indianapolis, IN

Oracle Developer\Oracle DBA

Responsibilities:

• Oracle PL\SQL stored procedures and packages used in the production claims and insurance data marts.
• SQL query performance tuning, utilizing the tracing capabilities and the explain plan utility for query tuning.
• Utilizing query hints to optimize execution.
• Partial redesign of data mart, and reconfiguration of existing hardware to improve performance and response time.
• Export of production database onto the development platform, utilizing the Oracle export and import utilities.

Confidential - Chicago, IL

Oracle Developer

Responsibilities:

• Created Commercial Paper Trading Project.
• The project entailed the migration of a batch Commercial Paper Trading application to an online, real time Commercial Paper Trading application.
• Wrote stored procedures and functions, within a package framework, to implement the business logic, which included new functionality.
• Wrote stored procedures used in the debugging and testing phase of the application, for business logic verification.
• Wrote the interface to allow a remote communication server to interface with Oracle for remote stored procedure calls.
• Created the record sets used to pass parameters within existing Bank applications.
• Worked directly with Line of Business personnel, to aid in the testing and debugging of the trading application.

Confidential,Chicago, IL

Manager of IT

Responsibilities:

• 3 years Oracle development experience utilizing packages, procedures, functions, triggers, records, and ref cursors.
• SQL query performance tuning, utilizing the tracing capabilities and the explain plan utility for query tuning.
• Utilized OLE DB to connect Microsoft Active Server Pages to an Oracle 8i database.
• Used Microsoft Visual Studio 6 to debug e-commerce Web application.
• Installed, updated, and maintained IIS 4.0 Web server, for both development and production web sites.
• Utilized Red Hat Linux to successfully install, architect, and deploy Oracle 8i
• Designed the hardware architecture for production Oracle 8i database to be OFA compliant.
• Installation and administration of 2 Checkpoint-1 Firewalls.