Senior Oracle Core/Apps DBA with 14 years experience in IT

8/2015 – offen

Remote Database Administration (Oracle, PostgreSQL) for the CWK's clients:
-Oracle Database 10g/11g/12c Installation and Support on Unix/Linux and Windows (Silent and GUI)
-Oracle Grid Control 11g Installation and Configuration (Silent and GUI)
-Oracle Cloud Control Installation and Configuration (Silent and GUI)
-Database Monitoring
-Oracle upgrading and patching
-Implementing backup scenarios
-Disaster Recovery
-Database Performance Tuning
-Database High Availability
-Data Migration To/From Oracle Database
-Database Migration (Version, Platform)
-PostgreSQL Database Administration
-Oracle Business Intelligent Installation, Patching and Administration
-Shell Scripting

Oracle Business Intelligence (BI), Oracle Data Guard, Oracle Database, Oracle Grid Engine, Oracle RMAN (Recovery Manager)

5/2008 – 7/2015

-Install and maintain Oracle databases in development, test, training and production environments. (IBM AIX and Linux)
-Develop and maintain sound backup and recovery policies, and procedures.
-Develop disaster recovery plans, and perform disaster recovery tests.
-Monitor multiple databases and applications using internal and external tools.
-Maintain maximum system availability. (Oracle Data Guard)
-Perform database and application tuning and performance monitoring.
-Plan growth and changes ensuring appropriate storage for the database (capacity planning).
-Write and maintain database stored procedures, packages, triggers and views (PL/SQL).
-Provide troubleshooting and root cause analysis for database related issues.
-Work as part of a team and provide 7x24 support on rotational basis.
-Setup and maintain documentation and standards.
-Provide help and consultation to development teams and other internal staff.
-Recommend software and hardware upgrades as they relate to database functionality and performance.
-Train onsite technical support staff.
-Keep up to date with latest technology.
-Meet deadlines for deliverables.
-Data Migration To Oracle Database.
-Oracle E-Business Suite 11i DBA.
-Implementing Automatic Journal Imports on Oracle GL. (Oracle GL does not have it and Oracle customers need it from 2003.)
-Upgrade Oracle E-Business Suite 11.5.10 to 11.5.10.2
-Shell Scripting
-Implementing MS SQL Server Mirroring (2005)

Oracle Data Guard, Oracle Database, Oracle E-Business Suite, Oracle RMAN (Recovery Manager)

8/2006 – 5/2008

-Oracle Installation on Unix/Linux Family
(HP-UX11i & Linux SUSE Enterprise 8,9 & RedHat Enterprise 4 Linux)
-Oracle Installation on Microsoft Windows Server 2003
-Oracle upgrading and patching
-Creating database (dbca / Script)
-Creating database objects (OEM, Third-Party database Tools and Script)
-Monitoring database by OEM and Third-Party Database Tools (Quest, ...)
-Implementing database security
-Configuring Oracle Network
-Implementing backup scenarios (imp/exp, cold-backup, hot-backup, Rman)
-Disaster Recovery
-Database Performance Tuning (STATPACK,AWR)
-Implementing Oracle Replication
-Implementing Oracle DataGuard (HP-UX11i / RedHat Enterprise 4 Linux)
-Familiar with Oracle Real Application Clusters.
-Oracle10g downgrade to 9i
-Oracle-Report6i Installation on HP-UX11i
-Data Migration To Oracle Database
-Shell Scripting
-Supporting multiple database instances 24/7 in a large data centre environment
-Assisting developers by writing DDL and DML statements and tune scripts in SQL and PL/SQL