Function: DBA, Oracle CloudControl Consultant Environment: Oracle 10g/11g/12c (5TB+; 2000+ databases), Linux, RAC, Failover DB, CloudControl 12c, IBM TEC(Tivoli Enterprise Console) Key tasks: - Monitoring Migration from IBM TEC to Oracle Cloud Control 12c - Building Monitoring Templates for databases, clusters, hosts, WebLogic and OIM targets - Building customer specific Metric Extensions(ME: Agent-Site and Repository-Site) to extend Oracle monitoring capabilities - Creating reports based on ME data and CloudControl target-metadata - Creating Incidents and Notification Rules - Monitoring of performance degradation over time with AWR Warehouse and Repository Metrics - Automatic identification of database configuration issues like: high number of redolog switchs, logfile sizing, Undo issues in clusters, failover databases monitored by wrong agent - Creating documentation in Confluence

Collecting prerequisite/coordination/realization of Proof of Concept Designing of testing methodology and creating/performing numbers of test scenarios oriented on high availability Installation of Oracle Virtual Machine(OVM3.3) on 4 nodes Creating Repositories/Servers Pools Deploying Oracle Templates and creating own-templates with variety of Oracle releases/configurations Deploying Real Application Cluster on OVM with deploy-cluster scripts Integration the Oracle VM Manager into Oracle CloudControl Generating Load on databases and virtual machines Comparing usage reports thought Chargback Managing users for role-base separation within CloudControl

Validation of Data model and indexing strategy Scheduling statistic collection and rediscovering candidates columns for extended statistics collection adjusting instance parameters to storage-level characteristic tunning of batch job and setup direct path load processing adjusting backup procedure after nologging operations turning on compression for best candidates readjusting optimizer parameters testing of new features tunnig delete procedure for big tables with exchange partitioning functionality Documenting of the results

Remote Administration on a daily basis for various customers on the production systems, Oracle versions 9i to 11g Release 2 Responsible for managing, troubleshooting, optimizing efficiency and high availability of Oracle databases ensuring regular backup and restore developing, implementing and managing security Performance Tuning(AWR, Statspack, SQL Trace, set event 10046, 10053) Data Guard (Primary + physical standby) installation and configuration Installation and configuration of test environment

- Monitoring GoldenGate environment, installation and configuration, performing initial data load, configuring the Manager process and Data Pump process - Configuring online change synchronization and DDL-support synchronization, filtering and mapping data for ZeroDowntime cross-platform migration - Carrying out of the tests - Documenting of the results

- Configuration Linux installation server for rapid setup of network installation environments and creating environment for automatic Oracle installation during system boot for HA purpose Creating central server with system-repositories - Cobbler installation and configuration - Test and implementation, managing Redhat, OEL and Suse scripts, snippets and distros - Configuration DHCP server for PXE-bootoption - Documenting of the results

- Configuration multipathing for Storage-server connection using iSCSI, performance test, presenting LUN to database admin, HA various solution - Implementation bonding-solution for boost Interconnect speed between RAC-node, creating High-availability bonding - Performance-test and finding maximum throughput in a multiple switch topology - Documenting of the results

- Aligning Flash Modules for optimal performance - Configuring Database Flash Cache, identifying ideal Oracle Database objects for Flash Storage and Accelerators with AWR or another tools, - Test Flash Card for redologs, temp tablespace, heavily used database tables and indexes or all database on flash for max performance - Documenting of the results