SUMMARY:

• Highly motivated and skilled Information Technology and Bioinformatics Professional. 16 years Oracle DBA, network and Unix/Linux Administration experience. Oracle versions (8, 8i, 9i, 10g and 11g). 5 years Bioinformatics data and database experiences. Database sizes up to 2 Terabytes. Complete Oracle lifecycle from concept to design, architecture, hardware selection, installation and patches, database creation, backup/recovery scripting and testing (with IBM Tivoli, RMAN and EMC Symetrix), database security, database performance tuning and monitoring, event notification, waits, locks, automated scripted creation and refresh of reporting databases from production and mentoring developers. Veritas Cluster Server and Real Application Cluster (RAC). Standby database (DataGuard). Utilize a large personal collection of tuning, performance monitoring and bottleneck identification scripts. Use a number of database design tools including Erwin and Enterprise Architect UML Designer. Highly skilled in program languages: SQL, PL/SQL, Perl and Shell Scripts.

TECHNICAL SKILLS:

Software:   

• Oracle 8i
• 9i
• 10g
• 11g
• SQL
• PL/SQL
• Enterprise Architect UML
• Erwin
• UNIX Shell Scripts
• Perl and BioPerl
• XML
• HTML
• Java SDK
• JSP and Servlets
• DBVisulizer. Oracle Developer 2000 Form and Report Builder
• Platinum Erwin 3.5.2 Toad (Quest)
• Microsoft Visual Sourcesafe - PVCS NetTerm Secure CRT
• Secure FX; WS FTP; Hummingbird X
• MS Access
• MS Word
• MS Excel
• MS PowerPoint
• Visio
• MS Project
• Unix/Linux

Hardware:

• Sun Sparc 420R
• 220R
• E450
• Ultra 2
• Sun Solaris E15000
• IBM Tivoli Storage
• Linux and various PC EMC Symetrix

PERSONAL STRENGTHS:

• Tenacity and diligence during challenging assignments
• Demonstrated leadership and team building capabilities
• Exceptional ability to launch, and manage highly successful projects and ideas
• Versatility, adaptability and willingness to tackle new responsibilities
• Self-assured, assertive, self-confident, and aggressive

PROFESSIONAL PROFILE:

• Mastery of all phases of the product development life cycle, including requirements definition, design, development, implementation, testing and support
• Particular expertise in Oracle Database and UNIX/LINUX Administration.
• Adaptability to changing workplace conditions, job responsibilities and new technologies
• Ability to multi-task with ease in high-pressure, fast-paced environment
• Analytical approach to resolving technical challenges; attention to detail
• Ability to work equally well collaboratively or independently

PROFESSIONAL EXPERIENCE:

SEnior Oracle DBA  Confidential, Rockville, MD

• Database Design: Successfully designed a database to handle the orders and information transaction (by Telephone, FAX, E-mail and web), warehouse inventory tracking, warehouse item location and receiving etc.
• Database planning and implementation: Plan and install oracle databases in the development, test and production UNIX environments.
• Database Backup and Recovery: Plan, design and implementation of database backup and recovery system for our oracle database.
• Data Migration: Successfully migrated data from several sql Server database to the oracle database by using PL/SQL, SQL.
• PL/SQL development: Developed the interface between the shipping system (Hasler) and Oracle database. Developed packages to transfer orders from sql server database to oracle database.
• Routine database support: Production database monitor and tuning and support for the development team. Handle various data request for about 10 projects.
• Data Warehouse design, development.  Administration of MicroStrategy and Use MicroStrategy to develop various reports and Jasper Report Developer.
• SQL SERVER 2000, 2005, 2008 and 2012 Administration

DATA/Database ARCHITECT  Confidential, ROCKVILLE, MD

• caBIO: Design, develop and implement the caBIO (Cancer Biology) database to handle various biological data including genomes, sequences, genes, proteins, snps and microarrays, etc. Large amounts of various biological data were downloaded, mapped, parsed and loaded into the databases using Java, Perl, SQL, PL/SQL and UNIX shell programming.
• NCIA: Design, develop and implement the NCIA (National Cancer Image Archive) database to handle various medical and clinical images, including dicom images.
• caMOD: Design, develop and implement the caMOD (Cancer Mouse Model) database to handle various mouse, yeast and other model organism used in the Cancer researches .
• caLAB: Design, develop and implement the caLAB (Cancer Laboratory) database to handle various laboratory data. This LIMS (Laboratory Information Management System) system is currently used by a NanoTechnoogy laboratory.

