Database Administrator
Current- Performed daily maintenance and operational support of 40+ SQL instances and several windows failover clusters - Regular Patching and upgrade of all SQL servers products including database Engine, SSIS, SSRS, SSAS and all dependent tools/drivers used in the environment like Oracle, DB2, Snowflake etc - Actively Participated like a primary DBA in different projects like data center migrations, SQL server environments migrations to VMWare clusters and physical clusters, cloud… Show more - Performed daily maintenance and operational support of 40+ SQL instances and several windows failover clusters - Regular Patching and upgrade of all SQL servers products including database Engine, SSIS, SSRS, SSAS and all dependent tools/drivers used in the environment like Oracle, DB2, Snowflake etc - Actively Participated like a primary DBA in different projects like data center migrations, SQL server environments migrations to VMWare clusters and physical clusters, cloud DR migrations, migration of SQL data warehouses to Snowflake, data managements - archiving and big tables maintenance and partitioning. - Extensive experience in providing High Availability solutions such us Windows Failover Cluster, SQL mirroring 2008/2012/2016 and Always On Availability groups setup in multisubnet environments for critical applications - Installations and Setup and configuring SSIS, Numerous migrations of SSIS system catalog to the latest versions with over 200 SSIS packages, troubleshooting different connections, security and performance issues - Installations. setup and configuring SSRS WEB portal , SSRS migrations to the newest versions, reports deploying and subscription managements. - Troubleshooting of different performance, connections, security issues working with business application groups and vendors- Code optimization and improving - regular code optimization and reviewing , tuning and improvement with applying different indexes strategies- Partitioning of big tables, setup numerous archiving processes- Always following best SQL server practices in security, configurations, performance etc - Snowflake administration and support on regular basis Show less
