Data DBA Database-Architect

John MJ Chung

Mobile (***) *** – ****; E-Mail ********@*****.***

EXPERIENCE

oClarity Software Solution, Inc., Madison, CT – Database Architecture (03/2020 – Present)

-Migrate On-Premise MariaDB to AWS Aurora MySQL.

-Database High Availability & Disaster Recovery Design and Implementation.

-Data Model Documentation and Optimization.

-Database Administration including Root Cause Analysis, SQL Code Review, and SQL Tuning, etc.

-Database Monitoring and Alerting using IDERA SQL Diagnostics for MySQL.

oLadders Inc., New York, NY – Database Engineer II (10/2018 – 03/2020)

-MariaDB and MS SQL Server Administration.

-Root Cause Analysis for Database System Issue, and Nightly ETL Process.

-Migrate EC2 based MariaDB to AWS RDS MariaDB with “Zero” down time.

-Configure Replication between MariaDB Servers.

-Configure Replication from MariaDB to MS SQL on LINUX environment.

-Automate Database Maintenance, ETL Job, and Test Database Refresh from Production Backup using Shell Script.

-Implementation of Database System Monitoring and Alerting using Shell Script.

-SQL Optimization, Development (Write Stored Procedure, Trigger, Function, and View), and Code Review.

-Generate Financial and Application Metric Report from MariaDB and MS SQL Server.

-Create ETL Jobs to extract Data from MariaDB & MS SQL to AWS RedShift.

oKWI Inc., Greenvale, NY – DBA (09/2017 – 10/2018)

-MySQL Database Administration.

-SQL Development, Code Review, and Performance Tuning

-Automate Database System Monitoring and Audit Reporting.

-Install and Configure Enterprise Scheduling System using Run Deck.

-Root Cause Analysis for ETL Process and Database Server failure.

-Implement Backup and Setup Data Refresh to Testing and Development Environment.

-Deploy PERCONA Monitoring Management to Centralize Performance Monitoring.

-MySQL Database Upgrade.

oNASDAQ, New York, NY – DBA Technical Senior Manager (01/2016 – 04/2017)

-Manage team of DBAs located in multiple regions which includes US, EMEA, Vilnius, and Bangalore.

-Build DBA Team to provide Follow-the-Sun Enterprise Level Support for Multiple Database Platform.

-Automate DBA Maintenance and Monitoring through Environment Standardization and Implement Solar Winds.

-Lead Cloud Database Migration and Database Audit Project.

-Provide Road Map for Enterprise Database Technology.

-Create Database Inventory System to include all Database Platform used by NASDAQ.

-Lead and Conduct “POC” for New Database Technologies to Integrated into NASDQ Technology Stack.

-Lead Database Administration Support and Train DBA Team for Cross Function.

oNASDAQ, New York, NY – DBA Senior Specialist (09/2014 – 12/2015)

-Administration of MySQL as Primary, and Oracle, Sybase Servers (ASE, REP, and IQ) as Backup.

-Standardize MySQL environment for ease management of MySQL environment.

-Automate, and Centralize MySQL backup.

-Centralize Collecting and Analyzing MySQL Database Health Metric.

-Automate Latency Monitoring in Trade Capture System, and Alert when Latency Crosses Threshold.

-Automate MySQL Compliance Reporting Systems for Database InfoSec and Internal Audit.

-Configure MySQL for High Availability using Replication and Galera Cluster with Proxy HA.

-Configure MySQL Monitoring & Alerting using HP Open View.

-Tune Database Server for performance.

-Perform MySQL Database Version Upgrade.

-Document Data & Connectivity Information for Upstream and Downstream.

-Discover, and Document all MySQL Servers used by NASDAQ.

-Migrate On-Prem MySQL Instances to AWS Cloud on EC2, RDS, and Aurora.

oNYSE, New York, NY – Enterprise Data Architect Technical Director (01/2013 – 08/2014)

-Maintain, and Troubleshoot ETL process for Enterprise Data Warehouse in Netezza and GreenPlum.

-Provide Root Cause Analysis for ETL Failure.

-Build and Test Hadoop to Integrate into Data Warehouse Asset.

-Provide Support for Ab Initio and Tableau Implementation.

oNYSE, New York, NY – DBA Technical Director (Apr 2009 – Dec 2012)

-Manage DBA Team to support Database Servers for Trading, Trade Data Processing, and Web environment.

-Centralize DBMS Monitor using Oracle OEM for MySQL, Oracle, and Times-Ten RDBMS.

