Objective

Senior Database Administrator in a software development and production environment

Experience

Jan 2006 – July 2007, July 2010 - present Confidential Glendale, CA
Senior Oracle DBA
As Senior Oracle DBA, performed installation, upgrade and maintenance for the Oracle 11gR2 (4 node) RAC databases for 24X7 production support on Linux platform. Also conducted performance tuning and database/recovery for database disaster planning and implementation with Oracle Data Guard, RMAN and EMC BCV SAN snapshots. Designed and developed bi-directional Active-Active Oracle Streams Replication for 99.99% database high availability over WAN. Developed OEM 10g Grid Control, UNIX shell and Perl scripts for database monitoring; provided SQL and PL/SQL tuning and programming support to Oracle Application Server staff.

April 2007 – July 2010 Confidential Monterey Park, CA
Senior Oracle DBA
As Lead Senior Oracle DBA, speared head installation, upgrade and maintenance for over 30 Oracle 9i/10g/11g databases including RAC with Streams Replication for 24X7 production support on Solaris/Linux/AIX platform. Conducted performance tuning and optimization for Datawarehouse databases for DSS Informatica applications. Performed disaster recovery planning and implementation with Oracle Data Guard, RMAN and NetApp Snapshot technology. Deployed Oracle Grid Control and UNIX scripts for enterprise database monitoring and tuning. Provided SQL and PL/SQL tuning and programming support to application development staff.

Aug 2007 – Mar 2008 Confidential Burbank, CA
Senior Oracle DBA
As Senior Oracle DBA, performed installation, upgrade and maintenance for the Oracle 10g (3 node) RAC databases for 24X7 production support on SUN Solaris platform. Also conducted performance tuning and database/recovery for database disaster planning and implementation with Oracle Data Guard, RMAN with Veritas Netbackup. Developed OEM 10g Grid Control and UNIX scripts for database monitoring with SOX security; provided SQL and PL/SQL tuning and programming support to application development staff.

April 2004 – Dec 2005 Confidential Santa Monica, CA
DBA Manager/Senior Oracle DBA
As DBA Manager, managed a team of Oracle and SQL Server DBA’s in supporting the corporate OLTP and data warehousing databases. As Senior Oracle DBA, performed installation, upgrade and maintenance for the Oracle 9i databases for 24X7 production support. Also performed performance tuning and database/recovery for database disaster planning and implementation with Oracle Data Guard, data replication and database cloning for QA testing. Developed UNIX shell scripts for database maintenance and monitoring functionalities; provided SQL and PL/SQL tuning and support for Web Engineering staff in program development support. Designed and developed an in-house Oracle 10g data warehouse database for consumer experience research.

August 2003 – April 2004 Confidential Brea, CA
Perl/C# Developer (Contract)
Designed and developed Perl/C# financial application accessing Oracle databases with ADO.Net

August 2002 – August 2003 Confidential Pasadena, CA
Operations DBA ( Contract)
Acted as Operations DBA/Data Architect to perform server consolidation of over 120 Oracle 8i and Sybase 11.i servers to 4 AIX 32-CPU p-series Logical Partition systems. Conducted capacity planing and performance tuning for target systems. Performed database/recovery for database disaster planing and implementation with Oracle Data Guard, and other production support functions of the consolidated systems. Furnished and reported project plan and maintenance documentation to senior management. Developed PERL and UNIX Shell scripts to support database monitoring and maintenance.

March 2001 – Sept 2002 Confidential Santa Ana, CA
Senior Oracle DBA
Designed and developed both the OLTP and data warehousing databases for the company labor and budget reporting system, using Oracle 9i in a HP/UX environment. Developed and designed an OLTP accounting database system with ER modeling tool, ERWIN. Provided SQL/PLSQL and Java JDBC/SQLJ programming and tuning support to development staff. Developed PERL scripts to monitor database performance. Performed database backup and recovery functions with RMAN and Veritas Netbackup software. Set up Oracle Data Guard (Standby Database) for disaster recovery. Performed system and database performance tuning for data warehousing applications. Installed and maintained Oracle Financials applications and Oracle Enterprise Manager on Windows 2000.

Sept 1991 – Feb 2001 Confidential Colorado Springs, CO
Principal Database Administrator

• Developed near real-time telephone fraud detection system with VAX/VMS and Sybase RDBMS.
• Developed Client/Server UNIX application with Sybase Open Server/Client API and TCP/IP socket library in C++.
• Developed cross-platform SQL database access C++ class library using ODBC, Oracle OCI and Sybase ctlib APIs.
• Developed and maintained the ASSET Management Department Intranet Web Site using Cold Fusion Web development tool, PERL CGI scripts and SQL Server. Developed PERL scripts to generate makefile dependencies for software configuration management.
• Developed C++ object-oriented data warehousing and reporting application for the corporate revenue data using Sybase 10 and Oracle 8i database on a SUN Solaris platform. Acted as C++ mentor and team lead to the team.
• Acted as Principal Oracle DBA, coordinated with system administrator and other DBA’s in designing and maintaining an electronic trouble ticket management system using Oracle Parallel Server and C++/Java CORBA technologies on a SUN Solaris E10000 Veritas clustered platform. Developed Server side Java database access layer and Java stored procedures. Other major responsibilities include:
• Performed daily and scheduled database backup and recovery, using Legato and Veritas DLT tape backup robotic systems and Oracle DBMS_JOB job scheduling package.
• Monitored and tuned the Oracle databases to enhance OLAP performance and response time for user access. Average concurrent number of users online was about 2500 worldwide and acceptable response time was not more than 5 seconds for average data warehousing applications on database size up to 500 gigabytes in size. Oracle performance tuning tools used include Explain Plan, TKPROF, SQL*Trace and Oracle Expert.
• Provided proactive database capacity planning utilizing Oracle 8i database partitioning, Oracle Parallel Server (OPS) option, and RAID-5 clustered storage techniques.
• Implemented Oracle databases for their logical and physical designs using Oracle Design 6i, ERWIN and Power Designer ER database modeling tools.
• Designed and implemented database disaster recovery plan to ensure data availability and integrity.
• Mentored and supported junior DBA’s in maintaining the 24x7 production databases.
• Developed and optimized PL/SQL and Java stored procedures and packages for maximum database access performance.
• Designed and developed data warehousing application using Oracle 8i R2 features: Populated ODS through data aggregation by creating staging, fact, dimension and summary tables using Oracle partitioning techniques and Dimensional Data Analysis methodology. Loaded source data through the ETT (Extraction, Transformation and Transport) process. Made extensive use of PERL programming to perform data cleansing and transformation.

May 1999- March 2000 Confidential Colorado Springs, CO
Senior Software Engineer
Designed and developed server side gateway services for outsourcing email using Oracle 8i and C++ on a Sun Solaris platform.

Jan 1987–Aug 1991 Confidential Denver, CO
Independent Consultant
Provided consulting services to clients in training, system management, troubleshooting and project management. Areas of service include UNIX, VAX/VMS, VAX/Rdb, Ingres and Oracle.

Education

Confidential University 
Enrolled in M Eng. Degree program majoring in Computer Telecommunications
Confidential University 
Graduated with B.S.E.E. in Electrical Engineering.
Graduated Summa Cum Laude.

Management Training

Dale Carnegie Course.
Certificate of Professional Management.