Oracle Developer Resume Samples

Oracle Developers are database developers who are basically involved in creating and configuring applications using Oracle technologies. The roles and responsibilities that are usually carried out by these Oracle developers include – developing database system, launching database, maintaining and upgrading company storage capacity, consulting with clients and providing technical support, preparing reports for the management, administering networks, conducting test trials, reviewing programs and correcting program errors.

Essential job skills to be highlighted in the Oracle Developer Resume are good programming skills, Oracle technology expertise, and time management, knowledge of computer system components, networking and coding skills. Apart from these skills, an Oracle developer is expected to have a good understanding of the security of related application networks. Most of the candidates seeking job position as an Oracle developer possess certification in Oracle or at least have a degree in Computer Science or the related field.

Oracle Developer Resume

Headline : Oracle Developer with around 5 years of IT experience as a database developer, with a strong background in Design, development, Data Warehousing/ Decision support systems and Business Intelligence (BI). Detailed Knowledge of Oracle Architecture, Data Dictionary, DBMS Packages and Normalization Techniques. Rich development experience in creating SQL, Stored procedures, Functions, Packages, Database triggers, Shell-Scripts and SQL Loader scripts.

Skills : MS Visio Ticketing Systems, HP Service Center, Service Manager, Service Now, JIRA, SYSAID Version Control/Other Tools SVN, CVS, Putty, Filezilla, SSRS

Description :

  • Gathered the requirements from business users and passed on the requirements to the team.
  • Created custom PL/SQL procedures to read data from flat files to dump to oracle database using SQL Loader.
  • Developed PL/SQL procedures and database triggers for the validation of input data and to implement business rules.
  • Created database objects like packages, procedures, and functions according to the client requirement.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
  • Extracting the data from simple flat text files in the operational database.
  • Creation of database objects like tables, views, materialized views, procedures, packages using Oracle tools like SQL Loader.
  • Extracted data from existing data stores and perform ad-hoc queries.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
BS

Sr.Oracle Developer Resume

Summary : Sr.Oracle Developer with about 8 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and multi-tired applications using the Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux. . Expertise in implementing ETL (extract, transform and load) by using Oracle Warehouse Builder (OWB).

Skills : SQL, PL/SQL, Unix Shell Scripts, JSP, C, C++, Java, CSS, HTML, XML. RDBMS Oracle MS-SQL Server Sybase, DB2 MS Access. Oracle Utilities SQLPlus, SQLLoader

Description :

  • Working with the Business Analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
  • Involved in designing an ER diagram using Visio, to set the logical and physical relationships of the database.
  • Developed stored procedures, functions, packages and SQL scripts using PL/SQL.
  • Loading the data into database tables using SQL Loader from the text and excel files.
  • Developed data model, SQL coding, SQL query tuning process, and schemas.
  • Developed SQL scripts, packages, and procedures for business rules check to implement business rules.
  • Using bulk collections, indexes, and materialized views to improve the query executions.
  • Using Ref cursors and collections for accessing complex data resulted from the joining of a large number of tables in PL/SQL blocks and even have experience with exception handling.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Senior
Education
Education
Bachelors Of Engineering


Oracle Developer Resume

Objective : A Technology-driven Oracle Developer with over 4 years of experience in designing and developing Complex applications, using SQL in a large-scale relational database environment. Experience in gathering business requirements and converting them into functional, technical specifications and developed mapping documents to map source systems to the Data Warehouse Model. Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.

