Summary

Expertise

Project Highlights

Education

Agency

PP

English:

Upper Intermediate

Paulo Henrique P.

vetted by Youteam

Vetted by YouTeam

Brazil

UTC -03:00

America/Sao_Paulo

English:

Upper Intermediate

Senior Oracle DBA working with Clusterware, RAC, 10g and 11g Databases on ASM and ACFS.

1) Published Performance tuning article for Oracle Database in SQL Magazine ed 95 - 2012 2) Instructor for Oracle 12c Administration Workshop in KA Solutions (40 hours workshop) 3) Planned and executed data center migrations (moved all servers to a different data center) 4) Planned and executed disaster recovery setup and DR tests (creation and test of DR plan) 5) Chosen to lead the team at an early stage, after 2,5 years working on my first-ever job role 6) Earned salary bonus on the current project at Oowlish due to performance and customer feedback

Want to hire this engineer?

Check if Paulo Henrique is available

Expertise

Years of commercial development experience

14 years of experience

Core technologies

Oracle database 10 years
PL/SQL 5 years
Scripting 5 years
SQL Server 2 years
PostgreSQL Administration 2 years
AWS 2 years

Other technologies

SAP
MS SQL Server

Project Highlights

icon
PostgreSQL DBA

Oowlish Technology

Feb `21 - Present

4 years

Support, manage, monitor and tune cloud PostgreSQL DB clusters

Responsibilities & achievements

- Research, develop and automate solutions or processes related to DB administration considering best practices available - Enabled AWS multi region redundancy as disaster recovery strategy

AWS
PostgreSQL
icon
Technical Consultant

Vector ITC Group

Aug `19 - Dec `19

4 months

Technical Consultant on project for implementing Transportation Manager (TMS) JDA software

Responsibilities & achievements

• Responsible for interactions between Technical Architect (from India) and Customer team • Understand project scope and coordinate integration between SAP, JDA TMS and Mulesoft softwares • Test Webservice calls using SOAPUI and customize XML formatting • Global project with team composed of employees from US, India, Chile, Spain and Brazil

SAP
XML
soapUI
icon
Oracle DBA

Amil Assistência Médica Internacional S/A

Oct `11 - Jun `18

7 years

Manage over 80 Oracle instances (production and non-production)

Responsibilities & achievements

• Perform refresh of QA and test databases (export/import, duplicate or backup/restore) • Apply database security patches (CPU, PSU) • Manage ACFS space and mount points on ASM and on OS • Update schema objects (e.g. triggers, procedures, packages) • Code in Shell script and PL/SQL for monitoring and backup purposes • Instance migration to new servers • Manage Service Requests at My Oracle Support/Metalink • Attend conference calls with team members from USA (UnitedHealth Group) • Create Disaster Recovery Sites and perform Disaster Recovery tests • Create and maintain Standby/Data Guard databases • Work with development team to solve issues and make improvements • Address security vulnerabilities found on Oracle Database servers Key achievements • Earned a permanent position after working as temporarily consultant for 8 months • Invited to join New Projects Team and deliver new database servers (both Oracle and MSSQL) • Invited to be part of Security Team in order to address any security vulnerabilities on Oracle Database servers • Created and managed proactive monitors using shell scripts/crontab, third party tools and Oracle Enterprise Manager • Upgraded databases from 10g to 11g, from 11g to 12c and from single to RAC • Migrated 20 production databases to a new Data Center using storage replication and Data Guard • Created a disaster recovery site for all production databases

PL/SQL
Oracle database
MS SQL Server
icon
Oracle DBA

IBM Brazil

Jul `08 - Oct `11

3 years

Worldwide support team

Responsibilities & achievements

• Resolve proactive and reactive issues according to SLA policies • Perform scheduled changes and maintenance tasks • Recover availability as soon as possible in case of downtime • Attend global conference calls with team members from USA, England, India and Australia • Health check the databases regarding availability and performance • Follow backup and recovery tasks up on RMAN and TSM Tivoli • Manage logical and physical free space • Apply EBS patches

Oracle database

Education

Higher education in Computer Science

Agency

Near-Shore staffing agency #2268

100-400

GMT-3

Fortaleza/Brazil

Core Expertise

AngularJS
AWS
Cloud Engineer
Django
GitHub
JavaScript
Node.js
Python
React.js
React Native
TypeScript
Angular 2x
Bitbucket
Next.js
Terraform

Industries

E-Commerce & Retail, Banking & Finance, SaaS

Want to hire this engineer?

Check if Paulo Henrique is available