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, MS SQL DataBase) 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. Main the goal of the product is to increase the quality and value of providing medical services. REQUIREMENTS Understanding of relational databases Basic skills of working with MS SQL Server DBMS Skills of working with SQL Server Management Studio (users/accesses) Knowledge of basic SQL concepts Understanding of basic operations SELECT, INSERT, UPDATE, DELETE Knowledge of WHERE constructs for data filtering Ability to use ORDER BY to sort results Ability to create tables with definition of 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 Combining data from different tablesKnowledge of syntax for creating and calling stored proceduresUnderstanding parameters and their transfer to procedures and functionsAbility to return values ​​from functionsAbility to create VIEW for convenient data retrieval from the databaseUnderstanding the use of VIEW in SELECT queriesUsing the SQL Server agent for tasks WILL BE A PLUSExperience with MS SQL DBMS , databasesWriting code in t-sqlImplementation of dashboards in PowerBIUnderstanding the operation of window functionsSkills in working with MS SQL Server ProfilerBachelor's degree or higher in the field of computer engineeringEnglish. language Pre-Intermediate level The ability to see the big picture, correctly plan the approach to 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 for existing customer MIS installations (fulfilling customer tasks, customer support in chats) Filling the MIS database for the client (reporting and other data required for MIS operation) Testing of MIS before releases (Testing according to the test plan and test cases of the MIS functionality) Manipulation with database objects Writing procedures/views/functions in the database to implement custom customer processes. Description of what was implemented for the knowledge baseManipulation of data in the databasePrimary optimization of queries in proceduresImporting from other systems into the Doctor Eleks databaseYou can send your resume here: ResumeADVANTAGES OF COOPERATION WITH ELEKSCompetitive social packageClose cooperation with the clientInteresting tasksDevelopment of competenciesTeam of professionalsDynamic environment and developmentMedical insurance