Hi,
I have job requirement with our direct client. Kindly share the profiles for the job description below.
Job Title: DataWarehouse DBA
Location: San Diego, CA.
Duration: 6 Months.
Start date : ASAP.
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
Thanks and Regards,
Arunkumar Raju
Direct: (248) 603 2629
arunkumar@technosoftcorp.com
www.technosoftcorp.com
Technosoft Corporation
28411 Northwestern Hwy