Oracle Developer

Kandidát má zkušenosti s poskytováním technické podpory interním uživatelům a s vývojem softwarových aplikací pro potřeby společnosti. Rovněž se účastnil týmových schůzek, na kterých se projednávaly požadavky a průběh projektu.

SQL Developer (PostgreSQL and Google Big Query) 10.2020 – present Worked on improving report performance and transitioning report generation from PostgreSQL to Google Big Query. Created PostgreSQL functions to load data into Big Query and set up necessary objects on the Big Query side. Implemented denormalization and aggregation on Big Query. Also involved in resolving PostgreSQL performance issues.

Oracle RDBMS Developer 02.2017 – 09.2020 Worked on resolving locking and performance issues with Teradata DB. Conducted POC on moving report generation from Oracle to PostgreSQL for scalability. Implemented techniques like continuous tuning, correct partitioning, indexing schemas, and data flow concepts to improve Oracle DB performance. Worked closely with C developers on load processes and Oracle Advanced Queue functionality.

Oracle RDBMS Developer and Logical DBA 08.2014 – 11.2016 Developed and supported Oracle and PostgreSQL packages, stored procedures, functions, and bash scripts. Advised corporate clients on Oracle database installation, settings, and tuning. Developed new Oracle objects and implemented them using Liquibase.

Oracle Developer / ETL-Specialist 11.2011 – 08.2014 Optimized ETL processes in a bank's DWH, supported data marts, and made timely program changes. Optimized data marts, refactored code, and improved code design. Researched business requirements and designed new data marts.

Oracle Developer / DWH Support Specialist 02.2008 – 10.2011 Developed reports for business users, supported and improved regular reports, and worked with tables ranging from 50 million to 1 billion records. Conducted SQL tuning to reduce response time and performed data validation.

Oracle Technical Support Specialist 09.2005 – 02.2008 Provided consultation to business users on interacting with DSS and responded to requests by developing complex reports. Reduced request fulfillment time by more than half through deep software knowledge, understanding of business requirements, and request classification.

Software Developer / Programmer 11.1998 – 08.2005 Developed and implemented a database schema for an internet shop and created a billing calculation program.