Dong (John) Choi
Senior Oracle Administrator
Washington DC Metropolitan Area
OraDBA9i@hotmail.com
or
SeQueL_Consulting@yahoo.com
AIM: Oracle9iGuru
References Available Upon Request
Objective
Obtain a position as a senior level Oracle database administrator
with a company that can utilize my technical and analytical skills
in developing and support of database applications for the modern era.
With over seven years of experience working as an Oracle database
administrator for a diverse range of government and private institutions on
a variety of operating system platforms including most variants of UNIX and
Microsoft Servers, I will be able to accentuate any database team and strive to ensure
their continued success.
Professional Experience
Current Project Available Upon Request
Senior Oracle Consultant
Alexandria, Virginia
January 2003 / Present
-
Utilize PL/SQL to develop database application interfaces to Powerbuilder application components
developed for web access through EAServer for the United States Air Force aircraft and missile
maintenance program.
-
Provide support and guidance in all aspects regarding Oracle technologies to the application
development team in developing, debugging and system testing the deliverable application to
ensure that all the requirements as outlined by the United States Air Force are fulfilled.
-
Perform database upgrades as they are made publicly available by Oracle corporation to ensure
that all development efforts are performed on the most current release throughout the complete
development life cycle. Complete Oracle database server upgrades on HP-UX 11.11 from Oracle 8.1.7 to
9i release 2 including application of required HP-UX sytem patches to ensure full interoperability.
-
Develop required HP-UX shell scripts to perform system and application level administrative tasks
scheduled for nightly batch processing utilizing the operating system's cron facility.
-
Monitor database and application servers to track and respond to performance and system related
issues to ensure that all application components execute under extremely high performance
environments and standards.
-
Utilize Oracle's import/export as well as full backup sets to administer and maintain the development
and system test environments to ensure that both systems are fully accessible and properly configured
for their purpose.
Assi Foods International
Information Technology Consultant
Garden Grove, California - April 2002 / September 2002
-
Provided complete information technology solution by implementing core infrastructure for networking
and file sharing between the corporate headquarter and local retail outlets.
-
Assisted developers by providing database guidance in designing and implementing SQL Server 7.0
databases for maintaining inventory, accounts receivable and accounts payable information for the company.
-
Provided database backup and recovery solutions for the SQL Server databases as well as plans for
scheduled maintenance of vital corporate information.
-
Converted and migrated legacy information from flat files utilized in previous custom applications
to the newly developed SQL Server databases to be accessed by the inventory and accounting front-end
software.
-
Performed hardware capacity planning analysis to assess the current and future needs of the company
to ensure scalability of the infrastructure with the continued growth of the company.
The Sports Club of Los Angeles.
Senior Oracle Consultant
Los Angeles, California - October 2001 / February 2002
-
Provided UNIX system administration by installing and configuring Solaris 8 on several SUN E420R,
Netra T1 and Netra X1 servers.
-
Installed and configured Oracle 8i and 9i for optimal performance on the SUN servers for web access
by the membership interface from remote site locations across the United States.
-
Provided disaster recovery procedures by developing backup and recovery solutions utilizing Oracle’s
standby database technology to ensure minimal downtime for the client membership system.
-
Developed Unix shell scripts for the automation of daily backups, maintenance of production and
standby database servers, failure monitoring and general database administration tasks.
-
Provided on-call support for disaster recovery of the Oracle databases and also UNIX system
administration support of the membership system.
Calstate University Chancellor's Office.
Senior PeopleSoft Oracle DBA
Long Beach, California - June 2001 / October 2001
-
Supported Oracle 8i on Sun Solaris 2.8 for a Peoplesoft 7.6 HR and Financial application environments
for approximately 300+ database instances serving 11 first wave campuses.
-
Provided database architectural guidance and project plan for implementing Quest Shareplex Replication
software into the production environment for batch reporting services. Complete project plan included
resources from multiple vendors including Peoplesoft, Vigilent Pentasafe Database Security, Unisys
Global Services and Quest Software.
-
Responsible for assessing the security policies required and implementing those policies through the
security features available within Oracle, Peoplesoft authentication and Pentasafe Database Security modules.
-
Assisted in the conversion and migration of legacy information systems previously on IBM AIX servers
to SUN Solaris and Oracle 8i.
-
Developed UNIX shell scripts to perform scheduled and ad-hoc database and server administrative tasks.
-
Performed routine scheduled release upgrades, migrations, emergency fixes and patches to the
Peoplesoft web and client-server applications.
-
Provided database administration task and support services as requested by end-users of the campus
system maintained through the Remedy Help Desk application.
Screen Actors Guild / Pension and Health Plan.
Senior Oracle Consultant
Burbank, California - January 2001 / May 2001
-
Utilized Erwin to reengineer and redesign the database accessed by the accounts receivable application.
-
Installed, configured and managed Oracle 8i databases on multiple DEC/Alpha VMS, Windows NT and Windows
2000 database servers.
-
Developed PL/SQL stored procedures, functions and triggers to be accessed by the Visual C++ accounts
receivable application.
-
Implemented Oracle 8i’s new Virtual Private Database feature to provide secure fine grained access to
the company’s confidential accounts receivable and payroll information.
-
Developed configuration files to be used by Oracle’s sqlldr utility for the conversion dataload process
in migrating the legacy database to Oracle 8i databases.
-
Ensured consistent database development standards by implementing versioning for all database source
files including DDL, stored packages, procedures and various other information into the Microsoft Visual
Source Safe environment.
-
Assisted the C++ developers in testing, debugging and troubleshooting the client A/R application
interfaces to the Oracle database.
eCompanies LLC
Senior Resident Oracle DBA
Santa Monica, California - November 2000 / January 2001
-
Provided internal support as the resident database administator for new internet startup ventures in
all aspects of database technology.
-
Assisted development staff in designing and deploying web-enabled applications that interact with
Oracle 8i and Microsoft SQl Server 7.0 databases.
-
Developed and implement database design, development and enterprise database solutions to ensure high
availability, scalability and flexible architecture for mission critical information systems.
-
Converted and migrated custom applications that interacted with Microsoft SQL Server databases onto
Oracle 8i on UNIX and NT platforms.
-
Provided UNIX system administration support in installation, configuration and management of a variety
of Sun Enterprise servers.
-
Utilized Oracle Designer 6i to design, develop and reverse engineer the relational databases used by
the internet startups.
netSmart.com
Senior Oracle DBA
Burbank, California - July 2000 / November 2000
-
Utilized Oracle technology to design and implement a database architecture that would ensure scalability
and performance of the netSmart internet portal application in handling user requests.
-
Architected the enterprise database and server backup and recovery methodology to be used in the production
environment to ensure database high-availability during system failures.
-
Installed, upgraded and applied database and sun server patches to new and existing Oracle 8 and 8i databases
running on Sun Solaris 2.6 and 2.7 for a variety of SUN Enterprise servers.
-
Performed hardware capacity planning analysis to identify and address the current and future hardware
procurement needs to ensure site redundancy, stability and scalability.
-
Monitored, assessed and troubleshooted Oracle 8i databases configured as Oracle Parallel Servers on Sun
E10000's and Sun E6500's.
-
Provided UNIX system administration activities to install, configure and monitor Sun Solaris servers.
-
Conducted the planning, configuration and implementation of the system monitoring tools used by the network
operations center (NOC) in maintaining a 24/7 supervision of the production environment.
-
Implemented database coding standards and environments to be used by developers when coding database related
modules to ensure reliable maintenance and peak performance of the application in the production system.
PayMyBills.com
Senior Oracle DBA Consultant
Pasadena, California - May 2000 / July 2000
-
Developed an automated solution for refreshing the clients production information into local Oracle databases
for access by marketing and finance departments.
-
Provided a formal migration plan to guide the client in relocating their production site from a remote hosting
facility in Northern California to a geographically optimal co-location facility in Marina Del Ray, California.
-
Assisted developers in developing, troubleshooting and debugging Oracle stored procedures, triggers and data
model changes for client-server applications written in Java and Perl DBD modules.
-
Performed daily database and UNIX server administration tasks to ensure peak performance and stability of
Oracle database servers.
-
Provided application tuning by monitoring, analyzing and re-writing database stored procedures and packages
to ensure peak performance of the PayMyBills.com's internet application.
-
Developed customized UNIX shell scripts to automatically monitor, manage and notify members of the database
team of alerts, messages and notifications of database server issues.
Petsmart.com
Senior Oracle DBA
Pasadena, California - July 1999 / May 2000
-
Provided 24x7 production support as an Oracle database administrator for a B2C e-commerce company to ensure
data integrity, availability and peak performance of online purchases.
-
Developed, implemented and maintained standby Oracle databases, online and offline tape backups for failover
during potential disaster recovery scenarios.
-
Architected the relocation of the previous production site from an operations center on the East coast to the
new data center located in California with minimal site downtime.
-
Monitored, assessed and troubleshooted potential database problems to ensure 24x7 availability of the production
e-commerce website.
-
Implemented secure SQL*NET connectivity of the production databases to a Oracle transparent gateway for a DB2
database on an IBM AS400 across a T1 VPN for product inventory updates and online purchase validations.
-
Assisted developers in developing, troubleshooting and debugging Oracle client-server applications written in
Java and Perl DBD modules.
-
Installed, upgraded and applied database and system patches to new and existing Oracle 8 and 8i databases
running on Sun Solaris 2.6 and 2.7.
-
Produced hardware capacity planning system analysis to identify current and future hardware requirements for
procurement to ensure site redundancy, stability and scalability.
Hollywood.com
Oracle DBA Consultant
Santa Monica, California - May 1999 / July 1999
-
Performed Oracle server 8.x installations and upgrades on several Sun Sparcs running Solaris 2.6.
-
Designed and developed various custom UNIX shell scripts to perform automatic online, offline and export
backups of the production databases.
-
Developed UNIX shell scripts to perform batch operations including dataloads and updates to the database.
-
Performed server and application tuning to obtain optimal performance during dataloads and batch operations.
-
Utilized the C programming language to design and develop a dataload daemon that automatically detected
the presence of batch files and executed the dataload process.
-
Provided Oracle application support to developers in the development of stored procedures, triggers and
various SQL scripts.
Open Systems Group
Oracle DBA Consultant
Lanham, Maryland - September 1998 / April 1999
-
Performed Oracle server installations and upgrades on a variety of UNIX platforms including Pyramid Niles,
Solaris, NCR and Windows NT 4.0 server.
-
Provided end user support for the integration and test ITCC team of the Y2K software compliance facility of
the Internal Revenue Services.
-
Analyzed and troubleshooted database related problems including application, hardware and networking issues
for Oracle client server applications.
-
Interfaced and coordinated with system administrators to analyze and recommend system configurations in
preparation of the Oracle installations for optimal database performance.
-
Performed database recoveries from online and offline backup sets during server failures due to fatal errors
from hardware crashes or end user mistakes.
-
Developed unix shell scripts to perform database administration tasks that included performing automatic
database backups, generating usage reports and various other tasks.
Litton PRC
Oracle DBA / Database Programmer
McLean, Virginia - April 1997 / September 1998
-
Provided Oracle database administration support for the software development team on ITN/IAFIS, a federal
government contract tasked to implement an automatic fingerprint identification system for the Federal
Bureau of Investigation.
-
Utilized Oracle's Release 8.x and 7.x Pro*C development environment to develop database application
program interfaces for front end client-server applications written in C/Motif for a HP-UX 10.x UNIX environment.
-
Developed database stored procedures, triggers and functions using Oracle's PL/SQL facility to execute
dynamic DDL and DML commands against the Oracle database.
-
Assisted in the analysis, configuration and execution of feasibility and benchmark tests for prototyping
Oracle's Parallel Server configuration into the system architecture.
-
Performed system analysis on database requirements established by the client and utilized Oracle's Designer
2000 CASE tools to facilitate the logical and physical schema designs to support those requirements.
-
Provided on-site system and integration support during formal qualification tests of the production software.
Wedgco Engineering Inc.
Design Consultant
Gaithersburg, Maryland - November 1996 / March 1997
-
Utilized AutoCAD to design plumbing and fire protection sytems in commercial and public buildings in
accordance with jurisdictional code requirements.
-
Developed Visual Basic 4.0 applications to analyze design specifications and to perform engineering
calculations, such as the determination of pipe sizes and elevations to use in the system design.
-
Planned and implemented the company s migration of AutoCAD design tools.
-
Provided technical support to colleagues on the operation of software applications running under the
Microsoft Windows operating system.
-
Furnished hardware technical support to troubleshoot and repair office computer and peripheral devices.
DenTech Computer Consultants Inc.
Computer Technician
Silver Spring, Maryland - January 1995 / November 1996
-
Developed client specific applications in Visual Basic 4.0 that interfaced with Microsoft Access databases
for the company's clientele.
-
Performed hardware upgrades and configurations of client's business and personal computer systems.
-
Conducted software and hardware technical support for clientele to fulfill contractual obligations.
-
Provided technical support to clientele with the installation and upgrades of the Windows OS and various
other Windows applications.
-
Developed logical and physical database design implementations for in house applications to track and
maintain vital company information and resources.
Education / Professional Development
Bachelor of Science Mechanical Engineering
University of Maryland College Park
Colleg Park, Maryland
January 1995
Oracle DBA Masters Program
Oracle Education
Bethesda, Maryland
May 1997
PeopleSoft Administration Program
PeopleSoft Education
Irvine, California
July 2001
Technical Skills
Operating Systems
-
Sun Solaris 2.5, 2.6, 7, 8, 9
-
HP-UX 10.x, 11.x
-
NCR-UNIX
-
Siemens/Pyramid Unix
-
Linux
-
VMS on DEC / Alpha
-
AIX
-
Windows XP, NT, 2000, 98, 95, 3.x
Software Applications
-
Oracle 9i, 8i, 8.x, 7.x
-
Oracle Designer 6i, 2000
-
Oracle Developer 6i, 2000
-
Oracle Discoverer
-
Erwin
-
Peoplesoft 7.x, 8.x
-
Quest Shareplex
-
Veritas NetBackup
-
BMC Patrol
-
Microsoft SQL Server 7, 2000
-
Informix
Programming Languages
-
C
-
Pro*C
-
SQL
-
PL/SQL
-
Visual Basic
-
UNIX Shell Scripting