Database Administrator

Rafael Bahia Leandro

Hamilton – Ontario – Canada

Email: **************@*****.*** LinkedIn: linkedin.com/in/rafael-bahia-leandro-98434818/

Profile

I am a focused and results-oriented IT professional with more than twelve years of experience. Within those years, I have helped companies in various industry sectors get the most of their database setups, ensuring performance, stability and high-availability by making use of both simple and complex solutions. My ever-expanding technical skill set include (non)relational Database Administration, Business Intelligence, Data Engineering and Programming. My soft skills entail easy adaptation to different scenarios, effective communication, humility and attention to details.

Check my Microsoft transcript at https://mcp.microsoft.com/Anonymous//Transcript/Validate. ID=982413, Access Code=alucard535

Experience

Database Administrator at Canpar Express

March 2018 – Present

Deploy, monitor and maintain a wide range of cloud and on-premise (un)structured data solutions

Design and implement database recovery, high availability and disaster recovery strategies to increase business up-time. Vast experience with data replication, mirroring, cluster, log shipping and Always-ON availability groups

Implement security and auditing measures for secure and traceable data access

Write custom database maintenance solutions to keep internal heuristic statistics up to date and index fragmentation in check with minimized impact on business operations

Migrate data between on-premise data repositories (i.e., SAP ASE to MSSQL, MSSQL to SAP ASE, IBM DB2 to SAP ASE, MSSQL to MongoDB, MSSQL to SOLR)

Upgrade data solutions to make sure the latest versions are being used and reduce the security risks while enabling the usage of new features

Implement and maintain DevOps, DatabaseOps, CI and CD solutions. Experience with TFS and RedGate SQL Compare

Disseminate best practices on SQL programming, ensuring fast performing queries

Perform code review activities to proactively detect code deficiencies before they go to production environments, while identifying and rewriting poor performing SQL code already in production

Write monitoring solutions at the database and OS levels using various scripting languages (i.e., Perl, VBscripting, Power Shell, Python) to ensure the systems’ health and to allow proactive initiatives

Improve relational database models — both conceptual, logical and physical — to avoid data duplication and redundancy, save space, address wrong indexing strategies and data types misuses; all that to increase data quality and performance

Provide ER diagrams to support developers and ease their development efforts

Design and maintain Data Warehouse, BI and data lake solutions using diverse data technologies and products (i.e., SAP IQ, SSAS)

Install, configure and monitor columnstore databases and other NoSql technologies (i.e., MongoDB and SAP IQ), making sure these data repositories are responsive and available

Design and maintain data integration solutions (ETL and ELT) between heterogeneous systems using products like SSIS, IBM DataStage, BCP, among others. Large experience with data engineering, data munging, data cleansing and data quality assurance

Put data life cycle management (DLCM) best practices into effect, reducing hardware resource utilization and increasing data reliability

Install, configure, troubleshoot and secure operating systems (Linux and Windows Server)

Document database architecture and data flows

Document and prepare data systems so that they are 100% SOX compliant

Manage database projects and supervise their implementation from beginning to end

Database Administrator at Via Varejo SA

November 2009 - February 2018

End-to-end implementation of data-driven solutions: analysis, architecture, deployment, security, auditing, backup/restore strategy, disaster recovery, high availability and day-by-day maintenance and monitoring

Provide support for Cloud deployments and migrations (IaaS, PaaS and SaaS). Experience with hybrid setups where one leg of the data solution is on-premise and the other is on the cloud (Azure)

Disseminate knowledge about the best practices of SQL programming, ensuring fast performing queries and reports

Perform code review activities to proactively detect code deficiencies before they go to production environments, while identifying and rewriting poor performing SQL code already in production

Maintain and improve (non)relational database models — both conceptual, logical and physical — and data dictionaries to avoid data duplication and redundancy, reduce space consumption, address issues like wrong indexing strategies and data types misuses, and provide developers a clear picture of tables’ relationships and structure

Design and maintain ETL/ELT packages to CRM databases and across other database platforms using SSIS and Python. Experience with data munging, data wrangling and data life cycle management

Integrate data across different data repositories (i.e., MSSQL to MongoDB, MSSQL to SOLR) using advanced/custom (a)synchronous solutions (MSSQL CDC, MSSQL change tracking, triggers and customized scripts)

Support management teams to set priorities and ensure timely delivery of projects using both Waterfall and Agile methodologies (Scrum, Kanban)

Automate database health checks and performance counters extraction using scripting languages such as PowerShell, VBS and shell scripts in order to anticipate problems and establish performance baselines

Configure TFS to provide database versioning in order to make tracking of object and data change possible, allowing developers to quickly rollback any undesirable changes and enabling faster and more secure deliveries

Develop database continuous integration and delivery to production (Database Ops)

Web Developer

January 2009 - December 2014

Develop and maintain a web site using Front/Back End technologies (PHP, HTML, CSS, JavaScript, Ajax)

Solve connectivity and performance issues at the database and web server layers (MySQL,Apache)

Database Administrator (Internship) at BRQ

October 2008 - October 2009

Maintained database models to ensure compatibility with Normal Forms (SQL Server, Oracle, DB2)

Automated basic administrative tasks via database jobs and shell scripts

Supported development teams with basic SQL coding

EDUCATION & TRAINING

Data Engineer diploma

Data Science Academy, Online Learning Platform 01/09/2019 to 15/03/2021

Year Awarded: 2021

Data Scientist diploma

Data Science Academy, Online Learning Platform 01/04/2016 to 30/10/2018

Year Awarded: 2018

Systems Analysis and Development Bachelor degree

Centro Universitário Carioca, Rio de Janeiro, Rio de Janeiro, Brazil 01/01/2007 to 06/06/2010

Year Awarded: 2014

PROFESSIONAL MEMBERSHIPS

MCP (Microsoft Certified Program). Membership awarded for the following certifications:

MCTS: SQL Server 2008, Implementation and Maintenance

MCITP: Database Administrator 2008

MCTS: SQL Server 2008, Database Development

MCITP: Database Developer 2008

MCSA: SQL Server 2012/2014

MCSA: SQL 2016 Business Intelligence Development

MCSE: Data Platform

MCSE: Data Management and Analytics

MCPS: Microsoft Certified Professional

I.T SKILLS & LANGUAGES

English – fluent speaker

Portuguese – native proficiency

Contact this candidate