JUAN C. CONTRERAS

Orlando FL

adg0jo@r.postjobfree.com

https://www.linkedin.com/in/juancontrmo/

IT professional with experience as a Developer (Oracle Forms & PLSQL Certified) and DBA, in addition to ODI support work experience, helping customers to solve issues related to Data integration ETL mappings, performance, bug documentation, patching, testing, and development. Skilled problem identifier and troubleshooter in a range of IT environments with certified knowledge of Oracle Cloud Infrastructure (OCI). I am US resident, green card holder with no restrictions to work in the United States. My employment history has been verified through an external company, see www.hireright.com

Highlights of IT Skills Microsoft SQL Server Administrator - 3 years

Oracle Forms – 5+ years

Oracle SQL, PLSQL - 8+ years

Transact SQL – 3 years

English-Spanish Phone Translator for IT support - 3 years Oracle Data Integrator Support – 5 years

Oracle Dataguard Standby/Failover Administration - 1 year Linux Bash Shell Scripting -1 year

Oracle Database Backup & Recovery -5 years

MSSQL Backup & Recovery -3 years

Oracle Cloud Infrastructure -1 year

AWS -Less than 1 year

Oracle RAC & ASM Administration - 1 year

Python programming - Less than 1 year

Education

Universidad Antonio Nariño – BS – Systems Engineering Bogota, D.C 1998 Test Automation Foundations - Course - Orlando, FL 2020 Learning Cloud Computing: Networking - Course - Orlando, FL 2020 Microsoft SQL Server 2019 Essential Training - Course Orlando, FL 2020 Oracle Database 12c: Backup and Recovery - Course Orlando, FL 2020 Oracle Database 12c: Security - Course Orlando, FL 2020 Learning Python - Course Orlando, FL 2020

Certifications

See https://www.youracclaim.com/users/juancarlos-contreras/badges (scroll down the page) OCA Certification - Oracle PL/SQL Certified Associate Bogota, D.C 2007 OCA Certification – Oracle Cloud Infrastructure Orlando FL 2020 OCA Certification - Oracle 11g Database Administrator Bogota, D.C 2013 OCA Certification - Oracle 10g Database Administrator Bogota, D.C 2009 Professional Experience

ORACLE – Senior Technical Support Engineer Orlando USA, FL Oct 21,2015 – Jul 15,2020

• Troubleshooting simple to complex Oracle data integrator issues for top account customers under SLAs predefined

• ODI upgrades from 11g to 12c versions for internal testing

• English-Spanish translator through phone calls and web conference to help Engineers Colleagues to provide support in ODI related issues.

• Configuration and design of virtual environments (database, OS, ODI agents) on Linux and Windows platforms to reproduce and solve ODI technical issues.

• ODI Topology Configuration to handle data integration connectivity with several source & target technologies like XML files, Databases, Hadoop, Netezza, Web Services and others.

• Tuning of ODI developments, Memory, IO checking to provide best practices to improve ODI performance

• Documentation of solved issues to be published on my Oracle Support site

• Code review (PLSQL, Python, Bash shell) to troubleshot ODI issues

• Load data into Oracle tables using SQL Loader

• Database Analysis, OS System, WebLogic logs and Network to troubleshot ODI requests

• ODI Source-target mapping among different technologies INDRA – Database Administrator Bogota, D.C.

July 9,2012 – Jan 31,2014

• Installed, configured and managed Oracle 10g, 11g on windows and Linux platform.

• Interacted with the Technical Design team and contributed in impact analysis and creation of the technical specifications.

• Manage Database administration assignments in SQL Server environments

• Worked on Oracle databases and MSSQL, this included backup, restoration, and quality control applications.

• Developed windows scripts, shell scripts, PL/SQL programming for automation of database administration tasks

• Detailed review of Oracle Forms and PL/SQL code on INDRA customers to troubleshoot performance issues as part of the customer’s software design.

• Developed and created definition of backup strategies for RMAN and EXPDP.

• Created database structures for developer and client needs on QA and production environments.

• Applied security patches on Oracle databases.

• Involved in session management and monitoring the critical wait events, blocking sessions in the databases (Oracle and MSSQL).

• Worked on Migration of Oracle 11g Databases from Windows to Linux on Production environment

EUD – IT Certification Trainer Bogota, D.C.

July 2011 – July 2012

• Training IT students in Database Administration, PL/SQL and Oracle Forms programming by using official Oracle documentation in order to help them to achieve Oracle Certifications.

