Juan Manuel Piombo Email & Phone Number

La Plata, Buenos Aires Province, Ar

Caba

Maintenance of the database infrastructure in both On-Prem and the Cloud- Oracle (11g,12c,19c ) Oracle Container y PDBs Multitenat.- Oracle Cloud infraestructure OCI (DbSystems, Autonomous DB) - Sql Server 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019.- Microsoft Azure (Sql Managed Instance, Sql databases, CosmosDB, Azure DataFactory)Internal support for Development and infrastructure projects and external support for different clients that have products belonging to the company.Process automation bash script & ansible (Linux)

Remote DBA support to Oracle databases 9i, 10g and 11g for different Sony Applications Installation, Migrations, Patching, Healtchecks, Performance Analysis, Troubleshooting, Tuning. Data encryption (TDE), FDAInstallation, configuration and monitoring Creation of scripts and shell scripts to monitor the databases.Creation of document with different procedures and tasks.RMAN

Buenos Aires

Remote DBA support to Oracle databases 8i, 9i, 10g and 11g for different clients in The United States in different Os Platforms such as Linux, HP-UX, Sun Solaris, AIX y Windows.Installation, Migrations, Patching, Healtchecks, Performance Analysis, Troubleshooting, Tuning.Implementation of backup policies: Cold backups, Hot backups, incremental backups with RMAN, etc. Cloning with user managed backups or RMAN.Installation, configuration and monitoring of Standby Databases, Data Guard broken, ASM Databases.Creation of scripts and shell scripts to monitor the databases.Follow up on Severity 1 issues with Oracle Support, Creation of document with different procedures and tasks.

Outsourcing database services for World Class companies.ResponsibilitiesInstallation, configuration and maintenance of RDBMS on Windows and Unix platforms(Solaris, AIX, HP-UX).Use of the backup and restore techniques (RMAN), Disaster Recovery, availability of services,troubleshooting, database tuning, monitoring, high availability techniques, scripting. Totalnumber of instances supported above 400. On-call support.Installation and Configuration of RAC 11g with ASM for Baxter accountFocal account – BaxterSME of the DBA team

ProjectsMunicipalidad Quilmes, ArgentinaResponsibilitiesMy main tasks were the design of PL/SQL code and database structures to purge the old dataof that entity.Bayer, ArgentinaResponsibilitiesInitially hired as a PL/SQL developer, my first responsibilities included the development ofPL/SQL packages to interface with other systems, including data loads and datadumps.BCRA, ArgentinaResponsibilitiesInstallation and configuration of Oracle database 10g R2 on Windows.I was responsible for installation of the Oracle server , including backup scripts. installation ofthe client/server SQL*Net configuration, for both end customers and internal developmentdatabases.Siemens, ArgentinaResponsibilitiesHired as a production support DBA, Extensive database level performance tuning includedcustomising Oracle memory settings, enforcing cursor_sharing .Other work includedconfiguring database backups using RMAN.Oracle Extended RAC 10g R2 SO : 64-bit Red Hat Linux with ASMNetbackup, ArgentinaResponsibilitiesHired to Implement backup policies with RMAN and Netbackup tool.IPLAN, ArgentinaResponsibilitiesInstallation and configuration of Oracle RAC 9i on Red Hat Linux with OCFS.Nextel, ArgentinaResponsibilitiesInstallation and configuration of RAC 10g R2 on Solaris with ASMThis project was a migration from pre-existing non-Oracle software to an Oracle RAC serverside.Siderar, Argentina.ResponsibilitiesI was responsible of the upgrade of an Oracle RAC version 9i to 10g with cluster filesystem on avery critical system.

Oracle DBA and PL/SQL Developer Sr

Analista De Computacion, Informatica

Computer Analyst