Ivan Paz, Developer in Florianópolis - State of Santa Catarina, Brazil
Ivan is available for hire
Hire Ivan

Ivan Paz

Verified Expert  in Engineering

Network Administrator and Database Developer

Florianópolis - State of Santa Catarina, Brazil

Toptal member since May 6, 2021

Expertise
Data ModelingPostgreSQLSQLLinuxJavaGoogle CloudMySQLDigitalOceanLinodeOracleWindows ServicesElasticsearchApache Tomcat
Bio

Ivan is a senior database and network administrator whose expertise includes software development, Elasticsearch, cloud servers (Digital Ocean, Google Cloud, AWS), and development in Java and Linux. He has designed and administrated a PostgreSQL database that handles millions of requests a day, developed PL/pgSQL procedures for high-performance data manipulation, and configured Elasticsearch clusters for vast amounts of data.

Portfolio

Blueface
PostgreSQL, Linux, Python
Suntech
Oracle, Oracle PL/SQL, Data Modeling
DBJus
PostgreSQL, Elasticsearch, Google Compute Engine (GCE), Linode...

Experience

Linux - 13 yearsJava - 13 yearsPostgreSQL - 13 yearsData Modeling - 10 yearsMySQL - 7 yearsGoogle Compute Engine (GCE) - 7 yearsDigitalOcean - 4 yearsElasticsearch - 4 years

Availability

Part-time

Preferred Environment

Linux, DBeaver, Google Cloud, DigitalOcean, PostgreSQL, Java 8, Amazon Web Services (AWS), SQL, Python, Google Compute Engine (GCE)

The most amazing...

...database I've designed and managed was a web crawler that downloads millions of documents on the internet daily.

Work Experience

Database Administrator

2020 - 2021
Blueface
  • Wrote high-performance queries and stored procedures.
  • Configured and optimized PostgreSQL DBMS parameters.
  • Reviewed and optimized database indexes in production environments.
  • Configured and managed hot back-ups of the database.
  • Performed database changes on hot servers during software releases.
  • Created and configured database and application testing environments.
  • Performed data recovery after failures under production environments.
Technologies: PostgreSQL, Linux, Python

Oracle PL/SQL Developer

2019 - 2020
Suntech
  • Developed high performance queries in a huge Oracle database.
  • Developed high performance PL?SQL procedures in a large Oracle database.
  • Developed high performance data manipulation routines for the company's system.
Technologies: Oracle, Oracle PL/SQL, Data Modeling

Senior Database and Network Administrator

2017 - 2018
DBJus
  • Designed and administrated a PostgreSQL database that handles millions of requests a day.
  • Developed many queries and PL/SQL procedures for high-performance data manipulation routines.
  • Created and managed virtualized infra in multiple cloud hosts such as Google Compute Engine, AWS, Digital Ocean and Linode.
  • Created Bash scripts to automate servers administration routines.
  • Deployed, configured and managed Elasticsearch clusters.
  • Performed network troubleshooting with cloud server representatives on conference calls.
  • Configured recurrent back-ups and other security measures for multiple servers.
  • Configured networking and app installation for multiple Linux servers.
Technologies: PostgreSQL, Elasticsearch, Google Compute Engine (GCE), Linode, Amazon Web Services (AWS), SQL, Data Modeling, Linux, DigitalOcean, Amazon S3 (AWS S3), Bash Script, Networking

Database and Network Administrator

2014 - 2017
Fontec Tecnologia da Informação
  • Administrated multiple MySQL and PostgreSQL databases for different projects and products.
  • Performed database migrations from MySQL to PostgreSQL.
  • Developed PL/SQL procedures for high-performance data manipulation routines.
  • Designed and optimized schemas for the system's databases.
  • Wrote queries, updates, inserts and deletes for the system's databases.
  • Performed database changes on hot servers during software releases.
  • Created and configured database and application testing environments.
  • Created and managed virtual machines in multiple cloud hosts such as Google Cloud, AWS, DigitalOcean, and Linode.
  • Deployed, configured and managed Elasticsearch clusters.
  • Managed and configured Linux servers executing tasks such as networking configurations, SSL certificates installation, upgrades and other configurations.
Technologies: PostgreSQL, MySQL, Elasticsearch, Google Compute Engine (GCE), SQL, Amazon Web Services (AWS), Linux, Java, Apache Tomcat, DigitalOcean, Linode, Networking

Developer

2012 - 2014
Fontec Tecnologia da Informação
  • Developed Java server-side for a gaming platform website.
  • Developed JSP pages for the client-side of the gaming platform using HTML, CSS and JavaScript.
  • Deployed Apache Tomcat web apps in software releases.
  • Developed MySQL queries, updates, inserts and deletes for the gaming platform application.
  • Administrated minor tasks of the platform's MySQL database.
Technologies: Java, HTML, JavaScript, CSS, jQuery, Apache Tomcat, MySQL, Linux

Developer

2011 - 2012
Flexmobile Sistemas
  • Developed a software to generate Brazilian bank slips, communicate with bank API's and integrate payments from customers into the system ERP.
  • Developed a ERP in Delphi language specialized for transportation companies and product distributors.
  • Developed PostgreSQL queries, inserts, updates and deletes for the inner workings of the system.
Technologies: Delphi, PostgreSQL, Java

Oracle SQL Developer

2009 - 2011
Dataminer
  • Developed high performance queries for data extraction in a massive Oracle database.
  • Created and indexed schemas with huge data sets of the main database.
  • Developed high performance updates manipulation of vast data sets.
Technologies: Oracle, Oracle PL/SQL, SQL

Developer

2008 - 2009
Cellmidia
  • Developed windows services using Delphi service API.
  • Developed MySQL queries for email marketing campaings.
  • Troubleshot and developed the email marketing system in PHP.
Technologies: Delphi, Windows Services, MySQL, PHP

SQL Developer and Report Designer

2007 - 2008
Infoger Sistemas
  • Wrote PostgreSQL queries to obtain data for report generation.
  • Designed commercial reports using Jasper Reports API.
  • Programmed Java methods to add special features to reports.
Technologies: PostgreSQL, JasperReports, Java

Megajogos

https://www.megajogos.com.br/
A gaming platform with more than 30 board and card games, with a huge community, daily tournaments, and events. I started this project in 2012 as a Java web developer and two years later, moved to the infrastructure team, becoming the system's database administrator.

Libraries/APIs

jQuery, JasperReports

Tools

Google Compute Engine (GCE), Apache Tomcat

Languages

SQL, Java, Delphi, HTML, CSS, JavaScript, Python, PHP, Bash Script

Storage

PostgreSQL, Google Cloud, MySQL, Oracle PL/SQL, Elasticsearch, Redis, Amazon S3 (AWS S3)

Platforms

Linux, DigitalOcean, Linode, Debian Linux, Oracle, Ubuntu Linux, Amazon Web Services (AWS)

Other

Data Modeling, Windows Services, Networking

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring