IC Ai-Techo LLC (group of companies "Ai-Techo")
Role
Software development Expert
Description of Project
Work on the project on migration of the ATM accounting system application
Responsibilities
1. Database migration using Ora2Pg from Oracle to PostgreSQL.
2. Conversion of application SQL queries from Oracle to PostgreSQL.
3. Conversion of program code from PL/SQL to PL/pgSQL.
4. Development of instructions for installing software and launching migration processes.
5. Setting up data synchronization between Oracle and PostgreSQL using SymmetricDS.
6. Development of data analysis scripts and refinement of business code based on customer requirements.
Technology Stack
Java SE 1,6 (IO, NIO, Collections, JDBC, Swing)
Java EE (Servlet, JSP)
Java framework: Spring, Dropwizard
JasperReports 5.5.0
SQL, PL/SQL, Oracle 10g-12c, PostgreSQL
Delphi 7, JavaScript, JIRA, Confluence, XML, Json
tools: Oracle SQL Developer, PL/SQL Developer, DBeaver, Eclipse, NetBeance, IntelliJ IDEA, Apache Ant, Maven, SVN, Git
Period
09.2022 —
until now
(2 years 11 months)