Position: PowerBI and Database administrator/developer
Company: Intellias
Experience required: 2y
Category: Data Science
English level: intermediate
Published: 2021-09-01T00:00:00+03:00

**Project Overview:**

Our client is the largest Ukrainian telecommunication operator providing communications and data services based on a broad range of mobile and fixed-line technologies, including 4G. Company’s customer base amounts to over 26 million in mobile and more than 1 million in broadband internet. Our client is a part of one of the world’s largest integrated telecommunications companies, headquartered in Netherlands. The holding company owns telecom assets in the CIS countries, Europe, Asia, and Africa, and its shares are freely traded on the stock exchange (NASDAQ).

**Responsibilities:**
- Database tuning; query optimisation, monitoring database performance, planning storage allocation and architecture for best performance;
- Diagnose and resolve database access and performance problems;
- Assisting developers with developing optimal queries and optimal data designs;
- Conducting research and maintaining knowledge of database engine developments, and making recommendations on appropriate technology choices and upgrades;
- Reporting query performance issues to the product teams (and suggesting optimisations);
- Troubleshooting and fixing performance issues (tuning configuration options);
- Working with several product teams to make sure their queries are designed for performance;
- Involved in the database design process, advises the developers on how to design new databases and how to optimize the structure of existing databases;
- Setup of data consistency monitoring and scheduling of data pipelines;
- Knowledge of English to communicate with technical support ( B1 — Intermediate or higher).

**Requirements:**
- Strong experience of using PL\SQL Developer, using and understanding Oracle objects like procedures/functions, packages, views(without materialised one). Simple performance tuning, understanding of partitioning. Good skills of SQL querying and performance tuning;
- Strong experience working with query optimisations;
- Experience on database architecture, database design, database optimisation;
- Basic Linux commands like top, copy, etc.

**Nice to have:**
- Knowledge of Microsoft SQL Server or PostgreSQL, NoSQL/CassandraDB or similar;
- Experience in Oracle database administration on Linux based platforms;
- Experience or at least high level understanding of PWC Informatica (a big plus);
- Experience in Python scripting;
- Experience in Powershell scripting;
- Experience in Power BI Report Server or SSRS.

**Soft skills:**
- Collaborative and proactive mindset;
- Ability to quick learning;
- Ability to solve problems independently (interaction with colleagues, technical support, etc.);
- Strong documentation skills.

**Higher Education:**
- Bachelor’s Degree/Master’s Degree.

**We offer:**

Besides such basics as a competitive salary, comfortable and motivating work environment, here at Intellias we offer:

For your professional growth — Innovative projects with advanced technologies; Individual approach to professional and career growth (Personal Development Plan); Regular educational events with leading industry experts; English and German courses.

For your comfort — Flexible working hours; Spacious office with lots of meeting rooms; Relocation program; Kids’ room with professional baby-sitter (offices in Lviv & Kyiv).

For your health — 3 health packages to choose from — medical insurance, sports attendance or mix of both; Annual vitaminization program; Annual vaccination and ophthalmologist check-up.

For your leisure — Corporate celebrations and fun activities; On-site massages; Beauty parlor (offices in Lviv & Kyiv).