SUMMARY
I have over 20 years experience in Information Technology. All 20 years have been dedicated to relational database. I am an expert in database design and specialize in creating the physical model from the logical model gaining optimum performance while maintaining referential integrity . I excel in SQL performance tuning and PL/SQL development. I have had assignments in many environments and learned from all of them. I have a lot of knowledge to share and will benefit any project.

TECHNICAL SKILLS
Oracle 5-11g, DBA, Data Architect, Oracle Enterprise Manager (OEM), Toad, Analyzing Explain plans, Pro*C, SQL*Plus, PL/SQL, SQL*Station, Database procedures, ETL, Database events, Database triggers, Database Design, Referential Integrity, Data distribution, System Integration, Sun Solaris, HP UX, vax/vms, Ingres, SDLC, Configuration Management, SQL*Loader, Oracle Import/Export, Oracle Forms, Oracle Reports, Oracle Developer Suite, S*Designer, Erwin, Shell Scripting, cron, Oracle Instance tuning (SGA), Tablespace maintenance, backup and recovery, Database purge and archival, C, Fortran, Pascal, Cobol, DCL, NT, Windows Server, File transfer, Word, Excel, Access

PROFESSIONAL EXPERIENCE
February 2009 Oracle DBA/Systems Analyst
Present Confidential,

• Database Administration tasks
• Tuned Oracle Database instance. Upgraded databases from 9i to 11g.
• Improved business processes by automating manual processes.
• Designed and developed a portal for customers to enter transportation orders.
• Developed data extracts and loads, reports, PL/SQL procedures.
• Developed Customer Reports and made available via web.
• Support Transportation Management (i2, KeyPoint) production systems.

Skills used: Oracle 8/9i/10g/11g, SQL, SQL*Plus, PL/SQL, Packages/Procedures, i2 Transporation Manager, e-Integrator, Toad, Windows Server, Crystal Reports, ETL

April 2008 Senior Data Architect
February 2009 Confidential,

• Data Warehouse database design and data mapping. (Oracle Designer)
• Designed and developed initial and ongoing ETL load procedures (PL/SQL) for fact, dimension, and aggregate tables
• Designed a common framework with reusable code for the above loads.

Skills used: Oracle 9i/10g/11g, SQL, SQL*Plus, PL/SQL, Packages/Procedures, SubVersion, Appworx, Oracle Designer, Toad, HP UX

January 2007 ACS, Inc., Southfield, MI
February 2008 Oracle DBA/Data Architect

• Maintained large Oracle 9i database
• Maintained data model and implemented physical database changes
• Vastly improved performance by tuning SQL
• Lead the database development team
• Performed as an application DBA, System DBA and PL/SQL developer

Skills used: Oracle 9i, Toad, OEM, SQL, SQL*Plus, PL/SQL Packages and Procedures, Triggers, Constraints, Erwin, Solaris

July 2006 Confidential,
December 2006 Oracle DBA

• Maintained over 25 Oracle databases on a Windows 2003 Server
• Converted 3 SQL Server databases to Oracle
• Vastly improved performance by tuning SQL
• Handle day-to-day work requests and customer enhancement requests
• Evaluated many SQL developer tools

Skills used: Oracle 9i/10g, OEM, SQL, SQL*Plus, PL/SQL, Procedures, Triggers, PL/SQL Developer, Toad

October 2005 Confidential,Redford, MI
April 2006 Oracle Developer

• Developed enhancements to an existing ERP system using PL/SQL, korn shell scripts, Pro*C. Oracle Reports and Forms
• Wrote and execute unit and user test plans
• Implement new software into production

Skills used: Oracle 9i/10g, SQL, PL/SQL, Oracle Forms, Oracle Reports, Database procedures, Triggers, PL/SQL Developer, SQL*Plus, SQL*Loader, Import/Export, Pro*C, Aix, Shell Scripting

June 2002 Confidential,Southfield, MI
December 2004 Lead IT Programmer Analyst/Oracle DBA

• Lead a production team that provided system enhancements and production support and customer fulfillment for Sales.
• Set the technical direction for the team.
• Lead initiatives in developing prototypes using Oracle Discoverer
• Acted as liaison between Sales, customers, and IT to provide technical feasibility and cost estimates.
• Remotely reloaded the Oracle production database utilizing Import, SQL*Loader, DB Links and parallel queries the last Sunday of every month.
• Denormalized tables to improve performance. Maintained the physical data model.
• Designed and developed PL/SQL procedures, Triggers, Oracle reports, and Proc*C programs to meet customer fulfillment and requirements.

Skills used: Oracle 9i/10g, SQL, PL/SQL, Oracle Enterprise Manager (OEM), Oracle Developer Suite, Oracle Forms, Oracle Reports, Database procedures, SQL*Plus, SQL*Station, SQL*Loader, Import/Export, Pro*C, Sun Solaris, Shell Scripting, Oracle Discoverer, Investigated Oracle Portal, Excel, Access, NT, Windows 2000

February 2001 Confidential,, MI
August 2001 Oracle DBA: Client: Confidential

• Supported databases on NT and Alpha VMS.
• Supported a very large MRP database on VMS and several small databases on NT.
• Supported two SQL Server databases.
• Developed purge procedures that were flexible and maintained referential integrity.
• Responsible for: Database backups, table/tablespace maintenance, performance tuning (SGA), software upgrades, and general support (help desk) for customers with issues and problems.

