Data technologies

Kwang Lee

**** ****** **.

Walnut Creek, CA ***98

Home: 925-***-****

Mobile: 617-***-****

*********@*****.***

OBJECTIVE

To seek a professional database position. (Database architect, administrator, engineer, manager, or consultant)

.

SUMMARY OF QUALIFICATIONS

Database system design and administration with extensive experience in engineering, testing, supporting 24x7, and troubleshooting a variety of DBMS solutions in Oracle, Postgres, Vertica, MS SQL, MySQL, Informix, Kudu, MongoDB, and other SQL, NoSQL databases. Proficient in an assortment of database technologies including Oracle RAC(CRS, ASM, EMC, Pure Storage), Data Guard, Streams(Golden Gate), Vertica, Amazon Redshift, Postgres (EDB), MS SQL Server Clustering, MySQL Clustering.

Specialty in the backup and recovery, performance tuning and capacity planning, SQL optimization, data replication, high availability and disaster recovery design and implementation.

Big data experience using Apache Hadoop Ecosystem (Kudu, Parquet/HDFS, Avro, Yarn, Hive, Zookeeper, Impala, and Kafka), Cloudera Manager, and Amazon Redshift. Extensive experience on Amazon AWS and other Cloud computing services.

Expert in Linux and other Unix Operating systems and Virtualization using VMware and Oracle Xen. Scripting in Python, Perl, Unix shells, PHP, Ruby/Rails.

Performance tuning of Linux and other Unix environments. In depth knowledge on Unix internals and Oracle internals.

Expert in complex database migration between different database types. Database schema change management (Ansible, Flyway, Alembic, Python scripting)

EXPERIENCE

Database Consultant, Risk Management Solutions

Newark, CA 2016 to current

Performance tuning of RMS(One), the core product running on Kudu and Postgres/Postgis. HA/DR of RMS Core Databases. Kudu and Veritca DB performance benchmarking. Security and access control implementation. Automation of deployment. Implemented data security and access control.. Schema migration with Flyway, Ansible, Python, Jenkins.

Database/Information Architect, Twist Bioscience

San Francisco, CA 2014 to 2015

Twist is a DNA synthesis manufacturing company preparing for full production in upcoming years. Developed performance metrics, security strategy, and capacity planning for data growth requirements. Implemented their LIMS database in Postgres EDB with HA/DR using streaming and PG_POOL. Evaluated Amazon Redshift and EMR.. Implemented Tableau as data visualization tool.

Implemented schema change management process using Ansible and Alembic. Enforced data integrity for production pipeline. Evaluated the data security solutions for Twist’s high security requirements.

Database consultant/DB manager, Thomson Reuters

Boston, MA 2008 to 2014

As an independent database consultant, I Improved performance of their fixed income databases. Tuned up dynamic SQL queries with millions of search permutations.

As a full time manager, I managed their database administrators to tackle a number of challenging migration and enhancement projects. Guided the database team to develop tools and protocols to manage and to monitor the database systems more effectively.

Led a number of pilot projects. Evaluated Cloudera based Hadoop management and implemented Amazon Redshift and EMR for Big Data solutions.

Database architect/consultant, IBM

Boston, MA 2002 to 2008

As a senior architect, I led a server consolidation project for InBev. InBev is the largest global beer conglomerate that owns hundreds of other beer companies. The project was to consolidate thousands of servers distributed remotely to hundreds of different data centers. Migrated and consolidated their applications and infrastructures into three new data centers (N. America, Europe, and Asia)

At IBT (Investors Bank and Trust. I led the project from the initial conceptual design to the final implementation phase in the project life cycle. Developed in-house tools to facilitate the migration tasks and high availability implementation of critical database systems.

Director of Operations, Visible Markets

Boston, MA 2000 to 2002

V.M was the first online bond trading company for fixed income securities. Built high transaction trading database from ground-up. My responsibilities expanded to include network performance and management, system administration, vendor management, release control and change management, and site uptime.

Database Administrator, Amazon.com / PlanetAll

Seattle, WA 1997 to 2000

Responsible for Amazon’s order and distribution databases. At the time, its core database was one of the biggest in size and transaction rate in the world. Implemented features to improve the site’s high availability and resiliency.(Achieved 5 9s)

PlanetAll was a social networking and contact tracking web site sold to Amazon in 1999. Ensured the site’s uptime (on call 24x7). Performance tuning on SQL and applications.

Database engineer, Genome Therapeutics

Cambridge, MA 1995 to 1997

Genome Therapeutics is a biotechnology company focused on discovery and development of pharmaceutical and diagnostic products. Developed databases to store DNA sequencing and structural analysis of genes and proteins. Created a data compression algorithm for DNA sequences.

EDUCATION

Rivier College

M.S in Computer Information Systems

Nashua, NH

University of Toledo

Bachelors in Biology

Toledo, OH

REFERENCES

Available upon request.

Contact this candidate