PL SQL Developer Resume Samples

A PL SQL developer takes charge of maintaining and building computer databases using Pl/SQL packages, the various other roles and responsibilities that are normally executed and included in the PL SQL Developer Resume are – developing and providing support to system interfaces, coordinating with other developers and project managers for evaluation of applications, developing various SQL packages, monitoring and recommending changes in PL/SQL packages, developing relational database, testing and troubleshooting databases, ensuring data security and merging database information.

The normal skills that are expected from a PL SQL developer are SQL expertise, working knowledge of various operating systems, programming language skills, familiarity with ETL tools and a good grip of Oracle, Java and D2K forms. While a Bachelor’s degree in the field of IT or computer science is considered ideal for this job role, some employers oversee work experience and skills over formal education.

Oracle PL/SQL Developer Resume

Objective : Oracle PL/SQL Developer with over 2 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 all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.

Skills : Oracle 10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER DB2, Teradata, MS Access. ETL Tools: Informatica (Power Center AB Initio And SQLLoader.

Description :

  • Involving in the full development cycle of PLanning, analysis, design, development, testing, and implementation.
  • Designing logical and physical data models for star and snowflake schemas using Erwin.
  • Created and modified SQL PLus, PL/SQL and SQL Loader scripts for data conversions.
  • 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.
  • Wrote SQL, PL/SQL, SQL PLus programs required to retrieve data using cursors and exception handling.
  • Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
  • 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 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
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Bachelors in Electrical


Oracle PL/SQL Developer Resume

Headline : About 6+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Data Modeling (Logical and Physical). Development of client/server, multi-tiered applications using the Oracle Relational Database Management System (RDBMS), SQL and PL/SQL on different platforms like Windows NT/2000/XP, UNIX, and Linux. Well experienced working with Waterfall &Agile Methodologies. Experienced in Tuning Queries for better performance with a large volume of data.

Skills : SQL LOADER, SQL Developer, SQL Plus, SQL Developer, Data Modeler, Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g, Crystal Reports, ETL,SSIS

Description :

  • Created technical design for the back end PL/SQL based on business requirement documents and the functional system design.
  • Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using Oracle tools like PL/SQL developer.
  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Involved in updating procedures, functions, triggers, and packages based on the change request.
  • Built complex queries using SQL and wrote stored procedures using PL/SQL.
  • Used ref cursors and collections for accessing comPLex data resulted from joining of a large number of tables.
  • Involved in moving the data from flat files to staging area tables using SQL loader.
  • Extensively used for all and bulk collect to fetch large volumes of data from the table.
  • Performed SQL and PL/SQL tuning and application tuning using various tools like tkprof, autotrace and dbms_SQLtune.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
MS


Oracle PL/SQL Developer Resume

Summary : Oracle PL/SQL Developer having 10 years of programming experience, as a Sr. Oracle SQL, PL/SQL and ETL Developer in Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Experience in Data Migration across various databases as well as within the same database across different systems. Well-versed in different stages of the Software Development Life Cycle (SDLC).

Skills : Oracle 11G, Oracle PL/ SQL, UNIX Shell Script, SQL Developer, Toad, Oracle Developer, IBM Rational, Agile & Waterfall, PowerBuilder

Description :

  • Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL PLus, SQL developer, and toad.
  • Enforced data integrity using integrity constraint and database triggers.
  • Proficient in advance features of Oracle 11g for PL/SQL programming like using records and collections, bulk bind, ref. Cursors, nested tables, and dynamic SQL.
  • Created partitioned tables and partitioned indexes to improve the performance of the applications.
  • Experience with performance tuning for Oracle RDBMS using explain plan and hints.
  • Interacted with web development team to develop in tandem back-end solutions with front-end web executions.
  • Executed Quality Control checks of source code created by other developers.
  • Monitored incoming/outgoing data. Troubleshoot errors as they occur.
Years of Experience
Experience
10+ Years
Experience Level
Level
Management
Education
Education
Bachelor Of Technology

Oracle PL/SQL Developer (Unix) Resume

Objective : Over 4+years of professional experience in IT industry as Oracle SQL/PLSQL developer, Analysis, Design, and Modeling. Strong knowledge of Oracle architecture and database design. Excellent skills in designing and development of applications using Oracle, SQL, PL/SQL Good knowledge on Oracle tools like SQL PLUS, PL/SQL, SQL and used TOAD in many development projects. Oracle Forms and Reports Experienced in all phases of Software Development Life Cycle (SDLC).

Skills : Informatica, ETL. Basic Knowledge Of SAS Programming: SQL, PL/SQL, T-SQL, UNIX Scripting. Operating Systems: Windows UNIX.

Description :

  • Participating in database design within an existing Oracle database structure.
  • Helping application development team in preparing technical designs and perform construction activities.
  • Working with developers to design and write complex packages to support their needs.
  • Writing complex functions and procedures for new packages and update existing packages in an established Oracle database using pre-defined business rules.
  • Working with database administrators to implement design changes and new packages.
  • Performance testing and rewriting of production Code/SQL statements & procedures performing badly, identified by database administrators.
  • Provided database support to developers who write code using WCF, WPF and. Net.
  • Supporting the application through the testing and implementation phases, including product test, stress/load test etc.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
BS

Oracle PL/SQL Developer Resume

Headline : Oracle PL/SQL Developer with around 6 years of total IT experience in Business Requirements Analysis, Application Design, data modeling, Datawarehousing, Coding, Development, Tuning, Testing, Oracle EBS and implementation of business applications with RDBMS,SQL,PL/SQL,Oracle Reports, UNIX Shell scripting, Java and J2EE. 8 years of working experience in Oracle SQL and PL/SQL procedures, functions, packages, triggers, cursors, view etc.

Skills : MS-VISIO, Visual Source Safe (VSS), CVS, Crystal Reports 8.0/XI, Forms 5.0, Forms 6i, Reports 6i, Forms 9i, Reports 9i, Oracle Reports 10G, Oracle Forms

Description :

  • Maintaining customer information and ensuring efficient data retrieval as required for core decision making.
  • Writing stored procedures, triggers and monitoring performance to ensure efficient data retrieval.
  • Understanding of clients functional requirements and participate in writing functional specs.
  • Coordinating with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Working on SQL Loader to load data from flat files obtained from various facilities every day.
  • Creating and modifying several Unix Shell scripts according to the changing needs of the project and client requirements.
  • Writing 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.
  • Involving in the continuous enhancements and fixing of production problems.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
BS

Junior Oracle PL/SQL Developer Resume

Objective : Junior Oracle PL/SQL Developer with over 3 years of experience in Design, Development, and Implementation of enterprise Oracle databases applications in both OLTP and Decision Support systems. Extensive experience using IDE Tools like Eclipse, NetBeans, and IDEA IntelliJ for Java/J2EE application development and web technologies like HTML, and XML as required for database management. Good knowledge and understanding of Data Modeling concepts, UML diagrams using MS Visio.

Skills : SQL Plus, SQL Loader, WinSCP, SharePoint, MS Project, Putty, EditPlus, Putty, Confluence, TextPad, Build (ANT, MAVEN), SVN, Log4J, PAC2000, JQuery

Description :

  • Wrote PL/SQL programs required to retrieve data from the data repository using cursors, UTL file i/o and exception handling sync up with confluence for project related information.
  • Used SQL Loader/Korn shell script to load data from various sources into an Oracle database.
  • Wrote complex SQL using joins, sub-queries and correlated sub-queries.
  • Used clear case for maintaining the component and for release and version management.
  • Maintained scripts using Korn shell scripting (extension-. Ksh) and Perl to support development.
  • Developed Unix shell scripts to automate repetitive database processes.
  • Tracked all the releases and updating the information on to a centralized location (wiki).
  • Developed Korn shell scripts for job scheduling, batch processing, and database transactions.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
College

Senior Oracle PL/SQL Developer Resume

Summary : Over 7 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). Good knowledge of logical and physical Data Modeling using normalizing Techniques. Created Tables, Views, Constraints, Index (B Tree, Bitmap, and Function Based). Developed Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.

