Database Tuner

TEKsystems•Lansing, MI

9d•$40 - $45•Remote

About The Position

Blend of performance DBA & application developer skillset - Experience in application development that helps with understanding how to tune application queries. - Experience in ORACLE 19c (such as Oracle optimizer, explain plans, SQL plans, hints, TKPROF, traces, structures). - Knowledge of Oracle Real Application Cluster (RAC) - Experience in SQL and optimizing queries - Experience in in developing PL/SQL and optimize PL/SQL code - Experience in optimizing database structures (indexes, Primary/Foreign keys, tables structures) - Some Java experience is preferred, but not required

Requirements

SQL
Oracle
PL/SQL
19c
RAC
Tuning
Real Application Cluster
Tune
Optimize
Query
Batch Jobs
OPtimization
Experience in application development that helps with understanding how to tune application queries
Experience in ORACLE 19c (such as Oracle optimizer, explain plans, SQL plans, hints, TKPROF, traces, structures)
Knowledge of Oracle Real Application Cluster (RAC)
Experience in SQL and optimizing queries
Experience in in developing PL/SQL and optimize PL/SQL code
Experience in optimizing database structures (indexes, Primary/Foreign keys, tables structures)
Knowledge of procedure/packages/triggers
Knowledge of SQL profiles and baselines
Using ASH and AWR reports (or even manually generating ASH and AWR reports)
Monitoring (or even monitoring with scripts)