jascal.blogg.se - No valid oracle clients found toad

Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.Coordinated wif the front end design team to provide them wif the necessary stored procedures, functions, packages to view appropriate data at GUI.Web Technologies: HTML, Websphere and XML Scripting Languages: Java Script, UNIX Scripting, shell Scripting, SQL and PLSQL Oracle Tools: ANSI SQL, Oracle PL/SQL, SQL*Plus, TOAD, SQL*Plus, SQL*Loaderĭevelopment Tools: Aginity, SQL Developer, PLSQL Developer and TOAD Operating Systems: Windows XP/7/8, UNIX, LINUXĭatabases: Oracle 12c/11g/10g, Netezza Twinfin/striper Creating profiles and attaching them wif users, performing.Creating roles and granting to users based on their group requirements.Creating different kinds of partitions on tables and indexes.Excellent technical and analytical skills wif clear understanding of OLTP and OLAP models.Strong Background in implementation of RDBMS and OOPS concepts.Extensive experience in utilizing Collections to boost performance in PL SQL block.Have extensive experience in Performance tuning by analyzing the execution plans of the query.Good understanding of the Oracle database, related utilities and tools.Proficient in data loading/extraction using SQL*Loader and Oracle utilities.

Strong in writing Stored Procedures and SQL queries.

Created materialized views like primary key, rowid, and sub query materialized views.

Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.

Experience in Performance Tuning & Optimization of SQL statements.

Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.

Experience in managing users and user groups in netezza.

Extensive experience in Netezza database design and workload management.

Specialized in writing NZSQL, NZLOAD and stored procedures.

Proficient noledge in HTML and JavaScript.

Worked wif query tools like Toad, SQL*Plus, SQL Developer.

Expertise in writing Packages, Stored Procedures, Functions, Views, Database Triggers using SQL and PL/SQL in Oracle.

Involved in all phases of the SDLC (Software Development Life Cycle) from Analysis, Design, Development, Testing, Implementation and Maintenance wif timely delivery.

Around 9 years of experience as OraclePL/SQL developer in Analysis, Design and Implementation of Oracle E - Business Suite Applications.