Jeremy Barrio
Verified Expert in Engineering
Database Administrator and Developer
Wellington, FL, United States
Toptal member since March 23, 2022
Jeremy is a Microsoft SQL Server database administrator and T-SQL developer offering nearly 15 years of experience working with SQL Server 2008-2019, developing T-SQL queries and stored procedures, managing database-related projects, monitoring and optimizing databases, and developing and maintaining recurring automated processes using SQL jobs, SSIS, and PowerShell. Jeremy enjoys learning new technologies and excels with replication, HA/DR, and clustering.
Portfolio
Experience
- Databases - 15 years
- Microsoft SQL Server - 15 years
- SQL - 15 years
- Business Intelligence (BI) - 15 years
- Database Replication - 13 years
- SQL Server DBA - 10 years
- Database Mirroring - 10 years
- Always On - 5 years
Preferred Environment
Windows, SQL Server DBA, Always On, Azure SQL, Business Intelligence (BI), Database Mirroring, Database Replication, Microsoft SQL Server, SQL, Windows PowerShell
The most amazing...
...SQL Server development work I've done is a project to automate student enrollment for Kaplan. I built a back-end solution in a 3rd-party application.
Work Experience
Senior Database Administrator
LexisNexis Risk Solutions
- Performed database maintenance and administration, performance tuning, troubleshooting, managing backups, security maintenance, monitoring, and disaster recovery.
- Configured and maintained DR solutions, including AlwaysOn, database mirroring, and peer-to-peer replications.
- Planned and performed SQL Server upgrades, migrations, and installations.
- Migrated databases from on-premises servers to Azure and AWS RDS.
- Automated solutions using PowerShell, SQL Server Jobs, and Ansible.
Senior Database Developer and Analyst
Hyster-Yale
- Implemented data migration from SAP Manufacturing to a SQL Server repository using Informatica Cloud and SQL Server.
- Handled data migration from various SQL Server instances into a centralized SQL Server repository using SQL jobs.
- Created documentation and trained employees on using the new system.
Senior Database Administrator
Kaplan Inc.
- Automated refreshes of Azure and SQL Server databases using PowerShell.
- Automated standard maintenance tasks for SQL Server and Azure databases.
- Supported database mirroring and peer-to-peer replication.
- Assisted in upgrade planning, testing, and deployment.
- Oversaw monitoring and maintaining system performance with tools such as SQL Sentry and SolarWinds.
Senior Systems Analyst
Kaplan University
- Oversaw maintenance and support of the SQL Server back end of a 3rd-party system containing thousands of tables, views, and stored procedures.
- Analyzed data schema, corrected defects in code when the application vendor was unable to provide solutions for defects, and developed code for in-house APIs.
- Served as lead developer on various projects, including design of the solution, coding, and documentation.
- Automated many financial aid functions that were previously run manually by integrating two 3rd-party applications.
SQL Developer
Open Finance Network
- Developed and maintained processes to aggregate data from websites, data feeds, and internal applications to create new (and update existing) clients and their accounts.
- Developed, deployed, and maintained reports for internal and external clients using T-SQL and SSIS packages.
- Managed schema changes (tables, stored procedures, functions, and views) related to enhancements to internal applications.
- Oversaw data migration and transformation between two concurrently running systems with different back-end structures.
Experience
Financial Aid Automation
Data Feed Automation
Failover Automation
Education
Master of Science Degree in Information Technology
Kaplan University - Davenport, IA, US | Online
Bachelor of Science Degree in Computer Science
Florida Atlantic University - Boca Raton, Florida, USA
Bachelor of Science Degree in Computer Engineering
Florida Atlantic University - Boca Raton, Florida, USA
Skills
Tools
Crystal Reports, SolarWinds, Terraform, Ansible, SQL BI Development Studio
Languages
SQL, Stored Procedure, Transact-SQL (T-SQL)
Paradigms
Business Intelligence (BI), ETL
Storage
SQL Server DBA, Databases, Microsoft SQL Server, Database Replication, Database Mirroring, SQL Stored Procedures, Database Modeling, Azure SQL, SQL Server Integration Services (SSIS)
Frameworks
Windows PowerShell
Platforms
Windows, Azure
Other
Always On, Data Modeling, Software Development Lifecycle (SDLC), Data Engineering, Software Development, Amazon RDS, SAP, Informatica Cloud, Data Analysis, SQL Design & Reporting, Documentation, Training
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring