I am Certified Database Administrator, Certified Database Developer, DB Architect, and an experienced Performance Tuning and troubleshooting expert. I have extensively worked on MySQL, MS SQL Server, Azure SQL DB, Azure Cosmos DB, AWS Aurora, AWS RDS, PostgreSQL, MariaDB, and Oracle.
With 15+ year experience as DB admin/ architect/ developer and performance tuning expert, I excel in DB design and audit for optimal performance, installation & configuration, upgrade, maintenance, and DB migration.
I can analyze slow queries and audit/ analyze database structure to find out root cause of performance issues. I can provide my recommendations and implement them to achieve optimal performance. I have completed many performance tuning jobs and achieved desired results. One of the performance optimization job involved tuning tables with more than 1.6 billion of records.
I can also configure appropriate monitors and alarms such as CPU usage, memory usage, session count monitors etc. for better monitoring and proactively controlling any performance hiccup.
I possess exceptional skills in SQL, ETL, indexing, partitioning, writing complex queries/ Stored Procedures, rewriting queries which are creating deadlocks/ bottlenecks to ensure optimal performance.
I have designed and developed many complex ERPs and CRMs both on distributed and centralized architecture throughout my professional career for large public and private sectors.
I am expert in database migration and one of my favorite area to work on. I have done many DB migrations throughout my career between homogeneous sources and heterogeneous sources. I know all pitfalls and challenges of migration, ETL and lightening quick in their resolution. I have great expertise and worked with Microsoft Data Migration Assistant, Microsoft SSIS package and Oracle Data Migration utility.