Berenice is currently unavailable
Berenice Harillo
Verified Expert in Engineering
SQL Developer
Rio Ceballos, Cordoba, Argentina
Toptal member since November 24, 2021
Bio
Berenice is a senior database engineer with solid experience working with relational and non-relational databases on-premises and in different clouds. She excels in managing massive data sets with various tools and dealing with performance issues. As a database expert, Berenice enjoys migrating it to the cloud and creating models and ETL in data warehousing.
Portfolio
QualiTest
Azure, PostgreSQL, Database Management, SQL Performance, Monitoring, Backups...
Softvision
PostgreSQL, Google Cloud Platform (GCP), Google Data Studio, Sequelize, GitLab...
Alpha Fintech
PostgreSQL, MongoDB, Azure, Sisense, ETL, Amazon Web Services (AWS)...
Experience
- Oracle - 13 years
- Unix - 10 years
- Database Replication - 8 years
- PostgreSQL - 3 years
- Azure SQL - 2 years
- MongoDB - 2 years
- Google Data Studio - 1 year
- Google Cloud Platform (GCP) - 1 year
Work Experience
Database Engineer
2023 - PRESENT
QualiTest
- Reviewed and maintained the current infrastructure for PostgreSQL databases running on Azure virtual machines.
- Analyzed several queries to tune them and get optimizations. I have improved execution times by about 90% for some main queries.
- Run performance tests to tune PostgreSQL parameters to improve database performance.
- Migrated and upgraded PostgreSQL databases from 9.6 to 14.8 on Azure Managed Instances.
- Configured database logs to get proper pgBadger reports and configured/improved Grafana dashboard reports for database monitoring.
- Reviewed, configured, and maintained database backups and PostgreSQL replication cluster.
- Supported and fixed database-related issues: connection issues, replication not working, temp problem space in a data warehouse, bloated tables and indexes, etc.
Technologies: Azure, PostgreSQL, Database Management, SQL Performance, Monitoring, Backups, Cloud, Data Migration, Upgrades, Database Replication, Database Clusters, Performance Testing, Agile Sprints
Database Engineer
2020 - 2023
Softvision
- Supported and maintained the cloud SQL databases in the Google Cloud Platform (GCP).
- Configured monitoring and alerts in GCP for all database environments.
- Participated in the application deployments and releases to apply and verify any database changes. Managed the database scripts in GitLab.
- Executed performance tuning using query insights and analyzing queries to maintain or improve the database performance.
- Created data sources through the Postgres connector or data extraction to Google Data Studio to generate dashboard reports for data analysis and business intelligence (BI).
Technologies: PostgreSQL, Google Cloud Platform (GCP), Google Data Studio, Sequelize, GitLab, Data Extraction
Database Engineer
2018 - 2020
Alpha Fintech
- Handled the database migrations to the cloud in AWS, Oracle Cloud, and Azure.
- Assisted developers in release deployments on all database-related tasks.
- Performed the databases queries and tuning in MongoDB and PostgreSQL.
- Implemented and designed the high availability strategies for relational and non-relational databases. Created the clusters configuring replica sets (master-slave) in MongoDB and Bi-directional replication clusters in PostgreSQL.
- Installed and designed an ETL model in Sisense from different sources according to the dashboard requirements.
- Administered and configured a database pool connection with PgBouncer.
- Maintained and tuned an enormous data warehouse in PostgreSQL used to generate reports from a UI.
Technologies: PostgreSQL, MongoDB, Azure, Sisense, ETL, Amazon Web Services (AWS), Oracle Cloud, Data Extraction
Database Administrator
2009 - 2018
IBM
- Planned, installed, configured, and maintained the high availability solutions such as Oracle Data Guards, Oracle Real Application Clusters (RAC), and Automatic Storage Management (ASM) environments.
- Planned and configured the backups and recovery strategies and disaster recovery exercises.
- Installed, configured, and administered a solution to manage the Oracle database from one console called Oracle Enterprise Manager Grid Control.
- Supported and managed as the main point of contact for the specific sites and daily support to customers like Novartis.
- Administered the Db2 LUW databases for IBM internal projects.
Technologies: Oracle, IBM Db2, Cluster, Oracle ASM, Oracle RMAN, Oracle RAC, Oracle Data Guard, Oracle Performance Tuning
Database Administrator
2007 - 2009
Motorola Solutions
- Participated in and managed several projects, including upgrades, patching, migrations, decommissioning, and Oracle agent installations.
- Planned and configured the backup strategies with RMAN and Oracle Statspack utility.
- Performed the maintenance of database tasks and participated in on-call rotation for support 24/7.
- Conducted the database monitoring and tunning for all database environments.
Technologies: Oracle, Database Administration (DBA), Unix, SQL
Data Analyst
2005 - 2007
Claro Argentina
- Created the reports from databases for financial purposes.
- Generated the tuning and statistics reports with Oracle Statspack utility to improve the database performance.
- Executed the SQL queries on the database to carry out specific requests.
Technologies: Oracle SQL Developer, Databases, Oracle Database Tuning
Project History
Exploring and Implementing Replication in MongoDB
I was the database administrator assigned to investigate the different deployment architectures to understand the replication concepts better and help define a high-availability solution for our MongoDB databases. Afterward, I implemented the suggested architecture and approved it.
Design and Implementation of a Data Warehouse
Together with the database engineer and data architect, I designed and modeled a data warehouse to extract data for analysis and business intelligence purposes. Since this project involved the ETL process in extracting the data from our main databases, I decided on the best method to automate the extraction.
Education
2000 - 2009
Engineer's Degree in System Engineering
Universidad Tecnológica Nacional - Córdoba, Argentina
2005 - 2007
Professional Degree in Database Administration
Fundación Proydesa - Córdoba, Argentina
Certifications
NOVEMBER 2023 - PRESENT
Google Cloud Certified Professional Data Engineer
JULY 2022 - PRESENT
Microsoft Certified: Azure Data Engineer Associate
Microsoft
DECEMBER 2017 - PRESENT
IT Specialist Profession
IBM
OCTOBER 2017 - PRESENT
Cloud Ready Program
IBM
DECEMBER 2010 - PRESENT
Oracle Certified Associate
Oracle
Skills
Tools
Sisense, PgBouncer, Cluster, Oracle RAC, Sequelize, GitLab, Chef
Platforms
Oracle, Unix, Google Cloud Platform (GCP), Azure, Amazon Web Services (AWS)
Storage
PostgreSQL, Databases, Database Administration (DBA), Oracle Database Tuning, Database Replication, Relational Databases, MongoDB, IBM Db2, Azure SQL, Oracle SQL Developer, Oracle Cloud, Database Management, SQL Performance
Languages
SQL
Paradigms
ETL
Other
Unix Shell Scripting, Engineering, Oracle ASM, Oracle RMAN, Oracle Data Guard, Oracle Performance Tuning, IT Projects, IT Administration, Development, Networking, Google Data Studio, Cloud, IBM Cloud, Google Cloud Functions, Analytical Dashboards, Data-driven Dashboards, Data Extraction, Data Migration, Monitoring, Backups, Upgrades, Database Clusters, Performance Testing, Agile Sprints, Data Engineering
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