A new Job, ID: 214883 <http://www.ejobsville.com/display-job/214883> was added at eJobsVille.com - For the Best Tech Jobs in Town <http://www.ejobsville.com>
Title: Data warehouse DBA posted on 2014-07-29 14:52:36 Job Description:*Job Title:Data warehouse DBA* *Location:Boston,MA.* *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. *Click here to view full job description and apply <http://www.ejobsville.com/display-job/214883> (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_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.