Providing support for database-related issues including performance, security, locks, bugs, connectivity, and auditing.

Establishing user needs and monitoring user access and security.

Maximizing service availability and overseeing database security.

Monitoring performance and managing parameters to provide fast responses to front-end users.

Working on a real estate analytics solution, implementing a global database across multiple AWS regions, writing Python scripts, and performance tuning slow-running T-SQL queries.

Creating a cloud data lake strategy for migrating the existing setup to cloud for easier administration.

Implementing cross-region replication using DynamoDB Global Tables for real-time data synchronization across regions.

Moving structured and unstructured data from Aurora PostgreSQL to an S3-based data lake using AWS Glue and S3.

Designing Redshift cluster configurations tailored to the client’s workload.

Worked on a P&C insurance analytics solution, migrating it from on-prem to cloud and creating AWS Glue jobs to fetch data in snapshot and incremental manners to AWS S3-based data lake in CSV format.

Created PySpark jobs and scripts to do a POC of transformations and ran them on an AWS EMR cluster for demo purposes.

Created AWS Lambda functions and designed an AWS Redshift cluster for migrating on-prem data warehouse to cloud data warehouse for higher performance and cost-effectiveness.

Optimized table design by selecting appropriate distribution styles (KEY, EVEN, ALL) and sort keys to maximize query performance and minimize data skew.

Worked on a passenger information system, converting the existing Windows services to ETLs to get faster data synchronization up to 200%.

Optimized existing ETLs to eliminate processing delays and job failures to handle a 4x larger load of incoming data.

Altered the data warehouse and cube structure to accommodate new features and changes to the system and altered the data warehouse, cubes, MDX queries, and reports for SSRS report optimization.

Identified slow running queries and tuned the server configuration at hardware and SQL Server levels to tune up the overall database server performance.

Worked on a scrap recycling & consolidation solution, designing data warehouse for a reporting system.

Developed a production server monitoring tool to identify blocking queries, wait statistics, slow running queries, server resource contention, and usage patterns.

Rewrote existing stored procedures for faster execution and less resource consumption.

Redesigned the database architecture to split the OLTP and Reporting modules into separate database for scalability & historical data support.

Migrated over 100 SSRS reports running on OLTP to data warehouse, supported by high-performance T-SQL queries and strong data testing.

Laid out a modular architecture and implementation plan for a BI solution for a European brewing giant.

Designed a new enterprise data warehouse and data mart architecture, created a data collection engine, and cleaned up the existing ETLs in production to resolve processing lags and optimize data processing.

Redesigned reports with a functional and analytical perspective and changed certain data storage and database design techniques for faster and easier queries.

Created stored procedures and new SSRS reports for each department to report their business and department performances.