Profileimage by JosNorberto Junior Database Engineer and Analyst from Cruzeiro

José Norberto Junior

partly available

Last update: 07.11.2023

Database Engineer and Analyst

Graduation: Web Designer and Programming Languages
Hourly-/Daily rates: show
Languages: English (Full Professional) | Portuguese (Native or Bilingual)

Attachments

Jose-Norberto-Bandeira-Junior_071123.pdf

Skills

Database Engineer and Analyst with more than 30 years of experience in SGBD and software development. Skilled in major programming languages (C/C++, Java, Python, PHP, Javascript), SQL (MySQL, MSSQL, PostgreSQL, Oracle) and NoSQL (Hadoop, MongoDB, Redshift and Snowflake). Fluent english.

Project history

10/2022 - Present
Senior Database Engineer
InsightSoftware by EvolveSquads (Internet and Information Technology, 500-1000 employees)

sql, postgresql, oracle cloud
• Writing of advanced SQL, analyzing developer SQL and make recommendations for
performance tuning SQL, rewriting SQL, or adding indexes for efficiency and creating/updating
stored procedures.
• Creation of stored procedures, triggers, functions, packages, Logical and Physical database
design.
• Operated in an agile development team and participate in the design, development, testing,
and debugging of applications.
• Working with a technical lead and product manager to clearly define product requirements.
• Working with colleagues and engineering leadership to define technical solutions that meet
business requirements.
• Development of clean, elegant, and reusable code that is easy to maintain and extend.
• Ensuring that the architectural integrity of the source code is maintained and improved.
• Identifying improvements to reduce technical debt.
• Conducting efficient code reviews and enforce team coding standards.

09/2021 - 06/2022
Data Engineer
Pinterest by Bairesdev (Internet and Information Technology, 1000-5000 employees)

python, mysql, aws, spark, javascript
•Data Engineering and Full Stack development at Pinterest.
•Migrating spark notebook's logic to back-end applications using Python.
•Mantenancing of home-made data science tools front-end using Javascript.

04/2021 - 09/2021
Data Engineer
Craftable Software (Internet and Information Technology, 50-250 employees)

pentaho, amazon‐redshift, apache-airflow
• Constructed ETLs. updated and guided overall features of Pentaho software.
• Coached and helped colleagues with Pentaho and Redshift technologies, including performance tunning, data structure, and monitoring.
• Maintained, updated, and provided overall Pentaho’s feature guidance

04/2019 - 01/2021
BI Database Engineer
Mynd Property Management (Other, 50-250 employees)

As a data engineer at Mynd i installed ETL/ELT technologies (docker, airflow, dbt, python) to improve BI infrastructure.
• Database development to support the BI analytics database using Postgres PSQL 
• Datawarehouse modelling for Snowflake and postgresql databases.
• Migrated ELT postgresql based views and materialized views to dbt scripts running on docker instances.
• Deployed and orchestrated dbt processes with airflow dags.

10/2017 - 06/2019
PostgreSQL DBA and Pentaho Developer
Justice Data Solutions (Public service, 10-50 employees)

Consolidated dozens of MS-SQL database sources to an unified PostgreSQL central database
using Pentaho transformations.

09/2018 - 11/2018
Back Office Infrastructure Engineer
Red Cap Networks (Energy, water and environment, 50-250 employees)

node, c++, v8, heroku, postgresql, database‐design, oltp
Updated and deployed C++ water leak detection application on Heroku environment and integrated with node.js data interface.
• Updated and deployed C++ water leak detection application to Heroku environment.
• Created node.js server webservice interfaces to external ip devices read from C++ application using V8 api
• Load data results in postgresql database

06/2017 - 07/2018
Datawarehouse Architect/Developer
Mad Studios (Pharmaceuticals and medical technology, 50-250 employees)

i worked with Mad Studios development team as a Pentaho developer.

 

  • Development of custom dashboards with protovis and javascript for LifeImage
  • Development of ETL process for TheVenture City company

Certifications

Oracle Cloud Data Management 2023 Certified Foundations Associate
2023
Oracle Cloud Infrastructure 2023 Certified Foundations Associate
2023

Local Availability

Only available for remote work
Profileimage by JosNorberto Junior Database Engineer and Analyst from Cruzeiro Database Engineer and Analyst
Register