We provide IT Staff Augmentation Services!

Oracle Developer Resume

0/5 (Submit Your Rating)


  • Around 9 Plus years of experience as Oracle Developer with Extensive knowledge and work Experience in SDLC including Requirements Gathering, Business Analysis, System Configuration, Design, Development, Testing, Technical Documentation and Support.
  • Strong experience in systems Analysis, design and development of complex software systems inBanking and Telecom Domain.
  • Have in - depth knowledge in Data analysis, Data warehousing and ETL techniques, Business Objects, UNIX Shell Scripting, SQL, Power Builder, PL/SQL scripts.
  • Rich experience working with Data Stage ETL tool for the extraction, transformation and loading of data among different databases.
  • Strong knowledge of ETL processes using UNIX shells scripting, SQL, PL/SQL and SQL Loader.
  • Strong Experience in front-end and back-end development usingForms11g/10g, SQL, PL/SQL,Oracle 11g/10gandOracle Designer10gfor Data modelling.
  • Experience with Data flow diagrams, Database normalisation techniques, Entity relation modeling and design techniques.
  • Rich experience in writingSQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, Dynamic SQL.
  • Strong knowledge of Data Extraction, Data Mapping, Data Conversion and Data Loading process using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
  • Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
  • Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Worked extensively on Ref Cursor, External Tables and Collections.
  • Good knowledge on logical and physical Data Modeling using normalizing Techniques.
  • Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
  • Extensively used bulk collection in PL/SQL objects for improving the performing.
  • Experienced in Design and Development of Data Warehousing solutions for Extraction, Transformation and Loading (ETL) mechanism.
  • Usage of vi editor for writing the Unix korn, bash scripts. Experience in Unix utilities like SED, AWK
  • Huge experience in developingOraclePL/SQL packages and object types. Proficiency in using UNIX shell scripts for testing the application.
  • Good Knowledge on UNIX and Batch scripts like File watcher, File ftp, Data Validation, User defined functions, File Format Validation, Crone Jobs.
  • Developed Materialized views for data replication in distributed environments.
  • Experience in query optimization, performance and tuning (PL/SQL) usingSQL Trace, Explain Plan, Indexing, Bulk Collect, AWR and table partitioning.
  • Collaborated with QA teams for creating and reviewing Test Plans and Test Cases.
  • Experience creating and managing defects in the Quality Center.
  • Strong Analytical and Problem Solving skills, Multi-Tasking abilities.
  • Self-motivated, flexible, knowledgeable, hardworking, and detail oriented person.
  • Good communicator, coordinator and organizer.
  • Worked with business users as well as senior management and Participated in walkthroughs with the management and developer team


Methodologies: Waterfall, Agile-Scrum

Requirements Management: JIRA

Database: SQL Server, Oracle 9i/10g/11g.

Scripting: Unix Shell, Perl 5.8.8

Release Management: ITCM, JIRA, RNOW (Release now)

Application Languages: Java, SQL, PLSQL

Scheduling Tools: Control M, Autosys

Testing Tools: HP Quality Center, JIRA

Operating Systems: Microsoft Windows Xp/2007/vista/7/8.

We'd love your feedback!