Ivan is available for hire
Hire IvanIvan Paz
Verified Expert in Engineering
Network Administrator and Database Developer
Location
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
Blueface
PostgreSQL, Linux, Python
Suntech
Oracle, Oracle PL/SQL, Data Modeling
DBJus
PostgreSQL, Elasticsearch, Google Compute Engine (GCE), Linode...
Experience
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
Experience
DBJUS
http://www.dbjus.comA web crawler for the Brazilian government's legal documents. I was the database and network administrator of the project. I developed, optimized, and administrated the project's database and infrastructure for high-performance, high availability, and security. We captured and indexed millions of new documents every day stored in both PostgreSQL and Elasticsearch, having a total size of more than 150 million documents stored.
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.
Webtorneios
http://www.webtorneios.com.br/A mobile card game for the Brazilian market. The app features game currency where players can bet in matches or participate in tournaments. I designed, implemented, and managed the server's database from scratch, including full logs of all matches and solid control of currency transactions. I also deployed and configured all the system's infrastructure, including database, scalable game, login, and website servers and all security and performance configurations.
Skills
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)
Other
Data Modeling, Windows Services, Networking
Tools
Google Compute Engine (GCE), Apache Tomcat
Platforms
Linux, DigitalOcean, Linode, Debian Linux, Oracle, Ubuntu Linux, Amazon Web Services (AWS)
Libraries/APIs
jQuery, JasperReports
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