printerhas.blogg.se - Oracle pl sql developer resumes

SQL*PLUS, SQL worksheet, iSQL*PLUS, TOAD, PLSQL Developer, SQL Developer, SQL Navigator OCA Oracle 9i Certified Associatein 9i SQL/PLSQL 1Z0-007 Certification.ĮRwin, ER Studio, SQL Developer Data Modeler, Visio.Able to explain technical concepts and communicate with users and system administrators at all levels. Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.Strong interpersonal skills, ability to interact with people at all levels.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.Identified several SQL and PL/SQL bottlenecks using PL/SQ Profiler(package DBMS_PROFILER), explain plan, auto trace.Experience in troubleshooting various aspects of the client/server architecture in both UNIX and Oracle setting.Experience in retrieving data from external data Files and loaded into oracle tables using tools like UTL_FILE, SQL*Loaderand External Tables.

Expertise in Database Performance Tuningand Optimization of SQLstatements using Oracle Hints, Explain plan, Tkprof, SQL*Traceand Table partitioning.

Expert in using PL/SQL advanced topics like System variables, Ref Cursors, Dynamic SQL, Collections, UTL_FILEto read and write the files.

Extensive experience in developing UNIX Shell scriptsand scheduled jobs on UNIX server using Crontab utility.

Expert knowledge in using data modeling tools like ERWIN and ER diagrams, Normalization Techniques for designing database with Relational technology.

Experience in deploying forms and reports on the web.

Hands on experience in design, developmentof end user screens and reports using Forms and Reports 9i and Oracle Developer Suite 10g.

Excellent conceptual knowledge of Oracle 9i/10g, PL/SQL.

Expert in creating Views, Stored Procedures, effective functionsand appropriate Triggersto facilitate efficient data manipulation and data consistency.

Strong knowledge in Oracle cursor management and exception handling.

Experience in creating stored procedures, PL/SQL Packages, Triggersand Functions.

Have a strong knowledge on Dataware-housing concepts and implementation using Oracle ware housing.Strong Knowledge on Oracle architectureand database design.Strong knowledge in front-end development using Oracle forms/reports6i/9i/10g.7 years of programming experience as an Oracle SQL, PL/SQL Developerin Analysis, Design, Data Modeling(Logical and Physical) and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).