Junior Oracle Developer Resume

SUMMARY

As a certified with un experience as a database developer, implementation of Oracle 8i, 9i, 10g, 11g, 12c and SQL Server 2005 and 2008, I am looking to obtain an interesting and challenging Oracle, SQL developer position.

TECHNICAL SKILLS

Databases: Oracle 8.x/9.x/10g/11g, 12c, MySQL 5.x, SQL Server 2005.

Programming Languages: SQL, PL/SQL, T - SQL, and PHP.

ETL: SQL Loader, External Table.

Operating Systems: Windows, UNIX, Linux, Shell Scripting.

Web Languages: HTML, XML, JavaScript.

Tools: SQL Developer, TOAD, SQL Server Management Studio (SSMT) Dream Weaver.

Knowledge: Java Database Connection JDBC and MySQL.

PROFESSIONAL EXPERIENCE

Junior Oracle Developer

Confidential

Environment: Oracle 11g, SQL - Developer, PL/SQL, ETL, Windows, Linux.

Responsibilities:

Worked on Inventory System where some of the tasks accomplished by this system include the ability to create inventory parts definitions, stocking locations, ability to retrieve availability information and purchase orders. I involved in development of database dictionary, back-end logic for Inventory System database through designing and implementing of tables, views, stored procedures, packages and performance tuning.
SQL-Developer for review and deploy DML/DDL scripts for the creation of tables, indexes and constraints, aggregate functions, and case statements. Oracle PL/SQL using cursors, for, next and open fetch loops, select into, raise application error, autonomous transactions, SQL Loader for loading flat files into oracle tables and validating data.

Freelance Oracle Database Developer

Confidential

Responsibilities:

Implemented database dictionary for Auto Process System database (IT services management system that involved in setting control and governance on the business processes) through designing, implementing tables, views, stored procedures, indexes using Oracle 11g.
Worked on development and maintaining of the Medicaid Enterprise Restructuring Project (MEPR) system for the sake of DHMH with tasks of: Supporting the application team with PL/SQL functions procedures and packages. Participating in code review and unit testing. Responsible of performance tuning of SQL and PL/SQL code and code reviewing.
Utilizing Oracle SQL-PL/SQL for writing DML/DDL scripts, cursors, for, next and open fetch loops, select into, raise application error, autonomous transactions and case statements, aggregate functions and dynamic SQL

Junior Oracle PL/SQL Developer

Confidential

Environment: Oracle 10g, SQL, PL/SQL, SQL Loader, PL/SQL-Developer, Shell Scripting, ETL.

Responsibilities:

Designing of data mapping for the NH-DOT Toll Road System.
Used SQL* Loader for loading flat files into oracle tables.
Developed validation scripts for the loading process using shell script.
Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
Developed PL/SQL procedures, SQL* ad-hoc reports for the Toll System loading process.
Responsible for performance improvement of the load process and optimizing the SQL queries.

Database Developer

Confidential

Environment: Windows, SQL-Server.

Responsibilities:

Using MySQL to create solutions that leverage practice-level information and consumer insights to deliver highly personal, relevant, timely communications and comprehensive services, which help enhance the veterinarian-pet owner-patient bond and drive revenue for practices.

Software engineer

Confidential

Environment: Windows, PHP, MySQL.

Responsibilities:

The project was for the sake of Chesapeake Bay Program. Invoiced in using PHP and writing SQL queries to implement modifications on an existing database system.
Prepared training materials Sql-Server users.
Conducted database training according to procedures.
Identified issues that affected delivery of training and Evaluated achievement of training program.

Database Developer

Confidential

Environment: Windows, Solaris, Oracle 10g, SQL, PL/SQL, PHP, MySQL, JavaScript, HTML Toad.

Responsibilities:

Simplified the company’s HR processes and reduced amount of time that it takes to do many routine tasks by developing of back-end logic for HR System using Oracle SQL, PL/SQL.
Implemented Call-Support System (hardware and software accidents tracking system) using PHP, MySQL, JavaScript.
Saved company’s money through designing and development database dictionary, back-end logic for Refuel System. The system used to document and control company’s sites refueling operations using Oracle SQL, PL/SQL.

SQL Server Developer

Confidential

Environment: Oracle, SQL Server 2005, PL/SQL Developer, SSMT, T SQL, Windows, UNIX.

Responsibilities:

Developed scripts for data loading flat files from SQL Server to Oracle 10g.
Developed the database of the Site Info, a company specific system, that collect information, creates reports and statistics using data drawn from the company’s sites across the country, generates information regarding: subscribers’ growth according to region, the quality of services, the loaded areas.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship