Alex Kargin Email & Phone Number

Boca Raton, Fl, Us

- Developed new data products, migrating pipelines to Snowflake to enhance system performance.- Designed and implemented dbt tasks for streamlined data modeling and transformations.- Optimized slow pipelines, reducing runtime and improving data accessibility.- Architected Snowflake table structures, ensuring scalability and efficient querying.- Managed a team of two Database Developers across five diverse products.- Implemented CI/CD pipelines using Jenkins and Azure DevOps to enable Agile workflows.- Built a cost-efficient data warehouse (OLAP) using TASKS, reducing Snowflake costs significantly.- Oversaw AWS infrastructure development, leveraging EC2, RDS, S3, and other services for operational efficiency.

Boca Raton, Fl, Us

Working with development of new products; Architect new structure with AuroraDB, MariaDB, MongoDB, SnowFlake, DynamoDB;Managing two Database Developers for 5 different products;Applying different Consistency Models;Creating/Using Docker containers for ETL processes;Working with Agile methodology through CI/CD pipeline (Jenkins, Azure DevOps, Liquibase);Creation of Data Warehouse (OLAP) with Procedures, and ETL scripts/events;Scaling Databases for different projects from single database to Cluster;Working with Infrastructure Development and Operations involving AWS Cloud Platforms EC2, EBS, S3, RDS, SES, ELB, Route53, Auto-scaling, CloudWatch, IAM and Redshift;Develop and administrate AuroraDB/MariaDB/MongoDB/DynamoDB/MySQL on AWS/Azure;Work with the project and development teams to create infrastructure within the cloud using Amazon Web Services and other cloud-based technologies;Normalize RDBMS for in different projects;Design and Develop database models and schemas utilizing best practices and the continuous integration/continuous deployment;Export/Import Databases to S3/Glassier;Developing and supporting production, QA and development environment;Monitors performance issues on all production and non-production databases;Importing/Exporting data from and to xml/csv/txt/tsv files with and without ETL;

Boca Raton, Fl, Us

Participated in the development of new products for Lenovo; Experience in Infrastructure Development and Operations involving AWS Cloud Platforms EC2, EBS, S3, RDS, SES, ELB, Route53, Auto-scaling, CloudWatch, IAM and Redis;Creation of Data Warehouse (OLAP) with Triggers, Procedures, and ETL scripts;Architect new structure with AuroraDB AWS (MySQL/MariaDB), MS SQL;Creating analytics with Power BI Desktop and Tableau;Working with Agile methodology through CI/CD pipeline;Develop and administrate MySQL/MariaDB/MongoDB/MSSQL on RDS;Work with the development teams to create infrastructure within the cloud using Amazon Web Services and other cloud-based technologies;Normalize RDBMS for 3NF;Design and Develop database models and schemas utilizing best practices and the continuous integration/continuous deployment;Scaling Databases for different projects from single database to Master-Slave and Clusters with OLTP/OLAP designSupport of ETL processes through bash, cronjob, python and T-SQL language;Developing and supporting production, QA and development environment;Monitors performance issues on all production and non-production databases;Importing/Exporting data from and to xml/csv/txt/tsv files with and without ETL;Trace the slow running queries and optimize SQL queries for improved performance and availability;Managing server instances (AWS RDS), disaster recovery, replication and clustering;Developing and supporting database replication and clustering, and plan and execute for database scalability; Working close with Business, supporting them with Data Analytics queries;Working with application engineers, developers and the QA team as well as applications support teams in the maintenance and care of the Linux Network and Database infrastructure;Designed power BI data visualization using cross tabs, maps, scatters plots, pie, bar and density charts;Wrote calculated columns, Measures query's in power bi desktop to show good data analysis techniques;

New York, Ny, Us

Participated in the development of new product; Analyzing current environment & designing workable in-house solutions; Understand core systems and data processes for normalization, data validation, data aggregation, and customized reporting and migrations to the new product;Identifying & building tools to assist in database and transactional processing (i.e. Store Procedures, Triggers, etc.)Worked on design and development of Relational Database Management System (RDBMS) and reduce the redundancy by data normalization;Migrated high-volume fields from MySQL to the ElasticSearch in order to get easy access and high speed users search;Traces the slow running queries and optimize SQL queries for improved performance and availability;Managing MySQL/MongoDB servers instances (AWS), disaster recovery and replication;Creating Data Warehouse with ETL processes;Creating Data Marts through views for different departments;

Us

o Responsible for designing, installation, administration and support of Unix/Linux servers;o Installed, configured and administered:o physical Linux servers under CentOS 5 and 6, on HP and Supermicro hardware;o Pull of virtual servers under Linux Citrix virtualization (ZEN Base) software;o Various services (sendmail, bind, apache, snmp, ntp, ssh, tftp, etc.)o Developed backup strategy, programmed scripts for it;o Monitored network and servers using Nagios;o Troubleshoot hardware and software, supported users.o Hadoop Administration, Cloudera distribution and monitoring activitieso Virtualizing the lab environment using Citrix Xen Server

* Supported Forex Trading system (250 servers x 2 locations). Functioned as DBA and Linux Administrator. Oracle database on RH 5 servers (16 instances), MySQL 5.1 (3 DBs) * Configured and Installed Oracle 11g on Red Hat servers (16 instances).* Regular database backup activity* Monitoring network and servers using Nagios,* Responsibility for DNS Servers with writing a security script, which allows programmers and production make they own zones for testing and using zones.* Supported MySQL Databases* Provide 24/7 support for multiple production instances * Performance tuning in Oracle Applications instances and other production DBs* Shell scripting for cron jobs & some customization in already created scripts.* Installed, configured and maintained over 500 GNU/Linux servers (Red Hat, CentOS, Fedora) across three different datacenters; managed installation, patching, monitoring, backups, disaster recovery and business continuity strategies, troubleshooting and resolution, application enhancements, and modifications. * Conducted configuration and maintenance of all data center systems and servers. HP G5 360, HP Blades c7000, Cisco MDS 9509.* Provided administration and support for Unix, Linux, and virtualization technologies, including Xen 5.5 and VMware 4.0 ESX* Configured and administered company websites, including general LAMP stack, Perl/Python/PHP/Java, Apache, Linux, and MySQL.* Performed troubleshooting, networking, security, services, reporting, monitoring, database-backed management, capacity planning, and strategic planning

Performed Unix installation and configure and troubleshoot server OS and hardware issues Installed and configured FreeBSD 5.4, 6.1, CentOS 3.6, 4.2, 4.3, 4.4. Windows workstation/ server 2003. Monitored network and servers using Cacti Implemented company network security and provided administration of several environments from Enterprise Level LAN/WAN and Production based Networks. Responsible for end-user and product-related technical support for Web based Applications, Hardware vs. Operating System Relationships, internal software suites, and logged application errors & end-user feature requests. Provided administration, monitoring, backup/recovery, problem determination and resolution (break/fix), and general technical support; configuration and maintenance of all data center systems and servers. Implemented data center security through proactive monitoring, maintenance and upgrades of security patches, anti-virus software, etc. Coordinate work with remote Network Operations Center, other Technology groups and Operations teams to provide detection and recovery of system outages, problems, and faults. Responsible software problem report tickets, daily reports, logs and changes are completed. Conducted capacity planning and development of datacenter services and processes, storage and network solutions for secure and reliable management of all systems.