Imran

SQL Database Engineer | Query Optimization | SSIS ETL | Power BI | Stored Procedures | Performance Tuning

i2c Inc • Tiempo completo

Jan 2021 - Present • 5 yrs 4 mos

Performance Optimization: Identified and resolved 50+ slow queries; improved execution time by 40-65% through indexing strategies, query refactoring, and execution plan analysis. Reduced database CPU usage by 35%, saving ₨500K+ annually in infrastructure costs ETL & Data Integration: Designed and deployed 12+ ETL pipelines processing 50GB+ daily data volumes using T-SQL and SSIS; achieved 99.95% uptime with automated error handling and recovery mechanisms Database Architecture: Architected and implemented 3 new databases supporting 150K+ monthly active users; implemented replication, backup strategies, and disaster recovery (HA/DR) protocols meeting RTO/RPO requirements Stored Procedures & Automation: Developed 40+ complex stored procedures, triggers, and functions reducing manual data processing time by 20 hours/week; automated routine maintenance tasks saving 15 hours/month Team Leadership: Mentored 5 junior database administrators; created 20+ technical documentation pieces; conducted weekly SQL optimization workshops improving team query-writing quality by 25% Data Migration: Led migration of 2 legacy systems to SQL Server 2019 with zero downtime; validated 500M+ records post-migration ensuring 100% data integrity Reporting & Analytics: Built 15+ SSRS reports and Power BI dashboards providing real-time insights to C-suite and operations teams; reduced manual reporting time from 20 hours to 2 hours/week Compliance & Documentation: Implemented database security policies (encryption, role-based access control); maintained detailed documentation of 200+ database objects; ensured 100% audit compliance