Berenice Harillo
Verified Expert in Engineering
SQL Developer
Rio Ceballos, Cordoba, Argentina
Toptal member since November 24, 2021
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
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
Availability
Preferred Environment
PostgreSQL, MongoDB, Oracle, Unix Shell Scripting, PgBouncer, Google Cloud Platform (GCP), Azure SQL, Database Replication, Data Migration, Google Data Studio
The most amazing...
...thing I've led and managed is the implementation of the HA solutions for all the environments in Mongo and PostgreSQL on-premises.
Work Experience
Database Engineer
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.
Database Engineer
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).
Database Engineer
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.
Database Administrator
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.
Database Administrator
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.
Data Analyst
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.
Experience
Exploring and Implementing Replication in MongoDB
Design and Implementation of a Data Warehouse
Education
Engineer's Degree in System Engineering
Universidad Tecnológica Nacional - Córdoba, Argentina
Professional Degree in Database Administration
Fundación Proydesa - Córdoba, Argentina
Certifications
Google Cloud Certified Professional Data Engineer
Microsoft Certified: Azure Data Engineer Associate
Microsoft
IT Specialist Profession
IBM
Cloud Ready Program
IBM
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
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