Skills : Oracle (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER DB2, Teradata, SAP Tables And MS Access. Developer Tools: PL/SQL Developer

Description :

  • Interacting with business analysts and participated in user requirement sessions to analyze and gather business requirements.
  • Coordinating with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Created/developed/modified procedures, functions, triggers, materialized views, packages, simple, ref & traditional cursors, dynamic SQL, table functions as part of project/application requirements.
  • Optimized a lot of SQL statements and PL/SQL blocks by analyzing the execute the plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
  • Developed various backend application programs, such as views, functions, triggers, procedures, and packages using SQL and PL/SQL language for the top management for decision making.
  • Worked on SQL Loader to load data from flat files obtained from various facilities every day.
  • Created and modified several Unix shell scripts according to the changing needs of the project and client requirements.
  • Wrote Unix shell scripts to process the files on a daily basis like renaming the file, extracting the date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors Of Engineering

Sr Oracle Developer Resume

Summary : Sr Oracle Developer with over 8+ Years of IT experience as an Oracle Developer in the analysis, Design, Data Modeling, Development and Implementation of Business application in Telecom, Banking, Healthcare and Retail industry using Oracle RDBMS. Highly experience in software Design, Analysis, Coding, Development and Testing with specialization in ORACLE based client-server & Three - Tier Architecture, Database Design, and Development, Implementation, Production support.

Skills : RDBMS Oracle 11g/10g/ 9i/, SQL Server MS Access Programming Languages SQL, PL/SQL, UNIX Shell Scripting, C And C++. Operating Systems Windows 2000/NT/XP, UNIX, Sun Solaris

Description :

  • Documenting business rules, functional and technical designs, test cases, and user guides in the system requirement specifications.
  • Performing the database design at the object level using array and object types.
  • Written PL/SQL scripts for partitioning and indexing database objects like tables, and functions for Oracle databases.
  • Extensively involved in writing PL/SQL stored procedures, functions and database triggers.
  • Extensively written Shell Scripts, Perl Scripts, PL/SQL packages, procedures, and functions.
  • Importing data from different varieties of sources like a flat file, excel file or Oracle dump file into oracle database source schema tables using SQL Loader.
  • Populating the database, exporting and importing data, and creation of packages, triggers, functions and stored procedures for implementing the business logic and database intensive logic.
  • Involving in the creation of dimensional modeling techniques to create dimensions, cubes, and fact tables.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Senior
Education
Education
Bachelor Of Technology


Oracle Developer I Resume

Summary : Oracle Developer I with 12 plus years of IT experience as a PL/SQL developer, Oracle SQL Developer, Developer Forms, and Reports. System Analysis, Design, Development & Support of Oracle Database 9i,10g, and 11g in Production, staging and Development environments. Experienced in interacting with Business Users, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.

Skills : UNIX, Windows XP/2000/NT Languages: C, C++, Java,J2EE,Servlets,JSP,JDBC,ODBC,EJB 2.0,PL/SQL, SQL, SQLPlus,.Net, Sharepoint

Description :

  • Analyzing business requirements of the project by studying the business requirement specification document.
  • Responsible for designing, developing, reviewing, implementing, testing of different modules.
  • Creating database objects queries, tables, indexes, views, materialized views, sequences, primary & foreign keys, constraints, triggers, PL/SQL procedures.
  • Creating constraints on the tables for data validations and for maintaining the clear data without any issues.
  • Creating database objects like tables, views, procedures, packages using Oracle tools like SQL developer, and toad.
  • Extracting data from flat files and transformed it in accordance with the business logic mentioned by the client using SQL Loader.
  • Involved the invalidating the data while data migration by creating PL/SQL packages, procedures, functions, triggers.
  • Modified existing codes and developed PL/SQL packages to perform certain specialized functions.
Years of Experience
Experience
10+ Years
Experience Level
Level
Management
Education
Education
BS

Oracle Developer II Resume

Summary : Oracle Developer II with over 16 years of IT experience including Oracle Database Administration and Oracle Development along with significant expertise in the wireless, Pharma/CRO and IT industries Expertise in Oracle Database clinical-related applications: Oracle Clinical 4.6/4.5, Clintrial, TrialDB, OpenClinica, ClinCapture in Good Clinical Practice (GCP), regulated environment and ITIL Configuration Management Database System (CMDB)

Skills : Oracle SQL SERVER DB2, Teradata Business Areas Applications & Systems Analysis, Design And Development, Windows, Unix, Solaris

Description :

  • Used PL/SQL to create packages, functions, and procedure for user/data validation, request and response.
  • Used PL/SQL and SQL Loader to load data from source file and triggers.
  • Worked on generation of scripts for creation of tables, indexes, views, synonyms, grants, roles and privileges.
  • Created indexes to improve performance and tuning of the SQL queries, which takes a long time to process the request using explain plan, hints to reduce the response time.
  • Perform technical analysis, design, coding, unit testing and problem resolution.
  • Involved in top customer derivation using Global Customer Hierarchy (GCH) golden gate tables.
  • Developed process to identify changes in GCH data and updated top customer according to changes made in GCH system.
  • Involved in developing a process to synch CMDB data based on esp golden gate tables using XML triggers. 
Years of Experience
Experience
10+ Years
Experience Level
Level
Consultant
Education
Education
Post Grad

Oracle Developer Resume

Objective : Oracle Developer with over 4 years of experience in Application Development using Oracle SQL, PL/SQL, ETL, Forms and Reports Developer. Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications. Excellent conceptual knowledge of Oracle PL/SQL and SQL.

Skills : Oracle SQL Server, Oracle APEX 5.0/4.0, MS Access. Application Tools MS Office And MS Visio. Operating Systems Windows 7, Windows Vista, XP, UNIX, Linux

Description :

  • Building complex queries using SQL and wrote stored procedures using PL/SQL.
  • Developed stored procedures, functions, packages and SQL scripts using PL/SQL.
  • Developed interface programs to import parts information to inventory base tables.
  • Establishing Obiee infrastructure and developing next-generation reporting capabilities for business users using Obiee/BI publisher tool.
  • Responsible for development of static reports using Oracle BI publisher and XML.
  • Converted open purchase orders from legacy system to Oracle purchasing using SQL Loader, PL/SQL, packages/procedures.
  • Created host programs using Unix shell scripting for remote database access and FTP of files to the supPLier site database.
  • Developed an interface for item data conversion to load items from flat file to oracle inventory using SQL Loader, PL/SQL, and import items program.
  • Designed apPLication framework and developed oracle apex application.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor Of Technology

Jr. Oracle Developer Resume

Objective : Jr. Oracle Developer with over 3 years of experience in Application Development using Oracle SQL, PL/SQL, and Developer Forms and Reports Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications Strong Knowledge of Oracle architecture and database design.

Skills : Oracle SQL Server, MS Access. Scripting: SQL, UNIX Shell Scripting, And JavaScript. GUI: Oracle Forms And Reports And VB. Language: PLSQL, HTML, CSS, JavaScript

Description :

  • Writing logic to extract all the data and output them to flat files.
  • Working with the business analysts and the dba for requirements gathering, business analysis, testing, metrics and project coordination.
  • Involved in logical modeling and physical modeling of the application using the Erwin tool and created SQL scripts.
  • Developed stored procedures, functions, packages and SQL scripts using PL/SQL.
  • Involving in the creation of conceptual modeling covering all the business requirements.
  • Loaded the data into database tables using SQL Loader from external files.
  • Developed SQL scripts for referential integrity check, which checks the validity of incoming data with master tables in the database.
  • Created ETL design documents for interfaces and mappings, ETL source to target mapping documents, ETL implementation documents using Oracle data integrator ETL tool, unit test plans and deployment checklists documents.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Associate

Oracle Developer Resume

Objective : Oracle Developer with over 5 years of extensive experience as a PL/SQL, Oracle Developer in various domains including Finance, Pharmaceuticals, Manufacturing, Banking, Service, and Communications. Expertise in Software Development Life Cycle (SDLC) of client implementations including Requirements Gathering, Design, Development, Testing, Technical Documentation, Delivery/migration and Support.

Skills : Oracle SQL Server Languages SQL, PL/SQL, ProC, C/C++, JAVA, XML, UNIX Shell Scripting, Perl Scripting Oracle Tools/ GUI Forms Reports 6i/9i/10g, Discoverer 4i/10g

Description :

  • Extensively developed PL/SQL packages, stored procedures, triggers, and finely tuned them for performance.
  • Extensively used PLSQL tables and bulk loader programs for processing data and loading into oracle tables.
  • Performed extensive defect fixing and support during the client pre-production testing phase, identifying issues and tracking them through hp quality center.
  • Wrote generic PL/SQL code modules (PL/SQL libraries) for reports to handle data manipulations on client.
  • Designed and imPLemented client-server apPLication using oracle forms builder.
  • Involved in the generation of the user interface using oracle forms by extensively creating forms as per the client requirements.
  • Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
  • Developed Unix scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
  • Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor Of Technology

Sr. Oracle Developer Resume

Summary : A dynamic Sr. Oracle Developer with over 9+ years of experience in Software Development Lifecycle as a Database Developer, which includes Analysis, Development, Implementation and testing & Team Management. Expertise in Design and Development of applications using Oracle Applications Express (APEX) Strong working experience in Oracle 11g/10g database programming using PL/SQL and standard built-in Oracle packages in UNIX and Windows environment.

Skills : PL/SQL, SQL, UNIX Shell Scripting, Java, C++, C Tools/Utilities SQLPLUS, SQLLoader, SQLDeveloper, TOAD, SQL Navigator

Description :

  • Involving in the continuous enhancements and fixing of production problems.
  • Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
  • Involved in data replication and high availability design scenarios with Oracle Streams.
  • Developed Unix shell scripts to automate repetitive database processes.
  • Monitoring committed to keeping accurate records, ensuring on-time deposits, and maintaining tax compliance. Possesses a numerical accuracy and calculating balances.
  • Worked on multiple tasks and multiple database instances at the same time.
  • Worked with ETL team involved in data loading from different sources and data validation process from the staging area to the catalog database.
  • Created page processes in several instances and computations in the apex.
  • Designed application framework and developed Oracle apex application.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Senior
Education
Education
Bachelor Of Technology