SUMMARY:

• 16 years of MySQL experience
• 12 years of Oracle experience
• 20 years of Linux & Unix experience

TECHNICAL SKILLS:

Database: MySQL, ORACLE, Sybase, SQL ServerWeb Application Apache, TomCat, .NET

Languages: Java, Python, Shell, Perl, C ++, PHP, UNIX CCASE & 4GL Hibernate, Content Central, Business Object, ERwin, JMeter

Operating Systems: Linux, Solaris, AIX

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Sr. DBA

Responsibilities:

• Configure, create and maintain physical database including hardware and software settings to support the high - traffic web sites and highly available scale-out architecture for growth;
• Design & implement SQL/NoSQL database backup procedure & HA feature;
• Design & implement SQL/NoSQL database multiple instances & replication chains;
• Troubleshoot and resolve database problems occurring in production environments;
• Design & implement the database schema for business metric reporting system;
• Design the ETL solution with the document management tool;
• Establish the data management framework that improves the data quality and standards for both database structures and repository;
• Serve as an expert resource for data modeling, scripting and writing stored procedures;
• Investigate and learn new database technologies (Big data, Reporting tool, NonSQL, etc.) as needed to implement new features.

Environment: Linux, MySQL 5.7, Java, Shell, Perl

Confidential, San Jose, CA

Database Architect

Responsibilities:

• Create and implement database on-going backup and disaster recovery plan, strategy and procedures;
• Establish the database design and management guideline, conduct walk through of database related automatic batch jobs, data modeling, stored procedures and so on;
• Create and maintain technical documentation required to facilitate continue maintenance or enhancements of the production;
• Design, implement and monitor M to M and chained replication infrastructure to support the highly available scale-out architecture for growth;
• Database trouble shooting and performance tuning;
• Design & implement ETL process;
• Configure, create and maintain physical database including hardware and software settings at both Linux and MySQL levels.

Environment: Linux, MySQL 5.5, Java, Shell, Perl

Confidential, Cupertino, CA

Sr. DBA

Responsibilities:

• Design, implement and monitor the database architecture;
• Design, implement the database HA solution;
• Database trouble shooting and performance turning;
• Establish the database design and management guideline, conduct walk through of data modeling, stored procedures and so on;
• Create and implement database disaster on-going backup and disaster recovery plan, strategy and procedures;
• Provide 24 * 7 on call support on a rotational basis.

Environment: Linux, MySQL 5.1, Shell, Perl

Confidential, Oakland, CA

Lead database developer

Responsibilities:

• Configure, create and maintain physical database including hardware and software settings to support the high-traffic web sites and highly available scale-out architecture for growth;
• Outline and implement master to master, dual clustering and data shard infrastructure;
• Database Performance tuning & trouble shooting;
• Migration from Oracle 10g to MySQL 5.1 using MySQL migration toolkit and other third party utility to accomplish the process of schema mapping and bulk data transfer;
• Conduct walk through of database design including the entire architecture, physical & logical schema, selection of storage engines(innoDB, MyISAM, NDBCLUSTER), coding of stored procedures & triggers prior to deploying solution;
• Create and maintain technical documentation required to facilitate continue maintenance or enhancements of the application;
• Establish organization’s standards & guidelines for database design, implementation and maintenance;
• Create and implement database migration, backup and recovery procedures.

Environment: Solaris, AIX, ORACLE 10g, RAC, MySQL 5.0/5.1, MEM, Shell, Perl, Java, JReport8, Business Object

Confidential, Mountain View, CA

Sr. Database Designer

Responsibilities:

• Install, configure and administer both development and production DB;
• Troubleshoot and resolve database problems occurring in production environments;
• Create and interpret appropriate database benchmarks to quantify performance bottlenecks and propose solutions to enhance and optimize the overall scalability of the system;
• Establish the data management framework that improves the data quality and standards for both database structures and repository;
• Migrate database from ORACLE to MySQL;
• Serve as an expert resource for data modeling, scripting and writing stored procedures.
• Investigate and learn new database technologies (e.g., advanced queuing, multi-mastered replication, load balancers, etc.) as needed to implement new features;
• Provide 24 * 7 on call support on a rotational basis.

Environment: Solaris9, Linux, My SQL 4.1, ORACLE 10g, TOAD, Java, PHP 4.1, Nagios, Shell, Perl, JMeter, Perforce

Confidential, Newark, CA

Sr. Database Architect

Responsibilities:

• Top level design of the entire system & database;
• Detail level design of some modules;
• Create stored procedure and triggers;
• Deployment.

Environment: Solaris 7, MySQL 3, ORACLE 8 & 9, Python, J2EE, Java 1.2, Shell, Perl

Confidential, San Ramon, CA

Sr. DBA

Responsibilities:

• Performance tuning up for attribute summary report, (the running time has been reduced from 30 min. down to 5 Sec.).
• Adding Operator Services as a new business area into this system.
• Terms of reference
• Requirement analysis
• User interface and database structure
• Application design
• QA plan and test cases

Environment: AIX, Solaris, ORACLE 8i, SQL Server, PL/SQL, Shell 6.5, Java scripts, VB scripts

Confidential, Sacramento, CA

Sr. System Analyst / Technical Leader

Responsibilities:

• Prototyping with different Web based application architectures terms of reference requirement analysis user interface and database structure application design and construction create tables, triggers and stored procedures design Web pages create ActiveX components create Distributed PB server .exe and .pbd

Environment: DEC ODF/1, Windows NT 4.0 IIS 4.0 (ASP), Visual InterDev, FrontPage MS VB 5.0, SQL Server, PowerBuilder 6.0, Java scripts, VB scripts