SUMMARY:

An Oracle DBA with over twenty years of hands on experience. 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. I also performed Linux admin work on a Cisco FlexPod, creating Volume Groups, Logical Volumes and file systems to support Oracle database installations.

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 7.2,7.1,5.9,5.4, 5.1, 5.0, and 4.4. Suse Linux, Windows XP, Server 2003.

Vendor Packages: Siebel, Genesis, Itron, PeopleSoft Java SE 8

WORK HISTORY:

Confidential

Oracle DBA

Responsibilities:

• Worked as a SQL Tuning DBA
• Able to reduce Load Times from 12 Hours + to 10 Minutes
• Improved load times by reviewing SQL statements and making hint adjustments
• Removed unwanted indexes
• Analyzed data and utilized natural keys wherever possible to create Primary Keys
• Created new indexes to support SQL Tuning efforts
• Reorganized the SQL in the load process to optimize performance.
• Modified statistics to improve query performance.
• Documented all activities for client
• Architected new tables to remove unwanted SQL joins across a link.

Confidential

Oracle DBA

Responsibilities:

• Created Oracle database in Oracle 12 Standard Edition 2
• Responsible for setting all Oracle parameters.
• Responsible for database design.
• Responsible for creating and implementing all table, indexing and primary keys.
• Responsible for data security by creating user access grants and permissions.
• Created backup and recovery strategy using RMAN and Data pump.
• Wrote all shell scripts to monitor Oracle instance in kshell.

Java Developer

Confidential

Responsibilities:

• Used Java SE 8 for the application
• Wrote application in NetBeans IDE.
• Created multiple classes to support contract specifications, broker connections.
• Created interface class to connect to the Brokers API for placing orders and trade executions.
• Created java Enum class to initialize the Universal Connection Pool (UCP)
• Wrote more than 400 Java methods to call data or update data in Oracle.
• Successfully wrote a profit and loss procedure to calculate PNL.
• Successfully implemented Java logic to place and maintain protective stops.
• Wrote Java class to capture and process live streaming data.
• Wrote Oracle stored procedure to capture data in multiple time frames.
• Utilized BigData methodology to control decimal points for Java double calculations.

Linux Admin

Confidential

Responsibilities:

• Responsible for setting all Linux kernel parameters in /etc/sysctl.conf
• Created all Linux Physical Volumes.
• Created Volume groups.
• Created logical volumes.
• Created the Oracle file systems.
• Created the Oracle directory structure with the mkdir command.
• Mounted the file system with mount command
• Added the filesystem in /etc/fstab
• Tested the mounts in /etc/fstab by issuing the mount - a command.
• Extended a Logical Volume with lvextend command
• Created Linux users and groups

Oracle DBA

Confidential, Rosemead, CA

Responsibilities:

• Oracle Exadata DBA
• Responsible for building and maintaining 4-Node RAC Clusters.
• Responsible for setting up Prod Like Data Guard.
• Responsible for setting up Production Data Guard.
• Responsible for setting up Prod Like Active Data Guard.
• Responsible for setting up Production Active Data Guard.
• Responsible for setting up RMAN backup for Data Guard instances.
• Responsible for testing RMAN Data Guard recovery procedures.
• Utilized the Confidential utility to create Data Guard Broker configurations.
• Responsible for testing Data Guard Broker setup in Data Guard instances.
• Responsible for testing Data Guard role reversal procedures and testing.
• Responsible for Oracle 12c Container and Pluggable Database’s.
• Created 12c Container Admin Managed Databases.
• Created 12c Container and Pluggable instances.
• Written RMAN ksh scripts to backup 11R2 Instances -12c Stand Alone Instances - 12c Container and 12c Pluggable Instances with the same script.
• Written RMAN ksh scripts to recover 12c Instances, tablespace and individual tables.
• Written ksh scripts to monitor tablespace sizes in Stand Alone, Container and Pluggable instances.
• Utilized IMPDP to import production data on AIX platform to Oracle Linux.
• Part of migration team that migrates instances from AIX to Oracle Linux.
• Used srvctl utility to create services.
• Responsible for setting /dev/shm for the Exadata compute nodes
• Responsible for the migration of 2.7 Tb mission critical production database from AIX to Exadata.
• Responsible for the migration of a 400 Gb mission critical production database from AIX to Exadata.

Confidential

Oracle DBA

Responsibilities:

• Changed DNS settings on the Exadata Appliance, including compute nodes, ILOM’s, PDU’s and all storage cells.
• Used cellcli commands to offline storage cells for DNS changes.
• Executed Oracle OneCommand OEDA utility to create ExaData installation scripts.
• Executed checkip check scripts to verify ExaData cluster configuration.
• Executed orachk to verify Oracle Database Appliance (ODA) cluster configuration.
• Modified scan listeners with crsctl utility.
• 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.

Oracle DBA

Confidential, Rosemead, CA

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
• Created an Active Data Guard physical standby database in maximum performance mode.
• Created an Active Data Guard physical standby database in maximum availability mode.
• 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.
• 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.

Linux Admin

Confidential

Responsibilities:

• Created Physical Volumes using root pvcreate /dev/sdn
• Created Linux users and groups
• Created Volume groups with the vgcreate command
• Created logical volumes with the lvcreate command
• Created Oracle ASM volumes using dd if=/dev/zero… command
• Created the Oracle file systems using mkfs.ext3 command
• Created the Oracle directory structure with the mkdir command.
• Mounted the file system with mount command
• Added the filesystem in /etc/fstab
• Tested the mounts in /etc/fstab by issuing the mount - a command.
• Extended a Logical Volume with lvextend command
• Removed a volume group with vgremove command.

Confidential

Oracle DBA, Pasadena, CA

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.

Oracle DBA

Confidential, Orange County, CA

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.

Oracle DBA

Confidential, Beverly Hills, CA

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 Confidential ’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.

Oracle DBA

Confidential, Camarillo, CA

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.