Experienced Database Administrator with over 6 years’ experience managing Microsoft Sql Server databases on Prem and in the Cloud .
Adept Knowledge in the set up and troubleshoot AlwaysOn, Clustering, Database Mirroring, Log Shipping, including Replication models (Snapshot, Transactional/Merge) Familiar with Database Backup using third party tools like Rubric, Commvault and Restore/Recovery, Query Optimization, Security, SQL Server Installation, Configuration of Stand-alone and Clustered environments Have done Migration/Upgrade, applying service packs and routine DBA operations like database health check, index optimization, updating statistics, client/server connectivity and capacity planning.
• MS SQL Server design, Development and administration using SQL Server 2005 – 2014 database environments.
• Monitored SQL health checks and identifying issues and fixing them.
• Used SQL Indexes for improving query performance, lower storage and maintenance cost
• Used Optimization tools such as SQL Profiler, Dynamic Management Views (DMVs) and Windows Performance Monitor for monitoring and tuning SQL Server performance.
• Implemented Installation, Configuration and Upgrading of SQL Server.
• Maintained server security by assigning logins, server and database roles and server permissions.
• Implemented disaster prevention and recovery strategies and supported High Availability features like Clustering, Always On, Log Shipping, Database Mirroring and Replication.
• Maintained database response times in 24X7 production environment and proactively generated reports
• Planned and Implemented database backup/restore and disaster recovery
• Created and maintained SQL objects like Tables, Views, Stored Procedure, Constraints and User defined functions
• Set up basic SSIS for our ETL processes, granted permissions for users of SSRS
I read Information Technology articles, LinkedIn learning, Plural sights and Udemy. Love to swim with family during summer, travel to new places and experience life.