Pedro Correia
Verified Expert in Engineering
SQL Database Developer
Oeiras, Portugal
Toptal member since January 25, 2021
Pedro has been working with Microsoft technologies since the early days of MS-DOS and GW-BASIC when he became fascinated with DBMS and used SQL Server 6.5 for the first time. During the last 20 years, he's implemented numerous web and Windows solutions in .NET, using SQL Server on the back end. Also, he taught several official Microsoft courses where he shared his expertise in the field. In one sentence, Pedro is eager to learn, inspired by challenges, and motivated to share.
Portfolio
Experience
- T-SQL (Transact-SQL) - 20 years
- Database Performance - 20 years
- Database Development - 20 years
- Database Administration (DBA) - 20 years
- Database Design - 20 years
- SQL - 20 years
- Performance Tuning - 20 years
- Microsoft SQL Server - 20 years
Availability
Preferred Environment
Visual Studio, SQL Server Management Studio (SSMS)
The most amazing...
...tasks I've worked on are the ones that seemed impossible at a first, second, and third glance, such as developing a solution to handle 1.5 million applications.
Work Experience
Chief Information Officer
Appointmaster Portugal
- Developed and maintained several private and public ASP.NET web applications supported by web services back end on top of SQL Server VLDB.
- Administrated and worked on performance tuning of SQL Server databases with different query access patterns and constraints. Designed and implemented a DRP for the database servers ecosystem to ensure the SLAs were established.
- Developed a set of C# services to exchange millions of messages daily. The solution's performance was our top priority, so its implementation recurred to several SQL Server features, such as the service broker, XML, stored procedures, and partitions.
- Coordinated the development team responsible for the maintenance and development of web front ends, mobile apps, back-end APIs, and server administration and maintenance.
Chief Information Officer
Foundation for Mobile Communications
- Developed a solution for registering and monitoring applications to the e.escola program, created by the Portuguese government. The program aimed to deliver laptops to all students and teachers, handling more than 1,500,000 candidates' applications.
- Coordinated the team responsible for the maintenance of the set of apps created to manage the e.escola program.
- Managed the team that worked on improving the company's IT processes and systems, following an audit by Deloitte that aimed to align the entire IT ecosystem with the COBIT framework.
Web Developer
FDTI
- Served as a web developer in the team, developing a set of web apps that manage the different training areas, such as student and class registration, trainer revenue, and room allocation.
- Developed a time card app that uses fingerprint and voice recognition to quickly register entrances and exits, absences, and delays and create detailed reports.
- Created a support ticket app that uses a web front end for the clients, an icon tray app for the technicians, and dynamic content emails for technicians' notifications.
Experience
Solution for the e.escola Program
This solution managed the data of more than 1,500,000 candidates' applications in interaction with several government entities. It included several applications that aimed to track each application, interact with the suppliers, and provide a set of decision support tools.
Education
Postgraduate Degree in Computer and Information Systems Security and Information Assurance
Royal Holloway, University of London - Egham, United Kingdom
Master's Degree in Psychology
Faculdade de Psicologia e Ciências de Educação da Universidade de Lisboa - Lisbon, Portugal
Engineer's Degree in Computer Science and Systems
Instituto Superior Técnico - Lisbon, Portugal
Certifications
Microsoft Certified: Azure AI Fundamentals
Microsoft
Microsoft Certified: Azure Data Fundamentals
Microsoft
Microsoft Certified Solutions Associate: SQL 2016 Database Development
Microsoft
Microsoft Certified Solutions Expert: Data Management and Analytics
Microsoft
Microsoft Certified Solutions Associate: BI Reporting
Microsoft
Microsoft Certified Solutions Associate: SQL Server 2008
Microsoft
Microsoft Specialist: Programming in C#
Microsoft
MCT Enrollment
Microsoft
Microsoft Certified Solutions Master: Charter - Data Platform
Microsoft
Microsoft Certified Solutions Associate: SQL Server 2012/2014
Microsoft
Microsoft Certified Master: SQL Server 2008
Microsoft
Microsoft Certified Solution Developer: Microsoft .NET
Microsoft
Skills
Libraries/APIs
Azure Cognitive Services, Azure Computer Vision API
Tools
Visual Studio, Azure Machine Learning, Git
Languages
T-SQL (Transact-SQL), Active Server Pages (ASP), SQL, SQL DML, Stored Procedure, C#, JavaScript, XML, HTML, CSS
Frameworks
ASP.NET Web Forms, ASP.NET, .NET, Windows PowerShell
Paradigms
Database Development, Database Design, COM+, ETL, ETL Implementation & Design
Storage
SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, SQL Server 2017, Database Performance, Database Administration (DBA), SQL Server Management Studio (SSMS), SQL Server DBA, SQL Stored Procedures, Microsoft SQL Server, Azure SQL, Azure Cosmos DB, Databases, DB, Database Architecture, SQL Server Integration Services (SSIS)
Industry Expertise
Teaching
Platforms
Azure, Amazon Web Services (AWS), WordPress
Other
Performance Tuning, Data Queries, Data Analysis, Database Optimization, Optimization, Reporting, BI Reporting, Computer Science, Psychology, IT Security, System Administration, ETL Development, ETL Testing, Cognitive Psychology, AnyDesk, GoDaddy
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring