ROLE: ORCALE DBA

LOCATION: 100% REMOTE

DURATION: LONG TERM CONTRACT

RESPONSIBILITIES:

Orace Data Warehouse Experience

•       Star Schemas, large fact tables, partitioning

•       Heavy Parallel query (PQ) and ETL workfloads

End to end performance diagnostics

•       SQL Execution Plans

•       ASH /AWR interpretation

•       Wait Event Analysis (I/O vs. CPU v. PX wait)

•       Performance tuning (report and ETL)

Workload Characterization

•       Peak concurrency patterns

•       ETL vs. Reporting contention

Capacity Modeling

•       CPU Core equivalency from M8 to OCI

•       Memory Pressure vs. SGA/PGA Sizing

•       IOPS vs. Throughput constraints

SQL PL/SQL knowledge