Job Description (Posting). - Evaluate the Database Server Hardware. - Define/Recommend/Maintain Database Standards and Architecture. - Recommend Server H/W, SQL Server Editions for a new Build - Expert in Database Design. - Research and Recommend Patch management for database/instance and Impact Analysis. - Initiate need and Impact Analysis for Database Migration/Upgrade - Technical Consultation. - Vendor Support and Interaction - Advance Database Performance tuning (Perfmon, Profiler,Database Tuning WIzard etc.) - Recommend and Review Backup and Recovery Strategies. - Knowledge about new feature of MS SQL Server 2008 (Policy Based Management, Resource Governor, Etc.) - Having experience of DR Solution/Implementation/Execution through various synch methods. - Designing strategy towards Capacity Management for DB tracks. - Designing SQL Server Security (Server hardening,Auditing,SOX compliance) - High Availability Features (Failover Clustering, Database Mirroring, Log Shipping, Replication) - Administering SSRS, SSIS and SSAS (Functional knowledge will be an added advantage) (1.) Depending on the work environment, the subject matter expert may lead or be an active participant of a work-group with the need for specialized knowledge. (2.) Meet all agreed-upon turnaround times for deliverables, deliverable reviews, or deliverable sign-off (3.) Understands, articulates and implements best practices related to his area of expertise. (4.) Provides guidance on how his area of capability can resolve an organizational need and actively participates in all phases of the solution life cycle. Design Solutions and best practices to meet clients objective. (5.) Work with clients to identify business challenges and contribute to client deliverables by refining, analyzing, and structuring relevant data Qualification B-Tech Skill (Primary) Application Operations-Apps DBA-SQL