Skills : SQL, PL/SQL, Unix Shell Scripts, Java, XML, C And C++ Other Tools: AutoSys, Control-M, PVCS, WIN CVS, Informatica Data Quality, B2B Data Transformation, Informatica Power Exchange

Description :

  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • 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.
  • Involved in the continuous enhancements and fixing of production problems.
  • Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Created PL/SQL stored procedures, functions, and packages for moving the data from the staging area to the data mart.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Executive
Education
Education
BS

Oracle PL/SQL Developer Resume

Summary : Oracle PL/SQL Developer with 7+ years of experience on various phases of SDLC such as Project Requirement Study, high-level design, low-level design, Coding, Testing, Quality assurance Documentation, Implementation and Project Planning. Expertise in data modeling for large data warehouses supporting business intelligence applications (OLAP) and also online transaction processing systems (OLTP).

Skills : Oracle, MS SQL Server, IBM DB2 UDB 8.0/7.0. Environment Windows XP, Red Hat Linux, Unix, Sun Solaris. Programming Languages PL/SQL, SQL, TSQL

Description :

  • Responsible for gathering requirements from users for reports development and interface program customizations and in analyzing the business process.
  • Created and maintained Oracle database objects like tables, views, materialized views, indexes, constraints, sequence, synonyms and database link using SQL.
  • Created numerous complex queries involving joins, correlated sub-queries diverse business requirements.
  • Partitioned tables by determining the suitable methodology to improve performance and manageability.
  • Planned, designed, and implemented the application database code objects, such as stored procedures and views, indexes.
  • Worked on advanced PL/SQL constructs like Oracle-supplied packages, nested tables, varrays, records, types, dynamic SQL and analytical functions.
  • Created temporary tables, packages and procedures using SQL developer.
  • Involved in writing the database triggers to furnish the audit details.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Senior
