Sam Meshesha, Developer in Cincinnati, OH, United States
Sam is available for hire
Hire Sam

Sam Meshesha

Verified Expert  in Engineering

Database Administrator and Developer

Location
Cincinnati, OH, United States
Toptal Member Since
June 18, 2020

Sam is a database administrator and developer with over 15 years of demonstrated experience in IT and a proven history for delivering exceptional software products. Thanks to his passion for building strong teams of individuals—and getting the most out of them—along with optimizing processes, Sam excels at helping a business become more efficient. Sam joined Toptal so that he could use his expansive and in-depth SQL knowledge to make meaningful, impactful contributions within an organization.

Portfolio

Apex Supply Chain Technologies
Amazon Aurora, PostgreSQL, Apache Kafka, Docker, Python 3
Apex Supply Chain Technology
Jenkins, Kubernetes, Docker, MySQL, Amazon Aurora, Oracle, Azure SQL Databases
Construct Connect
SQL Server Integration Services (SSIS), Database Replication...

Experience

Availability

Part-time

Preferred Environment

Linux, Windows, MySQL Workbench, SQL, SQL Server Management Studio, CODE, Visual Studio

The most amazing...

...project I've developed is an OLTP database system to support a SaaS application with sub-second transaction response times and manage over 2TB as active data.

Work Experience

Senior Architect

2018 - 2021
Apex Supply Chain Technologies
  • Developed a database to house a mobile application using a Postgres database.
  • Architected and developed business insight mart infrastructure.
  • Developed a data-mart to report on two distinct platforms using Amazon Aurora Postgres.
  • Worked with Debezium Kafka-connects to ingest data from MS SQL, MySQL and AWS DynamoDB and store to Kafka topics.
  • Developed a service to read Kafka topics and route them into a Postgres database using Python.
Technologies: Amazon Aurora, PostgreSQL, Apache Kafka, Docker, Python 3

Senior Database Administrator

2016 - 2020
Apex Supply Chain Technology
  • Migrated an existing app database using Oracle 11g to Microsoft SQL Server hosted on Azure. The tasks involved a lot of details—converting exiting schemas to their equivalent in Microsoft SQL Server and data type conversion with minimal data loss.
  • Identified poorly performing data structures, procedures, and application workflows; then optimized the stored procedures, updated the applications workflows with the appropriate development team which resulted a 100% application performance gain.
  • Aligned with DevOps' overall goal to achieve continuous integration and deployment, and completed the automated deployment of MySQL database into AWS Aurora infrastructure with the use of flyway and multi-branch Jenkins pipelines.
Technologies: Jenkins, Kubernetes, Docker, MySQL, Amazon Aurora, Oracle, Azure SQL Databases

Senior Database Administrator

2008 - 2016
Construct Connect
  • Architected and implemented the new OLTP databases for the company that would sustain the future growth of the organization.
  • Ensured that all platforms could link all customer data (regardless of platform) to become one seamless app. Assessed the needed infrastructure for all data and installed and configured SQL Server to consolidate various databases.
  • Implemented a process and solution for high availability and disaster recovery.
  • Built utility SQL servers on virtual and clustered machines to consolidate various application SQL servers—resulting in a streamlined administration, license, and hardware cost savings of $20,000.
  • Created analytic reports, heat maps, and forecasting models for infrastructure capacity planning using SCOM data warehouse in conjunction with additional performance statistic sources. This optimized the budget and capacity planning process.
  • Delivered a seamless customer experience across two platforms using Service Broker allowing the network to exist for customers using two different platforms.
Technologies: SQL Server Integration Services (SSIS), Database Replication, T-SQL (Transact-SQL), Microsoft SQL Server

Construction Bidding Platform for a SaaS Organization

I built a web-based application to manage the process in which general contractors manage and send their invitations to bid on projects.

The software is built on the strength of the database of subcontractors, vendors, projects, and architects. The application allowed subcontractors to quickly estimate project costs, allow them to bid on construction projects, and general contractors could select and award bids to subcontractor vendors. In addition, it provided notification and messaging tools.

Smart Device Platform for Supply Chain Delivery

I built a cloud-hosted platform to support a user interaction workflow engine on deployed devices and aggregate user transactions for insightful dashboards while providing a 99.99% uptime SLA. It also has a microservice architecture with various data storage solutions.

Associate Information Management System

I developed a web-hosted application that managed call center associates' work hours, training sessions, and support hours. The application was integrated with HR software (PeopleSoft) for payroll and administrative purposes. It included a highly redundant database in an active/active cluster with SQL Server Service Broker for transaction coordination.

Languages

SQL DDL, SQL, T-SQL (Transact-SQL), Python 2, JavaScript, Java, Python 3

Tools

Flyway, Keycloak, Docker Compose, Jenkins, AppDynamics, Visual Studio, MySQL Workbench

Paradigms

Database Development

Storage

Database Modeling, SQL Server DBA, Database Triggers, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Service Broker, Microsoft SQL Server, Azure SQL Databases, Amazon Aurora, Oracle PL/SQL, Database Caching, Database Replication, MySQL, PostgreSQL, SQL Server Management Studio

Platforms

Kubernetes, Oracle, Docker, Windows, Linux, Apache Kafka

1998 - 2003

Bachelor's Degree in Electrical Engineering Technologies

University of Cincinnati - Cincinnati, OH, USA