Jerome Sundiang Email & Phone Number

Singapore

Singapore

Philippines

Philippines

Public Service Industry• Team management - Offshore Team Lead for Application DBAs• Support developers for efficient SQL query and performance tuning.• Monitor database performance; performed data change requests, migration and objects rebuild for database maintenances.• Analyze performance issues and performance optimization.• Utilize UNIX shell scripting to automate system administration• Install, configure and manage scheduler jobs for both CRON and OEM jobs for daily health check of the database server system and maintained not more than 90 of Oracle databases hosted on RHEL platform under multitenant environments.• Oracle GoldenGate 19c Adminstrator, that includes, installation, monitoring, rebuilding and upgrading.

Philippines

Hotel and Travel Industry (5 star hotel)• Installation of Oracle software and building database, server re-platform and/or DB upgrades (ie. Oracle 12c installations on Red Hat Enterprise Linux) that uses automatic storage management (ASM) and/or logical volume storage.• Configure and manage RMAN backup and recovery (monitors RMAN weekly and daily backups activities and troubleshoot failed RMAN backups), performed database cloning, apply DB security patches and data refresh using export and import datapump approach.• Data change requests (DCR), database object migrations and rebuild for database maintenance to the client’s production environment. This includes reviewing the SQL scripts and instructions specified in the change request and executing the change based on change management process and performing technical validations (if applicable) to the objects migrated and/or data changed.• Analyze capacity and growth of the tablespaces of the databases using various automated testing tools and performance optimization.• Oracle Database Upgrade from 12c to 19c.• Installation of MongoDB software and building database, server re-platform and/or DB upgrades on Red Hat Enterprise Linux.• Configure and Manage import and export backup approach for MongoDB for Prod and Non-Prod environments• MongoDB Data change requests (DCR), database object migrations and rebuild for database maintenance to the client’s production environment.

Philippines

Project: Canadian BankKey responsibilities and authorities:Primary Skill : Oracle(9i, 10g, 11g, 12c, ASM, Exadata) • Provides 24x7 support/maintenance of Oracle Databases running on different UNIX platforms and some WINDOWS platforms• Backup jobs monitoring and making sure all jobs run successfully• Caters ad hoc job requests from the front-end application developers with their queries• Monitoring of Oracle Golden Gate• Monitor and managed Oracle in EXADATA environment, RAC cluster environment and stand-alone environment• Administrative Tasks on production, testing and development database servers : - Monitoring the user sessions and take appropriate action to kill the inactive sessions - Monitoring Tablespaces and Datafiles utilization and extending data files size - Performs backup and recovery when needed - Using DATAPUMP and Export /Import utilities for logical backups - Generate AWR and ASH report - Ensure DataGuard is always synchronized• Governance on production, testing and development database servers : - Stopping and Starting of instances and listeners during activities like Reboot / Patching - Script Deployments (DML & DDL statements) Secondary Skill : MSSQL( 2008, 2008 R2, 2012)• Administrative Tasks(Capacity, Availability, Audit, Performance, Security, and Integrity Checks) - Monitoring Maintenance Plan - Monitoring Log shipping and troubleshooting errors - Monitoring SSIS and SSRS on a clustered and standalone environment - Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users• Governance (Reboot & Patching) - Responsible for implementation and release of database changes according to agreed timescales and costs

Philippines

Project: Shared Multinational Accounts in different Industries (more than 10)Key responsibilities and authorities:• Provides support for shared accounts via voice, email and other forms of communication• Incident Management• SPOC for multinational accounts• Monitoring / processing batch jobs and cycles• Troubleshoot / Investigates and ensure timely escalation for batch failures / long running jobs• Perform ad hoc job requests as per users’ demand• Creates / Acknowledge tickets / alerts for system down / job failures and other issues• Coordinates with other teams during maintenance for pre & post maintenance procedures• Trainer for new hires• Generates reports / metrics• Documenting / updating the process of the accounts we handledTools:• CA Workload Automation AE (AutoSys Edition)• BMC Control-M Enterprise Manager (EM)• IBM® Personal Communications (ESP Mainframe)• IBM® Tivoli Workload Scheduler / Maestro • HP Service Manager Software (Ticketing Tool)• ServiceNow (Ticketing Tool)• GlobalScape version 5 (FTP Tool)

Angeles, Central Luzon, Philippines

Health Industry• Troubleshooting Hardware and Software• Supported users regarding network issues

High School Diploma

Activities and Societies: Angeles Univerisity Foundation Symphonic Band

Bachelor Of Science (B.S.), Information Technology

Activities and Societies: • Junior Philippine Computer Society • Multi Media Development • Data Link (Official Publication of AUF-CCS) •.