Pl/sql Developer Resume
5.00/5 (Submit Your Rating)
OBJECTIVES
- To seek a competitive and challenging career opportunity in IT Firm, that utilizes my skills and knowledge and at the same time provides challenging opportunities for learning and growth.
SUMMARY
- Having 3+ years of IT experience in the field of oracle in pl/sql development.
- Main responsibilities include understanding of client requirements & develop solutions.
- Experience on pl/sql programming in Oracle 10g/11g relational and object relational database.
- Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers, cursor, bulk collect using SQL and PL/SQL with OOPS concept.
- Working on Oracle OLAP and hands on experience in SQL tuning/Re - writing SQLs in an alternate better way.
- Written SQL queries for DML operations, Sub queries, JOIN and queries optimization.
- Effectively made use ofTable Functions, Indexes, Collections, Analytical functions.
- Create the objects like tables, synonyms, sequences and views.
- Experience on SQL *PLUS, TOAD tools.
- Knowledge on UNIX.
- Ability to be an effective team player and work under time constraints.
TECHNICAL SKILLS
Operating System: Windows 98/NT/2000, Linux.
Language: SQL, PL/SQL.
RDBMS: ORACLE.
TOOLS: SQL * PLUS, TOAD.
PROFESSIONAL EXPERIENCE
Confidential
PL/SQL Developer
Responsibilities:
- Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
- Developed PL/SQL triggers and master tables for automatic creation of primary keys.
- Created PL/SQL stored procedures, functions and packages.
- Creating of new tables, views, queries for new enhancement in the application using TOAD.
- Retrieving data set in bulk using pl/sql tables.
- Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad and SQL* plus.
- Extensively used bulk collection in PL/SQL objects for improving the performing.
- Created records, tables, collections (nested tables and arrays) for improving Query performance.
- Identify suitable business scenario in the existing application and suggest/implement back end procedure implementation.
- Must be very comfortable in generating/understanding query plan and identify deficiency in query execution, suggesting, implementing changes for better performance.
- Hands on experience in SQL tuning/Re-writing SQLs in an alternate better way and queries optimization.
Confidential
PL/SQL Developer
Responsibilities:
- DML operation on tables, views, procedures and packages using oracle tools like Toad and SQL* plus.
- Working with Unix OS and shell scripting.
- Identify performance bottlenecks in PLSQL procedure and eliminate by alternate implementation.
- Developed PL/SQL triggers and master tables for automatic creation of primary keys.
- Extensively used bulk collection in PL/SQL objects for improving the performing.
- Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
- Used Bulk Collections for better performance and easy retrieval of data.
- Created records, collections (nested tables and arrays) for improving Query performance.
- Good knowledge in Analytical Functions and Notification,FUNCTION,PROCEDURE,PACKAGE,OOPS