Freelance Database Architecture & Engineering Services

Offering freelance services in Database Architecture and Development:

I have a diverse set of technology specialties including: AWS RDS, MySQL, MariaDB, Redshift, Percona XtraDB Cluster, PostgreSQL, Semarchy xDM, Apache Spark/PySpark, AWS Glue, Airflow, dbt, Amazon AWS, Hadoop/HDFS, Linux (Ubuntu, Red Hat).   

Business Continuity, High Availability, Disaster Recovery:

Ensuring minimal downtime of mission-critical databases by utilizing database replication, clustering, and backup testing and validation.

Performance Tuning:

I can analyze the database configuration, errors and events, physical resources, physical table design, and SQL queries to address performance issues.

Infrastructure Engineering:

In the AWS environment, I use a combination of Ansible, Python with the boto3 SDK, as well as the command line interface (CLI) to create and manage a variety of AWS services including EC2, RDS, S3, and more.

System Monitoring:

Maintaining historical performance metrics can be useful for proactive capacity planning, immediate outage detection, alerting, and analysis for optimization. I can use tools including Percona Monitoring & Management (PMM), and AWS tools such as Performance Insights and CloudWatch.

ETL Development:

I develop data processing pipelines using Python, Apache Spark/PySpark, and dbt.  For process orchestration, I utilize AWS Glue or Airflow.  I am experienced in integrating a variety of sources including AWS S3, REST API's, and all major relational databases.

Data Governance / Master Data Management:

I am experienced in all phases of development and administration on the Semarchy xDM Master Data Management Platform. 

  • Building the infrastructure and installing the software in AWS.

  • Entity design.

  • Developing the UI components for use by the data stewards to view and manage master data. 

  • Creating the internal procedures for data enrichment, validation, and duplicate consolidation.

  • Data ingestion (ETL).

  • Dashboard creation.

Data Quality Assessments:

Analyze, detect, and report data anomalies before critical processes are affected..

John Dzilvelis

john@analytic-arts.com
‪(720) 924-1498