We provide IT Staff Augmentation Services!

Oracle Database Developer Resume

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Developer

Responsibilities:

  • Enhancements and corrections to the Confidential SNAP program using Oracle 12c and JSON and Oracle Database 12c based on user requirements: Oracle Reports modifications: adding new columns, modifying text version and PDF versions, rearrange column titles and data placement
  • Extensive troubleshooting for all Oracle based applications. Escalation point for all Oracle development.
  • Oracle Forms modifications: add additional items to blocks, add items to screen displays, sort LOV based on user keywords.
  • Business analysis and recommendations for the Unified Timekeeping System for the 29,000 NYC Bus and Subway employees. The ORACLE framework consists of Forms 11g, Oracle Database 12c
  • Working with database objects and forms objects, i.e. triggers, packages, overloading, grants, etc.
  • Interview candidates for project work: Oracle Database skills, Oracle Forms skills, AIX skills.

Confidential

Oracle Database Developer

Responsibilities:

  • Developed Oracle 11g PL/SQL and Forms developer involved in new and maintenance projects
  • Completed 10g to 11gR2 upgrade covering Oracle Forms and database: byte/char conversion, semantics, AL32UTF8, remote dependencies mode.
  • Maintain and upgrade the in - house legacy Warehouse Management System (WMS) using C, ksh, UNIX, Oracle Forms 10g and Oracle 11g PL/SQL. Use of Stacked, Content, Horizontal, Vertical and Tab Canvases
  • Provide technical assistance and trained team members using ORACLE Forms 10g, C and PL/SQL
  • Work with Oracle 11g packages, functions, procedures, triggers, shared objects, global temporary tables.
  • Create synonym and grant scripts for DBAs., Oracle Experience: (11gR2/10g/9.x)
  • Query Oracle when necessary using data dictionary views.
  • Designed and implemented email application that notified users for various Oracle events using dbms utl.send email with BLOB attachments
  • Developed Oracle interface using socket connection and data transfer to a Global Logistics System
  • Interfaced to different servers using XML data transfer including Oracle eBusiness Suite and Transportation Management System (TMS)
  • Modified formsweb.cfg for message generator development using Oracle Forms 10g
  • Migrated legacy 60gbyte TIFF files to Oracle database with new development with Oracle Forms and packages
  • Wrote XML architectural design documents for off shore group. Managed project development.
  • Oracle skill set experience: SQL, PL/SQL, XML Stored Packages, Procedure, Functions, Database Triggers
  • Designed email utilities, csv file generation using many DBMS xxx Oracle functions
  • Designed and developed message generator using Oracle Forms
  • Estimation of Physical storage requirements for online database
  • Developed Master-Detail Forms using Control & Base table blocks
  • Forms Hierarchical tree control, Dynamic Record Groups, Alerts, Property Classes and Visual Attributes
  • Distributed database features, network and client-server programming
  • OID, SSO formsweb.cfg
  • ETL for analysis, projects

Hire Now