TECHNICAL SKILLS:

LANGUAGES APPLICATIONS OPERATING SYSTEMS: Oracle Enterprise Manager, Oracle Advanced Replication, Oracle Recovery Manager, J2EE JDBC, C, PRO*C, HTML, PERL, Various versions of UNIX including Linux, AIX, AUX, HPUX, Solaris, UNIX Shell script, SQL, PL/SQL, DOS Windows NT 2000 2003, Brio Query Analyser Server, ORACLE RDBMS versions 7, 8i and 9i, 10g, 11g, ORACLE*FORMS 4.5 ORACLE REPORTS 2.5, Oracle 9ias, Oracle 11i, Brio Server query, CRM applications Clarify Clearsupport ClearQuality, Erwin Data modeling, TCP IP, MVS, VM, Macintosh, JCL, SNA, VTAM, NCP, NETWARE, SharePlex, Visual SourceSafe, Nagios, Oracle Transparent Gateway, SQL - Server, MySQL, OBIEE 10g/11g, WebLogic, ONTAP7, HaDoop/NoSQL databases HBASE, Cassandra, MongoDB, Oracle NoSQL, Toad, SQL Developer.

HARDWARE: UNIX AIX AUX HPUX based workstations (IBM, Confidential, Apple, SUN), Linux, MS Windows NT DOS based PCs, IBM mainframes, Token Ring, Ethernet, FDDI, protocol analyzers, LAN analyzer, CISCO routers, Confidential filers.

EXPERIENCE:

Confidential

Senior Oracle DBA

Responsibilities:

• Install and configure Data Guard with Fast Fail-over Observer in the QA environment, the implementation was rolled out into production,
• Test Data Guard fail-over due to data file corruption/loss.
• Install and configure Golden Gate for bi-directional replication to support QA testing. Write documentation for recovering/restarting Golden Gate extract and replicate processing.
• Create spreadsheet for predicting storage growth due to implementing encryption of PCI data.
• Install and configure Oracle Secure Backup to implement encrypted database backups.
• Install and configure OEM 12c, for supporting the development and QA databases.
• Install Oracle 11g and 12c to support OEM and the online purchasing databases.
• Install various database patches using the OPatch utility.
• Monitor production databases to determine which SQL queries may need to be optimized.
• Use tools SQL Developer/Toad to optimize poorly performing SQL using the utility DBMS SQLTUNE.
• Test strategy to convert Oracle RDBMS to SQL-Server RDBMS using the SQL-Server Migration Assistant (SSMA).
• Integrate OEM and MS SQL-Server using the plug-in for MS SQL-Server. Allows the technicians to monitor MS SQL-Server using Oracle’s OEM12c or OEM13c.
• Write scripts using PL/SQL and SQL*Loader, to load data from multiple text files into various database tables.
• Oracle license renewals. Explain Oracle licensing options to management/finance and their impact on our ability to provide database services with Confidential management and procurement.

Engineer/DBA

Confidential

Responsibilities:

• Install and configure Oracle single instance and Oracle RAC database environments.
• Install Solaris 11 (Unix) and Oracle (v6 and v7), Red Hat 5 and 6, SUSE 10/11 Linux.
• Configure zoning for FC-AL using Brocade switch to support communications between the database server and the storage array.
• Perform “silent error” injection test to verify Hitachi’s T10-PI data protection using the Xgig Jammer in a ten node Oracle RAC environment.
• Setup 100TB RMAN database backups and work with the sales and network engineering team to achieve 100TB backups in 8 hours.
• Generate and evaluate database/system performance (IOPS) using AWR and BenchWare Performance Suite (PeakMarks).
• Install and configure Oracle SwingBench utility to generate OLTP and DSS data traffic/load.
• Configure storage array LUNs, parity and storage groups using Confidential Command Suite/Storage Navigator.
• Write Unix/Linux shell scripts to automate system tests and data collection.
• Install OEM12c and demonstrate the use of Confidential plugins for RMAN and ASM to various Confidential customers.
• Create Oracle RAC Data Guard environment (RAC primary to RAC secondary) and demonstrate primary to secondary failover, and recovery of the primary from the secondary.
• Setup and demonstrate Oracle database replication using Confidential Universal Replicator.
• Write white papers covering Hitachi’s T10-PI, OEM plugins for RMAN and ASM.

Contract DBA

Confidential, Sunnyvale, CA

Responsibilities:

