Pedro is available for hire

Pedro Oliveira

Verified Expert in Engineering

Software Developer

Location

Braga, Portugal

Toptal Member Since

June 18, 2020

Pedro is a motivated, organized, and goal-oriented self-starter with great aptitude for solving technical problems. He's also a leader and a planner as much as a developer, specialized in database design, software architecture, analysis and development, and project management.

Bootstrap UI Visual Basic 6 (VB6)T-SQL (Transact-SQL)Microsoft SQL Server Databases SQL Server 2005 ASP.NET SQL Performance Database Design OLAP MySQL JavaScript C#.NET 4 SQL Server 2008

Portfolio

Domínio Binário - Tecnologias De Informação, Lda

SQL Server 2016, SQL Server 2014

Domínio Binário - Tecnologias De Informação, Lda

SQL Server 2014, Bootstrap, ASP.NET MVC, WCF Web Services, .NET, C#

Multivector TI – Tecnologias de Informação, SA

SQL Sentry, SQL Server 2015

Experience

Microsoft SQL Server - 16 years Database Administration (DBA) - 10 years Database Design - 10 years C# - 10 years Database Performance - 9 years Web API - 6 years ASP.NET MVC 5 - 6 years

Availability

Part-time

Preferred Environment

Microsoft SQL Server

The most amazing...

...thing I've developed is a vertical database for a dynamic piece of CRM/ERP software.

Work Experience

DBA

2015 - PRESENT

Domínio Binário - Tecnologias De Informação, Lda

