• Standalone and Cluster SQL Server Installation and configuration. • Up-gradation and Patch management.Responsible for L3 and L4 Production issues. • Troubleshooting Production/UAT/DEV/TST SQL Server Issues (Job failure, , Login failure, Performance Issues, Blocking, Deadlock, Suspect database etc. • Supporting business user requests (Heath Check Reports, Performance Issue, Access/Permission, Job failures etc).Developed policy for database decommission, user decommission, SQL Server migration and escalation. • Performance and Tuning of SQL Server, Database and Queries. Capacity Planning (Backup Share, Disk, CPU and Memory).SQL Server Migration to the latest version • .Develop and configure the database maintenance script for all the production and UAT servers.Maintain the databases by creating the Backup Plan, Disaster Recovery Plan and Maintenance Plan. • Automated the Backup and Maintenance plan using third party tool. • Database and Application tuning, Performance monitoring and system tuning. • Troubleshooting and resolving SQL alerts and SQL errors arriving into the ticketing system/queue. • Implementation, Configuration and troubleshooting HA Services (Log Shipping, Database Mirroring, Replication and Cluster)Implementation, Monitoring and Troubleshooting database issues, jobs and database high-availability services. • Migration of SQL Server databases between production, development and staging servers OS and DB Alert setup on Production Server Daily Server health check Building DTS Packages, SSIS packages and managing them. • Designing database backup and maintenance plan. • Restoring the Databases using the Database Snapshots. Resolving the Disk Space Usage, Data file and T-Log files shrinking etc.Managing SQL Server security. • Knowledge on SCOM tool. Knowledge on Reporting services. • Team management & Coordination with the client. • Willingness to work on 24 x 7 (on call) & work during UK business hours. • Having knowledge on windows administration is an added advantage. Regards, Sharada Rawal -7411022014 /Ayesha Sultana- 7411022024 itjobs@pentagon-services.com Pentagon Consultancy Services
Education: Any Degree