Paweł Kotarba

Consulting and Supporting IBM DB2 Databases

• Oracle 10g, 11g, 12c Enterprise Edition Database management and control on Linux, Unix and Windows
• Monitoring, control & analysis of major operating system / database / backup / standby components in monitoring
• Creating new Oracle Software & new Oracle Databases on the new servers
• Cloning & Migrating Databases (RMAN Duplicate, Datapump Export/Import)
• Patching Databases
• Status queries from standby databases (Dataguard)
• Troubleshooting ORA errors (Alert Log, Trace Files)
• Creation of service requests for Oracle Support Team
• Execution of different SQL scripts (for Test & Prod environments)
• Generation of AWR reports with ADDM hints (for various performance issues), tuning of problematic SQL statements (SQL Tuning Advisor), SQL profile creation
• Creation of various DB dumps
• Configuration of Linux Crontab (e. g. Backup Jobs, Housekeeping Jobs)
• Working with Monitoring: (OVO – HP Operations Manager, Cloud Control)
• Installing Cloud Control Agents on the servers
• Incident Management, Change Management, Problem Management: REMEDY TOOL
• Publication of technical SOP articles in DB Team Knowledge Database
• Working with the technical documentation in German and English

• Oracle 10g, 11g, 12c and Oracle RAC 11g, 12c
Database management and control on Linux, Unix and Windows
• Monitoring, control & analysis of major operating system / database / backup / standby components in monitoring
• Status queries from standby databases (Dataguard & DB Visit)
• Troubleshooting ORA errors (Alert Log, Trace Files)
• Creation of service requests for Oracle Support Team
• Execution of different SQL scripts (for Test & Prod environments)
• Generation of AWR reports with ADDM hints (for various performance issues), tuning of problematic SQL statements (SQL Tuning Advisor), SQL profile creation
• Creation of various DB dumps
• Configuration of Linux Crontab (e. g. Backup Jobs, ADRCI housekeeping)
• Working with Nagios Monitoring System: (Check MK)
• Working with Grid Control & Cloud Control (control of alerts)
• Working with the bug-tracking systems: Assyst, JIRA
• Publication of technical SOP articles in Confluence
• Home Office during duty hours
• Working with the technical documentation in German and English

Technical Support for UBS Investment Bank

• Providing technical support to the UBS Investment Bank
• Support for large financial systems for users from around the world (APAC / EMEA / US time zones)
• Monitoring and troubleshooting of both major core components of the system: Realtime Cluster (Application + Oracle DB) and End-of-Day Feeds Cluster (Feeds Files + MS SQL DB)
• Maintaining PROD, TEST and UAT environments
• Monitoring and responding to all critical resources of the system, such as: Critical services (on multiple Windows / Unix machines) or the most important jobs in "Inactive", "Stuck", "Terminated" status
• Troubleshooting and analyzing inconsistencies in data provided by upstream systems and in data generated for downstream systems (Feeds Incidents)
• Maintaining and updating powershell scripts
• Participation in major / minor releases on PROD & UAT environments
• Close cooperation with Dev / Upstream / Downstream teams on incidents
• Creation of tickets with bugs and submission to dev team
• Creation of articles in the knowledge database in Confluence (regular support incidents, regular support tasks, SOPs, FAQs)
• Working with the technical documentation in English

• controlling the web applications created by the company (including SEMPro, OWAPro)
• providing technical assistance for application users, responding to reported errors and problems
• diagnosing the reasons for the reported problems associated with the operations of systems, log and statistics analysis, creating reports, etc.
• passing serious bugs to developers working according to SCRUM methodology of work, reporting incidents to Incident Manager
• working with MySQL database, pulling out or updating essential data in database
• working with systems for online marketing (e. g. Google Adwords, Yahoo Advertising, MSN Advertising, Facebook, Yandex)
• creating / modifying tools in Perl to enhance the performance and to automate tasks associated with support duties
• creating reports generated by the PERL script
• working with SVN repository
• working with the Bug Tracking Systems: JIRA, Flyspray
• working with Linux (CentOS)
• Home Office during duty hours (OpenVPN, Blackberry)
• working with the technical documentation in English

• developing Gemalto's software (PersGSM configuration and management)
• building/modifying additional modules in C/C++ (Visual C++)
• creating scripts for PersGSM software
• creating and modifying technical documentation for Gemalto
• cooperating with Testers
• contacting by phone/email with technical consultants
• working with SVN repository
• working with the technical documentation in English