Berenice Harillo
Verified Expert in Engineering
SQL Developer
Berenice是一名高级数据库工程师,在本地和不同云中使用关系和非关系数据库方面有着丰富的经验. 她擅长使用各种工具管理大量数据集和处理性能问题. As a database expert, Berenice喜欢将它迁移到云端,并在数据仓库中创建模型和ETL.
Portfolio
Experience
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...
...我领导和管理的事情是在Mongo和PostgreSQL内部部署的所有环境中实现HA解决方案.
Work Experience
Database Engineer
QualiTest
- 审查和维护运行在Azure虚拟机上的PostgreSQL数据库的当前基础架构.
- Analyzed several queries to tune them and get optimizations. 我已经将一些主查询的执行时间提高了大约90%.
- 运行性能测试以调优PostgreSQL参数以提高数据库性能.
- Migrated and upgraded PostgreSQL databases from 9.6 to 14.8 on Azure Managed Instances.
- 配置数据库日志以获得适当的pgBadger报告和配置/改进的Grafana仪表板报告,用于数据库监控.
- 审查、配置和维护数据库备份和PostgreSQL复制集群.
- 支持并修复了与数据库相关的问题:连接问题, replication not working, temp problem space in a data warehouse, bloated tables and indexes, etc.
Database Engineer
Softvision
- 支持和维护Google cloud Platform (GCP)中的云SQL数据库.
- 在GCP中为所有数据库环境配置监视和警报.
- 参与应用程序部署和发布,以应用和验证任何数据库更改. Managed the database scripts in GitLab.
- 使用查询洞察和分析查询执行性能调优,以维护或提高数据库性能.
- 通过Postgres连接器或数据提取到Google data Studio创建数据源,生成用于数据分析和商业智能(BI)的仪表板报告.
Database Engineer
Alpha Fintech
- 处理数据库迁移到AWS、Oracle cloud和Azure中的云.
- 协助开发人员在所有与数据库相关的任务上进行发布部署.
- 执行MongoDB和PostgreSQL的数据库查询和调优.
- 实现和设计关系数据库和非关系数据库的高可用性策略. 创建MongoDB中配置复制集(主从)的集群和PostgreSQL中配置双向复制的集群.
- 根据仪表板需求,在Sisense中安装并设计了来自不同来源的ETL模型.
- 使用PgBouncer管理和配置数据库池连接.
- 维护和调优PostgreSQL中一个巨大的数据仓库,用于从UI生成报告.
Database Administrator
IBM
- Planned, installed, configured, 维护Oracle Data guard等高可用性解决方案, Oracle Real Application Clusters (RAC), and Automatic Storage Management (ASM) environments.
- 计划和配置备份和恢复策略以及灾难恢复练习.
- Installed, configured, 并管理了一个解决方案,从一个名为Oracle Enterprise Manager Grid Control的控制台管理Oracle数据库.
- 作为特定站点的主要联络点进行支持和管理,并为诺华等客户提供日常支持.
- 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.
- 使用RMAN和Oracle Statspack实用程序规划和配置备份策略.
- 执行数据库维护任务,并参与全天候随叫随到的轮岗支持.
- 对所有数据库环境进行数据库监视和调优.
Data Analyst
Claro Argentina
- Created the reports from databases for financial purposes.
- 使用Oracle Statspack实用程序生成调优和统计报告,以提高数据库性能.
- 在数据库上执行SQL查询以执行特定的请求.
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
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
Platforms
甲骨文、Unix、谷歌云平台(GCP)、Azure、亚马逊网络服务(AWS)
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
在数小时内,而不是数周或数月,我们的网络将为您直接匹配全球行业专家.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring