Leo Hu, Database Engineer and Developer in Auckland, New Zealand
Leo Hu

Database Engineer and Developer in Auckland, New Zealand

Member since June 18, 2020
Leo Hu is not just a traditional database administrator (DBA) and engineer with 12+ years of database engineering and architecture experience—he is a passionate data guru. Leo prefers proactive database monitoring and thrives on projects where he has to solve severe problems and design an efficient database solution based on the client's requirement. Leo was named a Microsoft SQL Server MVP; also he has AWS certification as a cloud practitioner.
Leo is now available for hire

Portfolio

  • Fraedom (VISA)
    Amazon Web Services (AWS), Database Architecture, SQL, Microsoft Power BI...
  • Aderant
    Amazon Web Services (AWS), Database Design, Database Modeling, Obfuscation...
  • Volkswagen Finance China
    Mirroring, Clustering, Linux, MySQL, Windows PowerShell, Oracle...

Experience

Location

Auckland, New Zealand

Availability

Part-time

Preferred Environment

SQL, SQL Server DBA, Microsoft SQL Server, Windows

The most amazing...

...thing I've worked on is developing and maintaining the databases of the biggest law firm software company.

Employment

  • Senior Database Engineer

    2019 - PRESENT
    Fraedom (VISA)
    • Designed and developed a data platform for a fintech company, which benefit 600,000 organisations in 178 countries.
    • Worked with operations and database administrators to continuously improve production environments and helped mitigate database-related production incidents.
    • Provided database expertise to engineering and development teams, for example, reviews of database designs, queries and performance optimizations.
    • Designed and implemented database-related projects, e.g., data archiving, data streaming, and data classification.
    Technologies: Amazon Web Services (AWS), Database Architecture, SQL, Microsoft Power BI, Streaming Data, DB, Classification, Data, Windows PowerShell, Elasticsearch, Apache Kafka, AWS, Azure
  • Senior Database Administrator | Database Developer

    2016 - 2019
    Aderant
    • Optimized and supported databases for a global industry leader in providing comprehensive business management software for law firms.
    • Served in a multi-purpose role that combined the responsibilities of a database administrator and database developer.
    • Designed and implemented the database architecture and developed a database feature as a service to internal development teams.
    • Mentored and coordinated internal database-related development projects across all product teams, including a cloud-based product (AWS) along with providing solutions for database issues from the CRT (critical response team).
    Technologies: Amazon Web Services (AWS), Database Design, Database Modeling, Obfuscation, AWS, Windows PowerShell, .NET, Microsoft SQL Server
  • Database Administrator (DBA)

    2013 - 2015
    Volkswagen Finance China
    • Worked for the top-level auto finance company in China, as part of the Volkswagen Group, one of the largest automakers worldwide.
    • Served as a development/production database administrator and worked on release processes in a highly available database topology, featuring clusters and availability groups under SQL Server 2008 R2 and SQL Server 2012.
    • Defined the disaster recovery, designed and built the SQL Server, and reviewed, managed, and developed SQL Server DBA best practices.
    • Implemented the upgrades and support of the SQL Server along with performance-tuning and troubleshooting issues.
    • Monitored alerts and fulfilled other general DBA duties.
    Technologies: Mirroring, Clustering, Linux, MySQL, Windows PowerShell, Oracle, Microsoft SQL Server
  • Database Administrator (DBA) | Developer

    2011 - 2013
    Websense
    • Supported a database and IT system for a global company with 2,000+ employees.
    • Developed tools to integrate and monitor the availability and performance of IT services and infrastructure.
    • Dealt with database work involving high availability, emergencies, monitoring, analysis, and performance tuning.
    • Oversaw the database disaster recovery and security, database deployment, maintenance and management, and migration upgrade.
    Technologies: Salesforce, Visual Basic, Ruby, PHP, ASP.NET, Microsoft SQL Server

Experience

  • Database Archiving Solution

    I designed and implemented a database archiving solution. It's a configuration-based system that allows you to add a configuration for archiving tables and then this system will automatically generate archive stored procedures and scheduled jobs.

  • Push-mode Data-streaming for SQL Server

    I created a push-mode data streaming platform for SQL Server. Once the data is transformed, it pushes the incremental change to message queueing systems, e.g., Kafka and Service Broker, and digests it in the other application (like Elasticsearch) then eventually present it on reporting tools, Kibana, PowerBI, and so on.

  • Optimization of Complex Queries and Stored Procedures

    I optimized and refactored complex T-SQL queries or stored procedures for a few companies in the fintech, software, and eCommerce industries.

  • Database HA and DR Solution Design and Implementation

    I processed the database's HA (high availability) and DR (disaster recovery) architecture, including a range of SQL Server technologies such as AlwaysOn, clustering, mirroring, replication, and log shipping.

Skills

  • Languages

    SQL, PHP, Ruby, Visual Basic
  • Paradigms

    Database Development, Database Design
  • Storage

    Microsoft SQL Server, Database Administration (DBA), Database Architecture, Database Security, Database Triggers, Database Modeling, Database Mirroring, SQL Server DBA, AWS S3, Elasticsearch, DB, MySQL
  • Other

    High Availability Disaster Recovery (HADR), Database Clusters, Database as a Service (DBaaS), Streaming Data, Cloud, AWS, Data, Classification, Obfuscation, Clustering, Mirroring
  • Frameworks

    Windows PowerShell, .NET, ASP.NET
  • Tools

    Microsoft Power BI
  • Platforms

    Oracle, Windows, Azure, Apache Kafka, Linux, Salesforce, Amazon Web Services (AWS)

Education

  • Bachelor of Management in Information Management and Information System
    2001 - 2005
    Beijing Information Technology Institute - Beijing

Certifications

  • AWS Certified Cloud Practitioner
    AUGUST 2020 - PRESENT
    Amazon
  • MCSA — SQL 2016 Database Development
    JANUARY 2019 - PRESENT
    Microsoft
  • MCSE — Data Management and Analytics
    JANUARY 2019 - PRESENT
    Microsoft
  • MCSA — SQL 2016 Database Administration
    DECEMBER 2018 - PRESENT
    Microsoft
  • Microsoft SQL Server MVP
    APRIL 2014 - APRIL 2015
    Microsoft
  • MCITP — Database Administrator 2008
    MAY 2012 - PRESENT
    Microsoft

To view more profiles

Join Toptal
Share it with others