Database-related and business analytics tasks:

• understanding of QlikSense data models, relational databases

• developing data analysis applications using QlikSense – custom reports/dashboards for customers and internal usage,

• extracting, transforming and loading data from multiple data sources (Oracle, postgres, SOAP/REST APIs, flat files etc.) into QlikSense application and utilizing scripting language to meet complex business requirements,

• creating front-end part of visualisations (html+css+js)

• knowledge of SQL, PL/SQL, bash, basic perl and python

• creating SQL and PL/SQL scripts and procedures for Oracle databases,

• exporting and importing data into existing databases, performing refreshes,

• knowledge of Multitenant Architecture – Oracle Database 12c

• API / SOAP / REST web services consultancy

• working on Single Sign On (SAML) integrations between ForgeRock OpenAM and Microsoft ADFS

• providing support for new joiners and team members

• participating in DR tests

• client/3rd parties conference calls and meetings, understanding customer needs and translate them into technical requirements

• creating technical documentation

• ability to work on multiple projects simultaneously for customers from Europe, USA and Asia

• analysing errors, troubleshooting technical issues and implementing solutions

• troubleshooting and configuration of Oracle Database 11g/12c (and older versions),
• database performance checks,
• working with production and test environments,
• performing refreshes,
• analyzing various types of errors,
• communication with customers from all over the world.

Technologies:

• RMAN (backup and recovery of Oracle Database)
• Data Pump
• Data Guard
• Oracle Golden Gate
• Oracle Exadata

1-year training at Red Stack Tech in Cracow. Learning about Oracle Database 11g and 12c environment from basics to advanced issues. I also got to know other Oracle technologies - Data Guard, RAC, GoldenGate, Exadata, Multitenant Architecture.