Ensured all database availability and performance for all applications.
Implemented monitoring processes to get health status.
Implemented maintenance tasks to ensure availability.
Implemented performance tuning.
Develop a web CRM for real estate (database design and database implementation and tuning).
Develop a web CRM for real estate (front end in C# MVC Razor and back end with WebAPI).

Technologies: SQL Server 2016, SQL Server 2014

Systems and Solutions Architect

2015 - 2016

Domínio Binário - Tecnologias De Informação, Lda

Implemented a CRM web application.
Designed, architected, and modeled the platform as its system architect.
Provided object-oriented analysis and design for the web application.
Developed websites and web services.
Designed and modeled the database as a database architect.
Maintained and monitored disaster recovery tasks and plans.
Implemented and tuned the database.

Technologies: SQL Server 2014, Bootstrap, ASP.NET MVC, WCF Web Services, .NET, C#

DBA

2015 - 2015

Multivector TI – Tecnologias de Informação, SA

Ensured that all databases were available and performant for all applications.
Implemented monitoring processes to get health status.
Implemented maintenance tasks to ensure availability.
Implemented performance tuning.

Technologies: SQL Sentry, SQL Server 2015

System Architect

2015 - 2015

Multivector TI – Tecnologias de Informação, SA

Analyzed the database design and performance.
Reviewed the database design and processes to improve performance.
Performed tuning operations.
Implemented health monitoring tools.
Added security and backups.

Technologies: Web API, MVC Razor, C#, Microsoft SQL Server

ERP Platform Team Architect

2010 - 2015

PRIMAVERA Software – Business Software Solutions, SA

Implemented new features on the ERP Platform.
Implemented cloud services base on Windows Azure Service Bus.
Implemented a new licensing method to avoid license hacking.
Implemented performance improvements on existing processes.

Technologies: Visual Basic, C#, Microsoft SQL Server, Azure

ERP DBA

2010 - 2015

PRIMAVERA Software – Business Software Solutions, SA

Analyzed the ERP database performance problems.
Designed and conducted procedures analysis on the database.
Implemented a tool for optimal server and database configuration by changing SQL Server parameters and index analysis.
Analyzed infrastructure and implementation design.
Improved performance of major clients' databases by analyzing the indexes (creation and dropping).
Improved performance by refactoring procedures and functions.
Implemented maintenance tasks.

Technologies: Microsoft SQL Server

Development Lead, Innovation in New Technologies Department

2010 - 2015

PRIMAVERA Software – Business Software Solutions, SA

Led a team of web developers and planned the roadmap for the company’s web application.
Improved the application with SEO features.
Improved the application's performance.
Implemented WebAPI services for the web application to interact with the ERP platform.

Technologies: MVC Razor, C#, Microsoft SQL Server, ASP.NET

System Architect

2000 - 2010

Multivector TI – Tecnologias de Informação, SA

Analyzed the performance problem the platform was having and wrote a tuning report and maintenance tasks.
Analyzed database design and implemented monitoring, maintenance, and disaster recovery tasks/plans.
Analyzed and documented the database structure, with performance recommendations and best practices to implement.
Analyzed and documented the migration process for the database between two data centers at different location to minimize database downtime.
Analyzed, architected, and configured a Blade Server and SAN storage for the new database server.
Made the transition from traditional WinForm application software to a SaaS model, building a fully customized ERP/CRM web application.
Designed, architected, and modeled the platform.
Handled the transition from the WinForm application to web application.
Drew existing and future vision enterprise architecture.
Designed, tuned, and modeled the database.
Maintained, monitored, and created disaster recovery tasks/plans.
Conducted object-oriented analysis and design for the web application.
Developed custom .NET assemblies (C#).
Developed websites and web services.
Analyzed, reviewed, and tested code.
Explored new technologies to enhance the application.
Created a data source repository for all lines of business and applications so the information used globally would be a standard not only for our company but for anyone who wants to use it.
Managed and coordinated a three-element development team. Provided expertise to the team responsible for acquiring and loading the data and mentored less experienced colleagues.

Technologies: SQL Server Reporting Services (SSRS), Data Warehouse Design, Data Warehousing, SQL Server Management Studio (SSMS), SQL Server 2008, WCF Web Services, Model View Controller (MVC), ASP.NET, C#

Senior Analyst/Developer

2000 - 2010

Multivector TI – Tecnologias de Informação, SA

Built real estate and vehicle management software in the form of two applications with property/vehicle stock management, client management and tasks, accounting information, sales processes, post-sale follow-up, and more, with the ability to send active business items to a website to publish and distribute to several content providers.
Designed, architected, and modeled the platform.
Designed the database to satisfy technical and business requirements (software and website), and developed, optimized, and maintained the database.
Explored new tools and technologies that could ease and enhance the application’s development.
Coordinated a three-person development team, gathered requirements from clients, and mediated between clients and developers.
Mentored junior colleagues and provided training and support to clients and their support teams.
Developed and maintained software and websites as well as developing the synchronization system between the software and websites (using DOM, XML).
Analyzed and developed data integration processes for bringing the customer’s existing data into our software from multiple data sources (Excel, dBase, text files, other database structures, etc.).
Analyzed and developed the synchronization system between the websites’ database and other content providers.
Documented the software and the application’s help menus.
Architected the website and database servers, configuring them on Windows 2000/2003 and maintaining and monitoring them using Terminal Services.

Technologies: Web Services, Microsoft SQL Server, ASP.NET, XML, Visual Basic

Analyst/Developer

1999 - 2000

PRIMAVERA Software

Developed new functionality and built a web interface for HR application software.
Built the company’s customer and technical support intranet.
Interacted with technical and commercial team members to gather and analyze the application requirements.
Designed a database solution to satisfy technical and business requirements.
Designed a web application according to the user’s ability.
Built an eCommerce application to interact with the main software.
Analyzed and chose the technology to use between the Win Form application and web application.
Interacted with the Win Form application’s team to learn the application’s structure and functionality.

Technologies: Microsoft SQL Server, JavaScript, CSS, HTML, Active Server Pages (ASP), Microsoft Access, Visual Basic

Analyst/Developer

1998 - 1999

CPCis

Outsourced a major financial institution’s Home Banking system.
Handled outsourcing for a major communications institution’s intranet and extranet.
Interacted with the communications institution’s technical and database team to determine the back office structure, functionality, and communication abilities.
Analyzed and developed the application’s requirements.
Handled outsourcing for a major financial institution’s communication with the Portuguese stock market (BVL).
Interacted with technical team members and business stakeholders to gather and analyze application requirements and communication structures.

Technologies: Java, CORBA, Jakarta Server Pages (JSP), JavaScript, CSS, HTML

Experience

Web CRM Software

CRM Software for real-estate companies to manage properties and clients. Also exports the properties' public information for the company's website and for major real-estate portals.

I architected the system, designed and implemented the database, and contributed to the development of the WebAPI implementation in C# and user interface using Bootstrap, React, ASP.NET MVC Razor, and Less.

DBA

Set up and configured SQL Server 2014 for high availability: database design and analysis, performance tuning, and health monitoring.

Vertical Database Design

Going from traditional windows form application’s software to a SaaS model and building a fully customized ERP/CRM web application required a new database approach from the traditional horizontal tables. We used a vertical database approach to enable users to create their fields on the fly and add them to forms and reports.

Consulting

As a DBA consultant, I had to analyze several systems in different environments (physical, virtualized, NAS, SAN, ...). The main goal was to analyze both the operating system and SQL settings in order to get the best performance possible. Implementing monitoring health tools and analyzing SQL Server data to improve query performance was also a goal.

Database Architecture

As a database architect, the main goal was to design tables and implement T-SQL procedures, functions, queries, etc., to make the database as fast as possible.

Skills

Languages

Active Server Pages (ASP), Visual Basic 6 (VB6), ASP.NET Razor, T-SQL (Transact-SQL), JavaScript, C#, CSS, PHP, HTML, Java, Visual Basic, XML

Frameworks

ASP.NET MVC 5, ASP.NET, .NET 4, Razor, Kendo UI, Jakarta Server Pages (JSP), MVC Razor, .NET, ASP.NET MVC, Bootstrap

Libraries/APIs

Web API, jQuery, React

Paradigms

Database Design, Cross-platform, OLAP, Concurrent Programming, Agile Software Development, Model View Controller (MVC)

Storage

Azure SQL Databases, Azure SQL, SQL Performance, SQL Server 2005, SQL Server 2012, Microsoft SQL Server, MySQL, Databases, Database Administration (DBA), SQL Server 2014, Database Performance, SQL Server 2008, SQL Server Integration Services (SSIS), SQL CLR, PostgreSQL, SQL Server 2016, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Sentry

Other

Ajax, Consulting, Bootstrap UI, Responsive Design, Certified Scrum Developer, CORBA, Web Services, WCF Web Services, SQL Server 2015, Data Warehouse Design, Data Warehousing, IIS 8

Platforms

Azure, Windows, Amazon Web Services (AWS)

Tools

Microsoft Access

Minho University - Braga

Collaboration That Works

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

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring