Ivan Paz
Verified Expert in Engineering
Network Administrator and Database Developer
Florianópolis - State of Santa Catarina, Brazil
Toptal member since May 6, 2021
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
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
Availability
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
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.
Oracle PL/SQL Developer
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.
Senior Database and Network Administrator
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.
Database and Network Administrator
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.
Developer
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.
Developer
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.
Oracle SQL Developer
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.
Developer
Cellmidia
- Developed windows services using Delphi service API.
- Developed MySQL queries for email marketing campaings.
- Troubleshot and developed the email marketing system in PHP.
SQL Developer and Report Designer
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.
Experience
Megajogos
https://www.megajogos.com.br/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)
Other
Data Modeling, Windows Services, Networking
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring