SUMMARY

• High degree of understanding of business requirement, data analytics, enterprise architecture, application development environment, middleware connectivity, various DBMS features, operating system characteristics and network protocols with extensive IT experience in software analysis, design, development, testing, deployment, and administration.
• Strong leadership experience leading teams of data engineers.
• Strong technical recruitment and experience scaling a team onshore and offshore.
• Extensive Database Architecture/Modeling experience with Erwin, PowerDesigner, and Toad Modeler.
• In - depth hands-on performance tuning experience in PL/SQL & T-SQL.
• Extensive experience in Oracle 9i, 10g, 11g/SQL Server 7, 2000, 2005, 2008, 2012, 2014, 2016, 2017.
• Strong ETL Experience with Informatica and SSIS.
• Advance level of experience with NoSQL databases - DynamoDB, DataStax Cassandra.
• Premier data engineering experience on cloud infrastructure (AWS).
• In-depth Big Data Processing Knowledge of Apache Hadoop ecosystem (HDFS/MapReduce/YARN/Pig/Hive/Flume/Sqoop) and Apache Spark
• Extensive Database administration experience with Toad DBA Suite and Idera.
• Advanced understanding of relational database design principles and database schema.
• Complete knowledge of all phases of Software Development Life Cycle including Waterfall and Agile.
• Experience in implementing CRM, ERP and other business application systems.
• Experience with 24/7 large complex fast paced operating environments, providing support to internal systems and vendor applications.
• Strong problem solving and analytical skills.
• Excellent initiative in decision-making and assumption of responsibilities.
• Excellent team member and exceptional leadership and administration skills and supervisory experience.
• Trilingual: Mandarin, Taiwanese and English.

PROFESSIONAL EXPERIENCE

Confidential, Pasadena, CA

Manager, Software Engineering, Data Engineering

Responsibilities:

• Recruit, retain and focus strong data engineers (onshore and offshore)
• Responsible for designing, organizing, assessing enterprise database structures, overseeing implementation of end-to-end integrated systems.
• Participate in the detailed analysis, design, construction, documentation, and administration of database solutions for various applications.
• Coordinate with product owner, scrum master and development team on a wide range of technology projects.
• Translate business requirements and enterprises into long-term data architecture solutions, including logical and physical models with Toad Data Modeler, Erwin, and Visio.
• Review new and existing systems design projects and procurement or outsourcing plans for compliance with standards and architectural plans. Ensure that proposed and existing systems architectures are aligned with organizational goals and objectives.
• Design, document, review, and performance tune effective data access routines for SQL Server and Amazon Web Services (AWS) RDS (MySQL/Aurora) and NoSQL (DynamoDB, Cassandra)
• Design effective heavy duty data solutions for database archiving, data conversion, and batch data interface using SQL Server Integration Services (SSIS) and Informatica.
• Analyze and define enterprise master data management strategies and models.
• Defining and maintain best guidelines and standards for metadata, data, data modeling, and management.
• Handle the tasks of implementing and promoting governance processes for information and metadata to ensure establishment of a common language.
• Document the company's existing systems architecture and technology portfolio and make recommendations for improvements and/or alternatives.
• Document technology roadmaps and the transition from the current architectural framework to target architecture of the future.
• Handle responsibilities of data acquisition and access analysis and design.
• Conduct research on emerging technologies in support of systems development efforts, and recommend technologies that will increase cost effectiveness and systems flexibility Confer with end-users, clients, or senior management to define business requirements for complex systems and infrastructure development
• Advise technology and business groups on future technology options, outlining benefits, cost, risk, and capabilities.
• Design and implement solutions to fit long-term strategic and short-term tactical goals of company’s architecture standards/direction
• Adhere to all policies and procedures concerning all confidential information including but not limited to internal use and restricted information, including protected customer information (PCI).

Confidential

Project Data Manager / Principal Database Specialist

Responsibilities:

• Coordinate with project engineers and project managers on the PTC projects.
• Design data models of Positive Train Control’s Information Repository System.
• Create and manage databases of PTC’s Information Repository System.
• Develop and manage stored procedures of PTC’s Information Repository System.
• Develop and manage java EE web services and web applications of PTC’s Information Repository System.
• Install and manage Oracle Linux 6.1 and Oracle Database 11gR2.
• Deploy PTC’s Info Repository System on Oracle GlassFish Application Server/Oracle Database 11gR2.
• Develop HMAC SHA1 / RC2 calculator in Java and PL/SQL for WIUDATA in PTC Data Model.
• Generate Sub-Division WIUDATA compliant with PTC Data Model Revision P/Q/R and Interoperable Train Control Interface for Metrolink PTC Project.
• Install and manage MS SQL Server 2K8R2 / MS Windows Server 2K8R2 / MS Hyper-V Server 2K8R2.
• Install and manage IBM Rational ClearCase, ClearQuest, Quality Manager, RequisitePro, and Publishing Engine for project configuration management.
• Design and create forms and data models for project configuration management.
• Perform ongoing development database administration, maintenance, troubleshooting, installation for MS SQL Server 2008R2 databases and Oracle 11gR2.
• Use Sybase Power Designer for database architecting and modeling.
• Create Maintenance Plans and Manage SQL Server agent jobs.
• Plan and create disaster recovery strategy.
• Use Toad and SQL Developer to maintain and optimize PL/SQL on Oracle 11gR2.
• Provide support for SQL Server and Oracle Databases to other PTC projects.

