Oracle Dba
Resume:
Identification
Name
:
Duncan van der Zalm
Address
:
Poligono 15 percela 291
Zipcode
:
12180
City
:
Cabanes
Telephone
:
+34 6 855 50088
:
****.**@*****.***
Date of birth
:
19 Januari 1971
Nationality
:
Dutch
Function
:
DBA, Oracle specialist
DBA experience since
:
1997
Certification
2001
Prince2 Foundation
Business Courses
2009
Oracle 11G RAC
2009
Oracle 11G Administration Workshop II
2009
Oracle 11G Data Guard Administration
2009
Oracle 10G Performance and Tuning
2009
Oracle 10g Workshop I and II
2001
Prince2 Foundations
1998
Oracle 8 new features
1998
Oracle Tuning and Performance
1998
Oracle NET2
1997
IT Service Manager (ITIL Tool)
1997
Oracle 7 DBA op unix
Computer Proficiency
Standard Query Language(SQL) :
Expert
20 year
PL/SQL:
Good
13 year
Oracle Cloud 19c
Good
3 year
Oracle 12c:
Good
5 year
Oracle 11g:
Good
5 year
Oracle 10g:
Good
5 year
Oracle 9i Server:
Good
4 year
Oracle 8i Server:
Good
6 year
Oracle 7 Server:
Good
4 year
SQL*Loader
Good
4 year
Unix (Solaris / AIX)
Good
6 year
Windows
Good
7 year
Linux
Good
12 year
Exp/Imp impdp/expdp
Expert
5 year
Recovery Manager (Rman)
Good
8 year
Employment
Employer:
:
stanDaarD-Z
Customer
:
National Police Driebergen
Period:
:
Sept 2023 – Oct 2024
Position:
:
Oracle DBA
responsibilities
:
Administration and writing rapports in Oracle Analytics Publisher
Administrating Specific OEM 13 Incident Rules
Documentation daily tasks
Administrating grapics and reports using Grafana Monitoring
Administration PaaS platform
Scrum
Oracle 19c - 19.24
Employer:
:
stanDaarD-Z
Customer
:
Infradax Overheid
Period:
:
Sept 2022 - sept 2023
Position:
:
Oracle DBA
responsibilities
:
Oracle 19c database patching
OSP using perl scripting
Database Administration for Centric applications (key2burgerzaken, key2financien, key2vergunnigen)
Monitoring using Oracle Cloud control 13c and monitoring software PIM+
Backup using Microsoft Power Shell scripting (rman input automation)
SQL and PL/SQL scripting in 19c environments to spead up standard tasks.
Linux 7 and 8 disk space administration
Employer:
:
stanDaarD-Z
Customer
:
Caci
Period:
:
Jan 2021 - Jan 2022
Position:
:
Oracle DBA & Application Administrator
responsibilities
:
Ansible for 19c db cloning including post adjustments and result checks.
Backup & Recovery Oracle 19c on Oracle Linux (Shell scripts)
VM beheer. Stop, start, resource adjustments
Pluggable database kloning
OEM13c and Check_MK monitoring
Employer:
:
Apro Software Solutions BV
Period:
:
Dec 2019 - Nov 2020
Position:
:
Oracle DBA & Application administrator
responsibilities
:
Database, Weblogic Security patching.
12c to 19c cloud migration
Linux and PL/SQL scripting for backup and monitoring
Cloud and DB Performance.
Cloud control 13c
Employer:
:
stanDaarD-Z
Customer
:
Ministry of Economics Affairs
Period:
:
May 2017 – Oct 2019
Position:
:
Oracle DBA & Application-administrator
responsibilities
:
Oracle SQL tuning
Oracle security patches and releases
Rman hot backups using Veritas NetBackup
Maintenance scripts (BAT and sh)
OEM 12c entries
Application patches
Weblogic 10 patching
Jboss application patching
Employer
:
NCCW B.V.
Period
:
July 2013 – March 2017
Position
:
DBA & Application-administrator
Responsibilities
:
Database cloning using snap technology backups.
WSO2 Service Bus install and config
Oracle SQL tuning
Oracle security patches and releases
Rman hot backups on windows and linux
SQL Server 2008 and 2012 backups using scripts
maintenance scripts (BAT and sh)
Oracle partial database recovery
Oracle encryption
Employer:
:
FindWhere BV
Period:
:
November 2012 – June 2013
Position:
:
Oracle Specialist/Infra administrator
Responsibilities
:
Reconfiguring power supply of a full server RACK.
Oracle Linux v6.3 installation
Oracle VM installation and configuration
WebLogic + ADF Runtime + ADF Faces installation
PL/SQL packages creation and maintenance
Database design for Applications
HVM visualization using Xen command-line
Switch replacement
Network design (redundancy)
RAID configuration SAN
Oracle Linux administration (network, partitioning, volume-groups, users)
Employer:
Qualogy Suriname
Period:
June 2011 – June 2012
Position:
DBA Team lead / Infra specialist
Responsibilities
Team lead
Implementing ITIL Processes to organisation
CentOs Servers virtualization using VMWare ESX 4
Data and customwer requirement analyse to construct a technical solution/design
Implementing Oracle Rman backup & recovery
Implementing back-up & recovery strategie
Oracle 11g Administration
Design and implement a disaster recovery plan for customers
Trainig the Oracle team by creating a transparent monitoring tool which provides customers a view of monitoring data.
Integration with non-relationeel CISIS database
Google mail administration
Jira issue tracking administration
Year planning DBA team
Apex 4.1 and 4.1.1 installations
Employer:
Logica
Cusomer:
Centraal Justitieel Incassobureau (CJIB)
Period:
December 2010 – May 2011
Position:
Technical Applicationadministrator
Responsibilities
Oracle Workflow maintenance
Data corrections
Stored Procedures (PL/SQL) maintenance
Employer:
stanDaarD-Z
Customer:
IBM
Period:
April 2008 – Juli 2010
Position:
Oracle DBA
Responsibilities
●Administation of approx. 100 Oracle 8 t/m 10 databases
●AIX Crontab for database monitor scripts
●Databases patching
●Database releases
●Database migration from 32bits windows to 64bits AIX 5.3 using transporable tablespaces.
●Hot and cold backup and restore using Rman
●Manual Install Oracle Options (text, java SDK, WorkspaceManager)
●Performance & Tuning Oracle 8 t/m 10 Databases
●ASM tablespace admin (asmctl)
●Installation SQL Server 2008
●Scripting Bash and Bourne shell AIX
●Data analyses
Employer:
stanDaarD-Z
Customer:
BBNed
Period:
February 2008 – April 2008
Position:
Application-administrator
Responsibilities:
3de line support for Order Application. Oracle 8i.
Automating of Performance monitoring using Jmeter
PL/SQL to clean Application data
Analyse of flowbrix workflow to solve issues and adjust sofware designs
Employer:
stanDaarD-Z
Customer:
Buma Stemra
Period:
May 2007 – November 2007
Position:
Oracle DBA
Responsibilities:
SQL Tuning
Find and rebuild skewed indexes
Automation of daily maintenance checks
Database patches
Employer:
84IT
Customer:
IBM UWV
Period:
August 2006 – May 2007
Position:
Oracle DBA
Responsibilities:
Rman scripting
SQL Tuning
Training SQL Tuning to technical application admins
Application patches (Oracle 9.2) on AIX database servers
Database releases using OTAP
Employer:
Priority Telecom
Period:
March 2005 – Juli 2006
Position:
Oracle DBA
Responsibilities:
Performance using StatsPack
Table partitions
Tablespaces conversion from dictionary to locally managed
DataWareHouse setup
Install Designer 6 and Oracle enterprize Manager schema’s.
Convert normal views ot Materialised Views, refresh using dbms_job scheduling.
Data corrections using dynamic SQL
Checking for skewed indexes
Database users authorisation, direct or through a database role.
Employer:
Truston
Period:
April 2002 – February 2005
Position:
Oracle DBA
Responsibilities:
Genral DBA work.
Employer:
Qface
Period:
August 1997 – March 2002
Position:
Oracle DBA
Responsibilities:
Genral remote databases administration of serval customers
GWA: Data errors. Euro conversion using PL/SQL. (Oracle op NT)
Arbeidsbureau: DBA at devloping project Agora (Oracle on DG-UX)
Postbank: Data and design corrections using PL/SQL and DDL
Cap Gemini/ Justitie: DBA at development project. Database design comparing with Oracle Designer (Oracle on NT)
Zwisterleven Verzekeringen: Designing application in WebDB to store patch level of several databases. Data correction using ITIL. (Oracle op UNIX).
Pink Roccade: OpenZorg patches. Remote DBA. Diagnoses database growd
Employer:
Prolin Automation
Period:
May 1996 – Juli 1997
Position:
Software support engineer
Responsibilities:
Devlopment of pl/sql packages (API’s).
Oracle Reports / Business Objects maintenance
HP/Opandview Software and Prolin Software (IT Service Manager) integration development
Customer Support at Servicedesk.
Education
Study
Diploma
HTS Aircraft Operations
1995
MTS – WTB
1991
HAVO
1989
Contact this candidate