Oracle Developer Resume Tempe, AZ - Hire IT People

SUMMARY:

Over One and Half years of experience in SQL Developer.
Expertise skills in using the tools SQL * Loader, Oracle SQL Developer.
Hands - on experience with installation and building Database.
Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges. Writing and Tuning complex SQL statements.
Expertise in writing SQL queries, stored procedures, functions, packages, triggers, external tables, Analytical functions, Collections, BULK COLLECT and DBMS utilities.
Expertise in the different phases of the Software Development Life Cycle (SDLC) like Requirements Analysis, Design, Development, Unit Testing, Implementation, Software Management and Enhancement of various Applications on Client-Server Technologies.
Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
Good understanding of Oracle data dictionary, RDBMS and normalization techniques.
Experience in Data warehouse concepts, ETL.
Good knowledge on logical and physical Data Modeling using normalizing Techniques.
Excellent problem solving skills with a strong technical background. Creative, Adaptive and result-oriented professional with avidness to learn.

PROFESSIONAL EXPERIENCE:

Confidential, Tempe, AZ

Oracle Developer

Responsibilities:

Created and modified complex functions, stored procedures, packages and Triggers by using Oracle SQL based on the business rules.
Extensively worked on Schema Migration, Database Program Migration, Data Migration from Sybase to Oracle by using Oracle SQL Developer.
Worked on SQL Tuning by using various tools like EXPLAINPLAN, DBMS PROFILER, and Hints etc.
Worked on Dynamic SQL by using Execute Immediate and DBMS SQL along with Bulk Collect.
Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
Worked on Table partitioning and Index creation to improve the performance of the query.
Used various analytical functions to handle complex logic of SQL case statement scenarios.
Worked with DBA’s regarding the data checks during migration, loading, creation and management of tables, indexes, table spaces etc.
Developed SQL triggers and master tables for automatic creation of primary keys.
Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like SQL Developer and SQL* plus.
Developed custom shell scripts to create synonyms and grant necessary permissions for the objects which are being migrated into new instances.
Communicate with developers, database administrators, project managers, Systems analysts and senior management about the issues that impact the project’s success.
Facilitate and document the post implementation results in the form of closure reports.

Environment: Oracle 10g,11g, PL/SQL, SQL *Plus, Oracle Apex, Form & Reports 10g, Linux, Window Discoverer 10g, SQL*Load and XML publisher, BI Publisher.

We provide IT Staff Augmentation Services!

Oracle Developer Resume

Tempe, AZ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship