- administration of Oracle databases: Oracle 12C instances (about 30 databases) - developing some practice code (almost by PL/SQL procedures) for automatic differentt work processes - troubleshooting - searching & analyzing the reasons of different kinds of problems with inform systems and fix that bugs - some consultations for testing engineers, analytics, support engineers, other different groups - support different kinds of activityes - Oracle Database Administration - solution of defects in the area of ​​responsibility of the administration group - reflection of the results of activity in the bug-tracking systems Remedy, TFS - configuration and configuration of information systems - installation and configuration of the Oracle DB - monitoring and execution of planned works in Oracle DB, works on restoration of working capacity - writing SQL queries for searching and preparing test data, custom entities, for monitoring and analyzing the operation of the Oracle DB - writing instructions for work - development of procedures (for example, procedure for depersonalization of data in the UMRS database) - participation and conduct of ACS - Establishment of correction of the zone of responsibility and the causes of various problems - configuration of configuration files for the correct functioning of the tested functionality - localization of defects - interaction with representatives of other structural divisions of MTS, provision of consultations - development of a questionnaire for the interview of candidates, participation in interviews - installation and configuration of information systems - conducting preliminary works on test benches - Monitoring and maintaining free space in Oracle database tablespaces - Conducting routine maintenance of the database on applications from REMEDY (itsm) (removing dump database schemas, deploying schemes from dumps, creating, granting database schemas, etc.) - Preparation of CTS test stands for regression and integration testing (depersonalization of data from product databases, setting up database audit, delineation of user access levels) Participation in conducting and analyzing the results of regression testing of releases Foris 5.7 - Foris 6.1. A number of problems were identified in the early stages - the occurrence of effects on the product environment was prevented.

system analyst - develope different test cases and write different code for search and modify start data for testing IT systems - some consultations for developers, support, testing engineers, analiytics etc. - Development and design of test scenarios in TFS based on documentation provided by developers - Searching, analyzing and updating the documentation - Analysis of the problems encountered during the operation of the information system "on the battlefield", identification of the lack of test coverage and the addition of a test model (IS Remedy) - Support for the development of automated tests, advice, explanations, completion of test cases, provision (development) of queries (SQL queries and PL / SQL procedures) to the database for finding (modifying, entering into the database) input test data and identifying objects that meet the testing requirements - Validation of the developed autotests, identification of deficiencies and coordination of necessary improvements - Interaction with adjacent units (developers of autotests, system administrators, developers, testing, business customers) - Work with defects in the bug tracking system - detection, registration, validation, localization, determination of the zone of responsibility and necessary measures for correction of the defect, correction, maintenance and retesting, completion of the test coverage - Writing complex SQL queries for the selection of test data, as well as PL / SQL procedures for data modification - Conducting internal training of employees on the use of IP, on working with Oracle DBMS; - Participation in meetings on audio conferencing to prioritize and solve problems with representatives of participating teams in the testing process - Assistance to colleagues in case of difficulties - Consultations of adjacent units during the implementation of integration testing - Carrying out works to optimize the test model Participation in conducting and analyzing the results of regression testing of releases Foris 5.4 - Foris 5.6 In the early stages, a number of code defects were identified and eliminated, several problems on the product environment were prevented.

- analyze documentation - consultations for different groups of testing - delopment of test cases system analyst (test designer / engineer / specialist) - Analysis of documentation for the new functionality - Development, actualization of test scenarios - Creation of templates of test sets (test set templates) for regression testing - Work with defects (detection, registration, correction, maintenance and retesting) - Carrying out works to optimize the test model Participation in regression testing Foris 5.2, Foris 5.3

- Creation and improvement of existing capabilities of the integrated information system "Дел&Фин" (CRM) according to users' requirements: - creation and updating of reports according to user requirements in Fast Report; - establishment and maintenance of up-to-date information in system directories: - correction of errors in the registers of documents, accounting entries, calculations; - writing scripts and SQL queries to the database; - setup and maintenance of a mini PBX (Astra BP250); - administration of BioSmart biometric time control system; - installation, setup and maintenance of commercial equipment (barcode scanners, cashless terminals, CMC, buyer displays) and office equipment (scanners, printers, faxes, copiers); - Maintenance and support of servers (file-servers, mail-servers, servers of databases, gateways) in the main store and branches (about 20 stores in the city and region): - installation of software on the server; - carrying out software revisions (further software) on the server; - maintenance of the operating status of the server software; - backup of server data; - maintenance of network documentation, preparation of written instructions for working with network software for users of any level; - maintaining the archive of software on the server, monitoring the relevance of information on the server; - installation, configuration and optimization of the system software of the network of enterprises «Дом Книги»; - maintenance of a necessary stock of expendable materials and accessories; - development of instructions for working with programs, consulting staff on the use of software, training in networking; - installation, installation and modernization of LAN; - development of the capabilities of the local network and the programs used; - current activities in accordance with work plans and applications of specialists and services; - Participation in the organization of inventory, ensuring its implementation and the formation of final documents on the results of inventory.

- Algorithmization and writing programs for calculating star catalogs; - creating and mastering a fundamentally new method for calculating the proper motions of stars; - the involuntary opening of a new scattered star cluster.

Физический, кафедра Астрономии и Геодезии, Информационные системы и технологии

ФГОУ СПО «Екатеринбургский экономико-технологический колледж», Графическая программа Auto Cad