Ralph Perez Email & Phone Number

Valenzuela, Ncr, Ph

• Data Mover Support – ensure all Data Mover jobs completes successful and address any sync issues before it becomes a Severity 1 incident (OLTP critical system)• BAR Job Development and Support – Develop backup script for the client’s data warehouse databases and ensure that the daily backup are completed within the backup window.• User Management – ensure logins are created for new joiners, average of 3 users a day. Users who no longer need access to the warehouse are dropped during the quarterly clean-up.• Access Management – grant roles and access rights on users and batch IDs. • Profiles Management – setup and/or assign profiles for new users and batch IDs• System Monitoring – ensure the system is running at an efficient level and address any issues that occur (example blocking, high impact queries).• Space Management – Monitor database space and add space as needed.• Alert Setup both Viewpoint and Unix Shell-Based Alerts• Workload Management - fine tune filter and throttle• Object Management – Create, update, and drop tables, database, views, and indexes.• System Report – prepare monthly system performance report.• Provides 2nd level support for Application and Hardware Issue via T@YS• UNIX Scripting – write automation scripts for simplifying repetitive task and automating important alerts. • Query Optimization – review poor performing and provide recommendation.

Philippines

• Data Mover Support – ensure all Data Mover jobs completes successful and address any sync issues before it becomes a Severity 1 incident (OLTP critical system)• BAR Job Development and Support – Develop backup script for the client’s data warehouse databases and ensure that the daily backup are completed within the backup window.• User Management – ensure logins are created for new joiners, average of 3 users a day. Users who no longer need access to the warehouse are dropped during the quarterly clean-up.• Access Management – grant roles and access rights on users and batch IDs. • Profiles Management – setup and/or assign profiles for new users and batch IDs• System Monitoring – ensure the system is running at an efficient level and address any issues that occur (example blocking, high impact queries).• Space Management – Monitor database space and add space as needed.• Alert Setup both Viewpoint and Unix Shell-Based Alerts• Workload Management - fine tune filter and throttle• Object Management – Create, update, and drop tables, database, views, and indexes.• System Report – prepare monthly system performance report.• Provides 2nd level support for Application and Hardware Issue via T@YS• UNIX Scripting – write automation scripts for simplifying repetitive task and automating important alerts. • Query Optimization – review poor performing and provide recommendation.

AMDOCS (Philippines) (July 1, 2012 - Present) (Absorbed)GSS Infra Division Project Optimus Senior SME - DBA.- Performs Database Administrator Tasks for Data Warehousing for Globe Telecoms Inc.. (Teradata).- Performs basic HADOOP troubleshooting, (HIVE, HBASE).- Coordinates with right teams for script execution to DEV/ST/UAT/PROD servers.- Creates Roles and Give access to users in needed databases.- Oversee tape backup (TARA) and monitoring via Teradata Viewpoint.- Provides 24x7 Database support.- Provide input / suggestions / ideas on how to improve the process regarding data warehousing tasks and management tasks.- Proactively monitor the database and table sizes and make sure that none will reach thresholds.- Provide capacity monitoring report and give suggestions if necessary on how to increase database / table sizes without sacrificing the performance.- Tune queries when needed.

Philippines

- Perfroms Database Administrator Tasks. (Oracle 9i and 10g)- Provide Oracle RDBMS (single instance and RAC) management and administration support for various applications and systems of ISG managed systems.- Troubleshoot any problems with the production servers regarding any database errors.- Analyze and sustain capacity and performance requirements.- Analyze, consolidate and tune database for optimal efficiency.- Monitor systems and platforms for availability.- Oversee backup, clustering, mirroring, replication and failover.- Restore and recover corrupted databases.- Install and test upgrades and patches- Communicates with monitoring team regarding issues.- Provide 24x7 on-call support to various systems assigned to our team.