Description
Implement and maintain database backup and recovery strategies to minimize data loss and downtime. Perform regular database maintenance tasks, such as index rebuilding, query optimization, and database tuning. Proactively identify and resolve database performance issues and bottlenecks.
Roles and Responsibilities
experienced in Installation, Configuration, Database Migrations and Upgrading of SQL Server from 2008 to SQL Server 2019 Experienced in Upgrading SQL Server Software to new versions with required Service Packs, Patches, and hot fixes. Handled all SQL administration related issues which includes, Installing, Configuring, and troubleshooting Always-On, Replication, Mirroring, Clustering and Log shipping issues. Analyze long running queries and tune to optimize application and system performance. Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities Extensive knowledge in database maintenance and SQL Server optimization using SQL tools such as SQL Profiler, Maintenance Plans Worked on controlling user privileges, monitoring the security and Audit issues. Also administering Security by setting up Groups, Logins for each Roles or Users at database level, server level and windows level Experienced in managing Alerts, Operators and Jobs using SQL Server Agent Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases. Proficiency in developing Maintenance plans, backup, recovery strategies Rebuild/Reorganize strategies Experience with moving physical data and log file from one drive to another drive. Expertise implementing high availability with Always on Availability Groups and failover clustering.
Technologies: MS SQL
Industry: Finance