Senior Database Specialist Resume
Summary of Experience:
- Over 15 years of experience in all stages of design, writing detail specifications & installation instructions, development, implementation, and maintenance of custom built Oracle applications (Manufacturing & Government)
- Over 10 years experience in Database Administration of Oracle (installation, upgrades, backup & recovery, security, creation of instances, tablespaces, tables, views, indexes, constraints, db links …etc) on Red Hat Linux, Solaris, Unix, Open VMS, and Windows
- 15 years of experience in PL/SQL development including creation of functions, procedures, packages, triggers, and database jobs
- Over 10 years experience utilizing Oracle Designer to store design efforts, facilitate data modeling, and production of entity relationship diagrams
- Oracle Certified Professional Oracle 10g Database Administrator and Oracle 8i Database Administrator.
- Experienced in installation and maintenance of various web servers using Oracle 10gAS
- Possess skills to performance tune applications using tkprof, explain plan, and other tools
- Possess experience creating End User Layers and Business Areas for use by Oracle’s Discoverer tool
- Past experience includes extensive development of Oracle Forms and Reports
- Possess Bachelor’s Degree in Computer Science (1989) UAHuntsville
- Pursuing Master’s Degree in Computer Science, UAHuntsville
Oracle Certifications and Examinations:
- Previsor/PL/SQL, Examination Score: Advanced, 93rd percentile (5/9/2011)
- Oracle 10g Database Administrator Certification (01/29/10)
- Kenexa/Oracle 10g DBA, Examination Score: 84% (09/22/08)
- Oracle 8i Database Administrator Certification (02/26/02)
- Oracle 8i: Network Administration Certification (2/26/02)
- Oracle 8i: Backup and Recovery Certification (1/08/02)
- Oracle 8i: Performance and Tuning Certification (10/30/01)
- Oracle 8i: Architecture and Administration Certification (8/16/01)
- SQL and PL/SQL Certification (7/13/01)
Software / Tools:
- Oracle Enterprise Manager, Oracle Application Server Control, Oracle Grid Control (configure & install), Recovery Manager (RMAN), Oracle Database (10g, 9i, 8i, 7, 6), Oracle Application Server (10gAS, 9iAS), Oracle Developer Suite (10g,9i,6i), Oracle Designer, Oracle Discoverer, PL/SQL, Sql*Plus, Sql*Loader, Data Pump, Pro*Fortran, Pro*C, Toad.
Operating Systems: (Including basic installation and configuration)
- Red Hat Linux, Solaris 8 & 10.0, HP Unix, Windows XP, 2000, NT, OS2
Professional Achievement and Awards:
- Professional Achievement Award – presented by “The Centech Group” (1/08)
- Team Achievement Award – presented by “The Centech Group”(7/08)
Employment History:
Senior Database Specialist – Project #2 (02/07 to 10/09) Confidential,Montgomery, AL
- Database Administrator for the Online Vehicle Information Management System (OLVIMS) for the Air Force
- Assignment involved migrating a standalone Cobol application to Oracle 10g Database
- Involved in designing and creating a relational database to hold the data, creating a mapping document for migration, Sql*Loader scripts, and procedures written in PL/SQL to process data from flat files into relational database
- Installed Solaris 10, Oracle 10g, and Oracle 10gAS on a Windows Server
- Migrated an existing Oracle 9.2.0.6 database to new Oracle 10g database via database links
- Legacy database had many data integrity problems, performance problems, and obsolete objects and were solved by utilizing a very concise normalized design and taking advantage of various Oracle constraints
- Wrote detailed specifications for modules and installation instructions for database & applications to be installed in the pre-production and production environments
- Selected to travel to Vandenberg Air Force Base for 2 week assignment and migrate a database from Oracle 9i to Oracle 10g, configure Oracle Discoverer, Reorganize data storage areas, and set up oracle backups
Web Administrator – Project #1 (09/06 to 02/07) Confidential, Montgomery, AL
- Member of Web Operations group in support of Automated Civil Engineering Systems (ACES) for the Air Force
- Performed troubleshooting and maintenance of forty-five servers divided evenly across three different production locations (Montgomery, Hawaii, and Germany)
- Each production location was running Oracle 10gAS and had 5 J2EE servers, 5 Forms Servers, 3 Discoverer Servers, an infrastructure, and a Grid Control Server
- Worked with Grid Control to monitor application servers and send emails when problems occur
- Utilized Oracle Application Server Control to monitor applications
- Utilized servers with Red Hat Linux on all web servers except the forms web server which was Windows 2000
- Deployed code changes to the appropriate environment when requested by developers
- Performed testing of new Oracle patches in the lab before deployment in production
- Provided field support on this application worldwide for the Air Force
Senior Software Developer (9/05 to 3/06) Confidential,Huntsville, AL
- Hired for short term assignment to assist current developers with their ever growing support task on the Real Estate Financial Management Information System (RFMIS)
- Created and maintained Oracle Reports and Forms
- Setup automated email notification for an Oracle database prior to 8i using DBMS_PIPE communicating to a listener program running on Unix
Senior Computer Scientist (1/05 to 7/05) Confidential,Huntsville, AL
- Performed as Team lead for maintenance and enhancements to a customer application developed for NASA (AKA MICS - Management Information Control Systems)
- Maintained team schedule, tracked all weekly accomplishments and reported to management
- Handled all incoming request for account changes for the application
- First on call for Trouble Ticket system, notification was sent via pager when tickets arrived
- Responsible for maintenance of certain modules within the application, other calls were passed on to other team members
Senior Database Administrator (11/03 to 12/04) Confidential,Huntsville, AL
(Future Research won the contract from SAIC below)
- Performed duties as a member of the P2 Project Team and maintained and enhanced previously developed reports for the Corps of Engineers
- Trained new team members in the relational design of Oracle Projects and Primavera
- Implemented Oracle Applications multi-org capability to segregate data between different parts of the business using Discoverer and Oracle Reports
- Configured and maintained Oracle 9iAS, Web Enabled Discoverer, and Oracle Report Server
- Cloned databases from one Unix environment to another environment on the same server and on different servers
- Performed duties as a Backup Database Administrator for all P2 databases including development, test, and production
- Assisted Primary DBA in day to day activities and served as Primary DBA in his absence
- Continued to enhance and build new Business Areas in Discoverer for the Corps
- Controlled all access privileges in Discoverer for the Corps worldwide
- Approved and implemented all production moves to a Unix server
Senior Software Engineer (4/02 to 11/03)Confidential,Huntsville, AL
- Member of P2 Project team at Corps of Engineers
- Researched and prototyped several different methods of implementing Oracle Reports on the Web concluding with Oracle Applications Concurrent Manager, Reports Server, and Discoverer
- Developed Reports 6i Template that was used for all Corps of Engineers reports developed by the P2 Project team
- Developed Oracle 9i Reports accessing distributed data on Oracle Projects and Primavera
- Created the End User Layer for Discoverer and configured Discoverer Business Areas
- Developed Continuity of Operations Plans entailing backups, redundancy, and replication to provide survivability in case of natural or man made disaster
Senior Software Engineer (5/01 to 2/02) Confidential, Huntsville, AL
- Member of the RFMIS and RECIS maintenance teams
- Database administrator of all internal Oracle databases
- Successfully installed Oracle 9iAS on a Windows 2000 workstation and demonstrated functionality with Portal, Discoverer, Reports and Forms Server
- Served as a PL/SQL resource for the RFMIS NT project where an Oracle 3.0 forms system was being rewritten on the Web using Java
- Performed all maintenance tasks on JRFC briefing charts, which were web reports written
Education and Professional Development:
Bachelors of Science in Computer Science / Mathematics
Masters of Science in Computer Science
Completed Oracle Courses:
- Oracle Applications 11i System Administration (8/06/02)
- Discoverer End User and Administration (5/03/02)
- Oracle 9iAS Administration (9/26/01)
- Reports 6i Development (5/03/02)
- International Oracle Users Week 1991, 1992, 1993, 1995, 1997, 2000