|
|
|
|
| Desired Industry: Computer Software/Programming |
SpiderID: 36406 |
| Desired Job Location: Charlottesville, Virginia |
Date Posted: 4/27/2010 |
| Type of Position: Full-Time Permanent |
Availability Date: May 1, 2010 |
| Desired Wage: 95K |
|
|
U.S. Work Authorization: Yes |
| Job Level: Experienced with over 2 years experience |
Willing to Travel: Yes, 25-50% |
| Highest Degree Attained: Masters |
Willing to Relocate: No |
Objective:
Oracle DBA position in Charlottesville. Will accept permanent or temporary full-time.
Experience:
Perrin Quarles Associates 11/2008 - Present
Oracle Database Administration and Development
Maintain databases on Linux servers. Responsible for DDL changes, data loads, performance tuning including materialized views, index optimization
Developed PL/SQL objects including database triggers, packages, procedures
Linux system administrator responsibilities included monitoring processes, performance tuning, backups
Responsible for installing Oracle and Linux patches, installing Oracle 11g, maintaining Oracle Enterprise Manager Grid Control
Stanley Associates 9/2005 10/2008
Oracle Database Administration, Design, and Development
Maintained backup, recovery on RAC database for Marine Corp and Army databases. Marine Corp: Unix and Microsoft operating systems. Army: Microsoft operating system.
Responsible for performance tuning at SQL level and server level.
Converted Sybase database to Oracle. Utilities used: Data Pump, SQL*Loader, external tables.
Installed databases on Linux.
Determined how conversions and interfaces would be implemented in GCSS-MC implementation. Evaluation included discussing current functionality with Marine Corp personnel, identifying Oracle API's required for implementation, mapping tables/columns to Oracle import and base tables
Worked on team that designed DB structure for Marine Corp.
Converted Marine Corp DB database from Dbase into Oracle. Designed and implemented database structure for converted application.
Wrote database DDL and DML scripts and modified objects when necessary for DB triggers, views, and tables
Responsible for DB imports and exports
Wrote PL/SQL utilities and Oracle Reports for Marine Corp project
Wrote interfaces for data transfers between mainframe and Linux servers
------------------------------------------
Independent Oracle Consultant 11/1990 7/2005
------------------------------------------------------------------------------------------------------------------------
Sungard Corporation and Lion Apparel, Oracle Consultant 11/2004 7/2005
Evaluated DB design of Sungard supply chain management DB
Developed software for Lion Apparels new supply chain management module and billing module.
Supported Sungards existing Oracle Inventory system.
Implemented PL/SQL packages for systems requirements
Developed reports in Discoverer 4.0.
Starkey Labs, Oracle Consultant
Applications: Oracle Order Management, Oracle Inventory, custom Order Management application.
7/2004 1/2005
Designed and developed asynchronous processes for Oracle Manufacturing
Oracle Advanced Queue development with Oracle Financials, PL/SQL, J2EE.
Used Oracle XML, building CLOB datatypes, to create XML files.
Developed database triggers, forms, and reports for inventory and order management modules.
Archway Marketing, Oracle DBA/Developer
Applications: Oracle OM, AR, CRM. 11/2003 6/2004
Developed PL/SQL programs for Backorder Collection reports.
Developed DB Design for custom logistics subsystem to Oracle Manufacturing module.
Responsible for DB exports and imports, SQL*Loader interfaces, and DB backup and recovery
Emerson Process Management, Technical Consultant 2/2003 8/2003
Applications: Oracle AR, OM, INV, Configurator
Developed interfaces, database triggers, forms, and reports for Oracle OM and INV modules.
Used Oracle JDeveloper to update java servlets built for Oracle Configurator.
Valspar Corporation, Consultant 9/2002 1/2003
Applications: Oracle GL, GMI, INV, OM, QP (Advanced Pricing).
Developed Custom Pricing functions for Oracle Advanced Pricing.
Rewrote Manufacturing reports, written in Java, in Oracle 6i Reports and Discoverer.
Developed custom reports and forms using Oracle 6i Reports and 6i Forms for the Oracle Advanced Pricing and Manufacturing.
Developed custom Oracle 6i Forms for Advanced Pricing.
Jostens, Consultant 4/2002 6/2002
Title: Consultant for Oracle 11i Order Management upgrade
Modified existing forms and reports as part of the software upgrade. Developed custom AR forms and reports.
Emerson Process Management, Consultant 8/2000 5/2002
Applications: Oracle AR, OM, INV, Configurator
Served as Technical Lead during for Oracle 11I Upgrade assessment and GAP analysis phases.
Developed java scripts using Oracle JDeveloper for Oracle Configurator.
Designed and developed interfaces in 10.7 Manufacturing environment.
Wrote and modified Reports 2.5 reports.
Emerson Process Management, Consultant 4/2000 6/2000
Applications: Oracle AR, AP, OM, BOM, FA, Configurator
Designed and developed interfaces between applications in PL/SQL.
Designed/developed error handling between Java in Web server and PL/SQL tool.
Land O Lakes, Lead Developer/Designer 5/1998 1/2000
Applications: Oracle OM, AR
Designed and developed bolt-ons for the CPG Order Entry and Oracle Financials CDOA modules.
Gathered requirements gathering for various bolt-ons.
Used the AIM methodology to write requirements, functional and technical specifications.
Designed and developed forms, reports, database triggers, PL/SQL packages, APIs.
Worked on evaluation and customization of EDI transactions.
Wrote a custom invoice print process.
Tracked work progress and lead other technical team members.
Responsible for data model design and controlling database object creation.
Carlson Companies, Lead Developer 12/1997 4/1998
Applications: Oracle AR, GL, GEMMS.
Designed, developed and programmed customized invoice process, customer statements, collection reports and lockbox process for Oracle Financials 10.7SC in a Windows NT, Windows 95 and Unix environment.
Worked on Oracle Applications Concurrent Manager, AOL and System Administration.
Customized using DDL, Forms 4.5, Reports 2.5, PL/SQL 2.3, database triggers, SQL*Loader, Unix Shell scripts, Discoverer 3.0, Oracle Alerts and Perl.
Worked with the following areas of Accounts Receivable: lock-box, invoicing, customer transactions and cash receipts.
Installed Oracle software onto client machines.
Mentored technical staff.
Valspar Corporation, Applications Specialist 8/1997 11/1997
Applications: Oracle GL, GMI, INV, OM, QP (Advanced Pricing).
Supported Oracle Receivables and GEMMS packages.
Resolved issues, bugs, improved performance and installed patches in Oracle Receivable, General Ledger and GEMMS.
Designed and developed reports in PL/SQL, SQL*Plus and Reports 2.0.
Customized lock-box process and EDI transactions.
Mentored technical staff.
Honeywell Home and Building Control, Lead Programmer/Analyst 6/1997 9/1997
Applications: Oracle AR, GL
Designed, developed and integrated Oracle Forms 4.5 Forms into AR module.
Designed and developed PL/SQL, SQL and Pro*C feeds from Oracle Financials modules into a Data Warehouse.
Customized customer interfaces, customer profiles and lock-box transmissions.
Honeywell Home and Building Control, Lead Programmer/Analyst 1/1997 5/1997
Applications: Oracle AR, GL
Converted legacy system to Oracle General Ledger using UNIX shell scripts, SQL and C.
Used SQL, C, Unix Shell scripts and PERL to automate the concurrent manager batch processing.
Automated processing with Autosys.
Delta Dental, Lead Analyst/Programmer 5/1996 12/1996
Applications: Oracle Accounts Receivable, Oracle Payables
Defined requirements and produced baseline project plan.
Designed relational database structure.
Designed programmatic interpretation of actuarial calculations.
Instructed employees on calculations development.
Developed calculations using PL/SQL, C and Pro*C.
Created supporting forms in Forms 4.0.
Delta Dental, Lead Designer 10/1995 4/1996
Applications: Oracle Pricing Strategy, AR, GL
Education:
M.S. Software EngineeringSt. Thomas University
A.B. Education/MusicUniversity of Michigan
Oracle PL/SQL Developer Certified Associate (2006)
Oracle 10g Database Administrator Certified Associate (2008)
Oracle 10g Database Administrator Certified Profession (2008)
Skills:
Skills:
ORACLE APPLICATIONS: Oracle Financials, Oracle Order Management, Oracle Manufacturing, Oracle Configurator, Oracle Advanced Pricing, Oracle Purchasing, Oracle Inventory, Vertex
SOFTWARE:, Oracle BI-Discoverer, Oracle Advanced Queue, TOAD, SQL Developer, Java, Intellij IDEA, Oracle Forms, Oracle Reports
DATABASES: Oracle 7 through 10g
Oracle DB Management Tools: Enterprise Manager, Net Manager, Database Configuration Assistant, Net Configuration Assistant, Universal Installer
OPERATING SYSTEMS: Unix: AIX, Solaris, HP; Linux: Red Hat; Windows XP, Vista
LANGUAGES: SQL, SQL*Plus, PL/SQL, Pro*C, Shell Scripts, Java, C
CERTIFICATIONS: Oracle 10g DBA Professional, Oracle 10g DBA Associate, PL/SQL Certified Associate
Reference:
Available upon request.
Candidate Contact Information:
JobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response. |
|
|
|
|
|