Summary: Senior MS SQL Developer with solid experience in database development, architecture, and performance optimization. Strong expertise in T-SQL, MS SQL Server, good skills in PostgreSQL, There is also experience in DWH, BigQuery development, proficiency in SSIS, SSAS, SSRS, PowerShell tools. Some experience with c#, Node.js, Delphi. Constant experience designing and optimizing large-scale, distributed database environments, working with databases containing a lot of records and high-volume ETL processes. Alse constant Skilled in troubleshooting complex technical and architectural issues, database redesign, and continuous performance improvement.

Last project: Global enterprise risk management and data analytics platform for a Big 4 client. The solution supports risk assessment and audit-related processes across multiple regions and countries. The ecosystem also includes a centralized Data Warehouse (DWH) and Data Mart used for reporting, analytics, data integration, and data exchange with external systems.

Responsibilities:

•Design and development of MS SQL databases for a large-scale enterprise platform operating across multiple regions and countries.

•Development and maintenance of T-SQL solutions, including stored procedures, functions, views, triggers, tables, indexes, and complex queries.

•Database architecture and design, including schema design, normalization, indexing, and continuous system optimization.

•Extensive SQL performance optimization, covering queries, stored procedures, database structures, and ETL processes. Analysis and resolution of architectural and technical issues, including debugging and optimization of existing database solutions.

•Development and optimization of ETL processes for a centralized Data Warehouse, processing up to hundreds of thousands of records per load.

•Development and support of a Data Mart for reporting and analytics, including data synchronization and integration with external systems.

Worked with distributed databases across multiple countries, with the largest tables containing millions of records.

•Continuous redesign and rearchitecture of the platform and Data Mart to support evolving business requirements and improve performance.

•Used Microsoft Copilot to support SQL development and code analysis, including work with large-scale procedures and database structures.