Data Warehouse project at Komerční banka- quality assurance and DW performance improvement- BI solutions development- ETL Developmentenv.: Teradata, Snowflake, Informatica, PowerDesigner, Jira, Confluence, GitHub, Jenkins, Apache NifiIndustries: Finance, Banking

Data Warehouse project at Home CreditETL Develover, PL/SQL Develoverenv. : Oracle 12c, Workflow builder, Oracle SQL Developer, PL/SQLIndustries: Finance, Banking

Data Warehouse project at Česká SpořitelnaETL Develover, PL/SQL Develover, Data miningenv. : Oracle 12c, ODI, Oracle Designer, Oracle SQL Developer, PL/SQLIndustries: Finance, Banking

Worked as a member of a team of eight Database Administrators assigned to the Sales Transformation Model group of IBM to install, develop and maintain OLTP, and Data Warehouse databases running on DB2 UDB 9.7/10.5 on AIX and Linux(Bluemix) platformsAchievements:Provided Application DBA support to implement optimized physical database structures.Designed and developed database security using AIX\Linux groups and roles.Owned and managed all changes to the data models, created data models, solution designs and data architecture documentation for complex information system.Created and managed instances, databases, tables, views, MQTs, indexes, triggers, functions and procedures.Optimized the existing stored procedures, ETL jobs, db structure, extract and load processes, archiving the historical data.Implemented the ETL process using stored procedures, cron jobs and shell scripts Created redirect-restore scripts to support development and testing activities between test and production databasesCopied the databases between AIX and Linux env.Installed the fixpacks Provided System DBA support to manage day to day database activities. System Admin Role in Bluemix (Linux)Developed and implemented monitoring shell scripts on AIX and Linux platforms. Environment: DB2/UDB multi-partition 9.x/10.5, AIX, IBM Bluemix (Redhat Linux)

Key responsibilities as Oracle DBA for Czech national part of the European Visa Information System:Production database supportWeekly Performance monitoringPerformance tuning of SQL, indexes, and databaseMaintenance security and integrity controlsShort and long term system/database analysis PL\SQL developmentuser and dev support

Key responsibilities as primary DB2 & Oracle DBA for IBM projectsDatabase migration from Oracle to DB2 , including data model, stored procedures in PL\SQLOwned and managed all changes to the data models, created data models, solution designs and data architecture documentation for complex information system. Install & Patch of db2 v8 to v9.7, Instance & db upgrade Install & Patch Oracle 10g, 11gBackup & recovery, offline & online \ full & incremental \ TSM & disk , moved the database to another machinesPerformance Tuning and troubleshooting in db2 and OracleInstalled and monitored the Replications in db2Configured and monitored the Workload manager, Optim Performance ManagerSQL queries oprtimization, db2 explain , exfmt and advis utilitiesMaterialized query tables, auditing, etcDeveloped and implemented monitoring shell scripts on AIXResponsibility for the database security , security model Provided System DBA support to manage day to day database activities.Dev team and report team support Cloning db to other platforms PL\SQL Development of stored procedures and functionsEnvironment: DB2 multi-partition 8.x/10.1 in AIX\Win2008 enterprise, Oracle 10g/11g in Linux

Key responsibilities as Oracle DBA for IBM (Public Employment Service Austria AMS)Oracle 10g installation and configuration on Solaris env. , patchingPerformance tuning, auditing in production env.Data migration RMAN backup & recoveryPL\SQL development of stored procedures, functions and packages

develop technical designs for application development and application code for java programs

Java\PLSQL developer on server side components analysis, design and constructionOracle and DB2 DBA, install, patch, maint., backup, dev team support

Various projects especially as IT consultant, Perl\Postgresql developer; Oracle consultant

C++ Developer, PL/SQL Developer, Oracle & Sybase DBA