Oracle DBA

Chicago, IL - USA

Monthly Salary: Not Disclosed

Posted on: 9 days ago

Vacancies: 1 Vacancy

Job Summary

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

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