SUMMARY:

• Hands - on and solution-driven technical lead with a 30 year experience servicing multinational clients in North America and Asia.
• Proven track record in dynamic environments with technical proficiency amidst challenges.
• In-depth experience across a broad spectrum of industries with strong sense of cost, values and management prospective for clients.
• Ability to integrate functional requirement, technical feasibility, work floats, support structure, legal requirement, mark-to-market initiative and budget into a working project
• Experience across a broad spectrum of industries, such as equipment leasing, wholesale/retail, manufacturing, insurance, financial, payment services and web portal
• Planning and management of development cycles: scope definition, feasibility studies, resource identification, functional specification, database design, program design and layout, testing schemes and schedules, production preparation, post production support
• Thirty years hands on IT experiences in various roles and capacity
• Seventeen years in Oracle DBA and DBA lead role
• Two years of MySQL DBA and support role
• Periodic SQL Server support and data analyst role
• Database clustering, multi-master replication, DR planning, configuration and implementation
• System, application and database architecture, design, implementation and optimization
• Experience with data modeling, documentation, version and release control
• Fault tolerance, load balance, performance optimization and security integrations
• Experience with merger due diligence, budgeting, risk management and policy compliance at every IT operations
• Multilingual: fluent in English, Cantonese and Putonghua.

TECHNICAL SKILLS:

• Oracle Certified Professional (OCP) DBA certification; 7, 8, 8i, 9i, 10g and 11g
• Oracle Application Server 9iAS and 10gAS
• PL/SQL, SQL*Plus, Forms 6i/9i, Designer, Discoverer, OEM, ASM, RMAN, Data Guard, LDAP, EM Grid, Oracle Warehouse Builder, Developer suite, ACFS, OCFS2
• Support experiences with Oracle RAC and Streams
• Microsoft SQL Server 2000 and 2014, T-SQL, SQL Server Management Studio
• MEM, Oracle MySQL 5.1/5.5/5.6, MariaDB 5.1/10.x, Percona 5.5
• VMware VM server and workstation, Oracle Virtual Machine
• Factory certificated trainings
• Oracle 11g features, Streams, RAC, EM Grid and RMAN
• Sun Solaris 10 system administrator courses
• HP-UX, Sun OS, Solaris 7/8/9/10, Free BSD, Linux, AIX, MPE/X

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Consultant, Database Analyst

• Contingency based assignment, data discovery, analysis and mining
• Rapid identification of bank customers impacted by certain aspect of service changes to protect bank and customer values
• Analyze data variances and gaps for data presentations to managements
• SQL Server data loads and T-SQL analytics

Confidential, San Jose, CA

Consultant, Senior Database Administrator

• Contingency based assignment, Commercial Cloud Computing Project
• Fact finding and business value analysis regarding infrastructure readiness for future commercial offering of IaaS and PaaS and business cost saving for current operations
• Monitor, deploy, configure and structure of databases for different cloud provision options
• MySQL database component of IaaS and PaaS
• Oracle MySQL, MariaDB and Percona multi-master/clustering databases, multiple datacenters
• Linux and Ubuntu on VM
• OpenStack cloud

Confidential, San Francisco, CA

Consultant, Senior Database Administrator

• Project based assignment, Portal Renewal Project
• Evaluate and streamline development lifecycle environments to achieve support cost reductions
• Install and patch Oracle databases on Solaris, AIX and Linux platforms
• Project sizing, estimations and documentations
• Development, QA, Staging environments deployments and oracle software installations
• ASM, Data Guard, RMAN implementations
• Contribute and support of projects with MySQL databases

Confidential, Foster City, CA

Consultant, Data Center Migration - DB track Lead

• Short term assignment, Data Center Migration from CyberSource data center into Confidential data center
• Data Center Migration project management for database relocation track
• Identify, consolidate, analyze and evaluate dependencies and constraints from various business line components to achieve minimal service interruption during database migration
• Identify and resolve application interdependencies, access privileges, compliances and standards issues
• Discovery, fact finding, technical feasibility and project write-ups
• Define tasks, resources and schedules to migrate Oracle databases into Confidential data centers
• Coordinate with Confidential employees for task assignments, schedules and project handoffs
• Coordinate with other DCM track leads regarding overall project designs, tasks and delivery schedules
• 4 business lines, 20 databases, 48 applications to relocate into 2 Confidential data centers

Confidential, San Mateo, CA

Consultant, Senior Database Administrator

• Project based assignment, database environment upgrades hosting paid client services
• Standardize Oracle database environment setups for better business values over competitors
• Install and patch Oracle 11gR2 RAC database and services on Linux platform
• Project sizing, estimations and documentations
• Development, QA environments build out and oracle software installations
• Production database monitoring and support
• Golden Gate, Data Pump and Data Guard implementations

Confidential, San Francisco, CA

Database Analyst

• Senior Oracle database lead, manage a team of 2
• Standardize preproduction database replication for rapid development cycles to achieve cost savings
• Online payment solutions business lines: Bill Pay, Desk Top Deposit, Foreign Exchange, Mobile Apps, etc.
• Internet payment development support and data security of multi-terabyte databases
• Data encryption and database security provisions
• Project sizing, cost estimations and documentations
• Data model reviews, development life cycle and version control
• Development, SIT and load test environments build out and oracle software installations
• SQL and database tunings
• Stream, Data Guard, RMAN implementations
• 9i, 10g and 11g upgrades
• Exposure to support role involving MySQL databases.

Confidential, San Francisco, CA

Senior Staff Consultant

• Long term projects, on-site assignments and client relationship with external clients
• In-house research of advance topics relating to Oracle databases features and internals for better support of external clients
• Project time and cost estimations for the agency to gain cost advantage over competitors
• Managing production databases for a variety of clients. This includes daily database reviews, proactive maintenance, pager support, and various short-term assignments for clients
• Assignments include high-level Oracle database design review, performance tuning, troubleshooting production problems, capacity planning, auditing and developing backup/recovery strategies, and implementing standby databases

Confidential

Consultant, Database Administrator

• Database and application servers bench mark test at HP test center to evaluate potential cost savings
• 3-tier, internet based application with multiple failover site structure
• Development and 24x7 production support
• Project DBA, data model, change control
• Oracle database upgrade and test environment installation
• Backup strategy, hot standby fail over and implementation
• SQL and database tuning

Confidential San Francisco, CA

Consultant, Database Administrator

• Provide production and developer support for multiple Oracle 8i databases that fuel this company’s 50,000,000+ hits-per-day web sites (Oracle 8i, Solaris, NT, Free BSD, Perl)
• 24x7 production support
• Internet business portal database support tasks
• Oracle database upgrade and migration
• Backup strategy, hot standby fail over and implementation
• Database security model, data encryption and database security structures
• Data warehouse planning and implementation
• Oracle to SQL Server database migration project

Confidential, San Francisco,CA

• Unix 9.04 to 10.20 migration projects
• Oracle systems Y2K projects
• Oracle 7.1 to 7.3 migration projects
• EDI and Web projects
• Oracle DBA tasks; setup and maintain databases for project developments.
• Program database triggers, procedures and performance tuning.
• Extensive programming with UNIX, PL/SQL, SQL*PLUS, Oracle Forms and Report faculties.

Confidential, San Francisco

Senior Programmer Analyst

• Project management, design, planning, research and implementation
• Led development and support team of 74 technical professionals
• Led development of data warehouse and Web-based booking system
• Planned, coded and tested for system re-engineering projects
• Supported all business systems and billing functions
• Developed project plans for merger, due diligence and transition options
• User training and remote site support
• Winner of Blue Star Award, which recognizes extraordinary employee contributions