Pedro Correia - SQL Server Database Engineer

👤 Profile

SQL Server expert and trainer with over 22 years of experience. Founder and trainer at JUST LEARN IT, providing SQL Server training and consulting services across various industries. Strong background in security and performance tuning, with extensive experience in data information systems development and maintenance. Microsoft Certified Master - SQL Server 2008 holder and passionate about teaching and sharing knowledge.

💼 Work Experience

Database Senior Engineer

🏢 Nimber • July 2024 - Present

Working at Prophix as a Database Senior Engineer, focusing on database development, testing, and performance optimization.

Developing comprehensive Unit Tests framework for SQL Server database
Performance tuning of SQL Server instances in both on-premise and AWS cloud environments
Implementing database optimization strategies and best practices
Managing and maintaining database infrastructure across multiple environments

SQL Server AWS Unit Testing Performance Tuning Database Optimization

Founder & Trainer

🏢 Just Learn IT • Feb 2018 - Present

Founded and runs SQL Server training and consulting services company, delivering expert knowledge and solutions to clients across various sectors.

Delivers comprehensive SQL Server training programs and consulting services
Specializes in performance tuning, security auditing, and database architecture
Presented numerous talks about SQL Server at technical conferences and events
Develops and maintains custom training materials and documentation

SQL Server 2016-2019 Performance Tuning Security Auditing Database Architecture

Chief Information Officer

🏢 Appointmaster PT • Nov 2017 - Jan 2022

Led the development and maintenance of a comprehensive veterinary online services solution that revolutionized clinic communications and booking management.

Developed and maintained ASP.NET web applications with SQL Server VLDB backend, serving over 100 million clients and 200 million pets
Implemented high-performance system processing 1 million daily communications (SMS/email/phone)
Designed and implemented Disaster Recovery Plan (DRP) for database servers
Created C# services for message exchange using SQL Server features including service broker, XML, and partitions

ASP.NET SQL Server 2019 AWS C# Service Broker

Chief Information Officer

🏢 Foundation for Mobile Communications • Mar 2009 - 2016

Led the development and implementation of the e.escola program, a nationwide initiative by the Portuguese government to provide laptops to students and teachers.

Developed and maintained solution handling over 1.5 million applications
Created custom applications for application tracking and supplier interaction
Managed IT process improvement following Deloitte audit, aligning with COBIT framework
Developed web services for integration with telecommunication companies

SQL Server 2008 ASP.NET Web Services COBIT

🎯 Skills & Technologies

Database Technologies

SQL Server 2000-2019 T-SQL Azure SQL Performance Tuning Database Administration SSIS SSAS Database Architecture

🏆 Certifications

Microsoft® Certified Solutions Expert: Data Management and Analytics
Microsoft® Certified Solutions Associate: SQL 2016 Database Development
Microsoft Certified Master - SQL Server® 2008
Microsoft Certified: Azure AI Engineer Associate
Microsoft Certified: Azure AI Fundamentals
Microsoft Certified: Azure Data Fundamentals

📚 Education

Postgraduate, Computer and Information Systems Security/Information Assurance

Royal Holloway, University of London

Psychology (3rd Year)

Faculdade de Psicologia e Ciências de Educação da Universidade de Lisboa

Computer Engineering (1st Year)

Instituto Superior Técnico