Home > Candidates > Marvin Magdaluyo
Marvin Magdaluyo

CA, US

Phone: xxx-xxx-xxxx

Email: xxx@xxxx.xxx



  • Looking For: Database Administrator, Database Architect

  • Occupation: IT and Math

  • Degree: Bachelor's Degree

  • Career Level: Fully Competent

  • Languages: English

Career Information:

Sign up to view Marvin Magdaluyo's full profile.

Highlights:As a subject matter expert (SME) in my field of expertise, I have been deployed to different countries and was able to maintain and manage the entire company database globally, specifically: * Installation and Configuration of SQL Server Instance and Databases (MSSQL 2012/2008 R2/2005/2000) * MS SQL Migration strategy with minimal downtime * Implementing and Designing High Availability and Disaster Recovery (HADR) Solution based on the company Recovery Tim Objective * Maintaining and Performing Database Management Tasks * Managing and Designing SQL Server Security and Database Solutions * Backup and Recovery Solutions (Full, Differential, Transaction Log and Compression) * Monitoring, troubleshooting and resolving performance issues * Policy base management * SQL Server Reporting Services (SSRS) Installation, Configuration, Migration & Managing Security Permission * SQL Server Analysis Services Installation and Configuration * SSIS Development

Skills:MS SQL Server, Database Administrator, Database Architect, SSIS, SSRS, SSAS, Cloud Azure, Oracle Golden Gate

Goal:I am a highly technical professional with 15 years of experience in Information Technology, 13 years as a Database Administrator and Database Architect with solid exposure in Project Management and leading a team globally. Also, I am a result-oriented person and can adapt to changes that focus on designing, building and maintaining intensive transactions with high availability and disaster recovery solutions for the company.

Membership:Microsoft Professionals

Certification:Microsoft Certified Information Technology Professional (MCITP) Microsoft Certified Technology Specialist (MCTS) * PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 * TS: SQL Server® 2008 - Implementation and Maintenance * TS: Microsoft® SQL Server™ 2005 - Implementation and Maintenance * TS: Microsoft .NET Framework - Application Development Foundation Microsoft Transcript Link: https://mcp.microsoft.com/Anonymous//Transcript/Validate Transcript ID: 742220 Access Code: MGM6592006


Experiences:

