Position: Database Engineer
Category: Data Engineer
English level: intermediate
Years of experience: 11


- 12+ years of IT experience in software development and database design.
- Experienced in Data Warehousing development, performance tuning, devising stored procedures, functions, views, writing complex SQL queries, using data replication.
- Experienced with both, design and development of ETL from scratch for wide variety of data sources and data formats, as well as with support, maintenance and optimization of existing data processing.
- Ability to work independently as well as a part of team.
- Very responsible approach to work.
- I'm enthusiastic and would be glad to get in touch with new
technologies such as Microsoft Azure\AWS Clouds. I have basic knowledge of Python; Azure SQL Database, Synapse Analytics, Blob Storage, Data Lake Storage, Cosmos DB.

09/2010 - 10/2022 (it's all one project)

Endpoint Consulting LLC, Miami, FL, USA (2010-2018)
MarketingG2 LLC, Horsham, PA, USA (2010-2018)
NavigaGlobal Bloomington, MN, USA (2019 - 10/2022)

Role: 
Database Engineer\Database Analyst

Project:
Marketing G2, Horsham, PA, USA (then NavigaGlobal, Bloomington, MN, USA) - a software company that develops digital tools for online subscriptions, customer engagement, data discovery and audience lifecycle management for newspaper and online media industry. 
     We have worked with the following circulation systems: DTI (most of our clients), DSI, CircPro, and Matrix. A team of 10 people was able to manage all processes for more than 30 clients and their databases from 1 TB and larger, also including test, dev, and deploy environments for these clients. In the last 3 years, after merging with NavigaGlobal, a large part of the work was moving processes from physical servers to AWS.
      I came to the project and participated in the transition from SQL Server 2000 DTS to SQL Server 2006 SSIS and creating a versioned product. 

Responsibilities included the design, development, testing, implementation, and optimization at the database and data level (using Agile and CD/CI methodology):
- Data preparation for BI (ETL). MS SQL, SSIS, C#, Alterian, Listrak.
- DWH - creation and support.
- Data management; content management; subscriber service: support console, account management.
- Performance monitoring and process optimization.
- Reporting (MS SSRS).
- Mentoring and training junior staff.