Data Architecture GCP Platform, Snowflake Implementation,Kafka data pipelines, BigQuery implementation. Researched and implemented Apache Iceberg universal data storage, sharing data between Snowflake and BigQuery, working on Polaris Catalog

Data Architecture, Data Governance, LLM's AI & MLDesign and implement Google Cloud gap Data Lake. Data Lake design and implementations using gcp Data Plex (data catalog), gcp DataFusion - data pipelines, gcp Pub/Sub data pipeline to BigQuery, BigQuery data modeling design and implementation, data processing in gcp DataFlow. BigQuery modeling - projects and data sets, secure data access design and implementation controlling column and row access in BigQuery. Data Governance and compliance implementation using DataPlex gcp data catalog.

Confluent Kafka implementation and deployment as a unified persistent messaging platform and data transport/data pipelines platform. Data capture into Confluent Kafka from transactional databases - PostgreSQL using Debezium data source connectors and data transformation to analytics destination using Confluent Kafka sink connectors for ML and data analytics -S3, Snowflake. Inflight data ingestion, analytics and transformation using KsqlDB and Confluent Kafka stream lineage.PostgreSQL databases management and administration on Heroku platform and aws RDS platform, ETL/ELT implementation and deployment using FiveTran and DBT Databases and messaging system migration from Heroku platform to amazon aws platform. Migrated relational databases from Heroku platform to amazon aws RDS platform. Migrated Heroku kafka to the Confluent Cloud kafka platform, implemented FiveTran ETL and DBT data transformations.

founder at KrolmWe are poised to disrupt Streaming Data and ETL, no more Extraction, Transformation and Loading. Instead fluid and flexible Streaming Data Pipelines that fill data lakes. The data can be analyzed, enriched, governed, filtered, ML, shared at any phase - from ingestion to consumption. Build Streaming Data Pipelines and Data Lakes in days, not months or years :-)Join us - learn, develop, brainstorm, we are looking for:django developers java developersaws experts alibaba cloud expertsGCP experts

Designed and implemented data infrastructure. Migrated 365 Retail Markets from physical datacenter to Amazon AWS cloud, on-premise databases, were replicated to aws RDS, dataplatform design and development – streaming data RDS -->CDCConnectors-->ConfluentCloud-->Snowflake sink connector-->Snowflake.Configured network infrastructure. Replicated databases from the data center to aws RDS.Developed and deployed Snowflake Datawarehouse for reporting. Developed and deployedCloud Formation configuration • Messaging system deployment Confluent Kafka cloud • Kafkaconnect deployment RDS and Snowflake Designed and developed streaming data/data lake.Data is ingested by RDS databases, CDC process reads database transaction logs andserializes individual transactions in AVRO messages, AVRO messages are streamed intoConfluent Kafka topics and from Kafka topics via sink connectors to final destinations S3,Snowflake. The entire configuration is powered by gitops. Fivetran and dbt are used to correlatedata and data transport.

MySQL NDBD Cluster consulting

Google GCP cloud data infrastructure. Google gcp CloudSQL database does not support the in-place upgrade or uninterrupted upgrades from MySQL release 5.6 to MySQL release 5.7. The challenge was to upgrade overflow databases live with no interruption in service - in order to upgrade the databases multi-day outage was required. All operations databases were upgraded live with no service interruption details are in this article on LinkedIn https://www.linkedin.com/pulse/doing-impossible-migrating-gcp-cloudsql-live-from-56-a-alexander/ Reporting/dw platform BG, Kafka< CloudSQL

Database Architect at Telmate. Designed and implemented MySQL/MariaDB highly available databases architecture, MySQL on PCI Flash and zfs filesystem.Deployed ScaleArc databases load balancer for databases high availability, load balancing and performance. Multizone data center using replication for multi zone hight availability. Amazon AWS Cloud databases architecture and deployment, Aurora and RDS. Managing PostgreSQL databases and MySQL databases and RDS/Aurora MySQL and PostgreSQL databases. Migration from Amazon RDS to Amazon Aurora. Amazon RedShift deployment.Designed new reporting platform, implemented Pentaho ETL, Flydata for data replication.Amazon Snowflake DSS pilot

