We provide IT Staff Augmentation Services!

Oracle Developer Resume

Alpharetta, GA

SUMMARY:

  • Over 8+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
  • Involved in leading software development on software projects from conception through implementation, execution and maintenance with timely delivery against aggressive deadlines.
  • Efficiently worked and deployed distinct Client - Server applications using Oracle 12c/11g/10g PL/SQL, iSQLPLUS, SQL *PLUS, TOAD and SQL*LOADER
  • Proficient in writing PL/SQL Stored Procedures, Functions, Cursors, Triggers and Packages
  • Created Tables, Views, Constraints
  • Created Shell Scripts for invoking SQL scripts
  • Have automated many jobs using unix crontab in unix
  • Have used Autosys as automated job control system for scheduling, monitoring and reporting jobs.
  • Strong skill set in using Oracle utilities like iSQLPLUS, SQL*PLUS, SQL*Loader, TOAD.
  • Loaded Data into Oracle Tables using SQL Loader.
  • Expertise in complex SQL queries including inline queries and subqueries for faster data retrieval from multiple tables.
  • Partitioned large Tables using range partition technique.
  • Tuned SQL queries to improve performance.
  • Good knowledge on SQL Performance tuning using Cost-Based Optimization (CBO) and Exception handling.
  • Good experience in Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
  • Experience in using Bulk collect, and Bulk binds
  • Troubleshoot and debug system and/or data errors.
  • Uncommon determination to learn and ability to learn fast

TECHNICAL SKILLS:

Database: Oracle 10g/11g/12c (SQL, PL/SQL)

Operating System: UNIX, Windows NT/2000, and Windows XP

Programming Languages: C, C++, Perl, Python, PL/SQL, Shell Scripting (sh/ksh/csh)

RDBMS: ORACLE

Markup Languages: XML, HTML, XHTML

Utilities: SQL*PLUS, iSQLPLUS, SQL*Loader, and TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Oracle Developer

Responsibilities:

  • Worked on Commissions and fraud applications
  • Used SQLDeveloper as oracle database tool.
  • Worked on oracle 11g
  • Loaded datas from different source systems to import database
  • Used JIRA as ticket tracking tool
  • Worked on data loading and calculation part for the commissions application.
  • Worked on packages, procedures, functions and various other database objects
  • Have fine-tuned sql queries
  • Have worked on new requirements, as well as enhancements
  • Have done couple of performance tuning using collections, bind variables, indexes, and partitioning
  • Used GIT and Stash for version control to checkin and checkout code and to run scripts to make changes in database objects
  • Have supported testing team whenever a bug is raised and worked on providing fix.
  • Worked on Agile methodology and made releases every 4 weeks

Environment: Oracle 11g, GIT, Stash, SQL Developer, JIRA, Windows XP

Confidential, Alpharetta, GA

Database Developer

Responsibilities:

  • Worked on data extraction and population process
  • Implemented solutions for data quality issues
  • Developed database objects to facilitate consistent data entry into the database
  • Created staging tables to load data files from source systems
  • Worked on views and Jsons to populate data to target tables
  • Have done database masking for lower environments
  • Worked on mappings before a table sits on database
  • Worked on new requirements as well as enhancements
  • Assisted testing team after the code has been moved from build stage
  • Involved in creation of various indexes on relational tables
  • Developed back end interfaces using packages and procedures
  • Worked on query optimization and performance tuning
  • Have done couple of performance tuning using collections, bind variables, indexes, and partitioning
  • Used Tortoise SVN for version control
  • Translated business into technical requirements

Environment: Oracle 11g, DB Visualizer, Tortoise SVN, Windows XP

Confidential, Tampa, FL

Oracle Developer

Responsibilities:

  • Worked on risk and fraud control applications
  • Followed agile methodology, a fast paced working environment and made releases every 2 weeks
  • Used toad 12.1 as oracle database tool
  • Created SCR (Software change request) to meet the business requirements
  • Worked on oracle 11g
  • Have used bulk data loading utilities like sql loader nad external tables
  • Have done export / import schemas and tables
  • Built the ETL source to Target specification documents by understanding the business requirements
  • Used oracle hints like index, no index and parallel
  • Have run queries in parallel to improve performance
  • Worked on JavaScipt and AngularJS to support internal error report portal
  • Developed mappings that perform Extraction, Transformation and load of source data into Target Schema and tables in Informatica
  • Worked on large database having trillions of records
  • Have done couple of performance tuning using collections, bind variables, indexes, and partitioning
  • Used GIT for version control to checkin and checkout code and to run scripts to make changes in database objects
  • Once the development and unit testing is done, rolled it to integration environments and finally to prod
  • Supported the issues raise in QA and redelivered the patch on time

