CIARA MIZTIE ARROYO
Binangonan, Rizal
Summary
Database Engineer with expertise in Database Design and Implementation. Delivered successful Project Support and Migration initiatives through Database configuration and administration skills. Focused on ensuring Security and Compliance while optimising performance.
Overview
16
16
years of professional experience
Work History
Database Engineer
Rimes Technologies Corporation
04.2024 - Current
- Subject Matter Expert to to the following tasks:
- Database Design & Implementation
- Project Support & Migration
- Maintenance, Monitoring & Patching
- Security & Compliance
- Collaboration & Documentation
- Technologies : MS SQL Server 2012-2022 ; Azure ;Failover Cluster and AlwayOn AG; IaC; Snowflake;
Database Administrator
NRI Australia & New Zealand
08.2021 - 04.2024
- Installing & configuring SQL Server in on-premises infrastructure and Azure VMs.
- Creating and managing database objects, users, roles, & permissions.
- Monitoring database performance & tuning database parameters.
- Implementing backup & recovery procedures.
- Ensuring database security & applying security patches & updates.
- Troubleshooting database issues & providing support to end-users & developers.
- Working with other IT professionals to integrate SQL server databases with other systems & applications.
- Migrating SQL Servers from on-prem to Azure Cloud.
- Ensuring compliance with industry standards & best practices.
- Technologies : MS SQL Server 2012-2022 ; Azure ;Failover Cluster and AlwayOn AG; Commvault
Database Support Engineer
TP-ICAP (Tullett Prebon – ICAP)
04.2019 - 06.2021
- Provide excellent technical support for Oracle, MS SQL, and MySQL Database technologies.
- Provide operational support for DB issues initiated from Incidents, Requests and Changes.
- Provide solutions and root-cause analysis of DB performance and Database related issues.
- Perform Database Installation, upgrade, and migration.
- Apply Database Patch in Oracle (DB and GRID Patch) and SQL Servers (Cumulative & Security Patch).
- Setup Availability group and Replication for MS SQL DBs.
- Perform Backup and Restore
- Performance monitoring / Testing and capacity planning.
- Creation / maintenance of full system documentation, including DR documentation and operational DB request and issues.
- Technologies : Oracle (11g,12c,19c) RAC, RMAN, Datapump, OEM, Dataguard, ASM
- MS SQL Server 2005,2008,2012,2014,2016,2017,2019 ; AlwayOn AG, Replication
- MySQL 5.7
Oracle/MS SQL server DBA
Yondu, Inc.
07.2018 - 02.2019
- Act as a Subject Matter Expert to all Non-Prod Project databases.
- Performed Database creation, Migration, Upgrade, DB Clone, RMAN backup/restore, Datapump.
- Monitored and update OEM 13c.
- Handled Database configuration, User and Object Management, Performance Issue.
- Coordinate with Oracle Support for in-depth technical issues.
- Created Documentation for Oracle Changes/Activities
- Delivered Knowledge Transfer to TA and Dev teams.
- Support MS SQL Server for non-prod databases.
- Installed SQL server to non-prod servers.
- Role : Associate Manager (Deployed in Accenture Philippines )
- Technologies : Oracle [(11g,12c) RAC, RMAN, Datapump, OEM
- MS SQL Server 2008, 2012
Oracle Database Administrator Level 3
DXC Technology
, Phillipines
08.2017 - 07.2018
- Administered more than 2,500 Oracle instances. (UNIX, Windows, Solaris platform).
- Handled Oracle Database Changes for any Customer’s request or DB configuration.
- Attended Bridge calls for any issues if requires DBA assistance.
- Handled Priority 1-2 (P1/P2) DB Incident tickets and helps L2s with P3-P4 incidents.
- Handled Dataguard monitoring, Golden Gate, Datapump or Active Cloning(RMAN) requests.
- Escalated a case to Oracle Support for in-depth technical issues.
- Performs backup and recovery through RMAN.
- Participated on Disaster Recovery Test (Failover/Switchover).
- Participated on rotational Shifting support.
- Technologies : Oracle (10g, 11g,12c) – RAC/EXADATA, Datapump, RMAN, DataGuard, Golden Gate
Database Administrator Expert
GLOBE TELECOM
10.2016 - 04.2017
- Managed database instances on 3 technologies (Oracle/MS SQL /MySQL).
- Acted as Subject Matter Expert on Oracle DBs and Operation support for non-Oracle.
- Monitor and analyze database object space and performance.
- Create resolution plan on database with problem record.
- Automate DBA tasks as necessary through cronjob and stored proc.
- Monitor backups and restore through RMAN, import and export DB files.
- Create and update Method of Procedures (MOP).
- 24x7 On-call support for escalated incidents.
- Log a case to Oracle Support for in-depth technical issues.
- Conducted Oracle trainings to level 2 supports as necessary.
- Technologies : Oracle (11g,12c), MS SQL Server 2008-2012, MySQL
Oracle Database Administrator
T-SYSTEMS MALAYSIA SDN. BHD
Malaysia
12.2014 - 09.2016
- Administered more than 3,000 Oracle databases. (UNIX and Windows platform)
- Helped MSSQL DBAs for handling incident tickets on MSSQL Server
- Pro-actively monitored 10g and 12c Oracle Enterprise Manager(OEM).
- Handled incident and change tickets through HP Service Manager tool.
- Managed database performance, capacity and availability.
- Performed backup and recovery.
- Identified database/OS/Storage issues with coordination from Server and Storage team.
- Participated in disaster recovery testing when required.
- Participated on a rotational weekend on-call and 24x7 shifting support.
- Automated/updated UNIX jobs through crontab as necessary to improve DBA tasks.
- Raised a case to Oracle Support for in-depth technical issues.
- Technologies : Oracle 9i/10g/11g/12c ; Exadata, RAC, Data Guard, MSSQL Server 2008-2012
Teradata DBA
TERADATA GCC PHILIPPINES INC.
Philippines
05.2013 - 05.2014
- Handled service requests, incidents and change implementation tasks assigned to Teradata DBA.
- Monitored backup/restore jobs on TARA GUI.
- Teradata Database structure administration: DDL and DML operations on databases, users, tables, indices, views, macros and stored procedures as required.
- Teradata data storage and space management: allocation, reallocation and modification of database, user or spool space as required. Sucurity and access managemet.
- Technologies : Teradata (13.10, 14), SQL Assistant, Teradata Viewpoint, Teradata Manager
Data Engineer – Oracle Apps DBA
HEWLETT- PACKARD AP (HK) Ltd.
Philippines
10.2011 - 04.2013
- Created and modified Oracle Database and UNIX accounts.
- Participated in database development and maintenance activities.
- Modified, test, released/deployed and maintained database objects. (i.e packages, procedures, triggers, indexes etc. ) as well as database security audit solutions.
- Managed database performance, capacity and availability
- Developed and maintained database support documentation.
- Data loading through sqlldr and toad utilities.
- Monitored database performance and pro-actively anticipates or identifies issues.
- (Philippines)
- Technologies : Oracle 10g, 11g, PL/SQL, SQL loader, UNIX shell scripting
Application Security Support
COMPUTER PROFESSIONALS, INC.
08.2010 - 09.2011
- Handled ticket requests as defined by Service Level Agreement (SLA) policies and procedures.
- Generated report using SQL plus/toad for massive requests based on Customer requirements.
- Assigned, changed and removed security roles and financial scopes through Client’s applications.
- Validated user’s access through Analyzer Checker access and LDAP.
- Processed Massive User registration requests and ensure proper escalation of requests if needed
- Technologies : Oracle SQL plus/Toad, UNIX shell scripting.
Education
Bachelor of Science - Information Technology
Technological Institute of the Philippines
Quezon City01.2010
Skills
- Oracle
- MS SQL Server
- Teradata
- MySQL
- Snowflake
- MS Azure
- AWS
- Windows
- Linux
- Solaris
- SQL Server tools
- Putty
- PowerShell
- Oracle Data Guard
- RMAN
- Datapump
- AlwaysOn Availability Group
- Replication
- Teradata Tools
- Commvault
- Redgate
- Druva
- Solarwinds Orion
- DPA
- Spotlight
- OEM
- Nagios
- SQL
- PL/SQL
- UNIX
- Teradata (BTEQ)
- Javascript
Timeline
Database Engineer
Rimes Technologies Corporation
04.2024 - Current
Database Administrator
NRI Australia & New Zealand
08.2021 - 04.2024
Database Support Engineer
TP-ICAP (Tullett Prebon – ICAP)
04.2019 - 06.2021
Oracle/MS SQL server DBA
Yondu, Inc.
07.2018 - 02.2019
Oracle Database Administrator Level 3
DXC Technology
08.2017 - 07.2018
Database Administrator Expert
GLOBE TELECOM
10.2016 - 04.2017
Oracle Database Administrator
T-SYSTEMS MALAYSIA SDN. BHD
12.2014 - 09.2016
Teradata DBA
TERADATA GCC PHILIPPINES INC.
05.2013 - 05.2014
Data Engineer – Oracle Apps DBA
HEWLETT- PACKARD AP (HK) Ltd.
10.2011 - 04.2013
Application Security Support
COMPUTER PROFESSIONALS, INC.
08.2010 - 09.2011
Bachelor of Science - Information Technology
Technological Institute of the Philippines