Rui Freitas

Faro

available

Last update: 20.04.2021

MSSQL DATABASE ADMINISTRATOR

Graduation: Bsc Electronics and Telecommunications

Hourly-/Daily rates: show

Languages: English (Full Professional) | Portuguese (Native or Bilingual)

Keywords

Databases MS SQL XML Azure Database MS SQL Server SSIS Microsoft SQL-Server SSRS SSRS Microsoft Sql-Server SSIS Database Development Datenbankadmin SQL Server Datenbankadmin SQL PowerBI power bi reporting & dashboards Reporting and Visualization

Skills

ORACL 11G Quering and monitoring for LOB aplication

Instalation and migration of MsSQL2000 to MsSQL 2016 Databases
SSIS
- Implemented a project to import data from raw text files to database tables in normalized format.
- Outputted files in XML format for invoice transfer to retail clients, in ftp subsystem.
- Transition from PS2 to Sepa XML file format for processing bank transfers for salary payment.
SSRS
- Handled all the requirements for day follow up campaigns of sales department, in reporting services AD-hoc Reporta and scheduled by e-mail.

-T-SQL Querys, Stored procedures, triggers.
- Database tunning
- Database Backup strategy and Restore scenarios.
- Always on implementations of Databases/Clustering.

- Created my personal web page in Azure (My free time) http://ruifreitas.azurewebsites.net/
(Free tier, takes time to boot:)

Project history

Contact
Bruno Vicente on TP-link. Worked with him and listed on my connections.
Also Francisco Henriques (PM @ SIGOS) was my project manager in deliveries using SSRS.