Environment: Oracle 11g, TOAD, GIT, SQL Developer, Windows XP

Confidential, Auburn Hills, MI

Oracle PL/SQL Developer

Responsibilities:

  • Worked on a banking application that involves lots of transaction, Financial information and lot other details in Oracle database
  • Using Shell scripting and Oracle as database worked on database development and maintenance project
  • Wrote tuned SQL queries to fetch huge number of data without any time delay and processed it as required
  • Created database objects like procedures, functions, triggers, views to accommodate the new functionality as per the client requests
  • Extensively Worked on Packages, Procedures, Functions, Views, cursors, ref cursors, table functions and Triggers in Oracle PL/SQL 12c/11g
  • Changed database objects without affecting the other modules which depend on it and have done the regression testing, if required
  • Used SQL*LOADER to load data into database from flat files
  • Worked with high volume data and Performance Tuning using various types of Hints, Partitioning and Indexes
  • Have automated data loading in database from various format flat files by creating unix shell scripts
  • Extensively used global temporary tables and ref cursors to store and process data
  • Actively involved in creating indexes and partitions on tables for Optimization and Tuning for enabling maximum database efficiency
  • Created functions for complex data parsing of multiple input parameters in Oracle
  • Used Autosys JIL (Job information Language) to create jobs.
  • Created new documents as well as maintained and updated the existing documents of the project

Environment: Oracle 12c, 11g, SQL * Plus, iSQLPLUS, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential, Troy, MI

Database Developer

Responsibilities:

  • Involved in various phases like Analysis, Detailed design, Development, Maintenance, Testing and deployment
  • Created User Schemas, tables, indexes, sequences, and views.
  • Created and developed Oracle PL/SQL packages, stored procedures, functions, and anonymous blocks
  • Involved in creating UNIX shell scripting.
  • Have done defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
  • Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
  • Modified existing Code according to the requirements
  • Documented all modules for user level and system level maintenance
  • Performed complex scripting and querying in both the development, testing as well as production environment
  • Worked on Data Transformations, Data Loading, Database Modeling and Performance Tuning
  • Worked on troubleshooting defects in timely manner.
  • Resolved technical related issues and documented procedures

Environment: Oracle 10g/11g, PL/SQL, SQL*LOADER, SQL PLUS, TOAD, UNIX Shell scripting, Windows XP

Confidential, Greensboro, NC

Oracle PL/SQL Developer

Responsibilities:

  • Worked for a billing Application Maintenance Project on which maintained and extended the application system for better performance and efficiency
  • Created and reorganized all types of Oracle database objects including tables, views, indexes, sequences, synonyms and setting proper parameters and values for all the objects
  • Wrote Oracle database triggers, stored procedures, stored functions, and stored packages to perform various automated tasks for better performance
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Created Shell Scripts for invoking SQL scripts
  • Created and modified several UNIX shell scripts according to the changing needs of the project.
  • Used different joins, sub-queries and nested queries in SQL query
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Analytical functions, and Materialized Views
  • Used the Cursor for Loop to fetch unconditional number of rows
  • Imported/Exported data from/to different databases using utilities like SQL*Loader
  • Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
  • Involved in the continuous enhancements and fixing of production problems.
  • Verified and validated data using SQL queries
  • Analyzed and prepared High and low level designs
  • Made clear, maintainable, efficient and reusable codes

Environment: Oracle 10g/11g SQL, PL/SQL, UNIX, SQL*Loader, SQL Navigator, TOAD, SQL DEVELOPER

Confidential

Programmer Analyst

Responsibilities:

  • Programmed in Perl using Oracle as database on UNIX environment to accomplish the requirements of the client
  • Have done production support with 24/7 uptime
  • Have done debugging, monitoring and support kind of work
  • Developed a mapping technique using Perl script that would take the SQL data and generate the XML output file on the UNIX system
  • Created Tables, Views, Constraints
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Worked on C, C++ and data structures
  • Created High level and Low level design documents to make enhancements in the existing database and on Unix server
  • Responsible for gathering requirements
  • Used Oracle utilities like SQL*Loader, TOAD, SQL*Navigator
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  • Loaded Data into Oracle Tables using SQL Loader.
  • Partitioned large Tables using range partition technique
  • Worked on CRs(Change requests) as equal as the new requirements
  • Written bug free code to the possible extent and tested by self to avoid the bug elevation to the testing environment
  • Identified the problem and fixed it, when something went wrong in production environmrent
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Had inter team and client interactions and discussions before the start of any work to avoid the miscommunication and to get the work neatly done.

Environment: UNIX, SQL*Loader, TOAD, SQL*Navigator, Oracle 9i/10g database, Shell scripting, Perl, XML

Hire Now