A new Job, ID: 215520 <http://www.ejobsville.com/display-job/215520> was added at eJobsVille.com - For the Best Tech Jobs in Town <http://www.ejobsville.com/>
Title: Data warehouse DBA posted on 2014-07-30 12:30:08 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: · 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 <http://www.ejobsville.com/display-job/215520> (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 "MCMS" group. To unsubscribe from this group and stop receiving emails from it, send an email to mcms+unsubscr...@googlegroups.com. To post to this group, send email to mcms@googlegroups.com. Visit this group at http://groups.google.com/group/mcms. For more options, visit https://groups.google.com/d/optout.
