Ronny Egner – Freelance Oracle DBA

Services

UNIX operating systems

  • SLES 8/9/10/11, RHEL 4/5, OEL 5, Sun Solaris (SPARC and x86), HP-UX, AIX
  • Install Linux (RHEL, SLES, OEL) and Solaris (not only for database-servers)
  • OS-optimization (UNIX, Linux, Windows) for database-servers (e.g. kernel parameters, limits, file system layout)
  • Shell-Scripting with bash and korn shell
  • Troubleshooting
  • Administration of UNIX, Linux and Windows operating systems
  • Performance-Monitoring
  • Automatic Deployment of Linux and Solaris Installations

Oracle Databases

  • Versions: 8i – 21ai
  • Installation, Upgrade and Patching
  • High Availability with logical / physical Data Guard
  • High Availability with Real Application Clusters (RAC)
  • Automatic Storage Management (ASM) Administration
  • Migrations with sqlldr or other mechanisms
  • Gateways to other databases with Oracle Transparent Gateways (e.g. to MS SQL or MySQL)
  • Performance-Tuning and -Management
  • SQL/Instance-Tuning
  • Troubleshooting
  • Monitoring
  • Security-Review
  • Backup/Recovery with RMAN and EMC/Legato Networker (3rd-party software)
  • Cloning with RMAN, Storage-Features or Scripts
  • Helping with Oracle Support (e.g. Priority 1 SRs, CreatingTestcases for Oracle SRs)
  • Training / Coaching

Oracle Grid Control

  • Versions: 10g (10.2.0.x)
  • Installation, Upgrade and Patching
  • Planning and Implementation of monitoring and notification system with Grid Control
  • writing custom monitoring scripts

EMC (Legato) Networker

  • Versions: 6.x / 7.x
  • Planning and Implementation of company-wide backup processes with Networker
  • Installation, Upgrade and Patching of Server, Client and Module Components
  • Backup / Restore Tuning
  • Troubleshooting

Virtualization

  • XEN
  • Oracle VM and
  • VMWare 3/4
  • Planning, Installation and Configuration
  • Deployment

Other

  • Nagios
    • Planning, Installation and Configuration writing custom nagios check plugins
  • Netapp (Network Appliance) Filer
    • Planning, Installation and Configuration
    • Troubleshooting
  • Source Code Management Tools CVS and Subversion
    • Planning, Installation and Configuration
    • Implement centralized authorization (e.g. with LDAP)