A new Job, ID: 223669 <http://www.ejobsville.com/display-job/223669> was added at eJobsVille.com - For the Best Tech Jobs in Town <http://www.ejobsville.com/>
Title: Data warehouse DBA posted on 2014-08-12 13:07:24 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 *Click here to view full job description and apply <http://www.ejobsville.com/display-job/223669> (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.
