SUMMARY:

• Over ten years of experience in software development and information systems
• Strong technical hands on experience in Oracle 11g/10g/9i/8i databases
• Experience in developing web applications using Oracle PL/SQL, Perl, CGI, TSQL, Tcl/Tkl, as well as other SQL flavors, ETL tasks, database and query optimization (Analyze, Explain Plan, TKPROF)
• Strong analytical skills including the ability to transform complex business
  requirements into a successful system design
• Database/System Administration with 8 years of professional experience in administrating various systems including UNIX administration.
• Understanding of XML and HTML
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment
• Excellent interpersonal and communication skills and willingness to learn new tools, concepts and environments

TECHNICAL SKILLS

Databases: Oracle, Sybase, Microsoft SQL Server, MySQL
Operating systems: UNIX (Solaris, HP-UX, IBM AIX), Linux (Red Hat), Windows NT, PICK/REALITY Operating System, OS/MVS
Languages: PL/SQL, Perl, Tcl, Expect, JavaScript, UNIX shell, C, SAS
Applications and Tools : PL/SQL Developer, TOAD, Oracle Enterprise Manager, Brio 6.0, SQL*Loader,
SQL*Plus, DB Artisan, Oracle Parallel Server, Oracle Application Express,
Sybase ASE 11.9/12.0/12.5, Sybase Central, Replication Server 12, SQL
Advantage, BMC SQL-BackTrack, Legato Networker, IBM ADSM, Veritas
Volume Manager, Veritas NetBackup
MC/ServiceGuard, HP Glance Plus, HP Omni Back II v.255, Remote Control
Web Servers : Apache Web Server 1.3/2.0, Apache Tomcat 4, Netscape Enterprise Server 6.0

Confidential,Menlo Park, CA 12/2005 – present
Confidential,Senior Database Engineer/Developer/DBA
Environment: Oracle 9i/10g/11g, Windows, Unix

• Responsible for database side implementation and development of PES (Partner Engagement System) releases using PL/SQL, SQL and Unix Shell scripting
• Migration of data through ETL processing from transactional systems to reporting systems
• Designed and implemented customized analytical reports for existing system using Brio
• SQL query optimization using Hints and utilities like Explain Plan, Auto Trace.
• Maintained data model via ERWIN
• Worked extensively to formalize the logical design using ERWIN and physical creation of database objects like tables, view, sequences, function, packages, procedures etc.
• Created and maintained database objects: tables, views, materialized views, indexes, constraints, triggers, sequence, synonyms and database link.
• Extensively used PL/ SQL blocks Collection, Procedures, Functions, Packages and Triggers for implementing complex business logic.
• Develop and maintained DB utilities to extract and load sets of data between the different systems
• Performed automated data load using shell scripting and Oracle tools and techniques such as: SQL*Loader, export/import, external tables
• Develop ad-hoc and on-demand reports using Brio
• Automated data load for I18N project using Unix shell scripting and Oracle tools and techniques such as: SQL*Loader, export/import
• Created UNIX Shell scripts for sending email to alert users for erroneous records.
• Cloning/Refresh Databases
• Perform data analysis to evaluation the existing interfaces, business needs and provide solution
• Worked with business departments to understand their reporting and business needs. Translated requirements into functional and technical specifications
• Perform data mapping, data mining and data cleansing
• Perform unit and integration testing and debugging and set test conditions based on code specifications
• Responsible for designing, developing, specification of test plans

Confidential,Newark, CA 04/2003 -12/2005
Network Storage
Senior Database Developer/Product Quality Data Lead
Environments: Oracle 9i, Unix, Perl, Javascript

