Kan vara tillgänglig
(Uppdaterat 2020-01-13)Seniorkonsulent
Hillerød, Denmark
Modersmål Danish, Flytande English, Mellan French, Svenska, Norwegian, German
- Oracle udviklerprofil med datamodelling, PL/SQL and SQL
- Oracle backup og High Availability (Data Guard, RAC osv.)
- 20+ års erfaring som Oracle database administrator (DBA)
Kompetenser (42)
OPERATIONS
Oracle 12
Oracle 6
RMAN
ORACLE 9
DATABASE ADMINISTRATOR
ROOT CAUSE ANALYSIS
MAINTENANCE
ORACLE 11
ORACLE 10
DOCUMENTATION
MICROSOFT WORD
Data Guard
Oracle Enterprise Manager
Exadata
Excel
DATABASE
WORD
ORACLE 7
Oracle
PERFORMANCE ANALYSIS
ORACLE 8
ASM
POWERPOINT
MICROSOFT POWERPOINT
RAC
Unix shell scripting
TEST CASES
Unix
SQL
PL/SQL
DATABASE MODELING
CUSTOMER RELATIONSHIP MANAGEMENT
ARCHITECTURE
SIEBEL
REPLICATION
PostgreSQL
FIXED INCOME
CRM
STRONG COMMUNICATION SKILLS
CAPITAL MARKETS
MENTOR
Sammanfattning
• Oracle Database Administrator (DBA) and database expert.
• Experienced problem analyst, troubleshooter and performance tuner.
• RMAN backup, restore and duplicate of Oracle databases.
• High-Availability solutions: RAC, Data Guard and Exadata.
• Development profile: Data modelling, SQL and PL/SQL
• Excellent overview - structured mindset - analytic sense.
• Strong communication and co-operation skills.
• Background as a developer (C programmer).
Professionell bakgrund
2019-04 - 2019-04
• Development of application programs in SQL and PL/SQL for Lector's clients.
• Participation in design of new solutions etc.
• Data modelling.
2018-10 - 2019-03
Areas of responsibility:
• Technical advisory and IT consultancy services to NNIT clients.
• Analysis of Oracle database related problems and challenges.
• High Availability (Data Guard etc.).
• Replication of data to data warehouse.
• Collaboration with Oracle service architect regarding new solutions.
• Participation in implementation of customer-specific PostgreSQL solution.
2012-01 - 2018-01
2014-01 - 2014-01
2013-01 - 2013-01
2011-01 - 2012-04
Areas of responsibility:
• Advice for projects and management.
• High-level troubleshooting during operational or performance related problems for Oracle databases as well as applications ('systemwide').
• Performance analysis and tuning.
• Participation in task forces related to operational problems.
• Platform owner for backup of Oracle.
• Primary DBA on RMAN backup/restore. Mentor for colleagues regarding backup, restore and duplikering af Oracle databaser.
• Member of Exadata Team, responsible for operation of Nordea's Oracle Exadata platform, i.e. 13 Exadata machines (X4, X5, X6), including troubleshooting, handling of SW- and HW-related errors, and create and maintenance of operational documentation.
• Participation in 24x7 on-call for Oracle System DBA and from 2016 Exadata.
Results:
• Participation in focus group regarding Exadata with external assistance from Oracle Development.
Result: IO performance optimized and Exadata operational stability improved.
• Participation in patch of Exadata infrastructure (CRS, IB, storage cells).
• Associated as overall technical database advisor for the strategic New Payment
project (architecture, performance etc.).
• Participation in PoC for migrering of business-critical 22 TB database from Solaris / M5000 to Exadata X4-2. Method: Export-import and Golden Gate.
• Participation in installation and prepare of Exadata X4-2 for production.
RMAN and ZFS Backup Appliance are chosen as backup solution.
• Primary DBA for NIMS, one of Nordeas largest and most critical systems.
• Develops migration metod for migration of Solaris Oracle systems from Nordic Processor datacenter i Stockholm to Nordea's datacenter in Copenhagen.
Method: Active duplicate with Data Guard Broker switchover.
• Participation in PoC regarding the Oracle Commodity platform (VMware on Windows 2008). Based on this, management decides to base the Oracle Commodity platform on Red Hat Linux and VMware. Participates in PoC regarding the latter as well.
• Advice related to future Oracle platform strategy: It is decided to migrate from a SUN Solaris M5000-based platform to a two-tier Oracle platform, comprising a Commodity platform hosting most of the databases and a more expensive Enterprise platform providing higher performance for the largest and most demanding databases. Exadata is chosen as the Enterprise platform.
• Author on Proof-of-Concept report regarding the first Oracle Exadata Database Machine in Denmark, bought by Nordea in 2010.
2012-01 - 2012-01
2011-01 - 2012-01
2012-01 - 2012-01
2003-11 - 2010-12
Nordic Processor Aps, Ballerup
- a joint venture between IBM (60 %) andNordea (40 %).
Oracle Database Administrator (DBA) in Oracle Team, Application Hosting. Domicile: Høje Taastrup, Ballerup and Christiansbro (København).
Areas of responsibility:
• Database-administration.
• Advice of projects and management related to Oracle databases.
• Performance analysis and tuning.
• High-level troubleshooting during operational and performance-related problems Oracle databases and applications ('systemwide').
• Participation in task forces related to operational and performance-related problems, including performance and stability-problems for the SUN Solaris M5000 platform.
• Installation and upgrade of Oracle databases to Oracle 9, 10.2 and 11.2.
• Root cause analysis of various kinds of problems.
• Primary DBA on RMAN backup/restore/duplicate.
• Main architecht on - and developer of - RMAN TSM-based backup/restore solution.
• On-site dedicated DBA for Nordea Capital Markets in Copenhagen.
Results:
• Advice related to decision regarding purchase of Oracle Exadata Database Machine in order to perform PoC.
• Participation in implementation of standardized Data Guard set-up and prepare of it for production. Author of 'Data Guard Cookbook'.
• Carries out different performance analyses regarding the Wall Street application. Proves based on a statistical model that the application - due to its design - will never be able to excute more than one trade per second. Result: Management decides to only partly phase the system out.
• Author of decison proposal regarding usage of Data Guard as resilience solution for Oracle.
• Author on 50 page manual regarding how to manually complete af failed RMAN duplicate. Forwards it to Oracle Support as a gift.
• Prepares a mathematical model for how to compute the backup tape consumption for a certain Oracle database.
• Prepares decision proposal regarding RMAN/TSM backup løsning in Nordea's central computer centre in Stockholm.
2003-01 - 2010-01
1994-08 - 2003-10
(until 2001: Unibank A/S, IT-Production, Høje Taastrup).
1996-01 - 2003-01
• Advice of projects and management related to Oracle.
• Oracle database set-up on AIX, Sun and Windows NT.
• Development and maintenance of operational procedures and installation documentation.
• Second- and third-level Oracle-related operational support.
• Advice regarding optimal disk set-up etc. for machines hosting Oracle databases.
• Development and maintenance of internal SQL- and PL/SQL-scripts.
• Thourbleshooting, construction of reproducible test cases for vendors, follow-up on bugs and test of patches.
• Ongoing upgrade of Oracle databases on AIX and Solaris to Oracle 7.2, 7.3, 8.0.5 and 8.1.4.
• Development and maintenanceof middleware (C, Oracle Pro*C).
• Participation in rationalization af Oracle licences.
Results:
• Assists Tryg in prepare of Siebel-baseret CRM-løsning for production. Result: Migration to Siebel within the deadline and meeting the requirements settled by Tryg management (½ year).
• Project manager on choise of new database for the Uni-EX branch platform. Analysis of two alternative scenarios: (1) upgrade to Oracle 7.3 and (2) migrate to IBM DB2. Presents analysis report for IT-management. Result: Management chooses status quo in order to save money.
• Strategy work and report writing related to analysis of pro's and con's for migration of the branch platform from OS/2 to NT. Result: IT management decides to drop the migration to NT.
• Participates together with Oracle Denmark in creation of a common Unibank/ Oracle testlab in Dublin. Short stay in Oracle's development department in Dublin related to this.
2001-01 - 2003-01
1994-01 - 2001-01
1994-01 - 1996-01
• Primarily working with the branch platform Uni-EX (Oracle on OS/2).
• Responsible for vendor contact to Oracle.
• Test and approval of new Oracle versions.
• Second-level operational support and author of operational procedures.
• Participates in development and maintenance of various database middleware (C, Pro*C, embedded SQL).
• Troubleshooting related to Oracle and on the interface between database and OS.
• Installation of and advice related to Oracle 7 on AIX.
1988-01 - 1994-07
• Prepares statistical analyses of error reports, based on software metrcs, i.e. measurement of SW-quality, error density etc.
• Create of databaseand presentation of results in Word, Excel, PowerPoint and Access.
• Result: New test strategy and education of development engineers.
1994-01 - 1994-01
1988-01 - 1993-12
• Project manager for project with three development engineers.
• Responsibility for timetables for 11 engineers. Result: Time schedules met.
• Technical co-ordinator for a development team with four members. Responsible for time schedules and technical co-ordination.
• Participation in specification, design and implementation of software to the main station (C, Oracle, Pro*C, SQL, X-Windows).
Selected courses
1988-01 - 1993-01
Akademisk bakgrund
2020-01 - 1987-01
2020-01 - 1982-01