We provide IT Staff Augmentation Services!

Lead Database Specialist Resume

Dulles, VA

SUMMARY:

  • Database designer, developer and technical/user support representative with over 25 years experience. The last 15 years has been primarily with Oracle products and previous to that with Wang. My primary responsibilities have to work with clients to design, develop, maintain and support their existing custom developed applications. Most work I have done is on undocumented systems, I have become adept at debugging, determining how the applications work, what needs to be done for improvements, enhancements and fixes.

PROFESSIONAL EXPERIENCE:

Confidential, Dulles VA

Lead Database Specialist

Responsibilities:

  • Design, develop, support, and maintain PMC’s Oracle based Custom Program Management database system.
  • This includes integrated Budget, Accounting, Labor, Personnel, Construction, Design, Procurement, Property, Planning, and Time accounting modules.
  • Create and maintain PL/SQL database procedures, functions, packages, views, indexes, synonyms, and triggers
  • Create and maintain all Oracle Forms and Reports.
  • Create, maintain, and manage Oracle all user records.
  • Access and use Oracles OTN and MOS for support.
  • Designed and created a new Timesheet application module and integrate it into all aspects of the current PMC system.
  • Created an email module and package to give the ability to for our users to get automated email for scheduled and event triggered events.
  • Write scripts to download data from the database for various members of the PMC group.
  • Determine how and work on a team to upgrade the entire DBMS to version 10g, including all Forms, Reports, database software, middle tier software and the servers needed to transform from a Client Server based system to Internet based.
  • Create a framework for the Oracle Forms to be converted to 10g to help standardize conversions.
  • Install Oracle CPU’s.
  • Work with other users to get requirements for additions, changes, enhancements to current system.
  • Work on and fix bugs, performance issues, hardware and software issues.
  • Write up user and technical documentation.

Environment: Oracle database 6, 7, 8, 8i, 9, 10g, Toad 10.6, SQL*PLUS10, Oracle Forms and Reports 6, 8, 10, Oracle Enterprise Managers, Microsoft Office products. Oracle Primavera Unifier, uStage, uDesigner, BI Publisher, Crystal Reports, Adobe Live Cycle.

Confidential, Burke, VA

Oracle Forms Database Developer

Responsibilities:

  • Learn how to use Oracle Designer Software
  • Generate Oracle Forms from Oracle Designer
  • Work with our own analysts and representatives of US Army of Fort Lee, Virginia in designing parts of the application as we were assigned.
  • Create Oracle Forms from Analyst designs.
  • Used Toad as an analysis tool.
  • Work with the Report developers to assist with backend analysis.
  • Used Lead Contractors Framework packages to in corporate in all Oracle Forms designs.
  • Test applications with lead test team members.
  • Using SQL*PLUS packages upload and download data to/from files and tables.
  • Used Configuration Management tool to track all changes to forms.

Environment: Oracle database 8, 8i, Oracle Designer, Toad, SQL 10, Oracle Forms 5, 6, 6i, Windows.

Confidential, Alexandria, VA

Oracle Forms Database Developer

Responsibilities:

  • Perform Queries and downloads to analyze problems with their data.
  • Worked on various aspects of the company’s system, identifying and fixing problems with its data.

Environment: Oracle database, MS Excel, Windows.

Confidential, Woodbridge/Arlington, VA

Database Developer/Consultant

Responsibilities:

  • Do database design, development, customer support, software maintenance
  • Conversion of custom application software for upgrades.
  • Responsible for training and documentation of the systems and applications.
  • Do ongoing customer support via phone, modem, and travel to sites.
  • Upgraded older Wang 2200 minicomputer systems to Novell networks on PC's
  • Rewrote or converted their custom programs to work with new versions of the AIMS database software.
  • Created my own Interface Framework software package to work with the AIMS Database to facilitate uniform code development and easier maintenance of custom program code.
  • I was the National Technical Support Representative for the AIMS Database software out of Austin TX.
  • Rewrote the source code to the AIMS+PLUS Database software to work on file sizes over 32K.

Environment: Wang 2200, Wang Basic2,, Niakwa Basic2c Interpreter, Windows, DOS, SuperDos.

Confidential, Arlington, VA

Database Developer/Consultant

Responsibilities:

  • Do database design, development, customer support, software maintenance
  • Conversion of custom application software for upgrades.
  • Responsible for training and documentation of the systems and applications.
  • Do ongoing customer support via phone, modem, and travel to sites.
  • Upgraded older Wang 2200 minicomputer systems to Novell networks on PC's.
  • Maintain the in - house computer system and software.
  • Designed and developed software tools to be sold to customers and used by in-house development staff.
  • Designed and developed graphic welcome screens for clients and the tool to develop it with.

Environment: Wang 2200, Wang Basic2,, Niakwa Basic2c Interpreter, Windows, DOS, SuperDos.

Confidential, Rockville, MD

Database Administrator

Responsibilities:

  • Trained myself on how to use the software packages.
  • Coordinated and implemented the changeover of their outside computer service to their new in house system.
  • Worked with the in-house staff analyzing their needs, bringing on-line different software modules as scheduled.
  • This included General Ledger, Accounts Receivable, and Accounts Payable, Payroll, various Homebuilder modules, and Inventory.
  • Responsible for training of all employees, implementation and bringing on-line of the different software modules used throughout the different departments.
  • Responsibilities covered all aspects of computers for the company of about 100 office employees.
  • Administer the database resolving all issues.
  • Create a backup procedure, backup software program, and train my assistant on how to use it.
  • Setup new PC to perform downloads from the minicomputer and use Lotus123 to do further analysis on data.

Environment: Wang 2200, Basic2c, Niakwa Interpreter, Windows, DOS, TOM Software homebuilder software.

Confidential, Reston, VA

Database Developer/Consultant

Responsibilities:

  • Design, develop and support custom computer applications for many different types of business clients of this firm.
  • Provided teaching of the packages created in-house.
  • Provide customer and technical support for all clients.
  • Initiated the development of software standards for their Association Plus package, which was developed here.
  • I was primary designer and developer of the company's CLUB+ package to be sold to Private clubs which included member, hotel and restaurant modules integrated with an accounting system.

Environment: Wang 2200, Basic2c, Niakwa Interpreter, DOS, Ledger+Plus Accounting Software, Association+Plus Membership Software, TOM Software products.

Confidential, Roncerverte, WV

Database Administrator

Responsibilities:

  • First learn new computer system the company bought
  • Bring on-line and get the system running.
  • Enter all data from old records.
  • Update, run, and maintain day to day operations of the company records, including inventory, inventory changes, accounts payables, accounts receivables, general ledger, payroll, procurement and all other accounting aspects of the system.
  • Train other staff on how to use various parts of the system.
  • Train replacement on all aspects of my job just prior to leaving.

Environment: Apple 2e, Accounting Software Package.

Hire Now