Matt King P. Mui Email & Phone Number

Chicago, Il, Us

Chicago, Il, Us

Waldorf, De

supported multiple mission-critical and customer-facing production databases, along with staging and pre-production environments.Designed and implemented sustainable, scalable data pipelines for data transfer and migration, optimizing for cloud migration projects.Developed and executed deployment processes to support regular product software releases.Automated in-house database maintenance tasks and ensured environment health through query tuning and troubleshooting.Key Projects:Cloud Migration: Took part in the development of an automated data pipeline using Python, PowerShell, SQLCMD, and T-SQL to migrate over 10,000 customers from a monolithic on-premises database to a tenant-isolated cloud environment on Kubernetes, utilizing GCP buckets for backups.Data Collection & Delivery: Created a framework in Python and T-SQL to handle multiple workflows for data collection and delivery, integrating with SQL Server nodes in a Kubernetes environment and utilizing Argo Workflows for scheduling.Process Optimization: Enhanced an SSIS-based data slicing process and an ActiveBatch scrubbing process, achieving significant performance improvements by optimizing parallelism and execution strategies.

Brampton, Ontario, Ca

Managed SQL Server and Oracle database administration for the Department of Water Management (DWM), City of Chicago.Enhanced database performance, conducted restorations, implemented recovery procedures, and performed regular backups.Designed and developed both internal and public-facing web applications and syncing processes to meet business needs.Key Projects:Production Database Availability: Served as senior DBA, maintaining over 70 production databases, ensuring high availability.311 Integration: Designed and developed a complex integration interface between DWM and the City of Chicago’s 311 system, significantly improving transaction speed and enabling two-way syncing.METERSAVE Program: Created a web-enabled scheduling system for city employees and residents, streamlining the water meter installation process.GIS Integration: Developed a middle-tier database to sync data between a project management system (InforEAM) and a geographic information system (GIS).Public Applications: Managed public-facing web applications, including Hydrant Use Permit and Email Notification System, ensuring efficient permit processing and community communication.

Alexandria, Virginia, Us

- Providing daily printing functions to support the production of construction blueprints and documents for client- Deploying technical knowledge in printing both standard files and large format drawings- Responsible for troubleshooting and fixing both hardware and software in terms of printing- Coordinating client’s printing server using Windows Server 2008/2012 to ensure smooth printing functions

Us

- Using SQL Server Management Studio to analyze data from medical billing software for client- Develop SQL statements to query CPT/ICD-9 codes, payer and patient data- Develop reports based on client’s requirements using SQL reporting service- Establish priorities to assignments with project manager and write up weekly status report

- Researched and analyzed the event procedures of the events planning industry- Focused and ensured the construction of an effective event planning website by utilizing information technology systems- Communicated to the project team and reporting company in a timely fashion

- Researched and analyzed the storage procedures of the condominium industry- Focused and ensured the construction of an effective marketing plan and strategy that utilized information technology systems- Communicated to the project team and reporting company in a timely fashion

- Designed and updated the web page for the English as a second language department- Ensured that the site was maintained on a continual basis- Provided media hardware technical support to promote an easy learning flow- Provided solution to problem in the case of computer usage and software- Communicated with teaching staff adequately in order to ensure their constant engagement in the progress of the different computers and software

Bachelor Of Business, Information Decision And Sciences

Education record