Skills used: Oracle 7.3/8i, SQL, PL/SQL, SQL*Plus, Oracle Enterprise Manager (OEM), Database procedures, SQL*Loader, Import/Export, VMS, DCL, NT

April 1995 Confidential,Southfield, MI
February 2001
(7/99-2/01) DBA/Developer: (Client: Kasle Steel )

• Performed all DBA functions including weekend maintenance, data distribution, capacity planning, and performance tuning.
• Upgraded all INGRES databases to be Y2K compliant in a VAX/VMS environment.
• Converted manufacturing system from INGRES 4GL (VAX/VMS) to ORACLE Developer 2000 (Windows 95/Sun Solaris).
• Converted forms from Developer 2.1 to Developer version 6.0.
• Responsible for: Installed software on Unix (ORACLE/EDI communication software), weekend database maintenance/backup, developed purge/utility programs (Embedded SQL/C), Unix development architecture, software configuration control, DCL and shell scripting.

Skills used: Oracle, SQL, PL/SQL, Oracle Forms, Database procedures, Pro*C, Sun Solaris, Shell Scripting, Ingres, ABF, VAX VMS, Alpha VMS, DCL, Embedded SQL/C, Data migration, EDI transmission, Database backup

(12/96-7/99) DBA/Developer: (Client: Confidential)

• Served as the application INGRES DBA for a new Sales Planning and Allocation system.
• Designed and constructed the physical model and database from the logical model.
• Responsible for: maintained the data model with new requirements, consulted developers in SQL, Data Sharing and Replication, SQL/ Performance Tuning, user and table accesses, maintained multiple test and production databases, data distribution, backup and recovery, defining and ensured referential integrity, and enhanced the database for future releases.
• Upgraded all databases to OpenIngres 2.0.
• Extracted large amounts of data to be ported to GMs Data Warehouse.

Skills used: Ingres, SQL, Database design, Data modeling, S*Designer, SQL, HP UX, Sun Solaris, Shell Scripting, Database backup and recovery, Production database, Test Database, Development Database

(6/96-12/96) DBA: (Client: Confidential)

• Provided DBA services for INGRES databases running on mid-range UNIX machines.
• Maintained a very large Customer Information Database.
• Responsible for: logical and physical data model, table maintenance, backup and recovery, SQL query optimization, data distribution, database procedures, and data conversions.
• Designed and developed an interface (Embedded SQL/C) to bulk copy data from the databases into ASCII files, then transferred (FTP) for input to the Data Warehousing pilot.

Skills used: Ingres, Database design, Data modeling, Database procedures, SQL, Solaris, Shell Scripting, Database backup and recovery, Production database, Test Database, Development Database

(7/95-4/96) Oracle Developer: (Client: Confidential)

• Developed communications software in an Alpha VMS environment for gages and tools on the assembly line at Detroit Diesel.
• The protocol used to communicate with the tools/gages was TCP/IP socket or serial port.
• Data obtained from the hardware was then stored in an ORACLE database.
• The code was written in C utilizing VAX/VMS System Services and Embedded SQL (Pro*C).

Skills used: Oracle, SQL*Plus, Oracle Forms, SQL, Pro*C, VAX VMS, Alpha VMS, DCL, database design, TCP/IP

(4/95-7/95) DBA/Developer: (Client: Confidential)

• Served as the INGRES DBA for the ESI (Electronic Service Information) system running in a Sun/Solaris environment.
• Created database procedures and rules to aid in performance and ensured data integrity.
• Wrote some database conversion software as well as advised in SQL.
• Short-term for the review of the database design and made recommendations to tune the database for higher performance.

Skills used: Sun Solaris, Shell Scripting, Ingres, Database procedures, Data Modeling

October 1994 Confidential,Troy, MI
April 1995 Developer: (Client: Confidential)

• Rewrote, supported, and enhanced a Quality Information System which was developed utilizing Embedded SQL, ORACLE, C, and JYACC forms.
• System ran in a UNIX client/server environment.

Skills used: Oracle, SQL, SQL*Plus, Pro*C, HP UX, Shell Scripting, JYACC

June 1994 Confidential,Southfield, MI
October 1994 DBA/Developer: (Client: Confidential)

• Installed software, designed the database, INGRES DBA functions, developed some user interfacing software, bulk data loading, and ad hoc reporting.
• Data was collected from the trucks at dealerships and downloaded to a Sun/Solaris workstation.

Installed and maintained Remedy Software.
Skills used: Sun Solaris, Shell Scripting, Ingres, Remedy

January 1991 Confidential,Atlanta, GA
September 1993 DBA/Developer: (Client: GE Nuclear Energy)

• Performed enhancements/maintenance on a Quality Management System for nuclear products in an ORACLE, ULTRIX, FORTRAN, SQL*FORMS (VAX)
• Converted user screens from SQL*FORMS 2.3 to SQL*FORMS 3.0
• Converted a data collecting system from utilizing flat files to ORACLE. This system also required graphic displays and reports

Skills used: Oracle, SQL, VAX Ultrix, Oracle Forms, Fortran

EDUCATION
B. S. Mathematics and Computer Science