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) - Adhering to SLAs - Mentoring / Training Team Members - Handling tickets / requests - Perform root cause analysis - Troubleshooting technical issues - Defining processes and ensuring that the processes are adhered to - Oversees and is responsible for successful completion of Installation, configuration and migration - Ensure maximum uptime according to the SLA - Understanding of Multi-geo support environment - Responsible for building / maintaining a test environment - Responsible for strategizing a backup plan and test plan for failure scenario - Improves and maintains customer and employee satisfaction - Suggests new technologies and design changes - Monitoring and maintaining SLA requirements by the team members - Planning Backup/Restoration Strategy for 24x7 operation support - Suggesting patches/upgrades to maintain security level - Testing / Auditing/processes as required from time to time - Identify Skill gaps and plan for training / knowledge updating •
Last updated on Oct 6, 2021