Database Engineer

ThinkMarkets

Sofia, Bulgaria

We are seeking an experienced Database Engineer to join our Sofia office.

This position will be responsible for working with Business Analysts, the Data science team, Backend Developers and/or other internal customers to analyze requirements and technical processes, and design and develop data architecture and integrations with 3^rd party tools, which will be accessible by internal/external customers from various branches across the globe.

The ideal candidate must be a self-starter and work well with others, as well as have excellent written and verbal communication skills to effectively interact with all stakeholders.

A successful candidate will apply extensive technical expertise in databases and data warehousing and will develop technical solutions to complex problems with ingenuity and creativity.

Responsibilities:

Define standards and frameworks for data architecture design;
Formulate event modeling; conceptual, logical, and physical data warehouse design; data warehouse optimization and performance; load strategy design and implementation;
Design and maintain data pipelines, ensure data quality and integrity;
Develop database procedures, functions, packages, jobs;
Create Database objects such as Tables, Views, Materialized Views etc.;
Manage data storage solutions, and support data processing needs;
Perform data profiling and analysis to assess data quality patterns, recommend data cleansing rules – conforming data standard rules and matching algorithms;
Develop custom queries and reports for data modelling through various tool sets to aggregate, analyze, and report results;
Running tests, performing statistical analysis, and interpreting test results;
Perform SQL Migrations to new Servers and configure and setup BI tools (SSRS, SSIS etc.);
Build integration with 3rd party platforms such as cloud marketing platforms ( Google BigData, Facebook, Apple), customer support (Salesforce, Zendesk, 3CX);
Maintain clustered, highly redundant database environments;
Develop, implement, and maintain Oracle, MSSQL and MySQL database structures in dev, quality assurance, and production environments, utilizing current standards policies and procedures;
Monitor the database health and participate actively in the fine-tuning and performance optimizations;
Work with System/Network Administrators to develop and maintain the replication, backup, and restoration of data within the system.

Requirements:

Degree in Computer Science or an equivalent combination of education and experience;
5+ years of experience in database engineering;
Experience in cloud database development, integration and maintenance is required (AWS, GCP or Azure);
Experience with Oracle, MSSQL, and MySQL is required, including writing database procedures, functions, packages, jobs;
Experience with NoSQL, Data warehousing, data quality assurance;
Experience with integration with 3^rd party platforms such as cloud marketing platforms (Google BigData, Facebook, Apple), customer support (Salesforce, Zendesk, 3CX);
Experience working with Real-Time/Time Series databases;
Experience with database administration and design of enterprise database systems;
Experience in setting up data replication in a cluster of database instances;
Experience with database fine-tuning and performance optimization;
Experience with deploying databases on a global scale;
Experience with utilizing database performance analysis tools, like SolarWinds or Redgate;
Experience with BI and Tableau is a plus;
Knowledge and experience with other DB engines is a plus.