• Write and present to management security specification document covering System Security Policy, Data Security Policy, User Security Policy, Password Management Policy and Auditing Policy.
• Write SQL and PL/SQL scripts to test implement the new security policies.
• Write documentation showing how to implement the new security strategy using the shell, SQL and PL/SQL scripts I wrote.
• Work with offshore DBA team, application and end user groups to schedule the implementation of the new security policies.
• Other work included writing RMAN scripts to do database backup and storage management, and writing scripts to automate database performance reporting using AWR/ADDM and shell scripting.
• Implement database tuning based on performance data from AWR and ADDM.
• Install/patch Oracle Ebusiness suite R12 including WebLogic for the CRM applications team.

Confidential, Sunnyvale, CA

Senior DBA

Responsibilities:

• Lead migration team to migrate the 10TB data warehouse to an Oracle 11gR2 RAC system using Oracle data pump (migrate legacy data) and Golden Gate (for replication of new incoming data)
• Write shell scripts to monitor Golden Gate replication
• Write shell scripts to create RMAN backups of the for the Exadata environment
• Explain data flow and schema for datamart to end users (hadoop -> datamart where obiee is used to mine the data), end users will mine the data using Oracle Business Intelligence (OBIEE 11g)
• Document and train junior DBA to support the installation and end user management of OBIEE 11g.
• Install Oracle Golden Gate 11g
• Setup replication to capture incoming data using Oracle Golden Gate (trail files, etc...)
• Debug and fix all problems associated with Golden Gate, create shell scripts to monitor the replication process
• Install OBIEE 10g with WebLogic for Red Hat Linux to support the Data Migration and the Engineering Metrics projects
• Upgrade OBIEE 10g to OBIEE11g and run the Repository Creation Uitility to create the OBIEE application schemas.
• Configure clustered OBIEE 11g on a four node Red Hat Linux cluster
• Write shell scripts to automate the startup/shutdown of OBIEE services including WebLogic Server, Node Manager and the Admin Server.
• Improve OBIEE/Weblogic performance by offloading HTTP data traffic.
• Evaluate/recommend NoSQL databases Cassandra, MongoDB, HBASE and Oracle NoSQL for use in creating the Engineering Build Metrics Dashboard.
• Install R, MongoDB, R HADOOP/HBASE
• Create collections and write shell script to populate and index collections.
• Write scripts to load data into Oracle that comes from the output of MongoDB map reduce, data is accessed using OBIEE data mining tool.
• Create documentation showing how to use the NoSQL database MongoDB. The documentation showed how to create tables, INSERT/Modify data in the tables
• Provide DBA support for Confidential Quality Center project
• Migrate single instance pilot QC/ALM database to a 11gR2 RAC environment running on the Red Hat linux platform (RHEL5)
• Create HA solution using Oracle Data Guard/standby datamase.
• Use RMAN to create multiple Data Guard environments
• Tune/configure Oracle Data Guard for maximum throughput
• Setup Oracle Data Guard to support Oracle RAC
• Document all processes and procedures used and train DBA team to support the system
• Choose and procure servers that will be used for the project
• Implement Control Data Capture for the Burt-N-Oracle project.
• Document all processes and procedures involved with implementing CDC.
• Install and configure Oracle Golden Gate to MySQLreplication
• Develope scripts to monitor Golden Gate replication
• Integrate Golden Gate monitoring scripts with OEM/UDP allowing OEM to monitor Golden Gate replication
• Upgrade from Oracle 10g to Oracle 11gR2 the databases used for capturing/storing data associated with building the Confidential ONTAP operating system
• Replicate data to the report server using Oracle Golden Gate
• Create highly available system using Oracle Data Guard/standby database.
• Backup and Disaster and Recovery Project
• Created and documented the backup and disaster recovery strategy for Confidential 's Database services group. This strategy is used to backup all application data that uses either a MySQL or Oracle database managed by Confidential 's Database Services group.
• Write shell scripts to automate Oracle RMAN backups.
• Developed methodology for reducing the time to backup and recover very large databases using Confidential 's Snapshot technology. Testing showed that very large databases are backed/recovered in minutes rather than hours.
• Developed scripts to implement data protection by replicating database backups to multiple sites using Confidential SnapMirror technology and Linux shell scripts
• Improve database performance and availability using AWR/ADDM
• Implement database hot backups
• Work with end users on SQL statement tuning
• Installed/configured open source system monitor Nagios to monitor Oracle/MySQL databases, disk/storage utilization and various Linux server processes.
• Install/configure MySQL InnoDB on VMWare ESX
• Create shell scripts for backup and recovery using MySQLDUMP
• Recover databases or corrupted/dropped tables
• Configure/monitor data replication
• Create MySQL Loader scripts to load dumped from Oracle
• Create shell scripts to sanitize the MySQL data prior to loading into Oracle
• Write shell scripts to monitor and re-start Apache web server
• Support/modify Perl scripts used to load text file data into MySQL database
• Create end user accounts
• Assist end users with tuning/indexing the data
• Migrate MySQL v4 and v5 databases to Oracle 11g
• Create project plan
• Create diaster recovery strategy with the application team
• Create project list of activities/tasks, responsible person/group, schedule/completion dates and project status
• Procure Linux servers to support Oracle RAC, OEM and Oracle Business intelligence (OBIEE/WebLogic)
• Install Oracle Enterprise Manager 11g (OEM) to monitor all databases and setup email alert notification
• Choose and procure servers that will be used for all Oracle database projects
• Create/test backup and recovery scripts using Recovery Manager (RMAN) and shell scripts
• Write shell scripts to automate backup, performance data collection and monitoring.
• End user management including working with customer to define user groups and which privileges they need and which tables users can access based on the group they are in
• Database Performance and tuning, including: Monitor system performance using OEM/SQL and shell scripts, SQL statement tuning, creating EXPLAIN plans using Tkprof/Hints/indexing, AWR/ADDM analysis, adjust database performance parameters to improve system performance.
• System Performance/tuning including: capture operating system performance using netstat, vmstat, sar, TOP, adjust operating system parameters to improve system performance.
• Index data to improve query performance
• Create/test triggers, procedures and functions written in PL/SQL
• Ceate/test/execute programs written in cshell, bourne or bash script
• Indexing data to improve query performance
• System tuning using AWR/ADDM
• Configure Oracle ASM to improve storage sub-system response.
• Document application schemas using Erwin Data Modeler
• Work with junior DBA to define project task, timelines and provide guidance for application/database rollout
• Application/database capacity planning for storage space and system/CPU utilization
• Install Nagios to monitor server and database availability (Later replaced by OEM for Oracle dartabases).

