Wenlong Hung

ad2lc8@r.postjobfree.com

Cell: 240-***-****

Technical Skills:

Database developing & administration, Upgrades, Data Architect & Modeling, automated scripts, and performance tuning on clouds and data centers: MS SQL (2005, 2008R2, 2012, 2014, 2016, 2017, 2019), PostgreSQL (9.0 9.3, 9.5, 9.6, 10,11,12, 13, EDB/Community Edition for on-premises and/or Cloud PostgreSQL and Aurora), Oracle (11gR2, 12c, 18,19), Sybase, PuppetDB, Liquidbase, and Greenplum (Data Warehouse and Data Lake analysis tools based on PostgreSQL Database) in Data Warehouse or Lake.

Software/Application developer: Utilize CI/CD with Jenkins, Docker containerization (Git/GitHub), AirFlow, OpenVMS/KVM and deployed application using Docker/Kubernetes. PowerShell, PL/SQL, SQL Scripts, Hadoop Eco(ElasticsearchJ2EE (JSP, XML, DOM, JDOM, EJB, Servlet), Apache Spark, Java (Applet, Swing, JSP, JDBC, RMI, Perl, curl, security, and Application), JavaScript(Node.js), Python, C/C++, Access/VBA, Toad, Erwin, Crystal Report, Informatica, OBIEE, Open Edge, QlikView/Sense, SAS, SSDT, SSIS, SSAS, SSRS and MS Studio Management, Python, Tableau, Orange, Visual studio, Apache NIFI, Jenkin/Jira, ODBC for MS SQL and AWS (Elasticsearch, React, Ansible,CloudFormation, S3, Redshift, RDS and EMR).

Operation System management and monitoring: Docker/Kubernetes, Agile, Jira/Git for version control and source control, Linux, CentOS, Ubuntu, Puppet, Solaris Ultra Sparc, TRU64 UNIX, Window Server (2003, 2008, 2008R2, 2012R2, 2016 and 2019), RAID/SQL server, VMWare (5.1 & 5.5) for virtual environment, AWS Liquidbase, and Microsoft Azure Cloud (MAC).

Strong business/database/data and systems analysis skills for data warehouse and data lake: analytical techniques, data gathering techniques, business modeling methods, business process, data gathering to solve complex issues, development of implementation plans based on Microservice Strategy, development of requirements, reports created and key analytical troubleshooting.

Language Capability: English, Mandarine and Taiwanese.

Experience Highlights:

ProSol1.com/ IRS 01/2023 – 10/2023

--Greenplum Database SME: Alexandria, VA

Design, implement and provide daily operational support for the encryption of Greenplum database and key management. Greenplum database is data warehouse tools based on PostgreSQL database and utilizes all PostgreSQL stored procedures and functions.

Teamwork with System /Network/ Development teams to support team development needs for setting up system configuration on servers and databases to encrypt and decrypt systems, paths, files or data involved and test PuppetDB..

Capgemini America Inc/ AFLAC 04/2022 – 06/2022

--Lead Solution Architect (Remote): Atlanta, GA

Assisting with the execution of migration discover workshop with the largest enterprise customers, Utilize CI/CD with Jenkins, Docker containerization (Git/GitHub), and deployed application using Docker/Kubernetes.

Building out proof of concept migration projects including databases and applications migration identifying technical solutions to migration obstacles to ensure appropriate resources on AWS clouds.

Knowledge and experience of relational databases, Oracle, SQL, PostgreSQL, Aurora, Open stack Cloud Infrastructure MongoDB, networking, and virtualization MySQL, PuppetDB, and DB2 to work with Apache Spark.

Draft plan to optimize and automate configuration plans with other team members for AWS cloud environment.

OST Global Inc/ ERP International / DOD-GFM 02/2021 – 01/2022

--PostgreSQL Architect /DBA /Developer: McLean, VA

Design and test database infrastructure and architecture to host information and develop schema, tables, stored procedures, and security setup to detect hacker/fraud to hold data on AWS/RDS/S3/Redshift, Python or JSON, Azure or Docker/DevOps or Kubernetes of Cloud environment (Utilize CI/CD with Jenkins, Docker containerization (Git/GitHub), and deployed application using Docker/Kubernetes) or on servers of data centers.

Teamwork with System /Network/ Development teams to support team development needs on Hadoop, Dockers, Kubernetes, Airflow, Apache Spark, and Azure cloud accesses.

Research, install, administer, monitor, troubleshoot, document, and maintain enterprise PostgreSQL 13 (EDB) on-premises and Cloud, Open stack Cloud Infrastructure MongoDB, networking and virtualization MySQL, SQL, Oracle (19), Liquidbase and Open-source PostgreSQL 13 databases to ensure maximum availability of mission critical systems and applications.

Identify and resolve issues as required working with our customers, internal and external support partners. Plan, build and execute multiple detailed projects/tasks simultaneously.

Migrating and Coding functions (PL/pgSQL, SQL scripts) and procedures, function, views and indexing for PostgreSQL to improve data quality and perform the same requirements as on Oracle environments via Liquibase and SolarWinds. AWS Glue, Aurora, Monitoring performance on both Oracle and PostgreSQL database servers.

Alta IT Services, Inc. / GDIT / CFTC ODT 08/2019 – 08/2020

--Database Administrator (DBA) / Developer: Washington, DC

Production Support on 5000+ Production and 1000+ non-Production SQL Databases to CFTC daily operation needs, including data warehouse, backup management, real time technical support, preventative analytical processes for possible problems and create/improve procedures for improve Database (SQL, PostgreSQL (on-premises and Cloud), ERP, Greenplum (on-premises) operations and Apache Spark.

Design and automate Performance monitoring Architecture to collection information from all servers and databases, data warehouse the collected data, data mining to find the causes of possible issues and generating daily reports.

Teamwork with System /Network/ Development teams to support daily operations needs from each department/division/location and cloud accesses with Active Director setting and AWS KMS (TLS) and DMS for SQL, SSIS and SSRS reporting applications, Open stack Cloud Infrastructure MongoDB, networking and virtualization MySQL, Python, SharePoint, PowerBI, PostgreSQL, AWS/Redshift, AWS GLUE and Greenplum databases based on Microservices for information usages.

Performed proactive database tuning tasks including creating indexes, tune SQL statements and queries (PL/SQL, SQL scripts), improve table join conditions, and provide database configuration tuning recommendations for SQL and Greenplum/PostgreSQL databases for better data quality and performance.

TTW Solutions, Inc. /Center of Excellence/ DHS OBIM-HART 01/2018 – 05/2019

--Sr. Data Architect/ Data Modeling, DBA & Developer: Fair Lakes, VA

Designed, coded, and tested functional components of information systems including middle-ware applications, according to project specifications, while ensuring the databases are correctly functioning according to system requirements and business operation based on Microservices design.

Performed logical and physical data modeling, data architecture and database design based on business requirements, workflows, functions, indexing, reporting, and naming standards. Created and updated functions, procedures, schema, tables, and related components.

Developed documentation (glossaries, process diagrams, ERD, data dictionary), agreed solution alternatives for existing IDENT issues into PostgreSQL and built scripts to implement, administer, and maintain infrastructure for ensuring the security and data integrity of project’s database(s) with Erwin Data Model tool.

Team works to build ETL environment for migrating from Oracle (12c) to PostgreSQL (9.6, 10 or later of Community Edition) with CloverDX ETL tool. Performed data integration and develop Extract, Transform and Load (ETL) scripts (PL/pgSQL, SQL scripts) to extract raw data from ERP or Oracle database sources and exported into PostgreSQL server databases for Application to use Jira/Confluence on CI/CD pipeline.

Generated or updated scripts to automatic creating services (IAM, Security Group, EC2, S3, Python, DynamoDB, and Aurora PostgreSQL) of AWS by utilizing EMR and CloudFormation stack function.

Designed and developed a data warehouse (PostgreSQL, RedShift, Open stack Cloud Infrastructure MongoDB, and networking and virtualization MySQL) to host all information to track progress, analyze data, data mining, generate reports and assess performance of process and key initiatives by using AWS related tools like Hadoop, Glue, DMS, Spark, Ansible (for database deployment) and utilized CI/CD with Jenkins, and deployed application using Docker/Kubernetes etc.

Crown Consulting, Inc. / Concept Solutions, Inc /FAA AMSSD 07/2017 – 10/2017

--Sr. PostgreSQL DBA /Developer: Reston, VA

Provided PostgreSQL (community edition on-premises and Cloud) and Oracle production databases support to users and developers in Amazon Web Services (AWS) RDS environments.

Enhanced/updated logical and physical data modeling, data architecture, and database design for transaction and analytics reports from OLTP and OLAP for Apache Spark.

Performed data migration from different data sources to PostgreSQL by utilizing available tools that support each data source/format and data quality.

Created, back up, restore & drop databases to duplicate Production environment for developer team.

Reviewed database schema & structure for design improvements and data normalization. Coordinate with developers for making approved changes to schema and table structures.

Reviewed all PostgreSQL logs for problems by PgBadger. Optimized postgresql.conf for performance improvement.

Automated and scheduled Scripted PL/PgSQL stored procedures (PL/SQL), data types, triggers, and constraints. Code shell scripts for scheduled maintenance.

TTW Solutions, Inc. /CPSC 01/2017 – 09/2017

--Sr. SQL Server DBA (Part time): Washington, DC

Provided Microsoft SQL Server Database administration services in production data center and development Amazon Web Services (AWS) environments while ensuring the databases are correctly functioning according to system requirements.

Develop, implement, administer, and maintain policies and procedures for ensuring the security and data integrity of project’s database(s) and utilized CI/CD with Jenkins and Docker/Kubernetes for upgrading and deployment of new version application.

Implement and continuously improve data models, database designs (OLTP), data access (by applying database-per-service of micro-service architecture) and table maintenance commands and scripts due to increased processing and growth trend.

Performed proactive database tuning tasks including creating indexes, tuning SQL statements and queries, improving table join conditions, and providing database configuration tuning recommendations.

Resolved database performance and capacity issues, replication, and other distributed data issues.

Monitoring computer hardware and software resource utilization and managing physical database usage and disk storage capacity to ensure proper usage and allocation.

Utilized Java/Python for application to access database data to present on the user interface for information reports.

Automated Performed database and table backup and recovery tasks when necessary.

Generated and updated procedures and data dictionary documentation.

Jerry Thompson & Associates /FAA 03/2016 – 06/2017

--PostgreSQL DBA / Data Model & Architect : Washington, DC

Owning, tracking, and resolving database related incidents and requests, fulfilling requests, and resolving incidents, reviewing services reports (database backups, maintenance, auto and manual monitoring) on daily basis to ensure service-related issues are identified and resolved within established SLAs on PostgreSQL (Community Edition), Greenplum, MySQL and Couchbase databases (on Ubuntu and Windows).

Conducted on-premises and Cloud PostgreSQL Database performance tuning, database security, promoting process improvement, capacity review and plan, database backups for Disaster Recovery, IT architecture and information security policies to improve performance of Databases and application by adding new hardware and decomposing application into different logical components.

Setup, administered, master/incremental backup and performance tune MS SQL Server database instances in a Microsoft Azure Cloud (MAC) environment for proof of concept (POC) to support testing of migrating existing MS SQL Server database instances to cloud and evaluated, reviewed, and proposed plans to migrate current Information system into cloud (AWS and Seagate) to support future 24/7 real-time applications.

Developed automated applications/functions/reports/views to collect information about each flight point in flight plans for performance analysis by utilizing MongoDB (for documents management).

Utilized Hadoop Ecosystem, middle-ware applications and in NAS Data Monitor tools for aviation automation, communication, navigation, surveillance, and/or weather systems in support of FAA performance analysis systems.

Implement and continuously improve data models, database designs (OLAP), data access (by applying schema-per-service of micro-service architecture), data mining (Orange) and table indexing and maintenance commands and scripts due to increased processing and growth trend. Develop front end daily reports to be used in daily Management meetings for all US airports performance information by utilizing Microservices API Gateway or Branches acts for different divisions.

Information Innovators Inc. / Department of Veterans Affairs 10/2013 – 10/2015

--Database Administrator & Developer: Falling Waters, WV

Evaluated, monitoring and propose Linux/Oracle (11g) & PostgreSQL and Windows/SQL (2008 & 2012) setup, including reallocating SAN disk space to engineer a robust, scale-able solution to utilize available and improve productivity.

Installed, configured, managed, and supported Linux/Windows systems for Oracle, PostgreSQL, and SQL database servers (2008R2 and 2012) including middle-ware applications – Performed maintenance (Space adjustment, Backup, Restoration, Mirroring & Replication), Troubleshooting for performance and notified related parties thru handheld devices and emails.

Worked in overall system architectures (including databases and AWS) planning (OLAP: Data Warehouse and Data Model), upgrade, migration and testing for network and data security for High Availability and Disaster Recovery.

Developed reports (by scripts and ad hoc query on supported applications) for system/database monitoring (CPU, Memory, Disk space, IO Latency) and performance tuning on VMWare Environment for Linux/Oracle and Windows/SQL (hosting Windows and RHEL OS) and pointed out the bottlenecks with statistics numbers based on Microservices API Gateway for different divisions.

Database Administration for SQL and Oracle Medicare databases troubles shooting and rebuild/restore Oracle database (11g) after database crash.

Developed and/or updated documentation, participates in the development of department technical procedures and designs user guides.

Boland 03/2005 – 07/2013

--Data Analyst developer/Database Administrator: Gaithersburg, MD

Tech Lead of migrating whole IT system from UNIX environment to Windows environment including database DBS (PostgreSQL on-premises /Linux and MySQL to MS Dynamics 365 GP/Windows on Gap analysis, Business Requirement Analysis, Function design, Testing, Go 'Live”, post Implementation Support and Continuous Improvement of User experiences by Microservices Chain responsibilty to support information needed for operation.

Acted as the overall systems (Accounting, Sales and HR departments) requirements expert, by leading and facilitating the requirements gathering process to improve reliability and efficiency and reduce system downtime to less than 1% per year.

Installed, configure, and optimize SQL (2005, 2008R2) database server (OLTP for GP and Wennsoft) for continuing operation efficiency, data warehouse design (OLAP, SSRS, EXCEL, ETL: SSIS and Dynamics 365 GP) for reporting and backup/restore plan for disaster recovery from days to less than a hour.

Created a system to monitor day-to-day tasks and activities to find area of improvement for SQL DBA daily maintenance operation and pinpoint the causes may lead to disaster on production servers schedule and accurately assess the risks of the requirements and analysis process.

Strong business and systems analysis skills, testing skills, troubleshooting skills, developing reports of operation and inventory and experience with numerous environments and architectures. Utilized SSRS to generate routine reports (SSRS, Access, Excel) requested by users.

Lead in feasibility study of overall company system/data storage architectures converting to virtual environment (VMWare 5.0) and new middle-ware application software implantation (including databases migration) and testing for network and data security. Migrated Linux/Progress database and Access data to SQL 2005 by using SSIS and Toad. Upgraded SQL 2005 to 2008R2 later.

CPS/SRA International 12/2004 – 03/2005

--Programmer/Developer (Contractor): Fairfax, VA

Utilizing Java Server Faces, WebLogic Platform 8.1, J2EE, JBuilder 2005, and MySQL, Oracle/PostgreSQL database as information Back-end tier for logistics/transportation related projects and Java/Python for Front end application.

SSA/Infused Solutions/DRC/NSF 10/2004 – 11/2004

--Programmer/Analyst (Contractor): Vienna, VA

System reengineer, integrate, debug & build content management for National Science Foundation by utilizing Tomcat, Java, J2EE (EJB, Java Bean, XML, JSP), struts, Eclipse, IntelliJ, RSS, ColdFusion, and Sybase database as information Back-end tier and JavaScript or Python for front end application.

TEK Systems/SAIC 06/2004 – 10/2004

--Programmer/Analyst (Contract): Reston, VA

Design and build Data migration and ADS-to-portal integration of SAIC-NAVSEA (PEO-IT) by utilizing Tomcat, Ant, Struts (validator & taglib for Front-end interface), J2EE (EJB, Java Beans, XML, JSP), JDOM, JAX-RPC and Axis.

Master Yi Yungao International Cultural Institute 04/2004 – 12/2006

--Consultant: CA & MD

System design, build, upgrade, and maintain membership database by utilizing MySQL database in Linux Operation environment as Back-end information tier.

Objective Data Storage (Former: US Design Corp) 7/2000 – 12/2003

--Software Engineer: Columbia, MD

Java (Application, GUI - swing & awt, JDBC, RPC, JAAS, and Servlet), C/C++ and Shell scripts coded Universal Superstore (by using JBuilder as IDE) to increase write/Read performance of USS by 200% on Solaris, Unix and Linux systems. Other application functions developed and added are to automate message logs size rollover, to display active devices from configured ones, to increase reading speed on jukeboxes with I TB capacity or more, and to improve GUI friendliness to users.

Manage and maintain web sites to supply B2C and B2B web services to customers and out of state offices. Proposed and built multi-tier network (JSP, Applet, and JavaBean for Front-end tier; Servlet, Apache Server, Tomcat, and MySQL for Back-end tier) collaborated with existing web site for Marketing/Sales Dept. to increase product publicity and to attract more potential customers.

System design, upgrade, install, maintain, troubleshooting, and document Linux and Linux server (VPN server, NFS server, FTP server, Gateway, Firewall, SSL, Qmail Server, Spam assassin, Samba, Apache server, WebLogic, Jakarta Tomcat and MySQL) for operation and testing. Reduce technical expenditures by waiving software licensing spending with open-source software and lower engineer personnel needs for 66%.

Chubb Computer Services 07/1999 – 06/2000

--TCP/IP Programmer: Reston, VA

Designed 3-tier network (Java Applet & Servlet, Apache-JServ, JDBC & MySQL database) procurement system. The UNIX operating system is Red Hat Linux on a TCP/IP network environment, which communicates with each other via TCP/IP socket.

Utilized UML (Business process and domain analysis, JAD session, usage of system, interaction among objects, object and component diagrams, prototype user GUI, plan for deployment and tests, construct code & test, install and test finished system on assigned hardware) to present the road map for developing.

Setup B2C E-Commerce site (Apache server, firewall, MySQL and Java technology) for Procurement Databases on Red Hat Linux server. Completion of this project resulted in speeding up the efficiency of accessing the database by 150%.

Professional Trainings & Certificates:

SCALED AGILE FRAMEWORK: Certified SAFe 5 Practioner 2021-2022

ISACA: 2020-2021 Certified CMMI Associate

Udemy: 2017-2023

AWS Administration – Database, Networking, and Beyond

Amazon DynamoDB: Build out NoSQL Databases in the AWS Cloud

AWS CloudFormation Master Class

AWS Certified Solutions Architect - Associate 2018

Learn How To Become an Azure SQL Database Architect

PostgreSQL: Advanced PostgreSQL Queries and Data Analysis

The Data Science Course 2020: Complete Data Science Boot camp

Introduction to Project Management

AZ-300/AZ303 Azure Architecture Technologies Exam Prep 2020

Database Engineer/DBA - (PostgreSQL, IBM-DB2, MariaDB,NoSQL)

Microsoft Azure Lab: Youtube/Microsoft

Microsoft Azure Database administration 2016

WennSoft: Milwaukee, MI

MS Dynamics GP administration 2012

ONLC: Columbia, MD MS SQL DBA for SQL2008 2011

Chubb Institute (Top Gun): Reston, VA

TCP/IP Client/Server Programming 1999

Anne Arundel Community College: Arnold, MD

Internet Specialist 1998

Education:

Wright State University: Dayton, OH

MBA, majored in Finance March 1991

National Sun Yat-Sen University: Kaohsiung, Taiwan

Bachelor, major in Business Administration June 1985

Contact this candidate