• Installed databases and OS in classroom environments

• As part of the students classes, provided recommendations to real issues happening on students’ jobs related to PLSQL coding and Oracle Forms design according to best practices SYNAPSIS (TIVIT) - Oracle Database Administrator Bogota, D.C May 5, 2010 – Dec 31, 2011

• Managed Oracle RMAN backups and tuning oracle sentences.

• Provided support for Oracle Data Guard administration

• Oracle database and MSSQL backups and recovery.

• Added more new features to existing analysis software tools.

• Created structural changes to the Oracle databases using DDL statements.

• Worked on Oracle configuration, third party backup software and backup testing.

• Supported DBA Junior SQL Server 2008 on replication scenario with log shipping.

• Made corrections of inefficient of high load SQL statements, suboptimal use of Oracle database, undersized memory structures, concurrency issues, database configuration, and locking issues.

• Created Bash Shell scripts to invoke SQL Scripts and scheduled them using OS crontab

• Developed Complex PL/SQL Code, Stored Procedures, Functions, Packages and Triggers which uses collections as part of temporary developments assignments

• Applied analysis, data collection techniques, database normalization, entity relation modeling in SDLC from analysis, design, development, testing, implementation and maintenance

• Reports generation based on multiple tables and subqueries by using ANSI SQL and T-SQL

• Involved in data loading using SQL Loader to load data from flat files

• Worked closely with clients to clarify development specifications Telefónica (Movistar) – IT Database Professional – Bogotá, DC Nov 3, 2009 – Apr 1, 2010

• Utilize Oracle diagnostic tools like Explain Plan, SQL Trace, TKPROF and AWR to analyze timing and execution for database tuning

• Created and modified existing Unix scripts for Oracle 10g

• Managed Standard Audit trail, audit parameters

• Used triggers to record additional customized Audit information

• Worked with development team for database object creation, query tuning and regular database related issues.

• Oracle database installation, patch installation, configuration, and maintenance.

• Tune the SQL queries by creating proper index, using hints and changing database parameters

• Involved in development of application functions, triggers, PL/SQL and packages

• 24 x 7 database on call support according to shift rotation schedule Additional Job Experience

COMPANY: ORATECH LTDA

Website: www.oratechla.com

Address: Av 15 No. 100 – 69 ofc 204 Ed. Vanguardia 101 (Bogotá – Colombia) Phone: (57) -1- 6017157, 6017158

August 2008 – July 2009

Position: Infrastructure Consultant

● Managed the Oracle database (RAC-Standby-ASM).

● Acted as a consultant for software development tools, PL / SQL-forms-reports.

● Trained clients in Oracle database administration.

● Supported DBA clients (Falabella, Colombian Army, Thomas Express, Movistar).

● Visited clients on business sites, provided quotes configuration and created systems reports for clients and management.

Environment: Oracle RAC 9i, Oracle Dataguard, Windows server 2005, Oracle Enterprise Manager (OEM), EXPDP, IMPDP, Exp, Imp, RMAN, TOAD, SQL, SQL*Loader, PL/SQL, SCP, FTP, Telnet

COMPANY: SBD LTDA

Website: www.sbd.com.co

Address: Cra 13a No 89-38 Of 308, (Bogotá – Colombia) Phone: 57 -1- 6182931

October 2007 – August 2008

Position: Oracle Database Administrator

● Created users and privileges according with their responsibilities

● Configuring backup and restore procedures with RMAN scripts

● Tuned Oracle Sentences

● Developed scripts with PL / SQL and Shell scripting on Unix environments for DBA automated tasks

● Created and interpreting statspack reports

● Supported on call 24/7 DBA .

Environment: Oracle 9i, Oracle 8, Exp, Imp, TOAD, SQLplus, SQL*Loader, PL/SQL, Unix, HP-UX, FTP

COMPANY: GEOSPATIAL

Website: www.geospatial.com.co

Address: Calle 39 Bis B # 29-43 (Bogotá, Colombia) Phone: (57) - 1 -2449506

April 2007 – October 2007

Position: Development Leader Database, Senior Analyst Project

● Managed the Oracle development team on activities related with PL / SQL and Oracle Forms-Reports programming.

● Geodatabase Modeling, Use Case Specification

● Analysed and design solutions according to the client requirements using RUP methodology

● Meeting clients face to face and on site to ascertain requirements.

● Producing and updating relevant documentation.

