Position: Data Engineer / Data Architect / Teamlead
Category: Data Engineer
English level: upper
Years of experience: 11


A highly skilled and motivated Data Engineer with focus on MS SQL Server and Architecture design offering a combination of cross-functional skills with 16+ years of  experience in the IT sphere as a DBA, DB Engineer, Data Architect, Team Lead.

Key Responsibilities:
Team management and mentoring UP to 11 people (DBA, DBD, QA, BI)
Code review. Unify code style
CICD implementation
Data storage optimisation 
Big Query data transfering
GCP data transfering
Creating Reports on SSRS;
SSRS server setting up and management
Creating and supporting dashboards in Qlikview/QlikSense;
Qlikview/QlikSense server management
Configuring ETL process
SQL Query optimization
Data recalculation and migration
MS SQL server replication setup and management
Failover cluster setup
Database BackUp/restoring

 2021 - present time, Data Engineer Team lead
	Team: Up to 11 people (DBA, DBD, BI, QA)
	
New data model for analytics:
One data structure for Big Query and MS Sql Server
Increasing performance for data query 10+ times
Decreasing query complexity

Big Query:
Data Uploading
Data Monitoring
 
 2018 - 2021, DBA Team lead
Team: Up to 4 people (DBA, DBD, BI, QA)
Interviewing, mentoring
Code review 
DBA Ms Sql Server support:
Up to 20 servers
100+ databases
Setup, back up, restore
Backup automatisation

MS Sql Server Replication:
Setup, support
Up to 7 servers in one system
Hundreds of tables
Single destination DB up to 7 TB

QlikView: Support

QlikSense:
Qlik view to Qlik Sense report migration
Setup
Reports - 2+ Billion Rows
New data model for user filtering:
200+ dimensions, 300 mln rows
30+ tables as datasource
6000 result reports per day (up to 50 mln records each)

Data migration:
For scalability PK was changed in the 20 biggest tables
Full data migration to GCP virtual machines
QlikSense migration to GCP
GDPR implementation

2014 - 2018, DB Developer
	MS SSRS:
50+ reports 
Version control, CICD implementation
Simplifying subscriptions. 200+ nightly subscriptions

Data model optimisation and refactoring