MSSQL DATABASE ADMINISTRATOR

MS SQL / ORACL 11G Quering and monitoring for LOB aplication

Instalation and migration of MsSQL2000 to MsSQL 2016 Databases

SSIS

- Implemented ETK projects

* to import data from raw text files to database tables in normalized format.

* To distill unstructured technical PDF into tables.

- 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 Report 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:)