Ivan is currently unavailable
Ivan Paz
Verified Expert in Engineering
Network Administrator and Database Developer
Florianópolis - State of Santa Catarina, Brazil
Toptal member since May 6, 2021
Bio
Ivan is a data architect whose expertise includes PostgreSQL, MySQL, Oracle, ElasticSearch, OpenSearch, EMR, Spark, software development in Java and Python, and cloud servers (Digital Ocean, Google Cloud, AWS). He has designed and administrated huge SQL databases that handles millions of requests daily, developed PL/pgSQL procedures for high-performance data manipulation, configured Elasticsearch/OpenSearch clusters for vast amounts of data, and built entire BigData environments for BI.
Portfolio
Blueface
PostgreSQL, Linux, Python
Suntech
Oracle, Oracle PL/SQL, Data Modeling
DBJus
PostgreSQL, Elasticsearch, Google Compute Engine (GCE), Linode...
Experience
- Linux - 13 years
- Java - 13 years
- PostgreSQL - 13 years
- Data Modeling - 10 years
- MySQL - 7 years
- Google Compute Engine (GCE) - 7 years
- DigitalOcean - 4 years
- Elasticsearch - 4 years
Preferred Environment
Linux, PostgreSQL, Amazon Web Services (AWS), Python, EMR, Elasticsearch, Amazon RDS, Spark, Amazon Redshift, Google Cloud Platform (GCP)
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
Experience
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.
Skills
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), Google Cloud Platform (GCP)
Frameworks
Spark
Other
Data Modeling, Windows Services, Networking, EMR, Amazon RDS, Amazon Redshift
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