Position: ORACLE SQL, PL/SQL Developer
Category: SQL
English level: intermediate
Years of experience: 7


ORACLE – more than 7 years:
-	data modeling, database structure
-	understanding of ORACLE database concepts 
-	writing complex SQL queries using aggregate, analytical functions, hierarchical queries, regular expression
-	creating stored procedures, functions, packages and database triggers with dynamic SQL, cursors, collections and PL/SQL concepts like Bulk collect and FORALL
-	tables (using partitioning), indexes, views, synonyms, directories and database links 
-	up- and downloading data using imp/exp utilities, Data Pump, SQL Loader, UTL_FILE, external tables
-	working with XML and JSON in PL/SQL
-	creating users, roles, granting privileges and roles to users
-	Experience in SQL performance tuning using explain plan, trace, tkprof, AWR report
-	experience in OLTP application design and development, OLAP maintaining
-	Working with high load and big (1-3TB storage, 750Gb Ram, more than 1000 users) databases
-	Installing oracle database, patches	
-	Administrating through RMAN - creating backup schedule, managing archive logs
-	creating standby and managing log exchange between primary db and standby
-	db migration from one server to another and db upgrading
-	experience with oracle 10g, 11g, 12c, 18c
-	Oracle apex
OTHER DATABASES 
-	Mysql 
-	Microsoft sql, access (using VBA) - junior level
-	Have a little experience in MongoDB, MarkLogic DB 
-	Graph databases concepts and development: TigerGraph, Neo4j
-	Experience in ETL using Informatica 9,10

PROJECT MANAGEMENT - 1.5 years
-	 Managing a team of 5 to 10 professionals and coordinating them
-	 Defining roles and responsibilities, task managing
-	 Creating and maintaining project schedules, resource planning
-	 Driving simultaneous execution of projects on different stages - from design to delivery
-	 Writing documentation (in Ukrainian)
-	 MS Project
OTHER SKILLS 
-	 Writing Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, data up- and downloading
-	 Power designer
-	 SVN, Git, Mantis, Trello