Ismael Estropia Email & Phone Number

Ontario, Canada

Toronto, Ontario, Canada

Philippines

Mckinley Hill

Level 3 troubleshooting, administration and support of Oracle databases(10g/11g/12c/RAC/Data Guard) running on Solaris/RHEL operating systems.

Taguig, Philippines

provided daily Oracle database administration support on multiple environments from Production, UAT to Dev servers. Support includes 24/7 on-call support and monitoring/administration of databases. Scope of work includes: - user administration - tablespace management - Dataguard management, configuration and support - create custom shell scripts used for monitoring database which include SQL and/or PL/SQL scripts - logical import/export of data (Datapump, traditional export/import) - manual database creation - alter database object parameters depending on business needs - file system space managementI had also provided support for the following products TERADATA - provided Teradata database administration for one of our projects IBM InfoSphere Change Data Capture - provided support for ISCDC which includes raising PMRs with IBM and doing Webex troubleshooting with IBM support I had implemented a Jenkins job to replace cron jobs for easier monitoring of the executions of scripts.I had also created a custom shell script which was used to integrate Sitescope monitoring with Informatica Data Replication.

- user creation and administration- table/index partition reorganization- database cloning- logical dataload (Datapump)- Data Guard administration and configuration- Linux shell scripting and automation- security patching (oPatch)- configuring Oracle Collector Manager- use of monitoring tools (Foglight, HP DataProtector- PL/SQL programming- database backup and recovery

- monitor the database server’s health and tuning accordingly- establish standards and schedules for database backups- perform database upgrade, installation and migration- perform logical data loads/backup (import and export using IMP/EXP or datapump)- perform various DBA routine tasks like tablespaces, segments, extents management, user administration, monitoring locks, top sessions, temporary tablespaces, materialized views)- user administration (creation, grants, user cloning, roles, password reset, profiles)- database backup and recovery (RMAN, Datapump)- change database parameters and setup to ensure optimal database performance- manage space allocated for database- troubleshoot database issues- Linux/Unix shell scripting- Oracle Data Guard setup and configuration- RAC and ASM setup, configuration and administration- instance tuning, SQL tuning, database performance tuning- daily support for application developers (PL/SQL, Oracle CC&B)- perform switchover, failover, rebuilding of databases during Disaster Recovery activities- installation/implementation of HP Performance Center/HP Load Generator

Eastwood, Bagumbayan, Quezon City

- daily administration and maintenance of Oracle Database 10g,11g on Unix (HP-UX, SunOS, IBM-AIX,Red Hat)- perform various DBA routine tasks like tablespaces, segments, extents management, user administration, monitoring locks, top sessions, temporary tablespaces.- perform logical data loads/backup (import and export using IMP/EXP or datapump), implementation of backup/restore routines using RMAN- management of database structures like tablespaces, datafiles, online redo log files, control files and archive logs- implementation of automatic crontab jobs (ex. SQL and PL*SQL scripts to monitor the DB)- creation of DB link to connect with other databases in different environments.- daily troubleshooting report of the databases environment.- Oracle patch installation.- OS patching support with the SA team relinking binaries, reloading parameters.- user administration (creation, grants, user cloning, roles, password reset, profiles- database migrations (tables, stored procedures, views, functions, packages, triggers)- working knowledge of RAC (Real Application Cluster)- working knowledge of ASM (Automatic Storage Management)- Unix shell scripting

- implemented Oracle Business Intelligence applications (OBIEE, SOA and BPM, Weblogic Server, Webcenter Portal, Oracle RDBMS) on Cloud servers (Amazon Websphere)- setup, installation and configuration of Oracle VM 3.0- supported Linux OS issues (OEL, RHEL)- assisted in scoping hardware configuration during business proposals

Corinthian Executive Regency, Ortigas Avenue, Pasig City

- Oracle 11gR2 RDMS installation (11.2.0.3)- Oracle 11g Grid Control installation (11.1.0.1)- knowledge in 12c Cloud Control installation (12.1.0.2)- created shell scripts depending on business requirements- created build book documentations- generated awr/addm reports- knowledge in RMAN backup and recovery- knowledge in RAC and ASM- conducts weekly analysis of database server alerts in order to create an action plan on how to resolve the top causes of these alerts.- assists in researching solutions for day to day server issues.

Cubao, Quezon City

- Did several data analysis regarding account performance which was presented to the client to explains sales/technical support call trends- Collaborated with Sales trainers to create training materials which would improve an agent’s sales conversion rate- Assisted agents in troubleshooting advanced software issues when necessary

Mall Of Asia, Pasay City

- Resolve/Process all escalated technical issues.- Monitor and manage team’s performance metrics.- Stack rank all team members based on performance.- Track/manage team attendance and review team performance.- Conduct pre/post shift meetings with team; cascade process-related updates.- Take corrective and preventive actions.- Conducts the necessary training and upskilling of agents to further improve them in handling their duties.- Responsible in managing of team in the absence of team manager. - DCSE and ARE Certified

Mall Of Asia, Pasay City

- Supports Dell Dimension Desktops and Inspiron Laptops- Provides Technical Support for Dell On Call entitled Home Consumer Account- Assists and gives step by step instructions to home users on how to troubleshoot and use their home computers.(basic usage, can’t connect to the internet, basic network setup, virus removal, advance software and blue screen issues) - sells Dell On Call software support warranty, hardware and other Peripherals

Makati, National Capital Region, Philippines

- Supports Earthlink Web Hosting Account- Provides both Technical and Customer Service support.- Assists users in setting up their webhosting account by setting up their desired bill plans and their billing concerns.- Assists customers in managing their website (adding new mailboxes, email account setup, basic HTML support , TRELLIX software support and use of an e-Commerce Software MIVA

Ortigas

Bachelor’S Degree, Business Administration And Management, General

Training: Oracle Database 11G: Performance Tuning

Training: Oracle Database 11G: Administration Workshop 2 Ed. 2

Training: Oracle Database 11G: Administration Workshop 1 Ed. 2

Training: Oracle Vm 3.0 Implementation Boot Camp

Training: Unix/Linux Fundamentals

Training: Unix/Linux Network Administration And Security

Education record