MySQL Galera Architecture. MySQL Galera implementation. Galera Replication internal, MySQL/MariaDB internals, network topology, physical and logical architecture and deployment strategy.

Designed MySQL and MariaDB database appliance. The appliance is based on PCI Flash devices from FusionIO for data storage and NVM (non volatile RAM) for logs storage, nvmfs filesystem. Transactional appliances delivered high performance database transaction synchronous and asynchronous data replication. Designed DSS Decision support database appliance for data analytics. The analytics appliance designed using columnar data store and data compression. PostgreSQL and Postgres XL development, architecture, high availability and scalability.

Transactional Databases. Designed and deployed synchronously replicated transactional databases. Migrated the existing database infrastructure from EMC storage to internal PCI Flash using Virident PCI Flash and xfs filesystem. New architecture achieved 99.999 databases uptime and eliminated replication lag. Deployed F5 Load balancers for databases reads balancing. Reporting Databases. Redesigned DSS and reporting architecture. New architectures reduced reports execution from several hours to several minutes delivering time sensitive reporting data. Designed and deployed Cassandra configuration for gaming messaging replacing MySQL databases.

Silicon Valley MySQL Meet Up Users Group tonight MySQL 5.7 What is new and exciting and whats not. http://www.meetup.com/mysql-silicon-valley/events/161598012/

Building scalable high performing MySQL infrastructure.

MySQL databases architecture and management. Designed and implemented Continuent Tungsten for MySQL databases and PostgreXC cluster.

Installed and configured Continuent Tungsten Enterprise for MySQL 5.1. Configures Master/Master cross data center replication.

MySQL NDB Cluster Architecture and Deployment. Designed architecture for MySQL 7.1 cluster deployment, installed and configured NDB cluster on Rhat platform. Migrated MySQL Cluster from 7.0 Ubuntu deployment with VIP HA to MySQL Cluster 7.1 with Barracuda Load Balancers on Rhat platform. Configured backup and recovery, developed deployment plan. Configured and deployed NDB cluster to cluster replication.

AkibanDB is a unique solution designed with Group Index concept. Designed and implemented product roadmap. Developed AkibanDB integration with open source databases – MySQL and MariaDB.Deployed AkibanDB at first customer site with fully integrated replication to open source databases – MySQL and PostgreSQL. Automate schema optimizationDistribute data across serversDistribute users across access nodesMaintain compatibility with existing SQL database applications

MySQL Databases Architect iAd platform

Continuent www.continuent.com - Continuous Data Availability. We keep your databases online 24/7/365 - MySQL, Postgres Oracle. Our product Tungsten - is carrier grade solution to for databases uptime, data loss prevention, databases scaling and resource utilization optimization. Simply put Tungsten - is a data replication and data propagation software - that will keep your data online - guaranteed.

Implementing DRBD (for uninitiated Distributed Block Replication Device) and MySQL/Postgres or simply - configuring databases for HA environment using DRBD and Linux-HA project's Heartbeat.

MySQL database Architecture and Administration. Implemented multi-master replication, cluster management. Pentaho DW implementation and deployment.

Managing MySQL Databases, DRBD, Oracle at Online Buddies, Inc.

Implementing Oracle Rman at FM Global

Senior Database Architect at Athletes' Performance. Design and implementation of MySQL OLTP and OLAP databases. MySQL HA (high availability) design and deployment using Multi Master Replications and DRBD. MySQL performance tuning and administration. Implemented MySQL backup and recovery using INNODB backup utility.

www.nyiso.comOracle Database physical/logical architecture. Database design and deployment. Oracle RAC, IBM PSeries, Tru64. Oracle Financials 11.5.12 System Administration, Database administration.

