Mid-Senior ORACLE DBA
PUERTO RICO ELECTRIC POWER AUTHORITY (PREPA)
ORACLE DBA (10g, 11g, 12c). RMAN 11g, 12c Backup. Enterprise Manager Cloud Control 13c Installation and configuration. Documentation IT processes and providing knowledge transfers to team members with RT: Request Tracker . Fulfill DBA daily activities, including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.); space management (tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database network connectivity). Monitor hardware, OS and application performance through available utilities. ORACLE Clients Installation and Configuration. PL/SQL Training. Develop and designs database solutions using Oracle Proprietary Product. Forms Builder, Procedure Builder, Report Builder and Graphic Builder. Installation and configuration of Developer 10g. Analyze Recommend software and hardware solutions for Informatics Office. Technical Support to office personnel in software solutions and programming. Windows 7, 8, 10, Linux, HP-UX 11.31. ORACLE APEX 5.0.3 Installation and configuration. PostgresSQL. MySQL. Casual working knowledge of MS-SQL Server 2016 (In progress). VMWare Virtualization (ESX). VMWare Virtualization (Server). ORACLE Virtual Box Virtualization . DB tuning for Linux, Windows and HP-UX Environment. Database Conversion. Dell Toad for Oracle 12. ORACLE SQLDeveloper. ORACLE DATA Streaming. Develops PL/SQL scripts for complex business requirements through analysis, design, development, testing, debugging and documentation phases. Performs Modeling/Schema design. Performs database tuning and optimization (schema and SQL). Assists the development staff with complex SQL. Creates and maintains database upgrade scripts. Delivers work estimates for proposed changes, both small and large in scope.