Automated the integration of large-scale data from various sources using Apache NIFI. Built a data warehouse from scratch including schema design, partitioning strategies, and data pipelines. Migrated large-scale datasets from AWS Athena into MYSQL. Delivered recommendations and tuning for SQL Server instances, improving slow queries, reducing index fragmentation and optimizing database storage.

Designed and implemented several Windows Server Failover Clusters with high availability solutions, configuring availability group listeners and quorum witnesses, and setting up multiple servers to maintain continuous availability of applications and services.

Installed SQL Server on 35 target servers, following the best practices and guidelines for the selected versions (SQL Server 2019, 2017 and 2016) and its latest updates.

Implemented High Availability features like Failover clustering and Availability Groups for target servers necessitating high availability solutions, while maintaining others on standalone servers as needed.

Retrieved data from multiple API sources and integrate it into Apache Solr indexes and SQL Server databases using SSIS and Apache NIFI.

Developed and maintained scripts, tools and workflows for automating data ingestion and migration tasks.

Performed data profiling, cleansing, and validation to ensure data quality and integrity.

Automate and optimize data import/export using SSIS or Talend packages for improved database server performance

Install and maintain databases, implementing SQL query optimization measures

Analyze execution plans and offer recommendations for query performance enhancements