Position: Application Database Engineer
Company: Unicorn Systems
Category: SQL
Experience required: 3y
English level: upper

Unicorn Systems is a renowned European company providing the largest information systems and solutions in the area of information and communication technologies. We have been focused on high added value and competitive advantage for our customers.
Now we are looking for an Application Database Engineer to join the development team of our client – a large Healthcare Company. 
Our client is an innovative, global healthcare company committed to improving health and well-being in 140 countries around the world. The product categories include heart and respiratory health, diabetes, consumer products and women’s health. They also work on the researches to prevent and treat diseases that threaten people and animals including cancer, infectious diseases and many more. The company was found in the U.S. in 1891 and have an impressive up-to-date history.
Project: data and analytics solution, BI tools for different processes of the company (transactions and analytics in pricing, tenders, contract management, revenue optimization, and decision support across therapeutic areas and across all markets).
Responsibilities:
•	Create and maintain conceptual, logical and physical data models with focus on BPM application;
•	Propose data structures which are optimal for application performance and can be ingested to serve analytics needs;
•	Work with application squad to translate application requirements into database changes;
•	Improve existing database structures and propose refactoring where necessary;
•	Optimize existing queries for application performance;
•	Ensure alignment with data modelers and application delivery squad;
•	Analyze data issues, perform impact analysis;
•	Create and maintain data lineage and other documentation;
•	Help to govern downstream impact of application database changes;
•	Provide inputs to QA/testing team for creation of test cases/scenario;
•	Help with data testing/validation activities;
•	Support deployment and release activities, help with SDLC deliverables;
•	Write and refine stories to support product features;
•	Estimate stories in the backlog with the team;
•	Communicate with business stakeholders and team members.

Requirements: 
•	Experience with database design for operational/transactional database;
•	Experience with BPM application is an advantage (preferably Appian);
•	Advanced experience with SQL;
•	Experience with agile way of working on a larger project/product (working in a delivery squad following agile practices);
•	Experience DB schema management and automation (flyway/liquibase);
•	Hands-on experience with Oracle;
•	Experience with Oracle SQL tuning and optimization of real-time applications;
•	Knowledge of Procedural SQL (PL/SQL);
•	Hands-on experience with data modeling tool;
•	Experience with AWS technologies is a plus;
•	Understanding of data warehouse concepts is a plus
•	Experience with working in global projects across multiple time zones;
•	Experience with JIRA and Confluence is an advantage;
•	Experience with modern data governance tools (e.g. Collibra) is an advantage.

Soft skills required:
•	English upper-intermediate or higher, daily usage;
•	Strong negotiation and self-organization skills;
•	High level of communication skills;
•	Active approach to work, self-driven.


We offer:
•	Direct cooperation with the client;
•	Full-time remote job;
•	Long-term cooperation.