Oracle DBA - Computer Software Programming Resume Search
Oracle DBA - Computer Software Programming Resume Search
My Spider Scam Awareness Contacting Us F. A. Q.
 
Job Seekers
Search Jobs
Browse Jobs
Post a Resume
Job Alerts
 
Employers
Search Resumes
Browse Resumes
Post a Job

Oracle DBA Resume


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 Apparel’s new supply chain management module and billing module.
• Supported Sungard’s 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, API’s.
• 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 Application’s 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 Engineering—St. Thomas University
• A.B. Education/Music—University 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.


    





© 2022 Job Spider
Privacy Policy | CC Marketing Sites | Site Map | Links