Jeremy Barrio, Developer in Wellington, FL, United States
Jeremy is available for hire
Hire Jeremy

Jeremy Barrio

Verified Expert  in Engineering

Database Administrator and Developer

Location
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.

WindowsSQL Server DBADatabasesMicrosoft SQL ServerSQLCrystal ReportsBusiness Intelligence (BI)Azure SQLWindows PowerShellAmazon RDSTerraformAnsibleSQL Server Integration Services (SSIS)ETLData Engineering

Portfolio

LexisNexis Risk Solutions
SQL Server DBA, Business Intelligence (BI), Always On, Azure SQL...
Hyster-Yale
SQL, SAP, Informatica Cloud, Data Analysis, SQL Design & Reporting...
Kaplan Inc.
SQL, SQL Server DBA, Business Intelligence (BI), Azure SQL, Windows PowerShell...

Experience

Microsoft SQL Server - 15 yearsDatabases - 15 yearsBusiness Intelligence (BI) - 15 yearsSQL - 15 yearsDatabase Replication - 13 yearsSQL Server DBA - 10 yearsDatabase Mirroring - 10 yearsAlways On - 5 years

Availability

Full-time

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

2019 - PRESENT
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.
Technologies: SQL Server DBA, Business Intelligence (BI), Always On, Azure SQL, Database Replication, Database Mirroring, Windows PowerShell, Microsoft SQL Server, Databases, Amazon RDS, Terraform, Ansible, SQL Server Integration Services (SSIS), Windows, Software Development Lifecycle (SDLC), ETL, Data Engineering, Data Modeling, SQL Stored Procedures, Stored Procedure, Azure, T-SQL (Transact-SQL), Database Modeling

Senior Database Developer and Analyst

2022 - 2023
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.
Technologies: SQL, SAP, Informatica Cloud, Data Analysis, SQL Design & Reporting, T-SQL (Transact-SQL), Documentation, Training, Database Modeling

Senior Database Administrator

2012 - 2019
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.
Technologies: SQL, SQL Server DBA, Business Intelligence (BI), Azure SQL, Windows PowerShell, Database Mirroring, Database Replication, SolarWinds, SQL Server Integration Services (SSIS), Windows, Software Development Lifecycle (SDLC), Databases, Microsoft SQL Server, ETL, Data Engineering, Data Modeling, SQL Stored Procedures, Stored Procedure, Azure, T-SQL (Transact-SQL), Database Modeling

Senior Systems Analyst

2009 - 2012
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.
Technologies: SQL, Crystal Reports, Business Intelligence (BI), SQL Server Integration Services (SSIS), Windows PowerShell, Windows, Software Development, Software Development Lifecycle (SDLC), Databases, Microsoft SQL Server, ETL, Data Engineering, Data Modeling, SQL Stored Procedures, Stored Procedure, T-SQL (Transact-SQL)

SQL Developer

2006 - 2009
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.
Technologies: SQL, Business Intelligence (BI), SQL Server Integration Services (SSIS), Windows, Software Development, Software Development Lifecycle (SDLC), Databases, Microsoft SQL Server, ETL, Data Engineering, Data Modeling, SQL Stored Procedures, Stored Procedure, T-SQL (Transact-SQL)

Financial Aid Automation

Kaplan University needed to automate the packaging of students' financial aid packages. They looked into many technologies, and their student management system vendor began development on an upgrade to accommodate the request. This effort would take years, and the business needed a solution as soon as possible. After weeks of proposing solutions, I was able to pitch a solution using the SQL Server back-end solely. I was able to modify the 3rd-party database by adding tables, stored procedures, and functions to completely automate the packaging of students' financial aid. This was the biggest savings the company had ever had in one project.

Data Feed Automation

I developed several processes to automate the importing of data feeds from banks. Clients needed their financial information imported from external banks and imported into our financial reporting system. I used SSIS to import files, parse the data, convert it, and upload the data into our client records.

Failover Automation

The client used a combination of mirroring and log shipping as a DR solution, and failing over to DR took over four hours. I used PowerShell and T-SQL to automate failovers and reduce the time to only four minutes.

Languages

SQL, Stored Procedure, T-SQL (Transact-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)

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

Frameworks

Windows PowerShell

Platforms

Windows, Azure

Tools

Crystal Reports, SolarWinds, Terraform, Ansible

2012 - 2013

Master of Science Degree in Information Technology

Kaplan University - Online

2003 - 2008

Bachelor of Science Degree in Computer Science

Florida Atlantic University - Boca Raton, Florida, USA

2003 - 2008

Bachelor of Science Degree in Computer Engineering

Florida Atlantic University - Boca Raton, Florida, USA