Engineer Data
Resume:
LIYA HUNG
**** ***** ***** ****, ***** ***-**, Kennesaw, GA, 30144
****.****@*****.***
Experience Summary:
Cloud Engineer/ VMware Server/Systems Engineer/Database Administrator /Deployment Engineer /Developer level in the fields of Windows, Linux, MS-SQL, ORACLE and .NET to assist in product development, system integration and support. Experience designing and implementing corporate and production web sites, systems modeling as well as integrating with legacy data and systems
Education:
Central Missouri State University
MBA, Major: Computer Information Systems
National Taichung Institute of Commerce
B.S. Major: Accounting and Information Systems
Certifications/Training:
HP-UX, A+ certification, Six Sigma
Technical Skills:
Languages:
PL/SQL, Toad, UNIX/Linux, Java, MS VB.Net, ASP.NET, C#, T-SQL, PowerShell, Visual Basic, Great Plains, C/C++, Perl, People soft, COBOL
Operating Systems: Windows server, Linux
Ancillary Skills: VMware, AWS, Azure, Citrix, MS-Office 365, Networking fundamentals, Oracle11i/ 12c, MS-SQL servers, and Business Objects, CMS-IBM, VAX/VMS, SUN, MVS/TSO, Crystal Reports, DB2, JCL
Experience:
2016/3 ABOLSoftware
Title SaaS Deployment Engineer
Setup, configuration, and maintenance of Azure and Amazon Virtual Machines
Management of Azure and AWS subscriptions
Configuration of Windows Server VMs for optimal cloud configuration
Performance Measurement and monitoring
Staging and Deployment of Application releases and updates
Monitoring of infrastructure and application
SQL Server High Availability Configuration
2005-2015 Datascan Technologies/ Jmfamily-JMSC
Title Sr. Systems Administrator
Configure, implement, support, & maintain all physical and virtual severs located in the data center facilities
Script automation jobs by Powershell
Support all Operating Systems, such as Windows, Linux
Create, configure new virtual servers in the VMWare environments
Install and configure new version of applications in AWS environment
Ensuring that the servers meet company standard and updated with the latest patches
Implement and or maintain client application systems in Citrix
Streamline and automate upgrade processes
Automation of Disaster Recovery where possible, responsible for Disaster Recovery testing
Wrote scripts to automate internal upgrade process.
Designed and created scripts to modify MS-SQL database structures which include: tables, indexes, triggers, stored procedures, functions and packages.
Installed and upgraded servers and application tools, loaded necessary patches to fix bugs.
Converted data into database and data warehouse from other sources.
Deploy application changes to QA/ Development, test and production environments.
Utilized Reporting tools to create reports for data analyses.
Prepared login ID and network access protocols to enable clients to gain local or remote access.
Worked as a Database/Systems Administrator to do backup and recovery, software distribution, planning the capacity needs of production servers for new projects.
Monitored and optimized servers using Windows Performance Monitor tool /SCOM.
Developed, designed, tested, implemented databases, wrote SQL scripts to automate the backup process; created packages, stored procedures, and triggers to enforce data integrity; analyzed table spaces and objects to get statistics.
Provided user support for developers, monitored server activities; tuned applications to improve performances.
Prepared Web page by ASP/ASP.NET and login scripts by VB/VB.NET; establishing network access protocols to enable customers to gain local or remote access.
Controlled and monitored users access to databases
2003-2004 Business Consulting and Investigations Inc.
Title: SOFTWARE ENGINEER/DBA
Integrated database from mainframe into Oracle9i database server as well as outside database on SQL Server 2000. Defined the logical data modeling, designed /developed the physical database utilizing Composer/IEF and ERWIN sized tables and indexes for efficient storage usage.
Translated older databases to SQL server for integration.
Developed and implemented company web sites, inventory, case database management, sales management, payroll, order processing program, and billing systems.
Utilized Crystal Reports create reports for manager to review.
Trained product users between client/server companies.
1999-2003 SUNTRUST BANK-Tech Services (Server Product Services)
Title: SOFTWARE/SYSTEMS ANALYST
Utilized Crystal Reports 9.2 /Actuate to create reports for data analyses. Developed project data model and supported services using ERWIN.
Prepared login scripts and establishing network access protocols to enable customers to gain local or remote access.
Prepared Web page login scripts by ASP/ASP.NET and establishing network access protocols to enable customers to gain local or remote access; controlled and monitored users access to databases.
Installed new version of Oracle9i applications, and other software related to DBMS administration.
Maintained databases, wrote PL/SQL scripts for Oracle9i servers to create packages, stored procedures, and triggers to enforce data integrity; analyzed table spaces and objects to get statistics.
Installed and upgraded the MS-SQL2000 server and application tools, loaded necessary patches to fix bugs, converted data into database and data warehouse from other sources.
Provided user support, monitored database activities, tuned applications to improve performances.
Did the initial data loading to tables using DTS, analyzed the Query plans for performance improvements; Managed transaction consistency and concurrency, database access, ODBC.
Installed new version of business applications, and other software related to DBMS administration.
Worked as a Database Administrator to do software distribution, backup and recovery.
Served as technical analyst with responsibility for significant project to resolve the most complex customer problems; e.g., by re-imaging customer workstations and correcting other workstations affected by similar problems.
Served as QA testing the computer programs before production.
Distributed enterprise Web applications to all servers/workstations and maintained control processes that load and updated data.
Documented guidelines for application users.
1998 Missouri Department of Social Services
Title: DATABASE DEVELOPER/ANALYST
Converted data files from mainframe into Oracle databases on NT; tested new software before moving into a production environment. New product was Windows NT-based with an SQL server front-end and an Oracle backend.
Developed project data model and supported services using Composer/IEF and ERWIN.
Defined the logical data modeling, designed the physical database, and built the database in Oracle 8; sized tables and indexes for efficient storage usage.
Used SQL*Plus to write queries to analyze and resolve data discrepancies and utilized PL/SQL for application modifications.
Operated and maintained databases including relational database design, version control of database objects, creation and maintenance of stored procedures, data triggers, performance tuning, back up and recovery database.
Responsibilities were 50% administration and design and 50% hands on analysis and development.
Defined the project goals and requirements, analyzed the functional and data requirements, and proposed solutions, interacted with clients to customize product for specific needs.
1997-1998 Central Missouri State University
Title: HTML/JAVA AUTHOR WITH CMSU
Used JAVA and HTML coding and maintaining the homepage of COIS department.
1996-1997 ABI Corporation
Title: ORACLE DEVELOPER/DATABASE ANALYST
Designed, developed and implemented an Oracle database, client/server application adaptable to a billing system.
Utilized Oracle 7.x Developer 2000, and PL/SQL (Forms 4.5, Reports 2.5, Graphics 2.5) as a front-end tool and SQL Plus environment at the server side on NT.
Conducted business requirement analysis and preliminary logical model and physical database design; created various server side objects, i.e., tables, views, indexes, procedures, functions, and database triggers.
Interfaced with clients to assist with customization needs, also used Visual Basic to create some product interfaces.
Installed and upgraded Oracle and supporting products.
Created databases and configured Oracle instances.
Configured and managed SQL*Net.
Monitored and audited database accesses and security, managed integrity constraints, designed logical and physical databases.
Allocated and managed storage structures.
Controlled system resources, managed database users, implemented the backup and recovery process. Administered Oracle on UNIX and NT: constructed, tested and maintained stored procedures using PL/SQL.
Provided on-call support to resolve production problems, and design, construct and maintain UNIX shell scripts to control processes that load and update the data.
Migrated tables, stored procedures, and shell scripts from development to production using Oracle’s Export and import utilities.
Sized tables appropriately for production volumes of data and ensure tables and indexes are placed in appropriate spaces.
Assisted development coordination team in maintaining project data model and assisted Senior DBA in the project development and support services using Oracle/SQL, MS-Access and Visual Basic.
Contact this candidate