Home  Post Resume Quick IT Job Search  Advanced IT Job Search 
Skip Navigation LinksHome » Job Details
HEMS, Inc.
  Company Profile
HEMS, Inc. works exclusively with Information Technology professionals and IT companies in the New York and New Jersey area. We work with full time, temporary and temp-to-hire IT professionals. At HEMS, Inc., we work with your vision in mind. Whether you are looking for a short time stint or a long time career choice, we work to help you achieve your goals. With us, you can expect the platinum standard.
  Job Details 

Oracle Data Warehouse dba : Atlanta, GA

Posted On:  7/21/2021 3:08:18 AM

Oracle Data Warehouse dba

No. of vacancies:  3
Qualifications:  Bachelor degree
Essential Skills: 
Minimum Total Experience:  3
Job Tenure:  Contract - Corp-to-Corp
Salary Offered:  DOE
Job Location:  Atlanta GA United States

  Job Description
Database tuning skills. Use utilities ADDM, AWR, Statspack

Automated Workload Repository -The AWR is a critical component for data warehouse predictive tools such as the dbms_advisor package. AWR allows you to run time-series reports of SQL access paths and intelligently create the most efficient materialized views for your warehouse. The AWR provides a time-series component of warehouse tuning that is critical for the identification of materialized views and holistic warehouse tuning. The most important data warehouse tracking with AWR includes tracking large-table-full-table scans, hash joins (which might be replaced with STAR joins), and tracking RAM usage within the pga_aggregate_target region.
Multiple Blocksizes- All data warehouse indexes that are accessed via range scans and Oracle objects that must be accessed via full-table, or full-index, scans should be in a 32k blocksize.

STAR query optimization -The Oracle 10g STAR query features make it easy to make complex DSS queries run at super-fast speeds.
Multi-level partitioning of tables and indexes, Oracle now has multi-level intelligent partitioning methods that allow Oracle to store data in a precise scheme. By controlling where data is stored on disk, Oracle10g SQL can reduce the disk I/O required to service any query.

  Contact Information
Reference Name (If Any): 

Terms and Conditions | Privacy Policy | FAQ | Contact Us | Why?? | Link to us