Confidential

Sr. Database Administrator

Responsibilities:

• Perform ongoing production database administration, maintenance, troubleshooting, installation, and data migration for MS SQL Server 2008R2 databases and Oracle 11gR2.
• Backup & Recovery, Performance Tuning, Data Replication, Security, Auditing, and Space Management.
• Daily support for SQL Server 2008R2 production and development databases on Windows Server 2008.
• Install and maintain Microsoft SQL Server 2008R2 in HIPAA compliant security zone.
• Implementation of Failover Clusters, Mirroring and Log Shipping for High Availability on SQL Server 2008R2.
• Implementation of Snapshot and Transactional Replication for Reporting Service on SQL Server 2008R2.
• Use TOAD for SQL Server and SSMS to manage multiple SQL Server Databases.
• Use TOAD Spotlight Enterprise to monitor SQL Servers and Oracle 11gR2.
• Use Power Designer for database modeling.
• Analyze execution plan and optimize stored procedures and SQL Scripts.
• Use SQL profiler, Database Engine Tuning Advisor and Quest SQL Optimizer for SQL Server for tracing and performance tuning.
• Create Maintenance Plans and Manage SQL Server agent jobs. Plan disaster recovery strategy.
• Use SQL compliance manager for SQL Server auditing of all user activity and data changes.
• Develop complex report and optimize existing reports with SQL Server Reporting Services (SSRS).
• Experience with Health Level Seven (HL-7)
• Install and manage Microsoft Hyper-V 2008 R2 for development and staging.
• Use Toad and SQL Developer to maintain and optimize PL/SQL on Oracle 11gR2.
• Large Database ETL between Oracle and SQL Server with SQL Server Integration Services (SSIS).
• Provide support for SQL Server and Oracle Databases.

Confidential

Director, Information Technology, Database Services

Responsibilities:

• Perform ongoing production database administration, maintenance, troubleshooting, installation, and data migration for Oracle 10g RAC & MS SQL Server databases.
• Backup & Recovery, Performance Tuning, Data Replication, Security, Auditing, and Space Management.
• Daily support for Oracle 10g production and development databases on Red Hat Enterprise Linux.
• Install and maintain multi-node 10g RAC environments, installation of Oracle Clusterware, ASM/RAC.
• Implementation of Oracle Data Guard Physical Standby database for High Availability.
• Implementation of Oracle Data Guard Logical Standby database for reporting purposes.
• Implementation of Oracle Steams to capture, propagate and transfer data for replication of databases.
• Use TOAD and Oracle Enterprise Manager Grid Control to manage multiple Oracle databases.
• Use TOAD Spotlight to monitor Oracle 10g databases.
• Use Automatic Shared Memory Management to automatically tune memory.
• Use Automatic Workload Repository (AWR) to collect extended statistics.
• Use Automatic Database Diagnostic Monitor (ADDM) to tune database with AWR information.
• Use Automatic SQL tuning Advisor to tune SQLs.
• Plan disaster recovery strategy. Write RMAN scripts and use RMAN to Backup & Recovery Databases.
• Install and create Oracle 11g databases for development and testing.
• Administrate and support Microsoft SQL Server 2000/2005.
• ETL experience with SQL Server 2000 (DTS) and SQL server 2005 (SSIS).
• Report development with SQL Server Reporting Services (SSRS).
• Install and create Microsoft SQL Server 2008 for development and testing.
• Analyze business requirements to implement and manage ERP and Microsoft CRM system.

Confidential

Director of Technology / Solution Architect

Responsibilities:

• Administrate Oracle 10g & MS SQL server 2000 databases, including data modeling, installation, configuration, database creation, management of users and object permissions, disk and backup management, performance tuning and optimization, monitoring and support.
• Use PowerDesigner for Data Modeling: Apply Entity Relationship Diagram, Data Schema Diagram and Table of Instance.
• Plan capacity and disaster recovery strategy.
• Backup/Recovery/Duplicate with RMAN scripts.
• Tune SQL queries and stored procedures. Optimize database performance.
• Ensure that database and server operations comply with policies, standards, and principals.
• Ensure database system integrity and operational stability and efficiency.
• On-Call Service to ensure that critical applications are performing effectively and to provide emergency support.
• Design and develop Digital Right Management System (IIS/SQL Server, Oracle AS/Oracle 9i, 10g RAC)
• Design and develop CD/DVD protection mechanisms and software (Mastering & C++ API).
• Design and develop Software Activation Protection (C++ API & .NET & Java server-side).
• Design and develop Online ID Verification and Tracking Web Service (C++ API & .NET & Java server-side).
• Design, create and upgrade new databases, support existing databases environments for DRM project.
• Analyze business requirements to design and develop applications best suited for clients.
• Implement standard software engineering procedures and documentation methods.
• Create architecture and specification documents.
• Manage and supervise development team; Plan and control development schedules.
• Provide technical support, guidance and solution for developers, testers, and clients.