A new Job, ID: 214738 was added at eJobsVille.com - For the Best Tech Jobs in Town
Title: Data warehouse DBA posted on 2014-07-29 12:24:45
Job Description: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:
· 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
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
Job Requirements: 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:
· 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
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
Click here to view full job description and apply (Registration not mandatory to apply for this job)
Best regards,
eJobsVille.com - For The Best Tech Jobs In Town
You received this message because you are subscribed to the Google Groups "IT JOBS in USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to it-jobs-in-usa+unsubscribe@googlegroups.com.
To post to this group, send email to it-jobs-in-usa@googlegroups.com.
Visit this group at http://groups.google.com/group/it-jobs-in-usa.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment