Responsible of the Oracle data bases. Lead and develop 1st and 2nd level of support under the SLA’s committed to the business.  

Maintained contact with suppliers and technical teams to attend to incidents, requests, sizing, and topics related to our new infrastructure.

 

   Job activities/responsibilities

 

●       Creat and administration DB Oracle 11g, 12c, etc.

●       Administration, maintenance, and reorganization of Oracle databases.

●       Manage Oracle DB 18c and 19c in OS Redhat Linux 6,7, and 8.

●       DRP Basic knowledge using Oracle Data Guard.

●       Knowledge of managing data structures within the database (tables, indexes, partitions, etc.)

•       Knowledge of data management activities (Export/Import) segmented by schemes, tablespaces, full, etc.

●       Execution of ETL processes of data from Oracle databases.

●       Analysis, creation, and maintenance of bulk load data scripts.

●       Knowledge of the management, maintenance, and improvement of the use of resources of the applications within the BD (sessions, processes, locks)

●       Knowledge of connection through JDBC, Pool's, and direct connections.

●       Expertise in tuning queries within the DB.

●       Expertise in tuning data structure to provide improvement recommendations.

●       Knowledge of layer environments (BD, APP, WEB)

●       Basic knowledge of connectivity to and from the DB with various systems and applications.

●       Manage Oracle rdbms versions 11,12,18c,19c; Toad and Jdeveloper, SQL, OS Linux.