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