Gerardo Landaverde

Technology Consultant, Database Administrator and Data Analyst

Location

Heredia , Costa Rica

Phone

(506) 8752 0481

I'm a technology professional with extensive experience designing, developing, installing and supporting solutions and services for small, medium and enterprise size environments. I have a strong background in infrastructure services, software development, solutions and software architecture, information security, compliance, management and customer relationship.

I am well versed in DevOps practices and Agile/Scrum methodologies. I am able to adapt quickly to demanding and high-pressure situation, and I also have experience leading technical teams in different national and international projects My career goals are to use my Technical experience and continue to develop my Project and TI Management skills.

I have strong experience as Database Administrator, Project Analyst and Programmer. I have experience working on Oracle Database performance tuning, troubleshooting, security and administration in Exadata or RAC configurations. I also have strong experience with computer programming languages as PL/SQL, Java, Python, R, Shell scripting and others. I have good knowledge of tools like Jira, Docker, Hadoop, Hive (HQL), AWS cloud, Github, Splunk and big data and analysis tools.

I Like to work at a people-oriented, high-technology corporation where I can use my strong analytical, detail oriented and interpersonal skills along with my exceptional common sense to improve services and products, reduce costs and lead times, delight customers and help and mentor others. All the while engaging in new challenges and learning experiences.

01

Advanced Oracle Database

I've worked as a Senior Oracle Database Administrator and Performance DB Administrator for more than 10 Years, with experience in Oracle and Oracle Exadata.

02

Project Management

Worked planning and managing projects aligning business goals with technology solutions to drive process improvements, competitive advantage and bottom-line gains.

03

Data Analyst

I have Experience in Big Data Analysis, Data Warehousing and many analytic tools as OBIEE and Tableau.

04

Java

I also have experience as a Java programmer, and with related tecnologies as Struts, Grails and Others.

05

PL/SQL

I am an expert PL/SQL developer, I've worked in many important projects based on Oracle Database programming.

06

Docker

I have experience in Docker and Docker swarm; I can build, manage and secure business-critical applications.

07

R / Python / Grails / Rust / MySQL / PostgreSQL

I have experience in data analysis oriented languages as R and Python. Also on other Web tools as Grails, High Performance Programming Languages as Rust, and other relational databases as MySQL and PostgreSQL.

08

Cloud & AI

Experience working with Terraform, AWS, AWS RDS, Snowflake, Oracle Cloud and multiple AI‑driven tooling used for automation, analysis and infrastructure optimization.

90%

Oracle DB / OEM

85%

PL/SQL and Java

75%

MySQL / Postgre SQL

70%

R-Studio

90%

MS Office Tools

70%

HPUX / Linux

70%

Python / Rust

65%

Data Analysis / Tableau

70%

Terraform / AWS / AWS RDS / Snowflake / AI

May. 2019 – Present

Mckinsey & Company .

Senior IT operations specialist

Heredia , Costa Rica.

Responsible for Oracle databases, MSSQL, MySql and Postgresql databases, daily maintenance, performance tuning, security, users access troubleshooting, scalability analysis, patching, etc. I am also responsible of planning with the team and stakeholders: maintenance, patching tasks, vulnerabilities assessment and remediation. Continuous improvement and automation of processes aimed to on‑premises and cloud infrastructure. Additionally, I worked with Terraform for infrastructure automation, AWS RDS for cloud‑managed database operations, and Snowflake administration for cloud‑based data warehousing.

Nov. 2014 – Feb. 2019

Intertec International (Micra Consulting).

Senior Performance Database Administrator

Heredia , Costa Rica.

Responsible for database high performance tuning, maintenance, security, users access and troubleshooting, working outsourced for one of the biggest banks in the world. Achievements: - Decreased response time for several business processes. - Improved readability of AWR, ADDM and Storage statistics report sets for stress test cluster databases running on Exadata. - Created shell scripts for manual processes.

Sep. 2012 – Nov. 2014

SITES / Siman Commerce Group / Unicomer

Senior Database Administrator

San Salvador

Database security administration, maintenance, performance tuning and troubleshooting of Oracle databases. Administration and maintenance of Oracle ASM and Oracle RAC (Real Application Cluster) configurations. Oracle Applications EBS DBA.Configuration of Oracle and third party tools to perform online and offline database backups. Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.

Oct. 2008 – Sep. 2012

CTE Telecom S.A. / Claro El Salvador

Oracle Projects Analyst and Database Administrator

San Salvador

Database security administration, maintenance, performance tuning and troubleshooting of Oracle databases. Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases. Automated and manual daily administrative tasks including space management, database backup and recovery. Linux and Unix scripting.

Nov. 2006 – Oct. 2008

Global Solutions Latinamerica.

Oracle Projects Analyst and Database Administrator

San Salvador

Database security administration, maintenance, performance tuning and troubleshooting of Oracle databases. Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases. Automated and manual daily administrative tasks including space management, database backup and recovery. Linux and Unix scripting.

Jun. 2001 – Nov. 2006

TACA Airlines (Now AVIANCA Airlines)

IT Project Coordinator.

San Salvador

IT Project Coordinator in the area of Revenue Accounting and the area of Human Resources.. Design and development of data conversions and interfaces for revenue accounting and human resources needs, developed with Oracle PL/SQL, Java, Oracle Forms Developer and Reports Developer. Development of Point of Sales ticket control system, to simplify revenue accounting operational and control tasks. Development of automated database backups on some of the revenue accounting cycles for the main revenue system.