We provide IT Staff Augmentation Services!

Oracle Database Developer Resume

SUMMARY:

  • 7 years of experience in developing applications using Oracle 10g/11g/12c.
  • Experience in HealthCare and Banking domains.
  • Extensive experience in all phases of Software Development Life Cycle (SDLC) such as Requirement gathering, Analysis, Development, Testing, Implementation and Support.
  • Expertise includes application development using Oracle 10g/11g, PL/SQL, T - SQL, Stored Procedures, Packages, Database Triggers, UNIX, SQL Server and working with partitions.
  • Experience in multiple Relational Database Management systems (RDBMS).
  • Expertise in writing various PL/SQL objects like Procedures, Functions, Packages, Cursors, Views and Triggers in accordance with the business needs.
  • Extensive experience in utilizing advanced PL/SQL concepts like Collections, Bulk collect and Dynamic SQL to boost performance.
  • Experience using Cursors and Ref-cursors for processing the data.
  • Experience in Query Optimization, Performance tuning of SQL queries and PL/SQL procedures using various types of Hints, Partitioning and Indexes.
  • Experience in using Oracle-defined exceptions, Non-predefined oracle exceptions and created User-defined exceptions for Exception handling .
  • Used supplied packages to extend the functionality of PL/SQL programs such as UTL FILE to read and write from database.
  • Expertise in Regular expressions.
  • Extensive experience in writing Static & Dynamic (REF) Cursors, Dynamic SQL, Records and Exception handlers.
  • Experience with logical backup utilities like EXPDP/IMPDP.
  • Experience on advanced feature like Global temporary table (GTT), PL/SQL tablee.
  • Abilty to analyze the query and it’s execution plan to check whether query is executed in best possible way .
  • Analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required
  • Worked on partitioned tables, local and global indexes, materialized views and database links.
  • Used supplied packages to extend the functionality of PL/SQL programs such as DBMS SCHEDULER to schedule jobs.
  • Created new several AUTOSYS jobs and updated existing AUTOSYS jobs according to the requirement.
  • Proficient in oracle tools and utilities such as SQL Loader, SQL developer, SQL PLUS and TOAD.
  • Hands on experience using Query Builder.
  • Knowledge on Oracle architecture and database design.
  • Knowledge in Star schema, Snowflake schemas, Fact and Dimension tables.
  • Knowledge on AWS IAM and S3.
  • Knowledge on Data Modeling(ERWIN tool).
  • Knowledge on PostgreSQL.
  • Effective written, oral and interpersonal skills to present technical ideas to teammates, stakeholders and non-technical individuals.
  • Ability to work individually as well as in a team with excellent problem solving and trouble- shooting capabilities .
  • Demonstrated ability to identify root causes of problems, considering both long-term and short-term impact of proposed solutions.

TECHNICAL SKILLS:

Operating Systems: Linux, Solaris, Windows XP/10 .

Languages: SQL, PL/SQL, C, HTML

Databases: Oracle 9i/10g/11g/12c, Microsoft SQL Server

IDE: TOAD, SQL Developer, SQL Plus, PUTTY

Version Control: CVS,SVN

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Developer

Roles & Responsibilities:

  • Responsible for designing, developing, and maintaining complex PL/SQL applications built off of Oracle 11g and 12c environment.
  • Participated in designing and development of Database using agile development practices
  • Worked thoroughly on coding and debugging of Stored Procedures, functions, packages, cursors and other Oracle objects to implement Business Rules
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
  • Optimized and enhanced the existing procedures and SQL statements for the better performance.
  • Analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
  • Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
  • Creation of Synonyms to create read only objects to maintain the security to give access to specific users.
  • Worked on AutoSys Jobs which will kick off the scripts at the scheduled time automatically.
  • Created different merge statement to make insert and update the table .
  • Created materialized views.
  • Involved in writing the database triggers to furnish the audit details.
  • Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
  • Created new AUTOSYS jobs and updated existing AUTOSYS jobs according to the requirement.
  • Used Analytical functions DENSE RANK, RANK and ROW NUMBER in our project whenever required.
  • Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Involved in Unit Testing, written unit test cases.
  • Worked with ALM(Application lifecycle management) Tool to raise tickets.
  • Experience with Jenkins for build and IBM urban code Deploy to deploy the code into different test environments.
  • Coordinated with various teams like Database, UNIX, Release Engineering teams to set up environments and for day to day activities.

Environment: Oracle 11g/12c, PL/SQL, SVN, TOAD, SQL*Loader, Windows 10, UNIX, HP ALM.

Confidential

Oracle Database Developer