Senior MS SQL Database Administrator 09/2013 - current
Tyche Consulting Ltd. ROHQ / Bodog Asia, Makati City, Philippines
Industry: Internet & Desktop Software Development Company
Senior MS SQL Database Administrator Level: Manager (Philippines) > Global DBA who supports London, Canada, Spain and Asia with 150+ SQL Server Instances > Production and Escalation (L3 | Tier 3) DBA
> Provide Database Infrastructure Setup (HA|DR), database monitoring, configuration and troubleshooting of server environment as well as analysis and resolution of performance issues (Server Health Check and Performance Report). > Deliver a high level of customer service and professionalism to all teams, client and vendor interactions > Plan, Install and Build, Manage, Support and Configure PRODUCTION and NON-PRODUCTION Servers based on company standards o 40+ Server builds have been made and all are SQL 2012 (DEV, INT “Functional”, TEST & PROD) o Only PROD and TEST “Load Testing” have SQL 2012 HADR Solution “AlwaysOn” (15 Server) Bodog Global Platform “BGP” (Web back office portal --- 3 Node and 2 shared cluster) o PROD OLTP Nodes 1 & 2 (AlwaysOn) “Active-Active”, Data Warehouse Node 3 & 4 (Windows/SQL Cluster) “Active-Passive” o SQL Server Reporting Services (SSRS) Installation, Configuration & (NON-PROD “3 SSSRS Server” | PROD “1 SSRS Server” – All using AlwaysOn Listeners) o Database configuration of CRM for AlwaysOn in all Nodes “Primary|Replica” > Dynamics AX (Financial System – 3 Node) o Implemented TDE with AlwaysOn for Dynamics AX DB’s on all nodes (UAT “Jan 25, 2015” & PROD “Feb 08, 2015”) > SharePoint (Employee portal – 3 Node) > Marval Ticketing System (2 Node) > TrendMicro Encryption Project (2 Node – SQL Cluster Setup) > Perform proactive alert monitoring and resolution on all database servers > Monitoring and troubleshooting of Oracle Golden Gate ETL Linked to SQL Server 2012 & Data Warehouse > Ensure that the HADR solution meets the recovery time and recovery point objectives not less than 10 minutes > Ensure 99.9 % uptime on all PROD environment > Provide on-call support (approximately 4-week rotation)--
MS SQL Architect 03/2013 - 09/2013
JP Morgan Chase & Co., Taguig City, Philippines
Industry: Banking and Financials
MS SQL Architect Level: Assistant Vice President > Responsible for the design, architecture, and implementation of the SQL Server 2008 R2. > Accountable for ensuring that the business and technical architecture of the delivered solution matches the Business functional requirements. > Provides technical expertise and ownership in the diagnosis and resolution of an issue, including the determination and provision of workaround solution. > Responsible for the support of all aspects of WSS Australia Operations.
* Active monitoring of supported applications and SQL database * Business support and provide solution for the business to improve performance * Problem investigation and correction * Mitigate the risk * Performance monitoring and tuning * Managed the Change management * Review and analyze developer project design and structure * Work closely with Global GTI team and DBA * Managed all SQL Server upgrade or migration--
MS SQL Database Administrator 06/2011 - 03/2013
Betting Technology Inc. (Betsson), Makati City, Philippines
Industry: Internet Swedish Gambling
MS SQL Database Administrator Level: Lead DBA in Philippines > Ensure 99.9 % uptime on PROD environment (MS SQL 2008 R2) > Manage and Administer databases in the DEV, UAT, QA and PROD environments using SQL 2008 R2 > Adhere to IT production change control policies and procedures > Act as the gatekeeper of the production SQL Servers; deploy all production changes to the database > Tune the SQL server databases and proactively identify areas for database optimization > Work with the team to troubleshoot and root cause outages
> Review proposed schema changes and other database artifacts such as stored procedures, views etc. and provide best practice and optimization feedback > Develop standards for change management and deployment process for database schema’s and reference data changes (Batch scripts execution) > Database maintenance (DBCC, Update Stats & Index Optimize “Reorganize/Rebuild”) > Setup SQL Database Mail > Automate Backup (Full, Differential & Log) > Shrink PROD Copy DB (500+ GB to 200+GB) and restore to PT & QA to maximize disk space > Server monitoring using MS SQL Profiler > Red Gate Tool “SQL Monitor, SQL Compare, SQL Multi Script, SQL Prompt”--
Database Administrator 2 03/2006 - 06/2011
AIG Shared Services Philippines, Makati City, Philippines
Industry: International Insurance
Database Administrator 2 Level: Lead DBA for MS SQL Servers > Primary DBA in MS SQL Server concerns (2000/2005/2008) > Primary DBA for MS SQL Server Installation & Migration > Primary DBA for Disaster Recovery Plan for MS SQL Server (Production) Databases > Primary DBA for MS SQL Server 2008 Transparent Database Encryption > Primary DBA for SQL Server 2005 Cell Level Encryption
> Support Microsoft Dynamic NAV (For Finance Department) > Support ACCUITY “FACFILTER” application used to trace terrorist > Support QUOTIUM "CYRANO" designed specifically to help DBAs, Developers and Quality Analyst optimize and fine-tune performance of applications in SYBASE Database Server. > Review Data Centre DB Operations o DB Server Installation/Maintenance (SQL Server/SYBASE ASE/Oracle) o Error Resolution (SQL Server/SYBASE ASE/Oracle) o DB Backup (SQL Server/SYBASE ASE/Oracle) o Compliance to standards/security (SQL Server/SYBASE ASE/Oracle) > Provide extensive Tier1&2 support to sites > Prepare training documents or presentations > Review business cases, injects DB perspective inputs/changes > Mentor Junior DBA > Represent the team in Project meetings, handle escalation issues from sites, present recommendations and alternatives for DB-related concerns/changes--
Consultant 11/2005 - 02/2006
System Generators Philippines Inc., Makati City, Philippines
Industry: Recruitment outsourcing company specializing in IT
Consultant Level: Contractual basis > Deployed in Orient Overseas Container Line (OOCL) for Production Support under Information Management Reporting System (IMRS) using SYBASE ASE, Visual Basic 6, Actuate Reports 7 and UNIX.
* Grant user access permission international and locally * Fix system web application defects using Actuate Reports 7 and Sybase 11/12 Database * Investigate on system application defects and implement efficient actions--
Unit Head, IT-Application Development Division 03/2002 - 11/2005
Quedan and Rural Credit Guarantee Corporation, Quezon City, Philippines
Industry: Republic of the Philippines Government
Unit Head, IT-Application Development Division Level: Team Lead > Lead System and Application DBA using MS SQL 2000 and MS SQL 2005 > Lead in Deployment of System Application Nationwide > Lead in Application Development using C# .net 2.0, VB 6, Crystal Reports
* Responsible for Installation & Configuration MS SQL Server Setup * Responsible for Backup & Recovery * Assist the team in Normalization of Database and Tables structures * Assist, Mentor & Checks Programmers codes based on programming standards * Created/Implemented Loan Monitoring Data Extraction Application distributed nationwide, VB scripting that extract all daily transaction of district offices to a file then encrypt and compress the files. * Created/Implemented Quedancor SQL writer, this application segregates/decrypt all SQL scripts nationwide and will be used to upload all daily transaction made by district offices to MS SQL Server database. * Created/Implemented Integrated Loan Monitoring System to be distributed nationwide. The system was made to accommodate the need of the organization to monitor the payments, balance and amortization schedule of each borrower in all district offices. * Created/Implemented Property Supply Division System for Property and Supply Department. The system was developed to facilitate the monitoring of the implementation of purchasing and inventory system. This supervises purchased report and memorandum receipt for all employee / department. * Created/Implemented Remedial Management Division System. This covers remedial action on problematic accounts and management disposition of acquired asset. The system was made to monitor all payments made by the clients in all region and district offices in the Philippines. It can monitor all loans in arrears accounts, outstanding balance, debt moratorium, loan restructured accounts and past due loans.--

Education:

University of the East 06/1993 - current
Caloocan City, Manila, Philippines
Degree: Bachelor's Degree
Major:Electronics and Communication Engineering
Took up Engineering but decided to pursue my passion and work in the IT industry for more than a decade.


Polytechnic University of the Philippines 06/2012 - 12/2012
Sta Mesa, Manila, Philippines
Degree: Bachelor's Degree
Major:Information Technology
Graduated in the Philippines in Bachelor of Science in Information Technology

Download Resume(Available to Employers Only):

Login to view resume: Marvin_Magdaluyo -



More About Marvin Magdaluyo
Please sign in or sign up an employer to view Marvin Magdaluyo's personal information.

  • Phone: xxx-xxx-xxxx
  • Email:xxx@xxxx.xxx
  • Visa: -
  • Work Authorization: -
  • Expected Salary: -
  • Intests & Hobbies: -