Microsoft Solutions Consultant
CurrentImporting and exporting databases for the purpose of upgrading and creation of development environment.Scheduling SQL server database backups daily, incremental, alternatively, weekly, monthly and quarterly basis.Creating MS SQL jobs, alerts and maintenance plans. Manage and monitor database users’ accounts to the database as per industry standards to provide a secure environment.Refine and automate regular processes, track issues, and document changes.Recommend, implement, and maintain best practices and corporate standards.Configure and maintain database servers and processes.Responsible for installation, upgradation, configuration of MS SQL Server standalone, always on failover cluster instance and always on availability group.Responsible for improvement and maintenance of the MS SQL databases to include upgrades and patching and able to troubleshoot if any patch failures.Responsible for MS-SQL Database design, development, and Administration of MS SQL Server in production and sandbox (non-production) environments.Responsible for the performance, integrity and security of a database.Experience in MS T-SQL i.e. writing stored procedure, scripts, views, function & triggers.Wrote PowerShell scripts for doing database switchover, database switchback, database failover, database failback, quorum checking and checking of application services.Manage and monitor MS SQL database backup and recovery processes to ensure recovery in case of a disaster.Experience in managing MS SQL Server High Availability (HA) and Disaster Recovery (DR) options for SQL Server.Monitor system's health and fine-tune the performance of all enterprise databases in all environments as appropriate.Communicating regularly with technical, applications and operational staff to ensure database integrity and security.Provide support for other teams as appropriate during upgrades and installations.Flexible to work outside of business hours and be on call duties if required.