Roles & Responsibilities:

  • Handling modules related to project development for logistics applications at the GENCO that includes analyzing,developing,debugging and testing code, in the real time application environment.
  • Worked thoroughly on coding and debugging of Stored Procedures, functions, packages, cursors and other Oracle objects to implement Business Rules
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
  • Optimized and enhanced the existing procedures and SQL statements for the better performance.
  • Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
  • Used BULK COLLECT in Stored Procedures for the better performance.
  • Analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
  • Creation of Synonyms to create read only objects to maintain the security to give access to specific users.
  • Created materialized views.
  • Involved in writing the database triggers to furnish the audit details.
  • Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
  • Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Consistently coordinated with production support and also responsible for estimating the time factor for several jobs depending upon the data volume size.
  • Involved in Unit Testing, written unit test cases.
  • Worked with BMC Remedy Tool to raise tickets.
  • Coordinated with various teams like Database, UNIX, Release Engineering teams to set up environments and for day to day activities.
  • Followed Enterprise Naming Standards to create any new objects in Database.

Environment: Oracle 11g/12c, PL/SQL, SVN, TOAD, SQL*Loader, Windows 8, UNIX, AutoSys, ER Studio.

Confidential

Oracle Database Developer

Roles & Responsibilities:

  • Involved in Database design, creating tables and defining relationship between tables.
  • Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
  • Participated in designing and development of Database using agile development practices
  • Worked thoroughly on coding and debugging of Stored Procedures, functions, packages, cursors and other Oracle objects to implement Business Rules
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
  • Loaded data from excel sheet to tables using SQL Loader.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files Involved in Data Extraction using UTL FILES in PL/SQL.
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Involved in Unit Testing, written unit test cases.
  • Worked with ClearQuest Tool to raise tickets.
  • Worked with DBAs to tune long running queries and to analyze query execution plan
  • Coordinated with various teams like Database, Release Engineering teams to set up environments and for day to day activities and Supported UAT.
  • Provided daily support for multi-task development, and worked on DEV/QA testing and interacting job between DEV/ QA/ PROD environment. Work with QA team to debug/fix issues.
  • Resolved Priority Production Support Issues and Defect Fixes.
  • Followed Enterprise Naming Standards to create any new objects in Database.

Environment: Oracle 11g, PL/SQL, SVN, TOAD, Windows 8, UNIX, ER Studio, SQL*Loader, MSExcel, WinCVS, WinSCP, WinMerge.

Confidential

Oracle Database Engineer

Roles & Responsibilities:

  • Actively participated in gathering requirements along with team member and Business users to satisfy the needs of the organization.
  • Actively participated in Database design, creating tables and defining relationship between tables.
  • Worked thoroughly on coding and debugging of Stored Procedures, functions, packages, cursors and other Oracle objects to implement Business Rules
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
  • Worked on Composite Table Partitioning to create partitions and sub-partitions on a table.
  • Extensively used PL/SQL tables to code Procedures and Functions.
  • Optimized queries by looking at the cost of the query, providing hints and adding indexes when and where needed.
  • Worked on Dynamic SQL and Ref Cursors.
  • Used FOR ALL and BULK COLLECT in Stored Procedures for the better performance.
  • Involved in Unit Testing of Stored Procedures and Functions
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Consistently coordinated with production support and also responsible for estimating the time factor for several jobs depending upon the data volume size.
  • Documenting changes related to application design for reflecting New, modified and obsolete features in the shared repository, accessed centrally.

Environment: TOAD, SQL Developer, Windows XP, WinSCP, Rational Rose.

Confidential

Associate Consultant (Oracle PL/ SQL Developer)

Roles & Responsibilities:

  • Involved in gathering the requirements.
  • Designed and Developed back-end routines using Oracle PL/SQL, Stored procedures/Packages, Functions, Triggers and cursors.
  • Developed complex SQL queries for data retrieval from various database objects including tables and views.
  • Co-ordination with various problem resolution groups like Database, QA teams.
  • Created materialized views, Inline Views and normal views as per business requirements.
  • Improved performance for several processes reducing the execution time. (PL/SQL queries for Oracle 11g Database with Toad 10).
  • Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
  • Wrote database triggers for audit and data validation.
  • Developed Stored Procedures, Functions, SQL statements and Packages using TOAD.
  • Worked on PL/SQL Error/Exception handling.
  • Used Synonyms to give alternative names to the objects.
  • Developed complex procedures to handle errors and exceptions at the database level using PL/SQL.
  • Created Synonyms for read only objects to maintain the security and restrict access to specific users.

Environment: Oracle 10g, SQL, PL/SQL, Windows XP, CVS, TOAD, SQL Developer, SQL Plus.

Hire Now