Hector is available for hire
Hire HectorHector Guevara
Verified Expert in Engineering
Database Administrator and Developer
Peabody, MA, United States
Toptal member since August 25, 2023
Bio
Hector is an accomplished database administrator with 19+ years of experience in the retail, finance, manufacturing, aerospace, precision, education, insurance, and medical device industries. He holds a BS in Systems Engineering and is certified in Database Administration, Project Management, and Data Science from MIT. With expertise in Epicor implementation, project management, and database administration, Hector is dedicated to delivering tailored solutions and driving business success.
Portfolio
CNSWARE
Epicor, Database Administration (DBA), SQL Server Reporting Services (SSRS)...
Aqualite US
Database Administration (DBA), Vtiger CRM, Salesforce, Networking...
Philip Morris International
IT Project Management, Databases, Agile, Virtualization, Windows Server...
Experience
- SQL Server Reporting Services (SSRS) - 20 years
- SQL - 20 years
- ITIL V3 Foundation Certified - 15 years
- PMI - 13 years
- Epicor - 8 years
- baq - 8 years
- Epicor 10 - 8 years
- Dashboards - 8 years
Availability
Part-time
Preferred Environment
SQL, Epicor, Epicor 10, PMI, ITIL V3 Foundation Certified, SQL Server Reporting Services (SSRS), Dashboards, baq, BPM, Quick Ship
The most amazing...
...thing I've achieved is the Above and Beyond the Call of Duty (ABCD) Award, recognizing my dedication, motivation, leadership, and ability to learn on the fly.
Work Experience
Epicor Senior Analyst and Database Administrator
2018 - PRESENT
CNSWARE
- Oversaw, administrated, and assigned resources to our Epicor customers, ensuring each customer received the most suitable resources based on their specific requirements.
- Managed and implemented new projects, database schema, security measures, and database servers.
- Implemented PMI practices to organize the work of Epicor business analysts, specifically in areas such as Epicor 9, 10, and Kinetic.
- Handled Epicor implementation, migration, and server upgrades for Epicor 9, 10, and Kinetic and optimized databases and complex SQL queries.
- Designed and implemented high availability and disaster recovery processes, introduced a ticket system to manage incidents and workload for the business analyst team, and coordinated Epicor support, documentation, and training efforts.
Technologies: Epicor, Database Administration (DBA), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), E2E Testing, Data Migration, Training, BPM, baq, Dashboards, Enterprise Resource Planning (ERP), Empathy, Business Analysis, CTO, CRM Implementation (Salesforce), ETL, Amazon Web Services (AWS)
IT Lead
2018 - 2020
Aqualite US
- Crafted, implemented, and integrated new technologies, including CRM, domain, email, databases, and security measures.
- Designed and implemented the new building network and domain. Additionally, created and optimized databases and devised and executed high availability and disaster recovery processes and a reporting service repository.
- Optimized databases, oversaw the implementation of a new data center, including establishing backup policies and procedures, implemented peripheral security measures, and migrated Microsoft Office 365, Exchange 365, and SQL Server from 2005 to 2016.
Technologies: Database Administration (DBA), Vtiger CRM, Salesforce, Networking, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MySQL, SQL, Empathy, SMS Marketing, CTO, Salesforce Marketing Cloud, CRM Implementation (Salesforce), WordPress, Stripe, Google Analytics, Next.js, ETL, Python, Django, Redshift, Amazon Web Services (AWS), Amazon Elastic Container Service (ECS)
Project Leader | Project Manager
2014 - 2017
Philip Morris International
- Managed and implemented new technologies, maintained and stabilized existing technologies, and served as the key point of contact between stakeholders, providers, and users.
- Reduced incidents and issues by 60% following the service-level agreement (SLA).
- Took the lead in coordinating and implementing new system enhancements, managed upgrades enabling the seamless integration of new business units, and successfully migrated from Windows Server 2008 to 2012.
- Established and executed procedures to ensure business continuity, stabilized the system infrastructure for the Dominican Republic, Central America, and the Caribbean regions, and provided support, administration, and management for cloud services.
Technologies: IT Project Management, Databases, Agile, Virtualization, Windows Server, Enterprise Resource Planning (ERP), Empathy, Business Analysis, SMS Marketing, CTO, CRM Implementation (Salesforce), WordPress, Google Analytics, ETL, Redshift, Amazon Web Services (AWS)
Database Administrator
2012 - 2014
StateTrust Group
- Managed, implemented, and maintained new processes related to database security, tuning, administration, business intelligence, and other services.
- Configured and implemented data warehouse, business intelligence, and reporting services.
- Implemented and managed virtualization technology using Microsoft VMware.
- Migrated all physical servers to virtual servers and upgraded database servers from SQL Server 2005 to 2012.
- Updated security policies, including transparent data encryption, database security procedures, and SQL Server high-availability and disaster-recovery processes.
Technologies: Database Administration (DBA), Empathy, CTO, ETL
Database Administrator
2011 - 2014
Ciphertelecom (Data Credito: Dominican Credit Bureau)
- Managed, implemented, and maintained new processes related to database security, tuning, administration, business intelligence, and other services.
- Implemented and configured business intelligence (BI) tools and SQL Server Reporting Services (SSRS).
- Migrated all physical servers to virtual servers and also migrated and upgraded the database servers from SQL Server 2005 to 2012.
- Updated security policies to include measures such as transparent data encryption and implemented robust database security procedures.
- Delivered SQL Server high availability and disaster recovery procedures and set up a robust data warehouse.
- Used SAP PowerDesigner for database servers and database modeling optimization and Microsoft Hyper-V to implement virtualization technology.
Technologies: Database Administration (DBA), Virtualization, Hyper-V, Credit Scores, Empathy, ETL
Database Administrator
2010 - 2012
Instituto Tecnológico de Santo Domingo
- Spearheaded the server migration project and successful implementation of business intelligence and reporting services.
- Migrated and upgraded the database servers from SQL Server 2000 to 2008 and successfully implemented and migrated data for Jenzabar, a CRM system tailored for universities.
- Implemented SQL Server high availability and disaster recovery procedures.
Technologies: SQL, Database Administration (DBA), Jenzabar, Server Backups, Enterprise Resource Planning (ERP), Empathy, CRM Implementation (Salesforce)
Senior Database Administrator
2008 - 2009
Banco Dominicano del Progreso
- Implemented and configured business intelligence (BI) tools and SQL Server Reporting Services (SSRS).
- Migrated all physical servers to virtual servers and also migrated and upgraded the database servers from SQL Server 2005 to 2012.
- Updated security policies, including data encryption, and implemented robust database security procedures.
- Delivered SQL Server high availability and disaster recovery procedures and established a robust data warehouse.
- Used T-SQL coding, report design, and database tuning techniques to meet specific business needs.
- Spearheaded the implementation of enhancements into database procedures.
- Led and coordinated the integration of different services and platforms.
- Implemented and managed cloud services and virtualization technology.
Technologies: Database Administration (DBA), IT Project Management
Database Administrator
2008 - 2008
Banco Confisa
- Led and managed security measures, implemented database optimization techniques, established a backup system, and provided extended support to operators.
- Created a system to notify ATM issues, implemented and optimized a new CRM database, and set and monitored the backup system.
- Enhanced user access security and database security measures.
- Conducted database modeling, design, tuning, and optimization activities, implemented branch data mining techniques, high availability measures, and a repository server, and led the configuration and implementation of a server monitoring system.
Technologies: Finance, Database Administration (DBA)
Lead System Consultant
2003 - 2008
SIASoft (now Patridge Consulting)
- Supported the operations of 35 insurance brokers using the SIASoft system, which involved providing system, server, and database support.
- Migrated databases from FoxPro to SQL Server and from SQL Server 2000 to SQL Server 2005.
- Coordinated and provided training to all broker insurance users.
- Created, designed, and provided a system user manual.
- Led, tested, and approved new system features while managing the version control of the system.
Technologies: SQL, Visual FoxPro 9, C#, Customer Service
Experience
Credit Bureau Processing Improvement
In this project, I had the opportunity to introduce several beneficial improvements to the credit bureau database aimed at enhancing the speed of searches at the front office and optimizing operations at the back office. To achieve this, I implemented virtual machines to handle data rendering, resulting in a high availability system for both the application and database servers, which involved incorporating replication and failover clustering to ensure uninterrupted service. Additionally, I implemented data encryption measures and optimized various aspects, including index optimization, filegroup policies, and more.
Education
1998 - 2002
Bachelor's Degree in Systems Engineering
Pedro Henríquez Ureña National University - Santo Domingo, Dominican Republic
Certifications
SEPTEMBER 2022 - PRESENT
Applied Data Science Program
MIT Professional Education
JULY 2017 - PRESENT
Oracle: Index and Table Enhancements
Oracle University
JULY 2017 - PRESENT
Oracle: Customer Experience (CX) Cloud Training and Certification
Oracle University
SEPTEMBER 2016 - PRESENT
Project Management Professional (PMP)
Project Management Institute (PMI)
NOVEMBER 2011 - PRESENT
Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance
TeKnowLogic
JUNE 2011 - PRESENT
ITIL V3 Foundation Certified
Pink Elephant
Skills
Libraries/APIs
Stripe
Tools
Epicor 10, Hyper-V, Salesforce Marketing Cloud, Vtiger CRM, Google Analytics, Amazon Elastic Container Service (ECS)
Languages
SQL, Python, Visual FoxPro 9, C#
Platforms
WordPress, Salesforce, Amazon Web Services (AWS), Windows Server, Oracle, Jenzabar
Storage
SQL Server Reporting Services (SSRS), Databases, Database Administration (DBA), SQL Server Integration Services (SSIS), MySQL, Redshift
Frameworks
Next.js, Django
Paradigms
ETL, Agile, E2E Testing
Other
Dashboards, baq, CRM Implementation (Salesforce), Epicor, ITIL V3 Foundation Certified, Project Management Professional (PMP), Enterprise Resource Planning (ERP), Empathy, Business Analysis, SMS Marketing, CTO, PMI, BPM, Quick Ship, Data Science, Development, IT Systems Engineering, Customer Service, Finance, IT Project Management, Server Backups, Virtualization, Credit Scores, Networking, Data Migration, Training
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring