SUMMARY:

• Over 16 years experience in DB2 LUW, Postgresql, MYSQL, SQL SERVER 2012/2008/2005 and MongoDB. Hands on experience in database modeling, design, database server built, creating database objects, database security, administration, installation/upgrade, configuration, backup and restore, data replication, performance monitoring, HADR, high availability and disaster recovery, and database clustering on Linux/Unix/Windows platforms.
• Confidential Certified DB2 Solution Expert - - Database Administrator.
• Proficient in shell scripting and DBA task automation.
• Co-authored six Confidential DB2/II Redbooks, two technical books and several research papers.
• Rich in Health and Financial industry experience and experience operating in a regulated environment.
• Experience in Database monitoring tools, such as Quest, foglight, and Precise.
• Seeking DB2 LUW, Postgresql, SQL SERVER DBA, lead, or Architect position in silicon valley of CA or remote position. Available time for call: 9 am to 5 pm PST

TECHNICAL SKILLS:

Software: DB2, Postgresql, MySQL, SQL SERVER, Oracle, MongoDB, Quest/foglight, SPUFI, QMF, BMC Suite, MS Office, MS Visio, JBOSS, WebLogic, Websphere, Data Warehouse, Data Mining, EMC Patrol, Precise, DB2 Performance Expert, Hobbit, AppMan, Bugzilla and CVS, Microsoft Office Project, Rational TestManager, CGI programming, C/C++/Java, KornShell, Bash, PHP/PI, HTML, UNIX Shells, Tivoli TSM/ADSM, JCL, FrameMaker, PaintShopPro, Intel 80x86 Assembly Language, Pascal, Basic.

Platforms: UNIX, AIX, Linux, zOS, Minix, MS-DOS, Windows, VM, and OS2.

Hardware: PC, Macintosh, and RS6000.

PROFESSIONAL EXPERIENCE:

Confidential

Database Administrator

Responsibilities:

• Built Postgresql environments for online health and wellness applications as the first and only Postgresql DBA.
• Led the creation of database security standard and file system standard.
• Led monitoring tool and backup tool evaluation.; setup monitoring with another team.
• Automated backup jobs and other maintenance jobs using script.
• Working with development for database related changes and requests.
• Helped with SQL SERVER and monogo database monitoring and requests.
• Sr. database consultant for HP and GAP. Responsible for DB2, Postgres, MS SQL SERVER, MYSQL database administration, database monitoring, space utilization, backup and recovery, performance tuning, and production databases support.
• Provided and fixed DB2 migration issues and successfully performed database tuning.
• Automate DBA tasks by scripts.

Confidential

Sr. Database Consultant

Responsibilities:

• First two DB2 UDB DBA to build DB2/SAP frame work for MWV and ACCO.
• Successfully migrated TB DB2 databases from main frame to Linux in seconds using EMC TimeFinder cloning; received high customer satisfaction and .
• Successfully setup database cluster using DB2 HADR and TSA.
• Successfully developed and implemented backup solution using TSM and NETBACKUP.
• Successfully setup DB2 monitoring using Tivoli and scripts.
• Supported SQL replication and CDC.

Confidential

Sr. Architect/DBA Consultant

Responsibilities:

• Successfully completed projects for new business requirement gathering, capacity planning, cost analysis, database physical design, infrastructure architecture design, and build of large infrastructures for financial transactions.
• Being the highest level escalation point for databases and data warehouse including DB2 UDB v9.7 /v9.5 in large DPF environments, MYSQL, SQL SERVER 2012, 2008 R2/2005 and Postgres in VMware environment.
• Responsible for new databases (DB2, MYSQL, SQL SERVER) planning, build, performance tuning and monitoring, maintenance setup, and backup and recovery setup.

Confidential

Lead Database Admin/Architect

Responsibilities:

• Being the first and only DBA to built stable, scalable, and high performance DB2 Database frame work from ground in cloud computing environment.
• Provided effective strategic planning, database standards, solutions for databases.
• Automated DB2 HADR and provided DB2 DR solution.
• Provided solution to dramatically increase productivity and performance using VMware and DB2 Virtualization. Reduced DB2 server built time from two days to 20 minutes.
• Built and supported data warehouse and BI server using DB2 and Pentaho.
• Experienced in SQL SERVER 2008 administration, installation, configuration, backup and restore, replication, performance monitoring and tuning.

Confidential

Sr DB2/ MySQL /SQL SERVER/ DBA

Responsibilities:

• Primary DBA for vary sized retail SAS 70 production databases including TB databases, data warehouse, and databases with Database Partition Feature (DPF). 24*7 support with global team. Performed installation, new customer build, database cloning, configuration, administration, performance monitoring and tuning, DB backup/restore, MDC table creating and conversion, plan and perform maintenance, DB security, release, DB patch, hot fix deployment, and troubleshooting.
• Installed and implemented DB2 Performance Expert. Experience in Precise, Hobbit, BMC, AppMan monitoring tools.
• Automated database admin tasks cross multiple machines.
• Responsible for DB2 database design, installation, configuration, administration, performance monitoring using BMC Patrol, performance tuning, DB backup/restore, HADR, database design, and production support.. Support e-commence, SAP/DB2, Bank, Medical, and Siebel/DB2 clients.
• Increased team productivity tremendously by setting up database naming, AIX File System, and monitoring standards.
• Achieved high client satisfaction from external clients.

Confidential

Senior Database Quality Assurance Engineer

Responsibilities:

• Responsible for DB2/Oracle/SQL SERVER security design and quality assurance for multi-platforms (UNIX/LINUX/AIX/WINDOWS/Zos).
• Setup three SSH Security Authentication methods.
• Developed and maintained knowledge database for resellers and customers.
• Provided company-wide DB2 technical to increase team productivity.
• Designed test cases for new modules and features.
• Discovered and tracked many defects and enhanced product quality.
• Led a large global development team for a TB data warehouse on zOS.
• Coordinated, monitored, and implemented data loading. The data loading process consists of Java programs, JCLs, and DB2 loading utility.
• Effectively managed defects clean up and quick turn over.
• Led DB2 UDB database design, performance tuning, troubleshooting, and support for Confidential intranet website. Simplified developer’s interface to DB2 and eliminated code changes to developers when database design has been changed.
• Provided consulting service to a project with large DB2 database and made breakthrough to tough DB2 problems and increased DBA productivity by 12 times using automation.
• Successfully managed and led seven tightly scheduled projects on time and within budget. Activities included identifying requirements and risks, creating/renewing contracts, staffing, project and financial planning, managing projects, providing technical direction, implementing, technical writing, overseeing the quality, and delivering Confidential Redbooks/services. Managed half million yearly.
• Co-authored six Confidential DB2/II Redbooks, including one with NetApp, NAS, two technical books and several research papers.
• Hands on experience in DB2 Information Integrator (II) Data replication/replication migration on AIX/Windows/OS390, including heterogeneous replication using DB2 V8/II.
• Projects covered DB2/II and/or with Webshpere, NAS, Java, and DB2 tools.
• Built good relationship with customers, business partners, and labs.

Confidential

Sr. DB2 UDB/MySQL/SQL Server DBA/Architect

Responsibilities:

• Silver winner for database modeling, design, and implementation.
• Managed SQL SERVER and MySQL development/test/production databases for commercial customer.
• Performed daily operation in customer support including DB2, SQL SERVER, MySQL, AIX, and applications (QMF and SAS). Proficient in DB2 installation/upgrade, create database objects, configuration, administration, performance tuning, database backup, and AIX/UNIX/WIN system administration.
• Rich commercial and internal customer experience with high customer satisfaction.
• Automated and tested DB2/AIX administration tasks using Kornshell script and C.
• Designed, implemented, tested, and maintained two databases on UNIX using Postgres95, MySQL, HTML, PHP/FI and CGI scripts.
• Accurately published and maintained electronic databases on Web and maintained Web site.