Confidential, Sunnyvale, CA

Oracle DBA UNIX administrator

Responsibilities:

• Install configure and support Oracle 9.2 on the Windows 2000 and the Sun Solaris platforms
• Install and configure Solaris 5.9 operating system on the Sun 450, 440, 880 and Sun 220R servers
• Configure disk IO subsystem to optimize database performance
• Install and configure Oracle Enterprise Manager (OEM) to manage QA and development databases
• Optimize SQL queries to improve database application performance and use PL SQL to write a transaction counter for the IDS product.
• Work with NAI professional services to install and configure NAIs Intrusion Detection System (IDS v1.9) with Oracle RDBMS v9.2 at customer locations including Ameriquest Corporation and QUALCOMM Corporation.
• Work with technical publications group to document Oracle RDBMS best practices for the Confidential IDS product for Oracle on Solaris and the Windows operating systems.
• Write shell scripts to automate database backups.
• Develop instructional applications using SQL*PLUS, PL SQL, ORACLE*FORMS 3.0 4.0 and ORACLE*REPORTS 1.0 2.0.
• Develop and teach the course Introduction To Oracle for DBAs.
• Upgrade Oracle DBA course material from Oracle8i to Oracle9i

Confidential, Fremont, CA

Technologies Oracle DBA

Responsibilities:

• Migrate from MySQL v3 to Oracle v9.2. Includes extracting data from MySQL database and loading into the Oracle database using SQL*LOADER and PL SQL.
• Minimize the storage required to install and configure Oracle 9.2 on Windows 2000 to support the Confidential Semiconductor Transport System.
• Query SQL statement tuning using TKPROF
• Implement database high availability solution using Oracle Data Guard
• Write shell/RMAN scripts to automate Oracle database backup
• Application schema design and analysis using Erwin
• Write update system installation and training documentation

Confidential, Mountain View, CA

Oracle Performance DBA

Responsibilities:

• Migrate data warehouse from Oracle 8.1.7 to v9.2.0.2
• Migrate database from HPUX 11.0 to Suse Linux SLES7
• Correct database fragmentation
• RDBMS system tuning using Oracle STATSPAK
• Write shell scripts to automate database backup and gathering of operation system performance data (CPU, memory and IO utilization).
• Implement database high availability solution using Oracle standby database

Confidential, San Francisco, CA

Senior Oracle DBA

Responsibilities:

