Description
Company is looking for a Oracle Development DBA for a 6 month contract assignment in the Tampa area.
Requirements:
- Experience in Data modelling, logical and physical database designs
- Experience in using SQL, PL/SQL stored procedures, indexes, materialized views, Shell Scripting, partitioned and non-portioned tables, packages and triggers for improved performance of the database.
- Experience in identifying and tuning poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE, OEM Grid Monitoring.
- Experience in database cloning to create Test and Development environments from Production.
- Experience in tuning for Oracle Day-to-day maintenance and management of the several different databases in development, test, regression and production environments.
Technical Skills - Databases:
- Oracle 10gRAC, 11gRAC, Postgres Operating Systems: Red Hat Linux, Client-UX, Sun Solaris and Windows.
- Languages: SQL, PL/SQL, C, Shell Scripting.
- Java Utilities: RMAN, Oracle 11g Grid Control, Data Guard, Performance Tuning, EXP, IMP, Datapump, SQL developer, Veritas NetBackup.
- Tools: TKPROF, TOAD, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH, AUTO Trace