Victor Arquero

SQL Database Administrator @Atos

Database ManagementSQLETLDatabase Administrator✔️ ITPowerBI

I am Victor Guzman Arquero, a seasoned and passionate Microsoft SQL Database Administrator with more than 30 years of combined experience as a database administrator. I have in-depth experiences in managing SQL Servers from version 7 to 2022 either the instance is on Azure or on-premises. I administer SQL Servers of various kinds such as Dev, QA, STG, UAT, Prod, or DR. I have a strong foundation in SQL clustering, AlwaysOn High Availability Group, or other DR solutions like replication, log shipping, or database mirroring. I have a deep understanding of backup and restore either using native or third-party backup solutions. I have immense experiences in automating database maintenance tasks to ensure availability and optimal performance of T-SQL queries. I have good experiences to share about troubleshooting SQL Server related incidents. I have strict experiences in securing SQL Servers and databases in accordance with SOX, ISO, HIPAA, and PCI requirements.

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Network Power<100 people

Roles

✔️100%

✨100%

Business Owner

📝100%

Influencer or Blogger

Geos

🇬🇧100%

United Kingdom

Work Background

AtosDatabase Administrator

Nov. 2023RemoteWorks as one of the Senior Microsoft SQL Database Administrators of the company.

DynaQuest Technology Services IncDBA Consultant

Mar. 2014 - Apr. 2024Philippines · RemoteProvides efficient database administration support to the clients of the company.

Fidelity & Guaranty LifeDBA Contractor

Mar. 2014 - Mar. 2024United States · Remote- Planned, implemented, maintained, optimized, and managed SQL Servers of the company both on-premises and SQL in Azure VM - Monitored the health and performance of the SQL Servers of the company using native tools and Spotlight by Quest - Ensured that the databases of the company are backed up appropriately and can be recovered correctly and quickly in the event of failure. Backups are configured either native, Rubrik, or Azure Backup Center - Ensured that the databases are protected and secured by applying only access that is reviewed and authorized - Assisted in upgrading, migrating, or installing and configuring new SQL Instances based on the standards of the company - Assisted in managing and restoring production to non-production databases for application development teams - Provided day-to-day support to the business by implementing approved change requests, assisted in remediating incidents, assisted in query tuning and troubleshooting of slow performing queries, and remediated space issues related to transaction log files consuming all space on the drive. - Ensured that all data loads and downstream jobs were completed successfully before business hour begin - Planned, configured, and maintained Transactional Replication for distribution and availability of lookup data from a main system to downstream processes - Supported SSRS, SSIS, JAMS Scheduler, and Informatica applications while maintaining the database environments of the company

TeleTechSenior Database Administrator

Jun. 2016 - Oct. 20232nd Floor, Robinson Plaza, Epifanio Delos Santos Avenue, Mandaluyong City · Remote- Managed and supported the corporate Microsoft SQL Servers of the company. - Spearheaded the development of a T-SQL based monitoring solution that supplements Solarwinds' Database Performance Analyzer formerly known as Confio Ignite. - Acted as SME for Microsoft SQL Server and as handyman in maintaining the SQL Servers of the company in all aspect for more than 7 years. - Spearheaded the design, planning, and implementation of the resilient database repository of OpManager Monitoring by Manage Engine using AlwaysOn High Availability Group. OpManager Monitoring was the chosen enterprise monitoring solution of the company - Spearheaded the design, planning, and building the Proof-Of-Concept for NICE DR using Multi-Site AlwaysOn Availability Groups. - Worked hand-in-hand with the Development Team in checking and remediating database related incidents, space issues due to ballooned transaction log or data files; and assisted in query tuning and troubleshooting of slow performing queries. - Worked on upgrading old versions of SQL Servers to recent versions; Decommissioned SQL Instances that are no longer in-used; installed Service Packs, Cumulative Updates, and essential security patches to ensure that SQL Servers of the company are up-to-date and PCI compliant. - Ensured that database backups can be recovered in case of failure; Performed test restores; Worked in the preparation of database schema and backup of essential database for Cold Storage. - Performed Quarterly review of users with full access and users with above read-only access to SOX databases of the company to ensure that all access is legitimate and authorized - Supported the business in maintaining its GCP projects; Assisted in refreshing and synchronizing data between regions or projects; Deployed approved job, task, triggers, connections, or updates to Production Talend Environment; Assisted in maintaining the ACL of the various GCP projects of the company.

Xerox Business Services Philippines, Inc.Database Administrator

Jun. 2010 - Apr. 2016PH : One-E-Com SM MOA Complex | US : 101 Yorkshire Blvd., Lexington, KY 40509• Spearheaded the development and continues improvement of a T-SQL base Centralized Monitoring Solution for SQL Servers that monitors 17 Divisions; the System was highlighted in Recent Successes and People in the Spotlight Section of the March 2013 HPP-IT Organization Newsletter on its feature that automatically attempts to release unused space from top data or transaction log files of SQL Servers ranked in terms of unused space when critical disk space situations are detected; this success reduced disk-space related Incident Tickets by 45%. • Developed and managed both ASP (classic and .net) and SSRS Reports about the data collected from the SQL Servers of each division • Designated as 2nd Shift DBA Manager in the US since February 1, 2011 • Administered and managed SQL Servers from multiple divisions of HealthCare Payer and Pharma Services and RTI • Proactively monitored SQL Servers and databases to ensure minimum downtime • Monitored more than 1000 MS SQL Servers (with types : Production, Staging, QA, Testing, and Development; with versions : 2000, 2005, 2008(R2), 2012, and 2014) • Monitored more than 10000 different MS SQL Databases • Automated and managed regular database maintenance tasks • Installed, configured, and upgraded SQL Servers as needed • Supported Production Control and Development in deployments, code reviews, troubleshooting and resolving SQL Server related problems such as slowness, time-out expired, permission issues, and failure of connections

