A new Job, ID: 217078 <http://www.ejobsville.com/display-job/217078> was added at eJobsVille.com - For the Best Tech Jobs in Town <http://www.ejobsville.com/>
Title: Sr. Data warehouse DBA at San Diego, CA. posted on 2014-08-01 16:56:51 Job Description:*Job Title: Sr. Data warehouse DBA* *Location: San Diego, CA.* *Duration: 6 month+* *Start Date:* *ASAP* *Job Description:* - 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 Title: Sr. Data warehouse DBA* *Location: San Diego, CA.* *Duration: 6 month+* *Start Date:* *ASAP* *Job Description:* - 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/217078> (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 "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-projects+unsubscr...@googlegroups.com. To post to this group, send email to oracle-projects@googlegroups.com. Visit this group at http://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.
