Results-driven professional with 15 years of experience in database administration and development, specializing in SQL optimization and ETL solutions. Achievements include a 50% increase in query performance and a 70% reduction in ETL extraction times. Extensive expertise in managing SQL Server and Azure databases, enhancing system performance and data security. Committed to delivering high-quality technological solutions through astrong work ethic and adaptability.
Kone Elevators (MES), 10/01/23 - 03/31/25, Worked as T-SQL Developer and Core DB Extended events, which help to reduce 80% of finding the queries during slowness, increase the performance of the expensive queries by 60% by handling the table joins and indexes in place. Implemented replication to reduce the load of the production database by 50% for the report generation
F&G Annuities & Life, 06/01/22, 10/31/23, Application DBA – Deploying scripts, performance tuning,and restoring backups from Prod to lower environment.
Horizon Retail, 07/01/19, 09/30/21, Developer cum DBA to manage and delivery the solutions as Independent Managing On-prem SQL server with replication. Expertise in T-SQL writing stored procedures, triggers, and functions. Improved data processing efficiency by 20% using SSIS and BULK INSERT ETL operations.
GTN Forecasting - R2 | RM, 06/01/14, 05/31/19, Managed DB Developers team – 15. Business requirement discussion with clients. Improved data processing efficiency by 20% by designing the schema and tables for optimized data flow. Implementation of business logic in stored procedures and abstract functions for reusability. Monitoring the DB server and performing tuning based on expensive queries. Performed day-to-day DBA activities such as monitoring SQL Server health, job status, and addressing user requirements. Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression – CTE.
Increased query performance by 50% through SQL optimization., Reduced ETL data extraction times by 70% implementing new solution., Enhanced system performance by 15% through data cleansing efforts., Implemented security algorithm improving data confidentiality by 80%.