TECHNICAL SKILLS:

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

Oracle DBA

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.
• Install and configure Oracle Golden Gate to MySQLreplication
• Perform “silent error” injection test to verify Confidential ’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 plugins for RMAN and ASM to various Confidential customers.
• Create shell scripts to sanitize the MySQL data prior to loading into Oracle
• 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 Universal Replicator.
• Write white papers covering T10-PI, OEM plugins for RMAN and ASM.

Confidential, Sunnyvale, CA

Oracle DBA

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 policies.
• Write documentation showing how to implement the new security strategy.
• 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 and shell scripting.
• Install/patch Oracle Ebusiness suite R12 for the CRM applications team.

Confidential, Sunnyvale CA

Senior Oracle DBA

Responsibilities:

• Install/configure MySQL InnoDB on VMWare ESX
• Create shell scripts for database backup and recovery using MySQLDUMP
• Use MySQLADMIN to perform most database administrative operations (create end users, monitor query performance, check server configuration, create databases, password management, start stop server replication).
• Restore/recover database or dropped/corrupted tables
• Configure and monitor data replication.
• Work with application developers to improve database/query performance.
• Configure Oracle Golden Gate for replicating data between Oracle and MySQL databases.
• Configure Nagios to monitor and database availability and send email alerts if a problem occurs.
• Migrate MySQL v4 and v5 to Oracle 11g
• Create MySQL Loader scripts to load dumped from Oracle into MySQL
• 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

Confidential

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 system end user management of OBIEE using Weblogic and OEM
• 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

Confidential

Responsibilities:

• 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.

Confidential, Mountain View, CA

Provide DBA support

Responsibilities:

• 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

Confidential

Responsibilities:

• 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 NetApp ONTAP operating system
• Replicate data to the report server using Oracle Golden Gate
• Create highly available system using Oracle Data Guard/standby database.
• Created and documented the backup and disaster recovery strategy for NetApp's Database services group. This strategy is used to backup all application data that uses either a MySQL or Oracle database managed by NetApp'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 NetApp'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 NetApp SnapMirror technology and Linux shell scripts

Confidential, Sunnyvale, CA

Responsibilities:

• 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.
• 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 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
• 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 Confidential and Confidential.
• 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.

Confidential , Fremont, CA

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 ASYST 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