-Automate Database ETL, Batch, Monitoring, Alerting, and Maintenance task.

-Design and Implement Fault-Tolerant High Availability Database System for Trading Application using Times-Ten.

-Implement DBA Framework for Database Servers.

-Provide Root Cause Analysis for ETL Process and Database Server failure.

-Database Administration of Oracle, MySQL, and Oracle Database Server.

oNYSE, New York, NY – DBA Lead (May 2007 – Mar 2009)

-Database Administration of MySQL, Oracle, OneTick, KDB, and UDB DB2.

-Design, Implement, and Maintain Monitor and Alert framework.

-Design and Implement Fault-Tolerant High Availability Database System.

-Install, upgrade, configure, performance tune, and troubleshoot Database Server for multi-RDBMS environment.

-Develop archive, batch, backup & recovery, monitoring, and fail-over & fail-back.

-Attend/Provide Enterprise wide Root Cause Analysis meeting to represent DBA Team for Trading Application.

-Assist Developers for developing and tuning Stored-Procedure, Views, and Trigger for various Database Platform.

oSIAC, New York, NY – DBA Senior (Apr 2001 – Apr 2007)

-Database Administration of MySQL, Oracle, UDB DB2, and MS SQL.

-Automate maintenance, backup, archive, and batch jobs for Database Servers.

-Provide root cause analysis for Data Process and Database Server failure to External Client.

-Plan Backup & Recovery Strategy for Database Servers.

-Design and Implement Fault-Tolerant High Availability Database System for Database Servers.

-Install, upgrade, configure, performance tune, and troubleshoot Database Servers.

-Assist Application Developers in writing and tuning SQL.

-Install, configure, upgrade, and troubleshoot IBM MQSeries, and IBM WebSphere Application Server.

oSIAC, New York, NY – DBA (Jun 2000 – Mar 2001)

-Administration and Development of Sybase Database and Replication Server.

-Automate Monitoring and Alerting of Sybase Database and Rep Server through In-House Built Framework.

-Automate Archive, Nightly Batch, Backup, and Fail-Over & Fail-Back process for Sybase Database servers.

-Provide Root Cause Analysis for Database Servers Issue and Failure.

-SQL Tuning and SQL Code Review for Application Developers.

oDeutsche Asset Management, New York, NY – DBA Associate (Aug 1999 – Jun 2000)

-Provide Root Cause Analysis SYBASE Server issues.

-Develop and Optimize SQL including Procedure, Function, View, and Trigger.

-Migrate Microsoft Access Database to Sybase Database.

-Develop Database for Trade Surveillance and Compliance System.

-Automate Data Process using KORN and PERL.

-Migrate Processes from VAX to UNIX environment by Collaborating with Mainframe Developer.

-Create Crystal Info 7 Report for Asset Management Group.

oSybase, New York, NY – DBA, Professional Services Consultant (Aug 1998 – Aug 1999)

-Provide Support and Root Cause Analysis of Sybase Database, Replication, IQ, and App Server for Sybase Customer.

-Provide On-Site Tech & Disaster Recovery Support for Sybase Customer.

-Designed and implemented Fault Tolerant Data Server System using Sybase Products for Customer.

oJP Morgan, New York, NY – DBA, Associate (Oct 1996 – Aug 1998)

-Administration of Sybase Database Server.

-Develop and Optimize Procedure to process Trading Information, calculate Asset Price, generate P&L, and Cashflow.

-Automate Data Upload of Trade Transaction to “Corporate Global Credit and Settlement” Database.

-Implement Trigger to Process and Maintain Reference Data.

-Develop APPLIX Spreadsheet to calculate Risk and Financial Report Corporate Senior Management.

-Develop Web Based Trading “Position and Transaction Report” using SQR.

oMerrill Lynch, New York, NY – Consultant (Nov 1995 – Oct 1996)

-Administration of Sybase Database Server.

-Automate Database Backups using Shell Script.

-Create/Alter database objects such as table, and index.

-Manage Database Access through Group and Role.

-Maintain scripts to post new information on CMO-Passport on Bloomberg.

-Process Asset Backed Instrument collateral and prepayment information from various media including Tape.

-Download and process collateral and payment information from various vendors.

-Research Supplement Mortgage Backed Asset data for Traders and Analyst.

-Maintain scripts for downloading deal information.

EDUCATION

New York University, Leonard N. Stern School of Business (Sep 1992 – May 1995) - Finance, and Information Systems Management.

MILITARY

U.S. Army Reserve, Fort Hamilton, NY (Feb 1993 – Feb 2001)

Contact this candidate