Sam Meshesha, Database Administrator and Developer in Cincinnati, OH, United States
Sam Meshesha

Database Administrator and Developer in Cincinnati, OH, United States

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.
Sam is now available for hire

Portfolio

Experience

Location

Cincinnati, OH, United States

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.

Employment

  • 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, Microsoft SQL Server

Experience

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

Skills

  • Languages

    SQL DDL, SQL, T-SQL, Python 2, JavaScript, Java, Python 3
  • Tools

    SSRS, Flyway, Keycloak, Docker Compose, Jenkins, AppDynamics, Visual Studio, MySQL Workbench
  • Paradigms

    Database Development
  • Storage

    Database Modeling, SQL Server DBA, Database Triggers, 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

Education

  • Bachelor's Degree in Electrical Engineering Technologies
    1998 - 2003
    University of Cincinnati - Cincinnati, OH, USA

To view more profiles

Join Toptal
Share it with others