John D.
Senior Data Engineer | Database Architect | DBA
I specialize in AWS Aurora/RDS, Snowflake, Redshift, AWS Glue, MySQL, and PostgreSQL. My services include data migrations, database architecture, performance tuning, and data engineering. With 25+ years of experience, I help organizations modernize and stabilize production databases and build reliable data pipelines. ### Core Services - Database architecture and technical leadership - Cloud database migrations, upgrades, and modernization - Performance tuning, query optimization, and production troubleshooting - High availability, replication, and disaster recovery design - Backup and recovery strategy - Database health assessments and architecture reviews - ETL, data integration, and platform-to-platform migration - Master Data Management (MDM), data governance, and data quality initiatives - Database and data pipeline monitoring and observability ### Production Database Expertise Extensive experience supporting production MySQL, PostgreSQL, MariaDB, and Percona environments, including AWS Aurora MySQL, Aurora PostgreSQL, and Amazon RDS. Projects include complex database migrations and upgrades, replication troubleshooting, performance optimization, high-availability design, backup and recovery, and resolution of production reliability issues. My experience includes multi-terabyte databases and environments where minimizing downtime, protecting data integrity, and maintaining business continuity are critical. ### Data Engineering & Integration Design and development of reliable data pipelines and integration solutions using AWS Glue, PySpark, Python, SQL, and dbt. Experience integrating relational databases, cloud storage, and analytical platforms, including Snowflake and Amazon Redshift. Work includes ETL development, large-scale data movement, schema management, data transformation, pipeline troubleshooting, and automation of data processing workflows. ### Representative Technologies **Database Platforms** AWS Aurora MySQL • Aurora PostgreSQL • Amazon RDS • MySQL • PostgreSQL • MariaDB • Percona Server • Snowflake • Amazon Redshift • Supabase **Cloud & Data Engineering** AWS Glue • PySpark • Python • dbt • SQL • Amazon S3 • ETL • Data Integration • Data Migration **Monitoring & Observability** AWS CloudWatch • Performance Insights • Percona Monitoring and Management (PMM) • Grafana **Data Governance & Master Data Management** Semarchy xDM • MDM • Data Standardization • Data Quality • Data Validation