• Managing MS SQL Server and MySQL Databases in a software development team for an airport project. • Performing daily checks to report the overall health status of the Databases. • Ensure that the Database backup routine is successful and react.• Monitor the overall performance of the databases and advise in tuning the performance of TSQL queries.• Perform basic windows administration tasks such as user, server resource management on the servers owned by the data warehouse team. • Deploy scripts during product releases and datafixes.• Manage Merge Replication for databases between business units.• Monitoring and managing high availability of databases using Windows Cluster.• Monitoring and managing data flow from MS SQL Server database to Oracle database using SSIS.

Managing MS SQL Server Databases in a Data warehouse environment for our client.Performing daily checks to report the overall health status of the Databases.Ensure that the Database backup routine is successful and react appropriately during failures.Monitoring performance of the Database and queries. Provide appropriate advice to tune the same.Plan for Disaster recovery strategy and ensure the DR environment is in sync with the production.Review the upgrade requirement for SQL Server and apply patches or service packs with minimal downtime.Maintain the availability of Clusters, Log shipped and Replicated databases.Responsible for the integrity of the Databases and have to secure them from access violation and hardware failures.Developed customized monitoring and alerting system for capacity issues and server and database availability issues using Powershell scripting.Perform basic windows administration tasks such as user, server resource management on the servers owned by the data warehouse team.Review the ETL process and recommend performance improvement to remove performance bottlenecks.

As a Technical Lead I have to manage and maintain SQL Server Databases for our clientand the local product development team.Led a team of 3 DBAs in performing database administration in a development project.Supervised the daily health checks of the databases and their environment.Optimized database systems for performance efficiency. Prepared design specifications and functional documentations for assigned database projects.Generated capacity planning report for all applications.Ensured the integrity of the databases.Created complex functions, scripts, stored procedures and triggers to support application development.Ensure data back-up and archival are performed on regular basis. Distribute service tickets among the DBAs and monitor till resolved.Reported to the clients, the current status of the service tickets.Troubleshoot escalated critical issues in a timely fashion and document the same.Develop security procedures to protect databases from unauthorized usage.

As a Technical services specialist I have to manage and maintain SQL server Databasesfor the IBM clients in the United Kingdom geo.Managed SQL Server Databases for the IBM clients.Demonstrated appropriate Incident, Change and Problem management.Pioneered in planning and performing Disaster Recovery exercise with reduced cost.Exceeded expectations of Project management team on Installation, Migration and Server Onboarding projects.Spearheaded Audit Compliance activities and represented the team for audits.Documented both technical and business solutions and processes for future reference.Guided a 12 member team whenever they needed SME assistance.Tutored team members by delivering Techtalk sessions and mentored team members to up-skill themselves.

Provided technical support for global Microsoft customers for SQL Server related issues from Setup till advanced topics such as Replication and Performance issues.Volunteered to file bugs to the product team and work on providing workarounds.Facilitated between Escalation Services, Clients and Product Team to resolve critical issues.Involved in providing Solution Objects(SO) and Publishing Blogs for unique issues identified and solved.