Description
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.
- 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.
