83 Installation and Upgrades
1. Performing server installation and configurations for SQL Server 2019/2017/2016/2014/2012/ 2008/2005 & 2000.
2. High Availability group configuration.
3. MSI / MSP fix
4. Issue resolution during upgrade.

83 Manage accounts and roles on the databases per documented processes.
83 Implement backup and recovery processes, provide system and SQL performance tuning and assist application teams during integrations.
83 Develops a methodology for the ongoing assessment of database performance and the identification of problem areas.
83 Research available technology solutions. Evaluates and recommends options to improve database server environment.
83 Implementing DR solution, Database clustering, Always on High availability, mirroring, replication, Log Shipping, and cross domain log shipping
83 Scheduling Full, Differential and Transactional log backups for databases by using the Database Maintenance Plan Wizard.
83 Experience with performance monitoring and troubleshooting SQL database instances.
83 Developing and Maintaining Database Backup and Recovery Plans
83 Health check and monitoring in DB instance and OS metrics.
83 Experience in Query tuning and preventative maintenance.
83 Guiding app teams on proper indexing and query tuning.
83 Perform Capacity planning.
83 Troubleshooting Log shipping, Mirroring and Always-on high availability.
83 Involved in capacity planning, sizing and database growth projections.
83 Managing Systems and database security as well as access control to sensitive business data.
83 Managing the establishment and maintenance of procedures to monitor, tune and control the databases to maximize performance and ensure data security, integrity and consistency.
83 Automating database Restoration process. And Automating disk space reclamation process & database login access
83 Performance Tuning on T-SQL queries and stored procedures.
83 SSRS and SSIS projects handling.
83 Strong problem solving and communication skills.
83 Troubleshooting of issues in Azure Portal ( Subscriptions/ Creating Resource groups etc.)
Good to have Skills:
83 Scripting knowledge for automation.
83 Analyzing Stored procedure
83 Exposure to automation tools