Designing and creating database structures in Oracle/MS SQL/SQLight, performance optimization
Java development (Spring, JDBC, Hibernate, RESTful, Servlets, JUnit, JS, JQuery, AJAX, Freemarker, Bootstrap, CSS, HTML5 etc)
Databse Dimensional Modeling, writing complicated ETL Stored Procedures using PL/SQL – shell scripting,
Technologies: Spring Boot, Spring Data, EJB3, Hibernate, RESTful, Microsoft Azure, JUnit, Angular JS, Twitter Bootstrap, CSS, HTML5, Liquibase, Swagger, Microsoft Azure cloud, SOA, Microservices, Event Sourcing, CQRS
RDBMS: Microsoft Azure SQL (MS SQL)
Version control: GIT
Project lifecycle management system: Microsoft Azure CI
RDBMS: Oracle, SQLight
Version control: GIT
Writing complicated Stored Procedures using PL/SQL;
Modeling and development ETL processes;
Logical/Physical data modeling.;
Application UI development using GWT;
Experience in design, development and organizing complex Informatica mappings, sessions and workflows to configure data flows from multiple sources (flat files, XML files, Oracle, MS SQL server) to targets persistent data stores. Using client tools like Designer (Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, and Workflow Manager and Workflow Monitor.
Tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
Database experience - using Oracle 11g/10g, SQL, PL/SQL, SQL*Loader, Stored Procedures, Functions, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views.
Building (Coding) the software using MS SQL 200020052008. Creating server logic using TSQL.
Designing huge databases and projecting business logic for server side of developed application. Creating diagrams, providing data warehouse, supporting existed databases.
Creating complicated stored procedures, functions, triggers
Optimizing queries to DB , analyzing database statistic ,using SQL-server options, DBMS
Specialist degree, Computer Science