Experience

ReMedi Health Solutions

• United States
• Hospitals and Health Care
• 1 - 100 Employee

• SQL Database Administrator

  • Oct 2022 - Present

   Manage database security (create logins, users, encryption, and data masking)  Configured Always on Availability Group, Log Shipping and Replication  Upgraded Databases from 2016 to 2019  Monitored several Servers for failed jobs and multiple performance issues.  Performed daily Health Check-up of all Databases. Developed and Implemented Disaster Recovery (DR) Plan.  Tested and Implemented different Physical and Logical Backup and Recovery methods and Point- in Time, Recovery, And Set up maintenance jobs.  Deployed Database Security Policy and Installation, using Passwords, Privileges and User Profiles.  Documented processes for installations, clustering, availability group setup, and patching  Designed and implemented comprehensive Backup plan and disaster recovery strategies.  Used Activity Monitor and SQL Profiler/Extended event as troubleshooting tools and enhanced the performance of database servers.  Working with System Owners to periodically review RPO's and RTOs to determine suitability.  Identify and automate regular/daily processes, track new and reoccurring issues, and document changes defined by the organization's configuration management processes.  Worked escalated Helpdesk tickets related to the databases.  Troubleshoot Blockings and Deadlocking issues by making appropriate changes to transaction isolation level and the type of lock being held and avoid keeping transactions open for long durations after completion depending on app logic, breaking large transactions to smaller ones.  Tested, Implemented different Physical and Logical Backup and Recovery methods up to Point-in Time, Recovery.  Implemented maintenance jobs, Re-build and reorganize indexes based on fragmentation level.  Performed Database Migration from AWS environment to Azure Database in the cloud. Show less



ModajPro IT Solutions (MPIT)

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• SQL Database Administrator

  • Jun 2019 - Oct 2022

   Installed, Configured and Setup of MS SQL Server in both clustered and standalone environments using PowerShell following Microsoft best practices and company policies.  Upgraded and Migrated databases.  Tracked and resolved trouble ticket requests made by end users with error handling measures to alert support team of incidents.  Designed and implemented comprehensive Backup plan and disaster recovery strategies  Troubleshooting of SQL Server service outages as they occurred, including providing on call support during after-hours and weekends.  Monitored several servers for failed jobs and multiple performance issues.  SQL Server upgrade using both in place and side-by-side methods  Designed and implemented redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.  Experience with SQL versions from 2008 to 2019.  Developed, implemented, and maintained change control and testing processes for modifications to databases.  Conduct patches with clustering and standalone SQL instances.  Proactively monitored and responded to MS SQL instances.  Created & administered database objects, tables, views, indexes, procedures for implementing some application functionality at the database side for performance improvement.  Administered the MS SQL Server security by enforcing security policy, creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups  Supported SSIS deployment.  Rebuilt indexes at regular intervals per Microsoft recommendations for better performance. Show less