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 "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at http://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment