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.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship