Senior Architect
2018 - 2021Apex 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 3Senior Database Administrator
2016 - 2020Apex 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 DatabasesSenior Database Administrator
2008 - 2016Construct 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
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
- Apex Supply Chain TechnologiesAmazon Aurora, PostgreSQL, Apache Kafka, Docker, Python 3
- Apex Supply Chain Technology Jenkins, Kubernetes, Docker, MySQL, Amazon Aurora, Oracle, Azure SQL Databases
- Construct ConnectSQL Server Integration Services (SSIS), Database Replication, T-SQL...
Experience
- SSRS 17 years
- Database Development 15 years
- Microsoft SQL Server 15 years
- SQL Server DBA 15 years
- Database Modeling 15 years
- MySQL 5 years
- PostgreSQL 3 years
- Oracle PL/SQL 3 years
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
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 3Tools
SSRS, Flyway, Keycloak, Docker Compose, Jenkins, AppDynamics, Visual Studio, MySQL WorkbenchParadigms
Database DevelopmentStorage
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 StudioPlatforms
Kubernetes, Oracle, Docker, Windows, Linux, Apache Kafka
Education
- Bachelor's Degree in Electrical Engineering Technologies1998 - 2003University of Cincinnati - Cincinnati, OH, USA