Xerox Global Services. Database/ERP/Datawarehouse Applications Management and Deployment. Developed and Implemented Logical and Technical applications and data warehouse architecture. Implementation of recommendations resulted in improvements of applications uptime and performance. Oracle Applications Rel 11i Oracle Database 10.2 Oracle Database 10.1.0.4 Data Guard implementation and deployment. Supported Development and Functional Teams. Implemented infrastructure monitoring systems and monitoring processes/plans, implemented and deployed Change Management System. Implemented database ERP Applications Change Management and deployment strategy. Participated. Proposed and implemented Organizational Redesign and Restructuring aimed at improving IT management efficiency.

Managed Applications Support team. Developed and implemented applications and database management approach and on-call schedule that reduced teams’ overtime hours, actively implemented flextime while significantly improving applications/databases uptime and reliability. Implemented team members training program designed to achieve Oracle Certification for the databases and development team members. Team was responsible for several Oracle Applications 11i instances, Peoplesoft applications and custom developed Club Management Applications. Developed applications Logical and Physical architecture. Implemented database/applications management policies and procedures. Proposed and implemented Change Management system – that substantially improved systems reliability and reduced downtime. DBA team managed physical infrastructure that comprised of IBM P Series/AIX, Red Hat Linux, Oracle Database 10g, Oracle Applications 11i, Peoplesoft. Developed SOX financial system compliance program.

Developed Logical and Physical databases architecture. Proposed and implemented OTRS Change Management System. Developed Change Management policies and controls. OTRS implementation resulted in additional improvement of production systems uptime. Implemented Oracle Database Rel. 9.2 Advanced Replication. Proposed and implemented infrastructure migration project from Oracle environments and PHP to MySql databases and JBOSS. Developed migrations and application development plans. Designed logical and physical applications architecture. Proposed project reduced license and administration costs resulting in $3M reduction of costs while significantly improving applications uptime and reliability. Managed teams of developers and database administrators.

GEFA Server consolidation project. The goal of the project was to consolidate strategic business systems on Sun Fire platform from HP-UX, improve performance and increase MTBF for the following applications: ECS - Enterprise claims systems, custom application. EWD - Enterprise wide disbursements, custom developed application Oracle Financials, 250 GB Oracle Financials (817 database), Oracle Financial Analyzer and Oracle Express. As project manager developed project planning and deployment strategy. Developed following documentation: Technical Architecture (source), Technical Architecture (target), Detailed Migration and Contingency Plan, setup, porting and deployment documentation for ECS, EWD and Oracle Financials. Coordinated development teams.

Developed Oracle Applications ERP implementation roadmap and plan. Developed Enterprise Resource Planning technical architecture and deployment plan. Gathered business requirements, developed and deployed hardware and network architecture to support ERP Oracle Applications and supporting environments. As part of technical architecture part of the project performed hardware platform selection (Sun Sparc), hardware and network sizing. Configured and coordinated installation Of Sun Operating system (5.8) and Veritas Foundation Suite.). Developed and implemented ERP Infrastructure administration policies and procedures. Developed and implemented IT Change management policies and procedures. Supervised and coordinated teams of Oracle developers, database administrators and user support organization.

Developed ERP Implementation Technical Architecture Roadmap. Developed ERP technical and functional architecture and Change Management policies and procedures. Performed Oracle Applications hardware sizing and configuration. Prepared and administered Oracle Applications environment for Go-Live project. Developed procedures for duplicating Oracle Applications production environment for test and development. Developed backup and recovery strategy using Oracle Recovery manager for Oracle Applications database/executables. Developed Oracle Application/Database administration policies and procedures. Prepared and executed DRP policies and procedures. Worked with teams of Oracle Developers and DBA’s .

Managed an Oracle Applications and Oracle GEMMS Technical Architecture Project Supervised team of six consultants. Assisted clients in the hardware and operating platform selection process, performed hardware and network (WAN, MAN, LAN) sizing and configuration. Conducted technical presentations and requirements definition sessions. Developed project plans and schedules

Principal Consultant for mid range ERP Applications Implementations and deployments. Solomon Accounting, Great Plains, Real World, Mas 90. Gather business requirements, developed project roadmap documentation. Performed ERP suited installations, configurations and deployments. Managed team of five consultants.