Product Implementation Analyst for Doctor Eleks (Report Developer, MS SQL DataBase) in ELEKS

The ELEKS company is looking for a Product Implementation Analyst (Report Developer, MSSQLDataBase) for the Doctor ELEKS product in Ukraine. About the productDoctor Eleks is a medical information system that helps to provide improved support to its patients thanks to the automation and optimization of complex operational processes of the patient's clinical data management methods. The main goal of the product is to improve quality and value of providing medical services. REQUIREMENTS Understanding of relational databases Basic skills of working with MSSQL Server DBMS Skills of working with SQL Server Management Studio (users/accesses) Knowledge of basic SQL concepts Understanding of basic SELECT, INSERT, UPDATE, DELETE operations Knowledge of WHERE constructs for data filtering Skills use ORDER BY to sort the results Ability to create tables by defining data types Understanding the use of keys (PRIMARY KEY, FOREIGN KEY) Ability to delete and modify tables Understanding different types of joins such as INNER JOIN, LEFT JOIN, RIGHT JOIN Ability to use joins to join knowledge of the syntax for creating and calling stored procedures Understanding of parameters and passing them to procedures and functions Ability to return values ​​from functions Ability to create VIEW for convenient retrieval of database data Understanding of using VIEW in SELECT queries Using SQL Server agent for tasks WILL BE A PLUS Experience with MSSQL DBMS, databases Writing code -sql Implementation of dashboards in PowerBI Understanding of the operation of window functions Skills of working with MSSQL Server Profiler Bachelor's degree or higher in the field of computer engineering Eng. language Pre-Intermediate level The ability to see the big picture, correctly plan the approach of finishing work The ability to work independently and self-organized The ability to think analytically and develop solutions that meet the needs of customers Planning, organization and time management skills RESPONSIBILITIES Support of existing MIS installations of customers (execution of customer tasks, support of customer studies) Filling the MIS database for the client (reporting, and other data required for MIS operation) MIS testing before releases (testing of the posttest plan and test cases of MIS functionality) Manipulation of database objects Writing procedures/views/functions in the database to implement custom processes of customers. Description of what is implemented for the knowledge base Manipulation of the submitted database Primary optimization of requests in procedures Carrying out imports of external systems of Doctor Eleks Advantages of cooperation with ELEKS Competitive social package Close cooperation with the client Interesting tasks Competence development Team of professionals Dynamic environment and development Medical insurance You can send your resume here: jobs.lever.co/ ...​ied&lever-source[]=dou.uaAbout ELEKS The ELEKS company has been developing custom software since 1991. We use our expertise, knowledge and experience, helping clients to create innovative software products for the development of their business. The ELEKS team is a reliable technology partner for many global brands. More than 2,000+ ELEKS specialists working in our offices around the world provide customers with a full range of software development services. Our key services: roproduct development, QA, R&D, design, technology consulting and specialty teams.