Affiliated Computer Services of the PhilippinesDatabase Administrator

May. 2008 - Aug. 2009PH : One-E-Com SM MOA Complex | US : 101 Yorkshire Blvd., Lexington, KY 40509• Managed SQL Servers that range from Version 7, 2000, or 2005 • Managed SQL Servers that are clustered into 2, 3, or 4 nodes • Automated and managed regular maintenance tasks • Monitored and managed SQL Servers with the aid of Idera SQLdm • Ensured that automated backup jobs completed successfully • Supported Production and Development Teams in troubleshooting and resolving SQL Server related problems such as slowness, time-out expired, permission issues, critical remaining free disk space, and failure of connections • Created or authenticated new login(s) based on approved access request tickets

Freelance System DeveloperFreelance System Developer

Jan. 2000 - Dec. 2007PhilippinesDeveloped the following applications : • GenServe International, Inc. Satellite Recording and Job Order System. Implemented on November 2007; records infromations about the satellite units of GenServe (http://www.genserv-ph.com/) and tracks the job orders of the company for maintenance; Bangkal, Makati City • Global Pacific Conglomerates Inc. Recording System. Implemented on November 2005; records the Dream-Nokia Transactions of GPCI; Legaspi Village, Makati City • Regional Development Council Region 02 Resolution Tracking System. Installed on March 2003; multi-user application using Visual FoxPro 6 • Saints Peter and Paul Metropolitan Cathedral Record System at Tuguegarao City. Installed and implemented on January 2002; multi-user application using Visual FoxPro 6 • Saint James Parish Record System at Santiago City. Installed and implemented on January 2001; multi-user application using Visual FoxPro 6 • Vulauan na Ciudad na Tuguegarao 2001 Tabulation System; multi-user application using Visual FoxPro 6, in collaboration with AMA Computer College, Tuguegarao City; utilized on August 15, 2001

Cagayan State UniversityInstructor I

Dec. 1999 - Jun. 2003Tuguegarao City, PhilippinesTaught computer and general mathematics subjects such as Finite Automata, Data Structure and Algorithm, Logic Circuit, Algebra, Trigonometry, Numerical Methods, Data Structure, Database Management, Computer Fundamentals, Basic Computer Programming (C++, VB, FoxPro), and Advance Computer Programming (VB and SQL)

Western Isabela Polytechnic CollegeInstructor

Jun. 1999 - Dec. 1999Mallig Plains, Isabela, PhilippinesTaught computer and general mathematics subjects such as Algebra, Trigonometry, Data Structure, Database Management, Computer Fundamentals, and Basic Computer Programming (C++, VB, FoxPro)

OSRP, LLC.Database Administrator

Sep. 2009 - Jun. 2010PH : EDSA Central, Mandaluyong City | US : Torrance, California USA• Managed and supported development, staging and production SQL Servers of PC Mall (www.pcmall.com) • Installed SQL Server Instances and setups new replication objects as needed • Monitored replications and ensured that SQL Servers are all synchronized; resolved replication issues as well • Worked closely with the Development Team in troubleshooting and resolving SQL Server related problems such as slowness, poorly performing routines, time-out expired, missing or fragmented indexes, and not synchronized data among servers • Wrote Database Design Documentations on some assigned projects • Worked closely with the other DBAs of the company to ensure smooth transition of tasks and pending issues

Cyber City TeleservicesDatabase Administrator I/II

Dec. 2005 - May. 2008On-site• Managed the SQL Servers of the company • Prepared a fail-over process to critical SQL Servers through transactional replication and scheduled synchronization of server objects and permissions from the primary server to the backup server • Applied tight security measures in consonance with the security certifications of the company • Administered Replications and Multi-server Systems • Established remote data migration through replication and data transformation services • Established remote data migration from Informix Database to MS SQL Database • Worked with the developers and helped in the design and optimization T-SQL Queries

Cyber City TeleservicesProgrammer I/II/III

Jun. 2003 - Dec. 2005• Spearheaded the development of the Payroll System of the Company. The system processes the time being captured on the TimeKeeping System into a useful Payroll Information • Headed the research and design of the Scheduling and Forecasting System that uses Erlang C computation in allocating the required number of agents based from the obtained call trends in the past and significant parameters given by the clients • Headed the design, development, and implementation of the TimeKeeping Systems for both Operations and Administrative Employees. For Operations, the system captures the actual working hours of the employee while working in-front of his/her terminal and the data captured will be used as basis of his/her payroll • Developed an Avaya G3 Listening System. The system directly listens to a broadcasting port of the Avaya G3 System then records the captured call information to a SQL Database • Developed SQL Sentinel System. The system is capable of tracking insert, update, and delete events on SQL Databases • Redeveloped and enhanced the original SQL Object Editor for Stored Procedures and UDFs. The system is capable of keeping an audit trail on every change users will do • Customized Microsoft SMS Sender to become an SQL Server SMS Alert Notification System • Member developer of the HRIS of the Company • Developed the Prototype of the Workforce Management of the Company and primarily programmed the following modules : - CCTL-WFM Payroll System - Call History Plotter - Attendance Viewer/Verifier - CSR's Schedule Loader - Incentives Monitoring and Report Generator • Designed and Completed the Following Programs : - CCTLPro Information System, pro HR Information System - CCTL Medical Information System, records the Medical Activities of CCTL Employees - CCTL Medicine Inventory System, records the inventory of Medical Supplies in CCTL • Worked as Database Developer and Designer of databases being used on the above mentioned systems