Ivan Ruiz Email & Phone Number

---> Oracle 12c, 18c & 19c DBA & Cloud Infrastructureo Administered the Oracle Database infrastructure of the campus and provided Support to different areas and users via ticketing or direct chat.o Managed the tablespaces by adding, increasing or configuring them.o Applied security and maintenance patches to the Oracle Database engine including Grid Infrastructure.o Administered the ASM instances and the two-node RAC environment.o Created a Data Guard infrastructure for our Oracle Cloud Production Databases.o Installed and configured OEM 13c to monitor our databaseso Upgraded our production DB and Grid from 12c to 19co Actively participated on several projects being migrating our On-Premise Databases to the Oracle Cloud Infrastructure the biggest one using the Lift & Shift method and created a whole documentation for those tasks.o Took care of the security of the databases via users, grants, sqlnet configurations, tnsnames configurations, listeners, OS firewall.o Performed several data migration between server using DataPumpo Managed basic aspects of the Oracle Cloud Infrastructure like users, groups, VMs creations, IP assignments, VCNs management.---> Linux & Windows Sysadmin & Bash Scriptingo Being Linux my main OS, I had to perform every kind of task related to it like Updates, Upgrades, migrations, disks management, File Systems management, user management.o Performed more than 30 Linux RedHat upgrades from RedHad 6 to RedHat 7 having to back up everything, install the new RedHad version and then restore everything back again.o Managed the entire OS firewall for security tasks like ports management, IP filtering, etc.o Created Bash Scripts for general purpose like automatic backups for DBs, applications, file transfers, generation of reports from many servers, automatic installations of DB2 software, automation of repetitive tasks or complex tasks, scheduling of tasks, DB cloning with a single script, OS preparation tasks for new databases.o Performed OS troubleshooting, File System management, basic network management, monitoring, updates, package installations, disks management, LV and VG creation, recovery mode, GRUB usage, user management, NFS configurations.---> DB2 at IBMo Worked as DB2, MS SQL and Oracle DBA for more than 30 accounts for a total of 60+ servers.o Provided DB2 support to many different customers via ticketing like General Motors, Exxon, Marriot, Jabil, Metlife; being those customers the biggest ones I worked with.o Had to attend many calls with my accounts and provide ideas, solutions, schedule tasks, etc.

• 

  Universidad De Guadalajara

  Computer Engineering