Database Administrator  Confidential

• Routine Oracle Database Administration on about 20 development and production databases: upgrade database from Oracle 8i to Oracle9i and from Oracle9i to Oraclec10g, install patches, database creation, database security, database backup and recovery using rman and IBM Tivoli storage, oracle internet directory setup and maintenance, database performance tuning, database performance monitor and report using OEM and UNIX scripts.
• Help Virginia Bioinformatics Institute to obtain two multi-million database grants (NIAID Bioinformatics Resource Center and NIAID Proteomics Center)
• Design, develop and build relational databases (Oracle, MySql and PostgresSQL) to host the following biological data.
• Genomics: Create several multi-organism relational databases in support of infection research of Bioinformatics Resource Centers (BRC), especially as it affects biodefense. The database was built based on Genomics Unified Schema (GUS). High quality curated genomic data was loaded into the databases using PERL and BioPERL program.
• Transcriptomics (Microarray): Installation and Maintenance of Affymetrix GCOS Microarray software and database, Microarray and Gene Expression (MAGE) database.
• Proteomics: Create several relational databases to host proteomics data, including 2D gel, Mass spectrometry, yeast two hybridization, and protein interaction in support of NIAID Proteomics Center. Various Proteomics data with different format was loaded into databases using PERL and SqlLoader
• LIMS (Laboratory Information Management System): Installation and administration of the following LIMS systems and databases: iLIMS (Beckmen Coulter), CALIMS (National Cancer Institute) and Worksbase (Bio-Rad) for proteomics.
• Database tools and other software installed/used: Erwin, Toad, DBVisulizer, Oracle Enterprise Manager (OEM), Oracle Recovery Manager (rman), Oracle import and export, Oracle sql Loader, Apache, Tomcat.

Oracle DBA/Unix System Administrator Confidential

• Six UNIX machines, One EMC Symmtrix Storage and various EMC softwares, Cisco Router and Firewall, Cisco Content Services Switch, Cisco Catalyst switchs, Solaris 2.6, Stronghold web server as a Proxy server, Weblogic Application Server, Oracle 8i Client and Server, Veritas Volume Manager, File System and Cluster Server.
• Configuration and administration of various Cisco equipment mentioned above, also configuration and administration of UNIX machines in the network. Administration of EMC Symmtrix and Veritas Cluster Server. Installation, configuration and administration of Web and Application servers including Apache, Stronghold and Weblogic (BEA system).
• Installation, configuration and administration of Business Intelligence products including Cognos and BusinessObjects. Using them to create reports. Spearheads all aspects of coding application programs and scripts in compliance with system designs ascertained as appropriate by the System Analyst. Effectively solves application defects expediently.
• Established a documentation tracking database using Microsoft Access that stored UNIX/Perl commands, flow charts, vacation time, and an array of diverse documents utilized on a daily basis.
• Oracle Database Administration:
• Design and development of Oracle Database (8i)
• Installation of Oracle server and client in UNIX and PCs.
• Creation of Oracle Database and various database objects.
• Database backup and recovery.
• Database performance tuning.
• Manage Physical Standby database (DataGuard)
• Manage Oracle Parallel Server Cluster (RAC)
• Other routine DBA work.
• Development of many SQL and PL/SQL programs.
• Administration of one Oracle Financials 11i
• UNIX and Window NT/2000 System Administration:
• Installation of Solaris 2.6 and Solaris 8.
• Upgrading Solaris 2.6 to Solaris 8.
• Setting up and maintenance of DiskSuite and various DiskSuite objects (Disk Stripping, Raid 5 and Mirror).
• Setting up and maintenance of Veritas Volume Manager, Filesystem and Cluster.
• Backup and restore of UNIX files and file systems.
• Diagnosis of hardware and software problems of SUN SPARC machines.
• Monitoring and Tuning of the Performance of UNIX machines
• Configuration of X-window system.
• Other routine administration of nine UNIX machines.
• Development of many UNIX Shell and PERL programs.

Intensive Oracle DBA and Developer Confidential

Research fellow Confidential

Responsibilities:

• Used GCG (installed in UNIX) to analyze DNA and protein sequence. Searched Genebank sequence database of NCBI through Internet. Used various bioinformatics data mining software, such as DNASIS, Gene Jokey to analyze DNA and protein sequence, structure and function. Used NIH image and Microsoft Excel to analyze various biological data.