Post Job Free

Resume

Sign in

Database Developer

Location:
Ocoee, FL
Posted:
January 23, 2023

Contact this candidate

Resume:

Presentation

I have large experience in reputable multinational companies, working with database development projects for clients in Brazil and abroad. I have been acting as a technical leader on data teams, working in projects throughout the whole information lifecycle: from conceptual modeling and, database design to the construction of data pipelines, always focused on performance, consistency, and quality.

Key Skills

Postgraduate in Data Science and Big Data – PUC 2019;

English Proficiency - Common European Framework (CEFR) level is B2 (Vantage or upper intermediate);

Work effectively in teams using agile methodologies (Scrum / Kanban);

Outstanding problem-solving, critical thinking and analytical skills;

Expert in translating business requirements into data structures;

Experience in architecting and building data warehouses, data marts, data hubs and data lakes;

Specialist in defining and developing data transformation and integration solutions;

Experience in using SQL/NoSQL databases on-premises and in the cloud;

Expert in database performance tuning;

Knowledge of MDM and Data Governance;

Professional Experience

Senior Data Engineer at PEBMED – February/2021 (current)

Evolve the analytics solution so that it is scalable and used by business analysts and data scientists;

Maintain the structure and operation of the data pipeline, integrating several sources into Data Lake;

Build codes for enriching and processing data (deduplicating, adjusting missing values);

Ensure that all indicators in all reports are being obtained correctly from a single reliable data source;

Deal with big data volume from different sources and performing exploratory data analysis;

Monitor and optimize solution resources in the cloud.

Technologies: AWS Redshift, EMR, Airflow, Python, Snowplow, Spark, Kafka, Azure ADF, Analysis Services.

BI Specialist at Seguradora Líder-DPVAT – May/2018 to February/2021

Design, model, build and manage database architecture;

Design and build data pipeline to obtain, clean, transform and load data;

Implement routines to ensure the quality and consistency of data;

Build complex queries, reports and data visualization solutions;

Model, document and load database to support SAS Financial Crimes Monitor solution;

Migrate on-premises databases to cloud database services;

Migrate on-premises ETL solutions (SSIS) to the cloud (Azure Data Factory);

Define the best database solution for each project (SQL and/or NoSQL).

Technologies: Azure - MS SQL Server, IBM DB2 for LUW, Erwin, Git, MS Visual Studio.

Senior Information Architect at CDS – July/2017 to May/2018

Design data models, and database structures both for transactional and decision support environments;

Create data migration plan for converting legacy data structures to new solution schema;

Lead the data migration and BI teams;

Help the integration team define the data flow between the new solution and other legacy systems.

Technologies: Oracle, MySQL, BI tools from SAP, ERwin, PowerDesigner.

Information Management Technical Coordinator at BRQ IT Services – October/2002 to July/2017

Coordinate the database consultant team, planning schedules, prioritizing tasks and planning activities;

Support development of database projects which includes to build data model and dictionary, design and create database physical structure, design efficient ETL workflows and database programs and perform database performance tuning;

Train project development teams to use database resources;

Develop database maintenance processes for development and test environments;

Define and implement proof of concepts, training sessions, and presentations for customers.

Technologies: IBM DB2, Oracle, SQL Server, Informix, ERwin, SAP PowerDesigner, BI tools from IBM, Oracle, and Microsoft.

Database Modeler/Developer at ACTIO Interactive Solutions – July/2000 to October/2002

Create DW and OLAP solutions, multidimensional modeling, ETL processes, OLAP cubes as well as data visualization layer; Define standards, procedures and best practices; Perform database performance tuning; Define and implement proof of concepts, training sessions and presentations for customers;

Database Specialist - Development Support Center at IBM Brazil – September/1996 to July/2000

Support development of database (DB2 and Lotus Notes) projects: database modeling, performance tuning, problem identification and correction;

Define standards, procedures, and best practices.

System Analyst - Software Development Department at IBM Brazil – February/1990 to September/1996

Coordinate project development teams as the technical leader for IBM's internal areas: Human Resources and Finance.

Formal Education

Data Science and Big Data – Postgraduate at PUC (2018-2019)

Big Data and Data Science – Executive Training at FGV (2017-2018)

Bachelor of Science in Mathematics and Computer Science at UERJ (1987-1991)

Courses

Microsoft Official Courses: Azure AZ-900 AI-900 DP-900 DP-200 – Ka Solution

Cloud Computing & Serverless Bootcamp – Digital Innovation One Inc.

DataFlux Data Management Studio: Essentials – SAS

Agile Methodology (SCRUM, KANBAN) – Petrobras University

Design Thinking – Keyword

Database Development and Administration – DB2 UDB V7, V8 e V9.7 – IBM Brazil

Database Development and Administration – ORACLE 9i e 10g – Extend

Professional Certifications

AWS Certified Data Analytics – Specialty

Astronomer Certification for Apache Airflow Fundamentals

SAS – DataFlux Data Management Studio: Essentials

CertiProf Kanban Foundation (KIKF)

CertiProf Scrum Foundation Professional Certificate (SFPC)

ORACLE 12c Database Administrator Certified Professional (OCP)

IBM Certified Advanced Database Administrator DB2 9 for Linux UNIX and Windows



Contact this candidate