·       Evaluation and enhancing the performance of a legacy solution, analyzing and optimizing code, queries, and database structures to improve overall system efficiency and responsiveness.

·       Preparing unit tests for existing stored procedures and functions, ensuring the accuracy and reliability of database logic and functionality

·       Refactoring the database, restructuring and optimizing database schema, tables, and relationships to improve data organization, performance, and maintainability.

·       Gathering information and requirements for a new functionality, collaborating with stakeholders to understand business needs and define functional requirements for the development process.

·       Designing and implementing a new architecture for an existing solution, reevaluating system design and components to address scalability, flexibility, and performance requirements.

·       Creating new database solutions for new clients based on their input files, including the creation of tables, indexes, primary and foreign keys, stored procedures, functions, and views.

·       Maintaining databases to ensure optimal functionality and reliability.

·       Development of self-generating T-SQL Stored Procedures, Functions and Scripts.

·       Cut the time it takes to complete existing stored procedures from 90 minutes to less than two minutes.

·       Prepared a custom view for the reporting system to display only necessary data while omitting sensitive information.

·       Resolved deadlock issues to maintain database integrity and performance.

·       Achieved over 90% code coverage by writing unit tests for the existing solution using the T-SQLT framework.