Description

Senior DBA with 23+ years of experience across PostgreSQL, MySQL, and SQL Server. I specialize in performance tuning, automation, configuration management, and observability. Skilled in Python, Bash, and PowerShell scripting to streamline operations. Experienced with large-scale deployments in both cloud (GCP, AWS) and on-prem environments.

Industry field of expertise

Languages

English
Native or bilingual
Russian
Fluent
Turkish
Conversational
German
Basic
Spanish
Basic

Workplace preferences

Remote only

Primarily works remotely

Core Data LLC
Independent Consultant (1099 Contractor)
CONSULTING AND AUDITS
July 2023 - Today (2 years and 11 months)
Hired by multiple clients to solve difficult database issues. Highlights include:
• Upgrade mission-critical, multi-terabyte MySQL web store with over a billion dollars of annual sales from version 5.7 to 8.0 with no downtime while moving to GTID-based replication behind a ProxySQL cluster
• Upgrade mission-critical, multi-terabyte PostgreSQL installation from version 13 to 17. Implemented failover management with Patroni and connection pooling and load balancing using pgpool2 and HAProxy
• Created Data Synchronization project to identify, correct, and prevent database drift among thousands of Windows-based MySQL instances using skeema.io
• Health Checks for PostgreSQL and MySQL installations for clients
PostgreSQL MySQL Database administration SQL Server Transact-SQL
Sweetwater Sound
Manager of Data Engineering
E-COMMERCE
January 2022 - July 2023 (1 year and 6 months)
• Responsible for a team of three Data Engineers and two Database Administrators
• Championed the creation of an Enterprise Lakehouse (Debezium, Kafka, and Big Query) integrating of various data systems and unleashing powerful predictive analytical insights.
• Brought together data from disparate systems in the Enterprise Lakehouse, which could previously only be done with Domo loads with full time travel capability include: PostgreSQL, MySQL, MongoDB
• Installed and configured DataHub to catalog our data systems opening the door to data governance and compliance efforts
Google cloud Team management BigQuery PostgreSQL MySQL
Sweetwater Sound
Open-Source Database Administrator
E-COMMERCE
June 2021 - January 2022 (7 months)
• The first official DBA to be hired in company's long history to manage large PostgreSQL and MySQL instances running on bare metal Linux servers
• Created and enforced standardized role-based Principle of Least Privilege database access eliminating over-permissioned shared account access across database systems
• Introduced DPA and subsequent integrations for Data Dog for database server observability and to identify problem queries and create indexing strategies
• Created centralized logical replication extracts from on premises instances to GCP to support Microservices development efforts in CloudSQL with real-time data
PostgreSQL MySQL SQL Server Google cloud Data Lake

Check out Jason's experience

Be the first to recommend Jason

Help this freelancer shine by sharing your experience working together.

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

Baptiste Duhen

Fullstack developer

4.6

(4)

Amed Hamou

Senior Lead Developer

(2)

Audrey Champion

Web developer

4.3

(3)

Signup to reveal

M.S. Data Science
Indiana University Bloomington
2019
M.S. Data Science
B.A. Slavic Languages & Literatures
Indiana University Bloomington
1999
B.A. Slavic Languages, Minor in Computer Science

Check out Jason's education

Data Analyst

Jason Carlson

Database Administrator | SQL Server, PostgreSQL

About Jason

Experience

Recommendations

These freelancer profiles also match your criteria

Education

Skill set

Categories