We provide IT Staff Augmentation Services!

Senior Database Specialist Resume

5.00/5 (Submit Your Rating)

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

We'd love your feedback!