• Write database encryption algorithms using Oracle Obfuscation Toolkit to implement the data encryption standard (DES) for the World Saving Online Banking web application.
• Write and test recovery manager (RMAN) backup and recovery scripts
• System tuning using Oracle ESTAT BSTAT and STATSPACK
• SQL statement tuning indexing using the Oracle trace facility and TKPROF
• Write scripts, procedures and triggers to load ASCII data into the database using Oracle SQL*LOADER and PL SQL
• Support the production and QA (quality assurance) systems
• Install and configure Oracle Transparent Gateway for Microsoft SQL-Server. This allowed for the creation of management reports using data from the Oracle and the SQL-Server databases.
• Write scripts in JAVA (J2EE) to test Oracle JDBC drivers
• Write shell scripts to automate database backup and the gathering of system performance data.
• Install, configure and support Oracle 11i applications AR, AP and General Ledger.
• Install Oracle 11i patches using the utility ADDPATCH
• Upgrade Oracle database from 8.1.6.1 to 8.1.7.3 for Oracle Financials 11.5.3
• Load Oracle payables interface tables using SQL*LOADER
• Use Oracle 11i financials Purge Archive utility to offload end of month data.

Confidential, Fremont, CA

Lead Oracle DBA and Quality Assurance

Responsibilities:

• Install and configure Oracle8 and Oracle8i and Oracle9i on the Sun Solaris, HPUX, AIX and Linux platforms
• Install and configure Solaris 2.7 and 2.8. Install and configure HPUX 10 and 11.
• Install Oracle 11i application development tools Oracle Forms Forms Server 6i and Oracle Reports Reports Server, Oracle 9iAS application server.
• Install and configure MS SQL-Server RDBMS on Windows NT
• Install and configure IBM DB2 RDBMS on the Sun Solaris platform
• Write scripts using UNIX shell, PL SQL, SQL*LOADER and SQL*PLUS to generate and collect database statistics for benchmarking
• Write the Confidential Oracle database backup utility. The shell script is used to automate database backup with or without Oracles RMAN utility.
• Develop interface between Oracle RDBMS and Veritas Netbackup.
• Install and configure Veritas cluster (VCS) and Veritas Volume Manager with fast IO on the EMC Symmetrix SAN to support RDBMS fail-over testing.
• Configure IBM AIX server to support the Oracle parallel server (OPS using IBM HACMP).
• Install and configure Rational ClearCase problem and change management software.
• Develop and conduct Oracle database training courses for Confidential engineers, consultants and marketing
• Support multiple large databases. Database size and activity are approximately 3 TB at 150 TPS
• Develop and implement table and index partitioning for databases over 500 GB (VLDB).
• Install and configure Nagios to monitor server, storage and database availability
• Write shell scripts to extend Nagios Oracle database support.
• Develop reports server using SNAPSHOT replication.

Confidential, Mountain View, CA

Lead DBA

Responsibilities:

• Design input schema and output star schema to support the data warehouse application
• Write data loading scripts using PL SQL, SQL*LOADER and UNIX shell script (HPUX 11.0)
• Install and configure HPUX 11.0 on Confidential K, N and L machines.
• Write database backup and recovery utilities using RMAN and shell scripts
• Install and tune databases in US, Brussels and Singapore to support the system
• Write scripts to monitor both database and operating system utilization
• Design application data model using Erwin
• Implement master to master data replication using Quest Software SharePlex
• Use end user reporting requirements to design star (constellation) schema for the warehouse data marts
• Install and manage MS Visual SourceSafe to support the developers and QA testing.
• Install and configure Oracle RDBMS on Red Hat Linux as a report server solution.
• Install and configure Oracle application server (Oracle 9ias) to support Oracle Reports
• Implement cascade replication to push data from the US database to the databases in Brussels and Singapore.
• Consolidate data from Confidential Brussels and Confidential Singapore databases into the Confidential US data warehouse.
• Implemented table and index partitioning for large tables and indexes in the data warehouse.

Confidential, Emeryville, CA

Lead Oracle DBA

Responsibilities:

• Install and configure Oracle8i on Red Hat Linux and Sun Solaris
• Write scripts in SQL and UNIX shell script to perform hot, cold and logical backups of the Oracle database.
• Implemented reports server using Oracle SNAPSHOT replication.
• Develop scripts to monitor database and system performance.
• Tune SQL queries using table indexing and table partitioning
• Write scripts in JAVA (J2EE) to test Oracle JDBC drivers
• Develop database table-indexing strategy to improve response of the Confidential web site.
• Lead DBA supporting the development, QA and production databases.
• Develop scripts procedures triggers in PL SQL to determine all relationships constraints in the database. The resulting report is used to correct the table relationships determined from using Erwins reverse engineering feature.