Home   Register   Sign In
Company Info

EApps Tech LLC

NC, United States

Web Site:

Company Profile

Data warehouse DBA


Job ID:



San Diego, CA, United States 



Job Views:


Employment Type:

Contract - Corp-to-Corp, Contract - W2



Job Description:

  • 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.
The responsibilities of a Database Administrator include:
1. Physical database design
2. Database maintenance
3. Backup and recovery
4. Participation on the Decision support steering committee
5. Data Replication
6. Repository Management
7. Security administration
8. Database loading
9. Performance Monitoring and Summary table creation
10. Ad-hoc data manipulation
11. Periodic table reorganization
• Structure update with change control
Specific tasks include:
• 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