Junior Database Administrator | MySQL, PostgreSQL, GCP CloudSQL, BigQuery

• Monitor and maintain 15 databases across production and lower environments, and troubleshoot replication between the MySQL replica and GCP CloudSQL.
• Resolved a replication failure from the MySQL replica to GCP CloudSQL triggered by a new stored procedure: traced the cause to the procedure running under the root account, and fixed it by creating a dedicated least-privilege user limited to INSERT access on a single database.
• Maintain automated database backups every 4 hours with 14-day retention (oldest backups deleted automatically), and built a restoration automation that recovers data to a chosen date.
• Create and maintain database tables, and apply the changes developers request.
• Investigate client-reported issues using GLB (Google Cloud load balancer) HTTP request logs, routed to BigQuery through a log sink. Built a Data Studio report showing the most frequently failing requests, and raised HubSpot tickets to get the data needed for tracing added to those logs.
• Deliver weekly, monthly, and ad-hoc client order reports and resolve report discrepancies. Built a Google Apps Script tool that pulls each client's orders by status (delivered, in progress, delayed, action required) and cleans the data for reporting.
• Build and maintain the HubSpot-to-BigQuery integration and produce weekly and ad-hoc reports from HubSpot data. Now automating report downloads to replace manual exports.

• Provided technical support for hardware and software issues and answered user inquiries.
• Managed IT inventory lists for branches in the Philippines, India, and the US.
• Performed hardware inventory audits, maintenance, troubleshooting, and equipment deployment across multiple branches.
• Handled user account onboarding and offboarding in line with security compliance requirements.
• Worked with other teams to resolve issues and escalated them when needed.
• Wrote documentation for new IT assets and updated existing documents after changes or upgrades.
• Logged and tracked issues in Jira, iTop, and HubSpot tickets until they were resolved.
• Fixed slow queries and tuned indexes to speed up data retrieval.
• Migrated a monolithic CRM database from local MariaDB to GCP CloudSQL using custom replication, and analytics reporting stayed at 100% uptime.
• Set up automatic archiving of GLB logs (network logs, HTTP request logs, and others) from BigQuery to a Google Cloud Storage bucket, which keeps them retrievable at a lower cost.
• Monitored virtual machine performance (storage, memory, error logs) across environments and worked with other teams to resolve incidents through Jira, iTop, and HubSpot.
• Built a Python data validation pipeline that tracks backup drive operations, audits integrity, and sends daily summaries of missing files.
• Built and maintained Data Studio dashboards for production and infrastructure KPIs, used by several global operations teams.
• Wrote a Google Apps Script tool that generates the HTML for marketing emails, cutting production time by up to 83% (1 hour to 10 minutes).

• Set up laptops and desktops and installed the onboarding and general applications.
• Applied OS and application patches on Windows machines using the Microsoft Download Center and on Mac machines using Jamf.
• Administered Microsoft 365, including the admin center, compliance, Teams, SharePoint, and OneDrive.
• Managed Active Directory and Azure AD.
• Audited IT hardware assets and evaluated whether devices were still usable.

• Set up the network for a building of several hundred employees: firewalls, switches, routers, Wi-Fi, and endpoints.
• Managed Active Directory and Azure AD.
• Reviewed daily system logs and ticket records to find recurring hardware and software problems to cover in user training.

As the sole IT staff member, supported IT infrastructure, managed Active Directory, performed preventive maintenance, and helped with system upgrades.