We provide IT Staff Augmentation Services!

Oracle Database Engineer Resume

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Engineer

Responsibilities:

  • Built PL/SQL code to load data from complex multi - dimensional array into hierarchal structure.
  • Build PL/SQL API’s.
  • Built PL/SQL code to replace multiple PL/SQL modules with single PL/SQL module performing all required work. New PL/SQL module reduced maintenance cost.
  • Built PL/SQL code to load data from multiple input arrays into multiple database tables performing complex validation of input data.
  • Designed and built a new generic code to load different types of LOB data.
  • Built new complex queries.
  • Added logging of execution of database modules.
  • Built standard error handling .
  • Defined and implemented code standards.
  • Reworked PL/SQL modules to implement single point of entry and single point of exit.
  • Tuned SQL statements.
  • Optimized PL/SQL code replacing single row processing with bulk processing.
  • Replaced unnecessary dynamic SQL with static SQL.
  • Optimized SQL statements in PL/SQL code.
  • Worked with application development team to improve application code.
  • Built scripts to automate routine tasks.

Confidential

Database designer/developer

Responsibilities:

  • Data access layer for Web application;
  • Asynchronous data load replacing batch jobs;
  • Synchronous data load - cascading changes into remote databases;
  • Data cleaning processes and tools;
  • ETL - replacement of vendor program: vendor code could not process required data volume and could not process all types of data;
  • Billing data load - replacement of vendor program: performance of vendor code was unacceptable;
  • Migration and conversion tasks;
  • Multiple batch jobs design and development;
  • All types of database code (PL/SQL packages, triggers, complex SQL);
  • PL/SQL API’s;
  • Oracle security: roles, privileges;
  • Troubleshooting, data problems research and correction;
  • Performance tuning;
  • Reporting: canned reports; ad-hoc reports;
  • Oracle consulting.

Environment: Oracle 11, 10, 9; Oracle Designer 9i.

Lead Designer/Developer

Confidential

Responsibilities:

  • (VMS, custom code, network database) to UNIX platform utilizing J2EE technology.
  • New application uses BEA WebLogic as an Application Server and Oracle 9i as a Database Server.
  • General Application Design;
  • Database Design (logical, physical, security) for J2EE application;
  • Database Code (PL/SQL packages, database triggers, data migration tasks, security);
  • Development DBA;
  • Performance tuning;
  • Project Management;
  • Oracle consulting.

Environment: Oracle 9i; Oracle Designer 9i; BEA WebLogic 7.0; Java Server Pages (JSP) with struts; servlets; Enterprise Java Beans (EJB), session beans; Message Queue; XML.

Technical Lead

Confidential

Responsibilities:

  • As Technical Lead, provide enhancement, optimization and support of on-line activation system.
  • Duties include requirements gathering; data analysis; data modeling, logical and physical design, system development, system conversion, troubleshooting, performance tuning, DBA tasks, security enhancements, team coaching and project related administrative functions.

Environment: Oracle RDBMS v.8.x, 7.x; PL/SQL; Oracle Forms v.6.0, 4.5; Oracle Reports 6.0, 2.5; Oracle Designer 2000, 6.x; PRO*C.

Hire Now