Dominica Leung

Dominica Leung Email and Phone Number

Senior Data Warehouse Engineer @ Medefy Health
Dominica Leung's Location
San Francisco Bay Area, United States, United States
Dominica Leung's Contact Details
About Dominica Leung

Skills/Qualifications:0) Win Komodo Health Founder Award in my first 6 months working in Komodo Health1) First Data engineer (ETL engr) in odesk, I built startup, help to build successful company. odesk acquired Elance and change name to Upwork. (I am interested in jumpstart and build a data engineering team in a startup as team lead, team manager. )2) Mentor junior Engineers, help in recruiting process, build successful data engineers team. 3) Petabytes Snowflake Datawarehouse experience. 10+ Petabytes experience.4) Expert in SQL performance tuning, SQL tuning expert in very large dataset (work with multiple petabytes data)5) Business Coding: Advanced SQL, Python, Bash, aggregation SQL6) OLTP Database: Oracle, PostgreSQL7) Datawarehouse Database: Snowflake-DB, Redshift, Greenplum8) Datawarehouse Design: Performance tuning, data modeling, Fact and Dimension tables, star schema. ETL metric and monitoring. Build robust datawarehouse pipeline.9) Technical Tool: AWS, kubernetes, Docker, Jenkins, Airflow10) Operating system: Linux, bash11) Expert in SQL performance tuning.12) Speaker for presentation on KomodoHealth Week 2020's MasterClass, Snowflake Query Optimization

Dominica Leung's Current Company Details
Medefy Health

Medefy Health

View
Senior Data Warehouse Engineer
Dominica Leung Work Experience Details
  • Medefy Health
    Data Engineer
    Medefy Health Feb 2024 - Present
    Tulsa, Ok, Us
    View
  • Komodo Health
    Senior Data Warehouse Engineer
    Komodo Health Dec 2019 - Sep 2023
    San Francisco, California, Us
    Build high performance , scalable data pipelines, ELT of billions row of records for medical and RX Claims. Tech stack, AWS, S3, Kubernete, Airflow. python, SQL, Snowflake database. Expert on Snowflake database performance tuning. Data warehouse ERD data modeling. Worked on Snowflake database that has PETAbyte data.
    View
  • Upwork
    Senior Data Engineer
    Upwork May 2015 - Sep 2019
    San Francisco, California, Us
    Data warehouse ETL/ELT development (SQL/Python)Perform all of the necessary data transformations to populate data into a warehouse table structure that is optimized for reporting.Build and maintain code to populate the data warehouse db with data loaded from production databases.Write home-grown transformation code(SQL) to do ETL pipeline. Write analytic Advanced SQL. SQL tuning/optimization. Design datawarehouse schema for aggregation analytics purpose.Develop ETL alert, metric, logging. Translate business requirement into data model.
    View
  • Elance-Odesk
    Data Services Architect
    Elance-Odesk Apr 2014 - Apr 2015
    Oo
    Data warehouse ETL/ELT development (SQL/Python). Data modeling datawarehouse core tables. These core tables serve as the foundation for data-platform to power analytics for risk/fraud team, marketing team, data-science team.Greenplum MPP Datawarehouse db administration (GP is PostgreSQL base kernel)Perform all of the necessary data transformations to populate data into a warehouse table structure that is optimized for reporting.Build and maintain code to populate the data warehouse db with data loaded from production databases.Write home-grown transformation code(SQL) to do ETL pipeline. Write analytic SQL. SQL tuning/optimization.Develop ETL alert, metric, logging.
    View
  • Elance-Odesk
    Data Services Architect
    Elance-Odesk Aug 2011 - Mar 2014
    Oo
    First data-engineer hired in the Data-team and built datawarehouse from ground up. Data warehouse ETL/ELT developement (SQL/Python)Greenplum Datawarehouse db administration (GP is PostgreSQL base kernel)Perform all of the necessary data transformations to populate data into a warehouse table structure that is optimized for reporting.Build and maintain code to populate the data warehouse db with data loaded from production databases.
    View
  • Convio
    Senior Oracle Dba
    Convio Feb 2007 - Aug 2011
    Austin, Tx, Us
    (GetActive get acquired by Convio, I work in Convio's Berkeley office)Production DBA on a high traffic website. (24x7 support) Backup and recovery and performance tunning. Capacity planning. Project planning and performance testing for 10g upgrades for all production databases(& development db). Write performance monitoring tools to monitor DB performance. Streamling oracle security patch by pre-patching ahead of time to make downtime only 5 minutes. Database cloning for QA testing purposes. Responsible for oracle security patches on all servers. Define/document database administration process/procedure. Use logminer to recover delete rows. RMAN backup.
    View
  • Convio
    Senior Oracle Dba
    Convio Feb 2005 - Feb 2007
    Austin, Tx, Us
    First full-time Oracle dba for GetActive. Production DBA on a high traffic website. (24x7 support) Backup and recovery and performance tunning. Capacity planning. Project planning and performance testing for 10g upgrades for all production databases(& development db). Write performance monitoring tools to monitor DB performance. Streamling oracle security patch by pre-patching ahead of time to make downtime only 5 minutes. Database cloning for QA testing purposes. Responsible for oracle security patches on all servers. Define/document database administration process/procedure. Use logminer to recover delete rows. RMAN backup.Plan and tested upgrade Oracle 8.1.7.4 to 10gR2
    View
  • Intuit
    Qa Engineer(Contractor)
    Intuit Dec 2003 - Aug 2004
    Mountain View, California, Us
    Testing the integration of Callidus software to Intuit's IT system (Peoplesoft). Test plan design.
    View
  • Zaplet
    Senior Oracle Dba
    Zaplet Jan 2000 - May 2002
    Us
    Production DBA in ZapletDesign HA system.Build hotstandby (dataguard) database for emergency failover.Design backup systemCapacity planning.(space management).Automate database cloning process for QA testing.Performance Monitoring.
    View
  • Concentric Network
    Oracle Dba Lead
    Concentric Network Jan 1997 - Jan 2000
    Nyc, New York, Us
    First Oracle DBA for concentric network(Acquired by XO communication).Responsible design/build/implement 16+ production databases, and a bunch of QA/testing oracle databases.Recruit/mentor junior members in the team.Implement data-center moving(database moving) project.Space management.
    View

Dominica Leung Skills

Databases Sql Oracle Shell Scripting Linux Bash Data Warehousing Postgresql Disaster Recovery Database Administration Integration Etl Vmware Enterprise Architecture High Availability Performance Tuning Agile Methodologies Servers Testing System Administration Perl Apache Html

Dominica Leung Education Details

  • University Of California, Riverside
    University Of California, Riverside
    Computer Science
  • University Of California, Riverside
    University Of California, Riverside
    Computer Science
  • Other
    Other

Frequently Asked Questions about Dominica Leung

What company does Dominica Leung work for?

Dominica Leung works for Medefy Health

What is Dominica Leung's role at the current company?

Dominica Leung's current role is Senior Data Warehouse Engineer.

What is Dominica Leung's email address?

Dominica Leung's email address is do****@****ail.com

What schools did Dominica Leung attend?

Dominica Leung attended University Of California, Riverside, University Of California, Riverside, Other.

What skills is Dominica Leung known for?

Dominica Leung has skills like Databases, Sql, Oracle, Shell Scripting, Linux, Bash, Data Warehousing, Postgresql, Disaster Recovery, Database Administration, Integration, Etl.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.