Cong Nguyen

Experience

• 

  McDonnell Douglas at

  Nov 1990 - Apr 1994

  Software Designed Engineer

  Designed/wrote C-program front-end data acquisition via socket streams (TCP), IPC (share memory, message queues, and name pipe), serial line interfaceSystem Admin/Oracle DBA for Cargo Interface Test Equipment

• 

  Allen Systems Group Inc

  Apr 1994 - May 1996

  Senior Software Designed Engineer

  Designed/wrote C-programming (TCP/IP) client and server applications Ported C-programs from Windows to UNIX environment to OS/2 or back to Windows.

• 

  Texas Instruments

  May 1996 - May 1998

  System Engineer.

  Installed Solaris 2.5on E3500, constructed RAID volumes (RSM2000)Performed various Oracle DBA and System Administrator jobsLoaded and reloaded data from testers (KLA/Tencor) to Oracle DatabaseWrote/modified C programs to interface testers and Oracle using OCI.Supported DMOS3/DMOS4/DMOS5 Test floor

• 

  CLUBCORP Corp

  May 1998 - Feb 1999

  Oracle Database Administrator

  Supported 10.7 Apps and 7.3.4 database on Digital UNIX Alpha server A4000/A8000 (true cluster)Wrote cold/hot backup scriptsInstalled and configured Legato/EBU to backup OS and Oracle DatabaseInstalled Oracle Financial 10.7 Apps NCA on Digital Unix cluster environment and Solaris 2.6Performed and documented Oracle Financial Applications and NCA cloning procedures. Installed and configured Solaris 2.5 on SUN E3500.Installed and supported Oracle Express database 6.xSolaris 2.x System Administrator and Oracle Database Administrator 7.3.x, Show less

• 

  Ft. Mortgage

  Feb 1999 - Nov 1999

  Oracle Database Consultant

  Supported Oracle 7.3.x on AIX 4.3.2 and NT ServersTuned Oracle resources SGA, rollback segments, redo logs, SQL statements Wrote/modified automated processes to check tablespaces, rows count, extents, objects count, database uptime via UNIX cron or NT schedulerCloned database, configured listener, installed Oracle RDBMS and Oracle client, enabled auditing, configured ODBC driver, recovered production database from hot backupSupported Platinum database applications. Supported Platinum products Show less

• 

  Alcatel USA, Inc

  Nov 1999 - Jan 2004

  Sr. Oracle DBA

  Provided 24x7 database support for OLAP (SharePlex, and physical standby) and OLTP databasesWrote procedure to clone database using hot backup, exp/imp, and transport tablespacesInstalled Oracle 8i, 9iAS, Designer 2000, 11i Apps, RMAN, Shareplex, I/Watch, SQlab, Space Manger, SpotlightWrote scripts to monitor overall database statusSetup, maintain, and upgrade Quest SharePlex versions 3.x and 4.xWrote instructions to upgrade 7.3.4 to 8.0.5 and 7.3.4 to 8i (8.1.7)Installed/upgraded Oracle ERP 10.7 to ERP 11.5.6I/O benchmarking UFS, RAW and VXFS Cache Quick I/O file system; Tested and wrote instructions to convert Oracle RAW datafiles to VXFS Cache Quick I/O datafilesSetup RMAN; customize backup jobs to work with NetBackupFile Systems support: UFS, VXFS, and RAWTuning PL/SQL statements, capture bad sql; tuning database resources: SGA, rollback, redo logs and latches; wrote trigger to pin objects upon database startupAnalyze Oracle system state dumps, and session trace dump file.Partition tables and indices to achieve data throughputTrained new DBA.Wrote Oracle database disaster recovery procedures planWrote ksh scripts and automated jobs to report Oracle database health check and extents report.Wrote ksh scripts to analyze 370 Gig database under 4 hoursInstalled OCFS (Oracle Cluster File System) on Red Hat Linux 2.4.21-20.ELInstalled Oracle 9.2.0.5 RAC on LinuxInstalled Oracle 9.2.0.5 RAC on Solaris 2.8 and VXFS file systemsInstalled Manugistics web works Show less

• 

  Dell Technologies

  Oct 2004 - now

  ASP (Application Service Provider) DBA team lead at Dell/Perot Systems last 5 years.Responsible for Database capacity planning for new ASP client.Provide 24x7 production support for 9 very large Health Care clients running on Diamond, Peradignm and Xcelys Apps.Support 10 OLTP production, 10 OLAP production data warehouse and 50 development databases. Database size ranging from 200 Gig to 1.5 Terabyte.Build and optimize database performance and SQL tuning. Setup database RMAN and begin/end table space backup.Wrote database monitoring scripts to save company money from buying database monitoring tools.Installed 9i, and 10g on RedHat Linux 5.x, AIX 5.x and HP UX.Upgraded 8i to 9i, and 9i to 10g.OEM support: Add database, monitors and scripting new alerts.Clone database via expdp/expdp, exp/imp, HOT BACKUP and RMAN.Build database materialized views.Knowledge in Oracle 10g Data Streams, 10g flash back, and 11g new features.Utilize function based index to help Oracle optimizer.Implemented tables and indices partitioning – improved run-time.Use Automatic Workload Repository (AWR) and Statspack to analyze database performance.Work with system admin to setup RAID Disk, analyze disk I/O. Show less

  • DBA

    Nov 2004 - now

  • Sr. Oracle DBA

    Oct 2004 - Oct 2019
• 

  Dell/PerotSystems Services

  Nov 2004 - now

  Sr. Oracle DBA

  ASP (Application Service Provider) DBA team lead at Dell/Perot System last 5 yearsResponsible for Database capacity planning for new ASP clientProvide 24x7 production support for 9 very large HealthCare clients running on Diamond, Peradignm and Xcelys AppsSupport 10 OLTP production, 10 OLAP production data warehouse and 50 development databases. Database size ranging from 200 Gig to 1.5 TerabyteBuild and optimize database performance and SQL tuning Setup database RMAN and begin/end table space backupWrote database monitoring scripts to save company money from buying database monitoring toolsInstalled 9i, and 10g on RedHat Linux 5.x, AIX 5.x and HP UX.Upgraded 8i to 9i, and 9i to 10gOEM support: Add database, monitors and scripting new alertsClone database via expdp/expdp, exp/imp, HOT BACKUP and RMAN Build database materialized viewsKnowledge in Oracle 10g Data Streams, 10g flash back, and 11g new featuresUtilize function based index to help Oracle optimizer Implemented tables and indices partitioning - improved run-timeUse Automatic Workload Repository (AWR) and Statspack to analyze database performanceWork with system admin to setup RAID Disk, analyze disk I/ Show less

• 

  Oracle

  Oct 2019 - now

  • Senior Principle Consultant

    Oct 2019 - now

  • Senior Principle Consultant

    Oct 2019 - now