John Sotiropoulos Email & Phone Number

John Sotiropoulos is a Database Management and SQL Development Specialist at Intale. They is proficient in English.

• 

  Sql Developer

  Intale

  Mar 2022 - Present - Athens Metropolitan Area

  During my tenure at Intale S.A., I spearheaded various critical tasks encompassing database management, issue resolution, documentation, SQL development, and communication collaboration. Notable accomplishments include crafting efficient procedures for data transformation and export, meticulously analyzing the production database to uncover inconsistencies, and adeptly restoring deleted schemas. Additionally, I engineered Non-Clustered indexes, significantly enhancing table performance with… Show more During my tenure at Intale S.A., I spearheaded various critical tasks encompassing database management, issue resolution, documentation, SQL development, and communication collaboration. Notable accomplishments include crafting efficient procedures for data transformation and export, meticulously analyzing the production database to uncover inconsistencies, and adeptly restoring deleted schemas. Additionally, I engineered Non-Clustered indexes, significantly enhancing table performance with large datasets. On the issue resolution front, I effectively addressed daily data fix requests and resolved complex Purgatory and Sync Action issues, amassing expertise in tackling over 300 Atlassian Jira issues.Moreover, I contributed extensively to documentation and knowledge sharing initiatives, crafting comprehensive onboarding materials for the production database and daily tasks, along with creating Confluence pages detailing investigation procedures and data restoration protocols. My adeptness in SQL development is evident in creating code tailored for various purposes, such as supporting data analytics, executing bulk update checks, and facilitating schema comparison. I also excelled in re-creating, simplifying, and optimizing SQL code utilized in the back office, alongside proficiently handling table creation, triggers, and developing stored procedures for improved performance.Proficient in SQL, T-SQL, Oracle SQL and PL/SQL, MySQL, and SQL Server Profiler, I am also well-versed in Git, SSRS cube creation and query, PHP, Azure Portal, SSIS, JavaScript, C#, and .NET. Furthermore, my expertise extends to data analysis and reporting, including Power BI Sync Actions and Power BI Sync Purgatory. I thrive in collaborative environments, adeptly working with diverse team members—including Support, Account managers, Data analysts, and Developers—to effectively address issues and devise innovative solutions. Show less