Education
Education
MS

PL/SQL Developer Resume

Summary : Oracle PL/SQL Developer with over 8 years of experience in the field of software development. Experience in Perl, Oracle and Unix Expertise in financial industries based applications including trading systems. Excellent database knowledge on RDBMS like Oracle, SQL, PL/SQL Solid experience in Perl programming using with JavaScript and Html. Experience in Oracle SQL queries and PL/SQL scripts, procedures, functions, triggers and packages and query optimization.

Skills : Microsoft Project, MS Excel, MS Access, T-SQL, SSIS, SSRS, MS Visio, Unix Shell/Perl Script

Description :

  • Involving in database development by creating Oracle PL/SQL functions, procedures, triggers, packages, records, and collections.
  • Creating database objects like SQL queries, tables, joins stored procedures using Oracle utilities like PL/SQL, SQL plus, SQL server.
  • Involving in performance tuning for complex SQL queries using explain plan tables, collections, and table partitions to optimize performance.
  • Generating SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants, and synonyms.
  • Involving in application enhancements according to user requirements.
  • Building physical data structures like tables, views, constraints & indexes.
  • Working with SQL loader and control files to load the data in different schema tables.
  • Implementing features including materialized views for better performance of summary tables, autonomous transactions, coding dynamic SQL statements.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Senior
Education
Education
MS

PL/SQL Developer Resume

Objective : PL/SQL Developer with 4+ years of extensive experience as an Oracle, PL/SQL Developer with ETL experience. Expertise in Software Development Life Cycle(SDLC) of client implementations including requirements gathering, business analysis, system configuration, design, development, testing, technical documentation, and support. Strong experience in providing technical documentation and status reports of the applications as per the requirement.

Skills : SQL, PL/SQL, XML, UNIX Shell Scripting, Perl Scripting, C, C++, Perl Programming Oracle Tools/GUI Forms

Description :

  • Developing complex database processes with PL/SQL containing batch or ETL functionality.
  • Developing and enhancing an existing DataMart in an OLAP schema.
  • Requirements gathering, design, development, testing, and documentation.
  • Designing logical and physical ERD diagrams, process flow diagrams, or related data processing documentation.
  • Leveraging Oracle 10g/11g features to their fullest on a large-scale multi-terabyte system.
  • Assisting the Decision Support team members including DBAs, database developers, requirements analysts, and others, in understanding data and meeting user requirements.
  • Providing production deployment and production support as needed.
  • Analyzing and converting business requirements to technical requirements, followed by designing and implementing the solutions
  • Participating in performance tuning activities.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
BS