Results-driven SQL Developer Manager at Talisma Corporation Pvt. Ltd, skilled in database optimization and cross-team collaboration. Achieved significant performance improvements through advanced query tuning and process enhancements. Proven problem solver with a strong focus on delivering efficient solutions and maintaining high user satisfaction in technical support.
Overview
10
10
years of professional experience
Work History
SQL Developer Manager
Talisma Corporation Pvt. Ltd
Bengaluru
06.2020 - Current
SQL automation, DB maintenance, tuning, DR drill.
Refined SOPs, KB articles, workflows.
Developed and implemented strategic initiatives that streamlined processes, boosting overall productivity and team collaboration.
Developed stored procedures, functions and triggers to support application requirements.
Optimized existing queries for better performance using SQL query tuning techniques.
Resolved customer service requests related to database errors or performance issues quickly and efficiently.
Performed backup and recovery of databases on a regular basis.
Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
Developed ETL processes using SSIS packages for loading data from various sources into a data warehouse environment.
Created and maintained database objects including tables, views, indexes, and triggers to ensure data integrity and performance efficiency.
Developed complex SQL queries to retrieve and manipulate data for reports.
Collaborated with cross-functional teams to understand database requirements and specifications.
Optimized existing SQL code for improved performance and efficiency in data retrieval.
Optimized SQL queries and stored procedures, reducing execution time by significant percentages.
Troubleshot and resolved issues within SSIS packages to ensure smooth execution.
Created complex SSIS packages with multiple transformations such as derived columns, lookups, conditional splits, script tasks and execute SQL tasks.
Technical Support Analyst
Talisma Corporation Pvt. Ltd
Bengaluru
05.2016 - 01.2020
Diagnosed and resolved software issues while maintaining user satisfaction.
Provided remote support services for clients using virtual private networks or other remote access technologies.
Managed customer inquiries through phone, email, and chat channels.
Provided timely updates on progress towards resolution of customer issues via email or phone calls.
Collaborated with development teams to address recurring technical problems.
Coordinated with product and engineering teams to report software bugs and request new features based on customer feedback.