TAM HUYNH
Aliso Viejo, CA
Cell: 626-***-****
Email: ada5pk@r.postjobfree.com
PROFESSIONAL SUMMARY:
IT professional with many years of industry experience with emphasis on administration and application development.
Experience administrator in 24/7 OLTP support and data warehouse database development
TECHNICAL SKILLS:
Databases: ORACLE 8i/10g/11g/12, MySQL 5.6/5.7, SQL Server 2005/2008/2012/2014, Postgres 9./10/11, Teradata
Tools: Red Hat Enterprise Linux, Oracle Grid Control, Oracle EM RAC, Export/Import, SQL Loader, SQLPlus, SAS, Pentaho 4.4.4, Visual Sourcesafe, Git, SQL Developer, MS Visio/Excel/Access, Toad DM, PgAdmin4, SqlYog, AWS, Navicat DM, gh-ost version 1.0.48, pt-table- sync version 3.0.11, percona xtrabackup, SSMS, SSIS/SSRS, AWS Rds Languages: SQL,PLSQL, Visual Basic 6.0, Perl, TCL scripting, C Shell, Java, C++/C, Bash shell scripting, Python3
EXPERIENCE:
2019- Present ACORNS, Irvine, CA
Database Administrator
Maintain 24/7 high availability application utilizing AWS architecture
Support over 50 Postgres databases and 10 Dynamodb databases 2014- 2019 INTERNET BRANDS, El Segundo, CA
Database Administrator
Maintained 24/7 high availability internet sites for IB including Fodors, DemandForce and WebMD
Troubleshoot and test disaster recovery planning
Migrated Mysql, Postgres, Mssql Server databases across data centers
Designed and scaled database backups, schemas, tables, indexes, users
Configured database processes, setup databases for test and production
Developed and designed ETL processes using SSIS packages
Worked with developers on performance tuning, store procedures
Developed data analysis TSQL/SQL to support dev projects
Experienced in working with high volume transactional databases on Linux/Windows
Implemented high availability solutions including clustering 2014 – 2014 KAISER PERMANENTE, Pasadena, CA
Technical Specialist
Extracted data from Clarity, HealthConnect production server
Worked with database team on ETL refresh processing
Worked with statisticians using SAS to report on diabetes population 2009 – 2014 KAISER PERMANENTE, Pharmacy Analytical Srvs, Downey, CA Data Consultant
Maintained 24/7 production application support for Pharmacy Online Interactive Tools (POINT) on data warehouse and OLTP side
Designed and maintained a Medicare supported application call Pharmacy Outpatient Pricing System (POPS) for national drug pricing
Designed and implemented database SOX requirement for the PSOS CM/CA Point tools for national compliance
2003 – 2009 KAISER PERMANENTE, Pharmacy Analytical Srvs, Downey, CA Senior Data Analyst
Manipulated and summarized large data sets for batch processing using Oracle 8i,10g, and 11g
Explained root cause, business processes using Remedy and track internal issues through Issue Manager
Designed ETL process using external tables for populating data marts
Extracted, loaded and maintained quality assurance for the membership data for the UCLA group for various sources
Asserted best practices in ETL transfer of information, data modeling
Provided technical guidance to junior developers to ensure standards are met for complex applications
2000 - 2002 SUNRISE TELECOM, INC., San Jose, CA
Software Engineer
Converted VoIPExplorer application database queries from MS Access to Oracle
Developed a graphical user interface for the Voice over IP application using Java with JDK 1.3 for VOIP simulation testing EDUCATION:
02/07 – 02/07 Oracle Database 10g Administrator Certified Professional 08/97 – 05/00 Bachelor of Science in Computer Science University of Kansas