 Around 8 years of experience in Database Administration of Microsoft SQL Server OLTP & DWH databases across all editions of versions 2000/2005/2008/R2/2012/2014/2016.  Microsoft Certified Professional (MCP) in SQL Server 2008 and SQL Server 2012 and ITIL V3 foundation certified.  Production Support (24x7) experience in the areas of Database Management, Disaster Recovery Management, Design, Development, Maintenance and Migration of databases in Automotive, Health, Finance and Insurance environments.  Expert in SQL Database Disaster Recovery Techniques like Log-Shipping, Mirroring, Replication (Snapshot, Transactional and Merge) and DB Snapshots in Cluster and Non-Cluster environments.  Expert in SQL Database High Availability Techniques like Clustering and Always-ON High Availability (HADR).  Experienced in Microsoft Windows and SQL Azure (in IaaS/PaaS/SaaS Environments) and configured Geo-Replication.  Worked on AWS Cloud environment and managed security, Storage and performance.  Good experience in designing, creating, debugging and tuning of stored procedures, triggers and functions.  Possess good knowledge of algorithms and design patterns in T-SQL and Power-shell scripting.  Worked on Sybase ASE server and Replication server and Oracle databases.  Worked on cross platform database migrations from Sybase ASE Server to SQL server.  Experienced in Planning and implementing database upgrade, downgrade and migration across different Versions and editions of SQL server.  Experienced in Designing, Creating and modifying SSRS reports and SSIS/DTS/ETL packages with Microsoft Visual Studio.  Worked on SSAS cubes processing, security, maintenance and troubleshooting and resolving the issues occurred while processing cubes in the jobs.  Worked on PowerBI Reporting tools for automation and robust report generation.  Expert in implementation and supporting MSSQL replication (Snapshot, Transactional, Peer to Peer and Merge) between MSSQL and/or non-MSSQL Database systems.  Expert in Build and Deployment analysis on UAT and deploying it in Prod environments.  Expert in analysis and resolution of performance bottlenecks involving CPU, I/O and memory usage.  Expert with Performance Monitor, SQL profiler, activity monitor and query execution plans.  Experience with Create and Maintain enterprise databases, Integrity, Backup & Recovery, Security, Capacity planning, Performance monitoring and tuning and Data archiving and compression techniques.  Experienced in working with SSL Administration & security certificates and Active Directory and OS Tools.  Excellent communication and technical writing skills in developing and implementing SOPs for ensuring the security and integrity of the databases and maintained SLA/OLA with ITIL standards.
©