PL SQL Developer Resume Samples

Description :

1. Involving in the full development cycle of PLanning, analysis, design, development, testing, and implementation.
2. Designing logical and physical data models for star and snowflake schemas using Erwin.
3. Created and modified SQL PLus, PL/SQL and SQL Loader scripts for data conversions.
4. 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.
5. Wrote SQL, PL/SQL, SQL PLus programs required to retrieve data using cursors and exception handling.
6. 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.
7. Coordinating with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
8. Created and modified several Unix shell scripts according to the changing needs of the project and client requirements.
9. 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.

Experience

0-2 Years

Level

Entry Level

Education

Bachelors in Electrical

Description :

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

Experience

5-7 Years

Level

Executive

Education

MS

Description :

1. Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL PLus, SQL developer, and toad.
2. Enforced data integrity using integrity constraint and database triggers.
3. 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.
4. Created partitioned tables and partitioned indexes to improve the performance of the applications.
5. Experience with performance tuning for Oracle RDBMS using explain plan and hints.
6. Interacted with web development team to develop in tandem back-end solutions with front-end web executions.
7. Executed Quality Control checks of source code created by other developers.
8. Monitored incoming/outgoing data. Troubleshoot errors as they occur.

Experience

10+ Years

Level

Management

Education

Bachelor Of Technology

Description :

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

Experience

2-5 Years

Level

Junior

Education

BS

Description :

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

Experience

5-7 Years

Level

Executive

Education

BS

Description :

1. 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.
2. Used SQL Loader/Korn shell script to load data from various sources into an Oracle database.
3. Wrote complex SQL using joins, sub-queries and correlated sub-queries.
4. Used clear case for maintaining the component and for release and version management.
5. Maintained scripts using Korn shell scripting (extension-. Ksh) and Perl to support development.
6. Developed Unix shell scripts to automate repetitive database processes.
7. Tracked all the releases and updating the information on to a centralized location (wiki).
8. Developed Korn shell scripts for job scheduling, batch processing, and database transactions.

Experience

2-5 Years

Level

Junior

Education

College

Description :

1. Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
2. Worked on SQL loader to load data from flat files obtained from various facilities every day.
3. Created and modified several Unix shell scripts according to the changing needs of the project and client requirements.
4. 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.
5. Involved in the continuous enhancements and fixing of production problems.
6. Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
7. Developed PL/SQL triggers and master tables for automatic creation of primary keys.
8. Created PL/SQL stored procedures, functions, and packages for moving the data from the staging area to the data mart.

Experience

7-10 Years

Level

Executive

Education

BS

Description :

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

Experience

7-10 Years

Level

Senior

Education

MS

Description :

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

Experience

7-10 Years

Level

Senior

Education

MS

Description :

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

Experience

2-5 Years

Level

Junior

Education

BS