• Developed a number of entirely new applications, store procedures, packages for reporting different product metric/scorecards with the goal of improving product availability and quality using PL/SQL, Tcl, Perl, CGI, Javascript, Lout, Unix Shell Scripting
• Used SQL Navigator to reverse engineer the model of the legacy applications.
• Assisted in the implementation Oracle OLAP, data mapping, data migration
• Implemented automated syntactic CLI test software for Honeycomb products using Perl, Tcl/Expect
• Design, develop and implement Health Check tracking process to improve customers quality experience using PL/SQL, HTML, Tcl, Perl, CGI, Javascript
• Performed data mining, created, and delivered custom reports, data models to help analyze different product quality metric (Escalations, Bugs, Radiance Cases, Install Base, FIN/FCO\'s, CPAS and etc...) using Brio, Perl for he Network Storage products
• Provided Quality Engineering support to product development teams during development and maintenance
• Built Web Pages with HTML, Java Script and CSS
• Implemented conversion of programs/reports from Scopus to Apollo (Sybase 12.0 to Oracle 9.0)
• Make all the programs/report/tools BugTraq2 compliant using Perl, CGI, Lout (PDF creation module)
• Perform data analysis utilizing establish scorecards of the Remote Monitoring/Telemetry Compatibility
• Fault tolerance/management metric, identifying product quality highlights and low lights
• Design, develop and implement NWS QCC Lesson Learned database and application utilizing PL/SQL, Perl, CGI, HTML
• Built new BRIO queries, user interfaces, and reports from scratch

Confidential,San Jose CA 09/1999 - 03/2003
Senior Database Developer/DBA//Unix System Administrator
Environments: Oracle 8.x/9i/Unix

· Developed packages, store procedures, functions, triggers using PL/SQL to support Facets application
· Responsible for non-stop (24X7) operation of all critical Lifeguard production environments running on Oracle 8x/9i databases on Solaris8
· Designed, implemented and maintained user security, resource utilization, etc. for both databases and
Unix servers by creating SQL, UNIX shell, Perl scripts
· Configured, administered, designed, implemented and tested failover strategy for production
environment using MC/ServiceGuard HP clusters
· Used XP-256 Remote Control to configure disks on XP-256 for disk storage reallocation
· Installed and configured Veritas Volume Manager and File system software on several Solaris servers
· Implemented RAID 5, created and maintain logical volumes using Veritas Volume Manager
· Management of Sendmail, Samba, DNS, NFS, NTP, Secure Shell, and Secure FTP applications
· Perform Solaris 8 and HP-UX 11.0 system administration including installation, configuration,
maintenance and logical volume management on L, K, N – classes HP boxes
· Maintain databases and UNIX Solaris and HP servers and their components through version upgrades
· DBA Lead in developing standards, policies and procedures related to database design and data
analysis
· Plan and design databases including local structures and forecasting further expansion
· Plan and implement backup/recovery strategy using Omniback and SQL-Backtrack
· Design, tune and monitor Oracle databases for performance
· Install and upgrade main Lifeguard application software Facets (complete medical insurance
processing system) on multiple platforms
· Develop SQL/UNIX/Perl/Tcl scripts to perform database and UNIX system maintenance
· Design, develop and implement robust enterprise infrastructure for XP-256

Database and System Engineer
Environments: Oracle 8.x/Unix

• Provided escalated level (including 24X7 support) to Sybase/Oracle DBA’s and UNIX/NT

system administrators on the backup and recovery of Sybase/Oracle databases

• Administrated Oracle and Sybase, SQL databases. Duties included server’s installation, database creation, and different backup/recovery scenarios testing.
• Installed and configured third party storage management software (Legato Networker, IBM ADSM, OmniBack).
• Implemented database backup and recovery strategy, developed and implemented various disaster revovery scenarious for external customers using SQL BackTrack and storate management software.
• Mentored new hires, provided training on databases and company products.
• Monitored the growth of database objects, fragmentation of database objects and capacity planning

Confidential,Palo Alto, CA 04/1996 - 09/1998

Database and Data System Administrator

• Focus on administration, configuration and maintenance of Oracle/Sybase databases
• Designed and developed database model for multi-user distributed system architecture
• Developed / documented processes and procedures
• Responsible for development and support of Perl and UNIX shell and Expect scripts to automate data processing
• Lead a project to create a migration strategy through new versions of Phone Print

· Supported Sybase databases on UNIX platforms (Solaris, HP-UX).

Confidential,San Jose, CA 01/1995 - 04/1996 Unix System Administrator/Programmer
· Design code and implement performance enhancements to meet customer requirement
· Client-side UI programming using Microsoft Visual C++/C
· Performed UNIX System Administration, network traffic control, system installation, upgrades,
maitenance and testing
· Worked with Informix to build UI’s to in-house databases under UNIX
· Designed, implemented and maintained user security, resource utilization for both databases and Unix
servers by creating SQL, Unix utilities(shell, awk, sed) and Perl scripts

Confidential,San Jose, CA 06/94 - 01/95
Programmer/Analyst
· Responsible for developing, coding and debugging of Instructions and Paper Inventory interface with
the PICK/REALITY Operating System
· System Administrator/MIS Administrator functions; evaluation of in-house computer hardware and
software to ensure user needs
· Maintenance and modification of Payroll, General Ledger and Account Payable systems

EDUCATION

Computer Science
BS, Major - Computer Science, Minor - Physics

Oracle courses: Enterprise DBA Part 1: Architecture and Administration, Oracle Performance Tuning Basics, OracleTuning Oracle SQL, Oracle Tuning Oracle instance, Oracle 9i – Program with PL/SQL, Database Administration for Oracle 8.x
SYBASE Courses: Fast Track to SQL Server, SQL Server Administration, Advanced Transact-SQL Techniques, Fast Track to Replication Server, Replication Server Disaster Recovery, Performance and Tuning: Configuring Adaptive Server Enterprise System and Database Administration for ASE 12.0, Performance & Tuning: ASE Query Optimizer
MICROSOFT Certified Course: Supporting Windows NT Server 3.51