Jimit_Pandya

DBA with skills in Oracle, SQL and PLSQL having 4+ years of experience.

Database: Oracle, PostgreSQL.
Versions: Oracle 10g, 11g, 12c, PostgreSQL 9.0
Tools: SQL*Plus, Oracle 12c SQL Developer, Toad developer & analysis, System ERP, SQL Server.
Development: Oracle Forms, Reports, Jasper Reports and etc.
Languages: SQL, Oracle SQL, Oracle PL/SQL, HTML.
Written SQL queries for DDL, DML, DCL operations.
Managing and Gathering Statics on Table, Schema and Database, System and Object Privileges Management.
Managing PL/SQL Blocks, Procedures, Functions, Packages, Debug PL/SQL Subprograms.
Use of Packages, Cursors, Dynamic SQL statement, Database Trigger.
External Table Creation.
Manage Merge, Multi-Table Insert, Exception Handling.
Perform Wrapper Utility, Predefined Packages, Mutating Objects.
Knowledge of Index by Table, Nested Table.
Knowledge of Gathering Data Dictionary information for Table, Schema and Database, System and Object Privileges Management.
Use of Dynamic Performance Views, Temporary Table.
Oracle Forms and Reports.

Oracle DBA