Environment: Windows, Office, Oracle 9i, Exp, Imp, SQLplus, PL/SQL, Forms, ESRI, ARC/INFO, ARCGIS, ARCVIEW, ARCCatalalog, Oracle Spatial, ARCSDE, Oracle Forms 6i COMPANY: INFORMATICA SIGLO 21

Webpage: www.i-siglo21.com

Address: Cra 13 29 21 Mz 1 Of. 242

Phone: (57) – 1- 2889480, 5612563 Ext. 108

November 2005 - March 2007

Position: Consulting Engineer

● Oracle10g Programming (Forms Builder, Reports Builder, PL / SQL)

● Development of New Buildings module and ranking contractors in Gas Natural ESP

● Application Maintenance NGV (Natural Gas Vehicle), IVM (Integrated Management of Sales), SAT

● Analyzed user requirements with UML methodology

● Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

COMPANY: SOFTMANAGEMENT

Webpage: www.softmanagement.com.co

Address: Cra. 9 No 72-61 Of. 303, (Bogotá, Colombia) Phone: (57) - 1- 2120441, 3212800

August 2003 - September 2005

Position: Senior Programmer

● Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

● Data analysis and generation of scripts for running reports

● Data analysis and generation of scripts for modification of information

● Change displays and programs Front-End, according to new requirements of the business.

● Programming Oracle (Forms 6i, PL / SQL and Reports), Procedures, Packages and Functions

● Involved in the support, maintenance and development of the financial system

● Defining and generating screen formats and report designs using Oracle Forms and Oracle Reports

● Developed in accordance with policies regarding secure coding & standards

● Carrying out design, construction, review and defect analysis activities.

● Developed using Oracle (Forms 6i, PL / SQL and Reports) in accordance with agreed design with consideration for usability, software quality and future maintenance Environment: Windows, Office, Oracle 9i, Exp, Imp, SQLplus, PL/SQL, SQLLoader, Oracle Forms 6i, Reports 6i

COMPANY: AVANZIT TECNOLOGÍA

Website: www.avanzit-tecnologia.com

Carrera 11 No. 94 – 02 Piso 3

Phone: (57) -1- 2187272 ext. – 304 – 316

June 2000 - February 2002

Position: Oracle Developer

● Analysis and Design of security database modules

● Administration of databases in development and testing environment

● Project coordination SIGART for public sector telecommunication company

● Training for application users

Environment: Windows, Office, Oracle 6i, Exp, Imp, SQLplus, PL/SQL, SQLLoader, Oracle Forms 6i, Reports 6i

COMPANY: SYNERSIS LTDA

Webpage: www.synersys.net

Address: Cra. 19B Nro. 84-31 Oficina 302

September 1999 - June 2000

● Analysis, design and programming of the human resources Information System

● Oracle Development using (Forms 4.5, Reports 2.5, SQLPLUS).

● Testing on QA environments for new software

● Defining and generating screen formats and report designs.

● Produced and updatied relevant documentation for new developments.

● Develop software in accordance with agreed design with consideration for usability, software quality and future maintenance.

Environment: Windows, Office, Oracle 6i, Exp, Imp, SQLplus, PL/SQL, SQLLoader, Oracle Forms 4.5, Reports 4.5, Graphics

COMPANY: SOFTBOLIVAR – SEGUROS BOLIVAR

Webpage: www.softbolivar.com

Address: Carrera 16 A No. 78 - 11 Piso 6

Phone: (57) -1- 6358586

April 1998 – June 1999

• Design and development of programs and reports for capitalization products

• Oracle Development using Forms 4.5, Reports 2.5, SQLPLUS Environment: Unix Terminal, Exp, Imp, SQLplus, SQL Reports, SQL Forms, SQL, SQLLoader, Oracle Forms 4.5, Reports 4.5

PUBLICATIONS

• YouTube channel “JC Contreras – Just a curious Tech Guy” Media channel for interesting IT configurations, which are not common for Information Technology environments in the cloud and on-premise, along with some practical data integration explanations step by step for newbies and advanced users. Video #1: Connecting Oracle SQLDeveloper to OCI & AWS (Part I) Screen casting video which explains how to connect SQL Developer tool to Oracle Autonomous Databases deployed in Oracle Cloud Infraestructure Video #2: Connecting Oracle SQLDeveloper to OCI & AWS (Part II) Screen casting video which explains how to connect SQL Developer tool to RDS Oracle Databases deployed in AWS

