Juliano P.
Database Administrator (Remote) at Opn- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Portuguese Native or bilingual proficiency
-
English Professional working proficiency
-
Italian Limited working proficiency
Topline Score
Bio
Credentials
-
Java Programming
LifeLong Learning CenterJan, 2020- Nov, 2024 -
Perl 5 Essential Training
Lynda.comJul, 2018- Nov, 2024 -
CompTIA Linux+ (Powered by LPI)
CompTIAJul, 2015- Nov, 2024 -
LPIC-1
Linux Professional InstituteJul, 2015- Nov, 2024 -
Novell Certified Linux Administrator - NCLA
NovellJul, 2015- Nov, 2024 -
English and Italian Fluency
DuolingoApr, 2015- Nov, 2024
Experience
-
Opn
-
Thailand
-
Financial Services
-
200 - 300 Employee
-
Database Administrator (Remote)
-
Aug 2020 - Present
Mastering database scale in this fully Amazon Cloud environment, AWS RDS and Aurora (Postgres, MySQL, DynamoDB), S3, CloudWatch. Daily tools: datadog, git, yaml, terraform, kubernetes, docker, helm, Jira, confluence, and a couple more Pokémon. A massive number of operations per second in a critical environment with top-level high availability. Unique experience along with awesome team members in a nice cosmopolitan company. Mastering database scale in this fully Amazon Cloud environment, AWS RDS and Aurora (Postgres, MySQL, DynamoDB), S3, CloudWatch. Daily tools: datadog, git, yaml, terraform, kubernetes, docker, helm, Jira, confluence, and a couple more Pokémon. A massive number of operations per second in a critical environment with top-level high availability. Unique experience along with awesome team members in a nice cosmopolitan company.
-
-
-
MiFinity
-
United Kingdom
-
Financial Services
-
1 - 100 Employee
-
DBA Postgres
-
Apr 2019 - Jul 2020
Administration of PostgreSQL HA Clusters and cascade streaming replication. Tuning Postgres and pgpool with heartbeat+watchdog and failover/failback (switchover/switchback) scenarios. Disaster recovery plans. Backups with pg_dump, pg_basebackup, PITR, scp, rsync. Linux updates and security paths. Daily use of technologies such as Confluence, Jira, and Kanban board. Creation and automation of monitoring tasks with alerts using bash and SQL scripts over Zabbix+Telegram. SQL performance improvements using explain, analyze, indexes, CTE, window functions, stored procedures, partitioning, autovacuum, reindex... Show less
-
-
-
University of Oxford
-
United Kingdom
-
Research Services
-
700 & Above Employee
-
Ingres and Perl trainee
-
Jul 2018 - Mar 2019
The daily basis was focused on maintaining huge Ingres databases and scripts Perl/bash. Monitor all systems, check errors on the logs, trace, and solve any eventually related issue. The daily basis was focused on maintaining huge Ingres databases and scripts Perl/bash. Monitor all systems, check errors on the logs, trace, and solve any eventually related issue.
-
-
-
Conduent
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
DBA PostgreSQL
-
Oct 2016 - Dec 2017
Database maintenance tasks on Linux Ubuntu servers, monitoring all systems, trace and fix bugs, security management, improvement of infrastructure, apply patches and updates, tuning, PSQL, maintain pg functions, jobs, foreign data wrapper, bash scripts, backup, restore, HA cluster, replication using repmgr, connection pool with PgBoucer, PITR using Barman, disaster recovery, pg_dump, pg_partman for partitioning and data encryption with pgcrypto. Database maintenance tasks on Linux Ubuntu servers, monitoring all systems, trace and fix bugs, security management, improvement of infrastructure, apply patches and updates, tuning, PSQL, maintain pg functions, jobs, foreign data wrapper, bash scripts, backup, restore, HA cluster, replication using repmgr, connection pool with PgBoucer, PITR using Barman, disaster recovery, pg_dump, pg_partman for partitioning and data encryption with pgcrypto.
-
-
-
WDS
-
United Kingdom
-
Telecommunications
-
300 - 400 Employee
-
Customer Advisor
-
Aug 2016 - Oct 2016
Google Play Store call center support in Portuguese language for Android devices in general. Focused on providing a first-class customer service experience and resolving any queries, complications or issues that may arise. An excellent communicator with a confident telephone manner and a natural affiliation to customer needs. An enthusiastic approach combined with genuine warmth and dedication to customer satisfaction. Google Play Store call center support in Portuguese language for Android devices in general. Focused on providing a first-class customer service experience and resolving any queries, complications or issues that may arise. An excellent communicator with a confident telephone manner and a natural affiliation to customer needs. An enthusiastic approach combined with genuine warmth and dedication to customer satisfaction.
-
-
-
Comunidade Canção Nova
-
Brazil
-
Religious Institutions
-
300 - 400 Employee
-
DBA Postgres and MySQL
-
Nov 2013 - Oct 2014
Maintenance and monitoring PostgreSQL and MySQL databases. Administration of Linux Debian servers, updates, security patches, account management, tuning, pg_dump, bash script. I also have been introduced to Oracle RAC and ODA. Maintenance and monitoring PostgreSQL and MySQL databases. Administration of Linux Debian servers, updates, security patches, account management, tuning, pg_dump, bash script. I also have been introduced to Oracle RAC and ODA.
-
-
-
Viação do Vale Transporte LTDA
-
Moreira César, São Paulo, Brazil
-
IT Coordinator
-
Aug 2010 - Jul 2013
Performing administration tasks on Windows Server 2003/2008, SQL Server 2003/2008, TMG firewall, Active Directory, LAN, WAN, VPN, DNS, Oracle database 10g, Oracle Linux 6, Globus/Prodata electronic bus ticket system with Mifare contactless smart card. Also, providing IT for the staff and external customer advisor. Performing administration tasks on Windows Server 2003/2008, SQL Server 2003/2008, TMG firewall, Active Directory, LAN, WAN, VPN, DNS, Oracle database 10g, Oracle Linux 6, Globus/Prodata electronic bus ticket system with Mifare contactless smart card. Also, providing IT for the staff and external customer advisor.
-
-
Education
-
Centro Universitário de Araraquara
Master of Business Administration - MBA, Data Modeling/Warehousing and Database Administration -
Funvic - Fundação Universitária Vida Cristã
Bachelor's degree, Information Technology