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

• Developing and supporting REST API
• Optimization and refactoring of code to improve performance and lead to uniform style
•  Changing the structure of the database
• Creating reports on the work done and monitoring the timely updating of product documentation
• Conducting staff training, documentation maintenance
Project within treat intelligence portfolio, we as a core of operation team provide the following services:
 - DBA administration:
 - Maintains and support the monitoring
 - Maintains and support the infrastructure 
 - Manage user management in AWS
US company
Project Role
Senior Data Engineer, DevOPS
Responsibilities
    • Help DevOps team to improve the SQL request
    • Help to design the MySQL DBA
    • Analyzing of the database structure, making recommendations on changing the structure
    • Add new or update JIRA projects, issue types, screens, fields, schemes
    • Update workflows
    • Create, update, delete users and roles, setting project permission
    • Write Python scripts for behavior
    • Create notification
Tools & Technologies
MySQL, JIRA, Webex, Confluence, AWS, Prometheus, Grafana
2)DB Optimization
The project required performance audit after migration from other database to MariaDB and validation migration correctness
US company
Responsibilities
    • Analyze queries, identify slow queries, optimize queries
    • Analyze indexes, collations, engines, configuration files, general parameters and optimize
    • Provide report of redundancies in DB schema, compare different schemes, validate migration correctness
    •  Created auto tests for slow queries
    • Estimation, prioritization, and distribution of tasks
    • Create pipeline
    • Analyzing of the database structure, making recommendations on changing the structure
Tools & Technologies
Linux; Windows PowerShell; Ubuntu; MySQL; Python, Apache Airflow
Percona (pt-duplicate-key-checker, pt-query-digest, sysbench), vSphere; pfSense, Webex, TargetProcess (for reporting tasks); Scrum
3) Software and hardware system to introduce a new generation of medical infusion devices
The project required database analysis for schema separation into smaller databases for use with microservices as well as creating those smaller databases along with their builder code (C# .Net)
US company
Responsibilities
    • Database analysis and mapping
    • Requirement’s analysis and clarification
    • Architecture and design of new database tables and recreation of the previously
I prefer a long-term contract, I like to work with a product company.

Ready to relocate to another country