Sr Sql Server Sap Hana Dba
• Softnet Ventures is a Managed IT Services provider, and a Software design company, managing its client databases in Production SQL 2016-2019.• Responsible for day-to-day operations for Production, UAT, and Development environment.• Database Backup & Recovery Plans in On-Premise Data Center.• SQL Agent jobs, tunning Stored Procedures, Indexes, Code Reviewing, and Query Optimization.• ETL SSIS, SSAS, and TSQL developer, supporting the client Data Warehouse and Data Loads.• Applied STIG/Security based on STIG guidelines on the SQL Server.• Configure and maintain the SQL Transactional and Snapshot Replication.• Applying patches on the Servers.• Configured and managed SQL Server 2019 Always on 3 NODES Replicas.• Configure SQL 2016 Active/Passive in the VMWARE environment.• SQL Migration from on-Prem to Azure laas Infrastructure VM SQL 2012 to SQL 2016.• Manage the Azure SQL Database Performance by increasing the DTUs for Premium SKU for Premium Storage.• Support AZURE SQL DBA administration task.• Tune database instances and applications and recommend changes to improve database performance.• Configure SAP HANA High Availability, Multitenant Database, and Fault Tolerance.• Configure SAP HANA Cockpit and HANA Studio.• Support SAP HANA System Administration using SAP HANA Cockpit and HANA Studio.• Implement SAP HANA Table Management and techniques in data compression, table partitioning, loading and unloading tables into the memory.• Implement SAP HANA Security strategies for the admin and users.• Support the SAP HANA Applications and SAP HANA System Monitoring.• Implement SAP HANA Database and Disaster Tolerance• Troubleshoot SAP HANA System and Performance Tuning.• Implement SAP HANA Backup and Recovery strategies.