Van Nguyen, MCSE, MCDBA, OCP

**** *** *****, *******, ** 90680

Phone 714-***-**** • Email: ac7tnu@r.postjobfree.com

Summary

High level of skill and creativity in information systems design and a solid technical understanding of database administration and design coupled with educational and in-service experience. More than sixteen years of experience in database, network, Web administration, and programming; ability to manage multiple complex projects for internal and external customers. Expertise with installing, configuring, and supporting high availability technologies of SQL Server Cluster on SAN, AlwaysOn, MySQL replication on Linux

Highlights

15+ years of SQL Database Administrator experience (MS SQL 2000-2014)

Systems Operations on AWS, 2016

MS Certified IT Professional (MCITP-Database Administrator) - SQL Server 2005, 2008

MS Certified Database Administrator (MCDBA)

MS Certified Technology Specialist (MCTS-DBA)

MS Certified Professional (MCP)

MS Certified Systems Engineer (MCSE) 2000, 2003

Oracle 12c Administration

Oracle Certified Professional (OCP)

Accomplishments

Created new SQL Server clusters on SAN and successfully managed data migration

Created new MySQL replications on Linux on both production and disaster recovery in remote area

Automated data backup, synchronization of data from production server to remote access servers

Converted successfully data from MSSQL to MySQL for Digital Library (www.computer.org)

Created and deployed a new CPIR systems & worked to correct issues with previous version of CPIR

Worked with development team and vendor to accomplish Prophix, financial analysis systems

Experience

Institute of Electrical and Electronics Engineers, Inc., Los Alamitos, CA 8/03 –9/18

Sr. Database Administrator

Performed database design, installation, administration, and supported all database environments of MS SQL Server, MySQL, MongoDB, Oracle including standard and clustering services on SAN.

Automated backup, recovery, tuning, optimizing, indexing, and checking data consistency with mail notification

Set up access privileges to databases, and create user security profiles

Participated in the database design process as required

Implemented, upgraded, and supported network operating systems, email systems, web servers, and applications issues

Enhanced end users’ understanding of DB systems by training Publication office staff members

Worked closely with software developers to meet user requests with prioritization

Performed other duties as assigned, e.g, Web Hosting Services, FTP Services

Processed daily, weekly, monthly reports for Marketing & Sales groups

Uploaded data into DB systems

One World Networks Integrated Technologies, Inc., Los Angeles, CA 3/02 – 7/03

Sr. Database Programmer/DBA

Worked directly with Vice President of CRM, VP of Data & Relational Marketing, Analysts, Financial Professionals to fulfill their special reporting requirements (i.e. quantitative data analysis reports)

Extracted data from multiple and complex data sources for daily, weekly, monthly data analysis and special financial reports

Designed and modified DTS packages to import, export data from multidimensional database files and flat files to central Data warehouse

Developed new customer marketing databases to enhance connection and continuity to customers

Modified, upgraded existing databases (stored procedures, triggers, RDBMS) to enhance database systems, resolve problems with cost-effective solutions (duplicate rows in marketing databases)

Upgraded and maintained documentation on programs and databases

Performed DBA tasks (optimizing/tuning/backup/recovery)

Evolved customer marketing databases to CRM architecture, converted business requirement into logical design, logical modeling technique to enhance customer-marketing opportunities

Downloaded files from FTP servers and extracted zip files to local disk

Processed data to input data into database system

Processed daily, weekly, monthly reports to VP in which pulled data from DB systems

Pacific Technology Solutions, Irvine, CA 10/99 – 1/02

Database Developer

Designed and implemented the entire databases for Internet-based training programs and Learning Management Systems for Hyundai Warranty Reviews, Warranty AuditTrac, Honeywell, Toshiba, Suzuki, Metronic, UEI, Hyundai Motors America Corp.

Designed and implemented e-Commerce Database for store owners to do business using Oracle Database, MS SQL Server, Cold Fusion, ODBC, ADO, and Web Technology

Developed DTS package, Triggers, stored procedures, user-defined functions

Modified, enhanced, and maintained existing databases with stored procedures, triggers to resolve problems with cost-effective solutions

Supported web development teams in defining efficient and appropriate access to data.

Directed and coordinated with users to support issues among client/server sites to ensure timely distribution, positive impact on user satisfaction.

Performed tuning the database and stored procedures, backup/recovery, data migration

Handled installation, configuration, administration of Oracle, SQL Server, and setup Linked Servers, Clustering Services, Web Server on NT Networks

American Suzuki Motor Corporation, Brea, CA 1/98 -10/99

Network Administrator

Tested software and hardware depending on departmental needs

Setup, upgraded, maintained, installed Routers, PC hardware and software, provided troubleshooting, and expanded PCs, monitors, printers

Operated and monitored various computers and their peripheral devices

Upgraded PCs documentation, monitors, printers

Interfaced with 300 end-users and application developmental staff as required on LAN/WAN environment

Education

California State University, Fullerton

Bachelor of Art (Hons) in Management Information Systems, 1999

Cypress College, Cypress

Associate of Science in Computer Information Systems, 1997

Professional Certification

MS Certified IT Professional (MCITP-Database Administrator) - SQL Server 2005, 2008

MS Certified Database Administrator (MCDBA)

MS Certified Technology Specialist (MCTS-DBA)

MS Certified Professional (MCP)

MS Certified Systems Engineer (MCSE) 2000, 2003

Oracle 12c Administration

Oracle Certified Professional (OCP)

e-Commerce Advanced Technology

Lotus Domino Administration

Systems Operations on AWS, 2016

IT Infrastructure Security, 2017

Additional Information

Database Systems: Oracle 8i/9i/10g/12c, MS SQL Server 7/2000/2005/2008/2012, MySQL, MongoDB, Solomon (Great Plain), Datatrax, Progress, Paradox, Prophix, QuickBooks, and MS-Access

Operating System: Windows Server, Linux

Programming languages: PL/SQL, Java, JavaScript, Visual Basic, C++, Crystal Report, Cold Fusion, ASP, HTML, Visio, Solaris Scripts, Unix Shell, Cobol

Special skills: Database Management Systems Design, Web Design/Administration, Data Migration

Expertise with failover clustering installation/configuration MS SQL Server, MySQL replication

Excellent understanding of SQL Server architecture, administration, T-SQL, query plans and security

Solid experience in disaster recovery solutions in SQL Server, Oracle, MySQL, data migration

Expertise with PL/SQL, triggers, User-defined functions, SSIS, DTS, DDL, DML, Replication

Experience with GUI, Network Utilities, i.e. MSDTC, ODBC, PeerSync

Proficient with Internet tools and techniques including FTP, Data Compression, Sun One Web Server Administration, Web Hosting Services

Working knowledge of a marketing/manufacturing/distribution/publication on both domestic and international environment

Ability to work both independently with minimal or no supervision, and in a team environment with varying levels of technical expertise in high-pressure situation and complex environments

Honors

Appreciation for 10 years of dedicated services at IEEE, 2014

Awards as a Golden Core Member of IEEE Computer Society, 2010

Team Award for supporting CPS & creation of new CPIR system, 2017

Team Award for launching CPIR Project, 2006, 2010

Member, Golden Key National Honor Society, 1999

Dean’s honor list, 1998

President’s honor list, 1997

Personal: Energetic, team player, honest, responsible

Contact this candidate