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