Manage data extraction, transformation, and loading from heterogeneous source systems using SSIS. Conduct regular backups and perform disaster recovery testing. Ensure user access and permissions compliance. Create and maintain documentation for database architecture and procedures. Lead a team of engineers, providing technical guidance and support.

Optimized existing jobs, stored procedures, and views for improved performance and readability. Created and managed clustered and non-clustered indexes. Utilized Execution Plan, SQL Profiler, and tuning advisor for query optimization. Coordinated with project management to meet database development timelines. Maintained technical and functional specifications.

Engaged in full life cycle development, collaborating with SQL/T-SQL, Java, and .NET developers. Developed stored procedures and user-defined scalar functions (UDFs) for SSIS packages and SQL scripts. Optimized complex queries using joins and sub-queries. Designed workflow and dataflow for SSIS ETL processes supporting various file structures and business processes. Analyzed and enhanced existing SQL queries.

Led a team of 10 DB developers in designing databases, writing/modifying stored procedures, and T-SQL queries for performance optimization. Successfully completed over 30 DB projects, meeting client specifications. Applied effective time management techniques to consistently meet tight deadlines.