Omkar Patil

• Installed, Configured and Maintained SQL Server 2019,2016,2014, 2012, and 2008 R2 in development, test, and production environment
• Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues
• Upgraded databases from SQL Server 2008 to 2012 to 2019 in testing and production environment
• Handling Disk space related to issues by shirking the files and other alternative methods
• Performing Database refreshes/Migrations and On-prem to AZURE migrations by using DMA tool
• Migrated databases from on-prem to Azure elastic pool
• Expert in Backup, Restore and Migration activity of the database.
• Create login, users and assign specific permissions to the database.
• Perform pre and post verification test on Database servers
• Installed and Configured SQL Server Reporting Services (SSRS)
• Performed point in time recovery
• Created jobs for database full backup, T-log backup, cleanup job.
• Knowledgeable in log shipping configuration.
• Knowledgeable in Database mirroring.
• Daily checking the assigned tickets and resolved the tickets depending on the priority level.
• Repetitive issue analysis and proposals for permanent resolutions.

ORACLE DBA ACTIVITY'S

• Created users and assigned permissions in Oracle databases.
• Handled backup and restore tasks using RMAN and expdp/impdp methods.
• Performed checks before and after patching to make sure everything worked properly.
• Carried out cleanup activities to improve performance and managed disk space issues, including raising requests for more space when needed.
• Monitored and managed tablespace to prevent storage problems.