Video #3: Data Integration example between Oracle and SQL Server Data Integration example with easy steps to generate useful mappings between Oracle and SQLServer databases to transfer data

PERSONAL ACHIVEMENTS

• Be able to adapt professionally and linguistically to support my family after moving from the country which I was born to the US 6 years ago.

• 5k runner in Orlando FL during two consecutive years LANGUAGES

- English – Advance Proficiency

- Spanish - Native

JOB REFERENCES

Juan Seijas – Principal Support Engineer at Oracle USA https://www.linkedin.com/in/juan-seijas-13b60126/

Oscar Peralta – Technical Analyst at Oracle USA

https://www.linkedin.com/in/oscar-peralta-b98a3241/ Erika Alvarez – Senior Principal Engineer at Oracle USA https://www.linkedin.com/in/erika-alvarez-3595a51/ PROFESSIONAL ACHIVEMENTS

Four Oracle Certifications achieved

More than 20 notes published in Oracle Support Site related to Oracle Data Integrator issues I was able to solve, along with more than 300 data integration service requests solved globally. 2588136.1 "Could not load JDBC driver class [oracle.bi.jdbc.AnaJdbcDriver]" when Testing Oracle BI Data Server Connection from ODI J2EE Agent https://support.oracle.com/knowledge/Middleware/2588136_1.html 2514263.1 "The SQL Server login requires an SSL connection" Error Received when Testing Microsoft Azure SQL Database Service with ODI Agent https://support.oracle.com/knowledge/Middleware/2514263_1.html 2670516.1 Attributes Missing in ODI Mappings after Using the OWB to ODI Migration Utility https://support.oracle.com/knowledge/Middleware/2670516_1.html 2668348.1 Duplicate Database Hints Observed in ODI Code https://support.oracle.com/knowledge/Middleware/2668348_1.html 2601394.1 java.lang.ArrayIndexOutOfBoundsException Error Received when Using "LKM File to Netezza (NZLOAD)" in ODI 12.2.1.3.190708

https://support.oracle.com/knowledge/Middleware/2601394_1.html 2273614.1 "ORA-01000: maximum open cursors exceeded" When Reverse Engineering ODI Models Including Datastore Subfolders

https://support.oracle.com/knowledge/Middleware/2273614_1.html 2655922.1 How To Call Multiple Commands in ODI for Oracle Data Server "On Connect/Disconnect" Events

https://support.oracle.com/knowledge/Middleware/2655922_1.html 2412849.1 Java Variable vPasswd Holding Wrong Cipher Data Value when Calling OdiSqlUnload - "ORA-01017: invalid username/password" https://support.oracle.com/knowledge/Middleware/2412849_1.html 2584874.1 ODI Studio Error Switching from Internal to Active Directory External Authentication https://support.oracle.com/knowledge/Middleware/2584874_1.html 2571502.1 "ODI-17570: Your text is too long LONG TEXT" Error is Received When Smart Importing an ODI 12c Variable

https://support.oracle.com/knowledge/Middleware/2571502_1.html 2631697.1 How To Execute 'startloadplan.sh' From the Command Line without Providing the Supervisor Password

https://support.oracle.com/knowledge/Middleware/2631697_1.html 2374381.1 ODI Executions Fail With "Connection Closed" Message After Migration of the Repositories to Oracle RAC Database

https://support.oracle.com/knowledge/Middleware/2374381_1.html 2642094.1 Unknown RegionID Error: "ODI-14213: The Input Parameter Region Is Not Valid. It Is Null, Empty Or Incorrect" Encountered when Configuring Oracle Object Storage Dataserver on ODI 12.2.1.3 and Older

https://support.oracle.com/knowledge/Middleware/2642094_1.html 2686373.1 ERROR GENERATING ANSI QUERY ODI

https://support.oracle.com/knowledge/Middleware/2686373_1.html 2646498.1 ODI 12c Does Reverse Engineer XSD CLOB Datatype as VARCHAR2 https://support.oracle.com/knowledge/Middleware/2646498_1.html 2518862.1 "class java.sql.SQLDataException... numeric value out of range" Message is Received on ODI 12c Flows that Use XML Data Server https://support.oracle.com/knowledge/Middleware/2518862_1.html 2649472.1 ODI Complex Driver Command 'CREATE XMLFILE' Results in "ORABPEL-11101 Translation Failure"

https://support.oracle.com/knowledge/Middleware/2649472_1.html

… A couple of notes more written but not published

Contact this candidate