Home   Register   Sign In
 
Company Info

EApps Tech LLC

4208 Six Forks Road, Suite 1000
Raleigh, NC, United States

Phone: 919-645-5790
Web Site: www.eappstech.com

Company Profile


Data warehouse DBA


col-narrow-left   

Job ID:

2516

Location:

San Diego, CA, United States 

Category:

Warehouse

Salary:

$60.00 per hour
col-narrow-right   

Job Views:

172

Zip Code:

92093

Employment Type:

Contract - Corp-to-Corp, Contract - W2

Posted:

07.29.2014
col-wide   

Job Description:

Job Title:Data warehouse DBA
Location:San Diego, CA.
Duration:6 Months.
Start date:ASAP

Job Description:
 
  • Must have 10+ years of experience.
  • Experience in handling BI EDW databases.
  • Understanding of typical BI DW architecture, ad-hoc queries, de-normalized data schemas, indexing.
  • Experience on Dynamic Management Views - missing indexes, fragmentation due to large IO operations , IO with Avg Disk Reads/Sec and also in Perfmon, page life expectancy etc.
  • Partitioning techniques like SQL Server 2008/2012 partitioning wizard and sliding window techniques
  • Monitoring SSIS jobs, scheduling etc.
  • Physical database design, Database maintenance,Backup and recovery.
  • Participation on the Decision support steering committee.
  • Data Replication.
  • Repository Management,Security administration,Database loading.
  • Performance Monitoring and Summary table creation
  • Ad-hoc data manipulation.
  • Periodic table reorganization.
  • Structure update with change control.
  • Extensive testing of the backup and recovery processes.
  • Ability to recover databases within the service level agreement.
  • Ability to articulate any data loss encountered.
  • Ensure logging and recoverability of database updates since the last backup.
  • Take frequent backups – full and incremental as needed.
Frequent offsite storage of the latest full back up in the event of a natural disaster.


© 2017 Powered by Rootjobs     About Us   Sitemap   Terms and Conditions   Privacy Policy   Mobile Version     Twitter RSS LinkedIn Facebook