always ready for new challenges
(updated April 2024)
PERSONAL INFORMATION
Full name |
Miguel Anjo Carvalho |
Email |
miguel@anjo.pt |
Birth date |
15.02.1979 |
Phone |
+41 79 264 88 63 |
Nationality |
Swiss, Portuguese |
Blog |
https://anjo.pt/keyword-oracle |
|
|
Location |
Bern |
SUMMARY OF SKILLS AND STRENGTHS
Databases |
23-year experience Oracle DBA (8i-23c, RAC, Cloud, DataGuard, GoldenGate, Security), PostgreSQL, MySQL |
Programming |
Shell scripting, web programming |
Platforms |
Linux, AIX, Windows |
Languages |
English, French – fluent/C1; German, Spanish – work knowledge/B2; Portuguese – native/C2; |
Personal skills |
Cooperative team member and facilitator. Highly motivated, fast learning and concerned about fulfilling the objectives. Best practices advocate. |
Certifications |
PMI – Project Management Professional Oracle ACE Associate Oracle Database Certified Professional (OCP); Oracle Cloud Infrastructure Certified Architect Associate Oracle Database Cloud Administrator Certified Professional Oracle Base Database Services Certified Professional Oracle Cloud Database Migration and Integration Certified Professional Oracle RAC Certified Expert Oracle Security Certified Implementation Specialist MySQL Heatwave Implementation Associate
|
PROFESSIONAL EXPERIENCE
12.2024 – present |
Senior Consultant, Tradeware, Switzerland |
- Oracle Database consultant and primary contact for several clients in industry, services, banking and education;
- Architecture, installation, migration, administration and automation of Oracle databases; technical project manager;
- Main projects:
- Oracle DB platform creation automation; Oracle DB migration self-service
-
|
09.2010 – 11.2023 |
Senior Consultant, Trivadis, Switzerland |
- Oracle Database consultant and primary contact for several clients in industry, services, banking and education;
- Architecture, installation, migration, administration of Oracle databases; technical project manager;
- Main projects:
- BKW (3-years, 20-100%): performance improvements on critical applications; Upgrade project 11g-19c; technical lead during internal team replacement;
- Nespresso (7-years, 50-100%): Coordination of DBA team; primary contact of the client; administration of 300+ RAC DBs and GoldenGate replication for 23 production databases;
- Teacher of Oracle Multitenant, Oracle Security and Goldengate courses;
- Part of Trivadis ‘Oracle security’ expert team; definition of security best practices; security patch testing
|
06.2010 – 09.2010 |
Assistant Vice-President, Merrill Lynch (Suisse) / Bank of America, Switzerland |
- Senior Database Administrator, responsible for 20+ databases, developers support and DataGuard configuration.
|
04.2004 – 03.2009 |
Staff member, CERN – European Laboratory for Particle Physics, Switzerland |
- Senior Database Administrator at the Physics Databases section of IT department.
- Responsible for LHC Computing Grid database and LHCb experiment database
- Definition and implementation of database security standards – auditing, roles and profiles
- Administration and optimization of multiple production 8-node Oracle RACs on Linux using ASM
- Meetings facilitator, best practice coordinator. Scripting of proactive monitoring; patch installation; usage reporting.
- Past: Oracle AS maintenance, RDBMS 1st line procedures documentation, RAC tests, migration 9i-10g.
|
09.2003 – 03.2004 |
Trainee at Database Group, CERN – European Laboratory for Particle Physics, Switzerland |
- Management of a service for European Data Grid project. Development of high availability solution using DNS switch.
- Testing and documentation of procedures for the installation and deployment of Oracle Application Server 9i.
|
08.2002 – 01.2003 |
Junior Researcher, Media Team Oulu, Finland |
07.2001 – 09.2001 |
Summer Student Database Group, CERN – European Lab for Particle Physics, Switzerland |
02.2001 – 09.2002 |
Part-time Webmaster, University of Coimbra, Portugal |
09.2000 – 05.2001 |
Part-time Oracle Developer, Pedro Nunes Institute, Coimbra, Portugal |
07.1996 – 02.2004 |
Part-time Web Developer/Editor, A Telefonia Virtual, Portugal |
EDUCATION
09.1997 – 02.2003 |
Licenciatura in Computer Engineering (5 year degree), University of Coimbra, Portugal |
Areas of study
- IT Management and Strategic Planning
- Database Administration
- Distributed and Parallel Programming
|
- Reliability and Quality Control
- Intelligent Data Analysis
- Network Communication Protocols
|
Thesis title: Personal Virtual Storage in Context-Aware Systems |
CERTIFICATIONS and COURSES
Project Management Institute |
06.2014 |
PMI Project Management Professional |
Oracle |
05.2018 |
Oracle Cloud Infrastructure Certified Architect Associate |
10.2015 |
Oracle Database 11g Security Certified Implementation Specialist |
03.2015 |
Oracle 12c RAC Certified Implementation Specialist |
12.2012 |
Oracle 11g Database Administrator Certified Professional |
03.2009 |
Oracle 10gR2 RAC Administrator Certified Expert |
11.2005 |
Oracle 10g Database Administrator Certified Professional |
10.2004 |
Oracle 9i Database Administrator Certified Professional |
CERN, Geneva, Switzerland |
2006 & 2008 |
Personal Awareness & Impact + Follow-up (3 + 2 day course) |
2005 |
Communicating Effectively (2 day course) |
ARTICLES & LECTURES
RedStack magazine, DOAG + SOUG magazine |
03.2016 |
Cloning solutions – a practical overview (translated for both French and German editions) |
Swiss Oracle User Group magazine |
12.2014 |
7 significant changes to user access control and privileges in Oracle 12.1 |
10.2013 |
Data Redaction & Transparent Sensitive Data Protection |
10.2012 |
Oracle GoldenGate, short usage review (prize of best article) |
Trivadis TechEvent, Zürich, Switzerland |
09.2015 |
Overview: database cloning solutions |
03.2015 |
Client example: Goldengate for upgrade from 10.2.0.4 32bit to 12.1.0.2 64bit |
03.2015 |
12c new Security Features + Proxy users – client example |
09.2014 |
Application Security (behind Oracle roles and profiles) |
03.2014 |
Oracle Database Vault and Privilege Capture |
09.2013 |
Data Redaction & Transparent Sensitive Data Protection |
04.2013 |
Stop using shared OS accounts to administer Oracle databases |
09.2012 |
Oracle DataMasking: what, when, how |
04.2011 |
GoldenGate, Yet Another Replication Tool and much more. |
International Symposium on Grid Computing, Taipei, Taiwan |
03.2008 |
Techniques for Implementing & Running Robust and Reliable DB-centric Grid Applications |
RAC & HA Special Interest Group, UK Oracle Users Group, London, United Kingdom |
02.2008 |
DBA experience in multi-RAC environment |
02.2008 |
Using DataGuard for hardware migration |
OTHER ACTIVITIES
|
Grünes Bündnis Bern, Switzerland |
11.2020 |
Candidate for the Bern city parliament (Stadtrat) |
Mobility carsharing cooperative, Switzerland |
03.2021 – present |
Delegate of the Bern Mittelland-Emmental-Seeland Region |
03.2019 – 02.2021 |
Alternate Delegate of the Bern Mittelland-Emmental-Seeland Region |
ProVelo Genève, Geneva, Switzerland |
03.2012 – 06.2016 |
Board member of the Geneva cyclists’ interests association; IT responsible; organizer of cycling travel workshop |
World trips |
07.2016 – 06.2017 |
Travel 13’000km by bicycle across Europe and South America |
04.2009 – 04.2010 |
Travel, mainly by train, through 20 countries and using Couchsurfing.org (‘worldwide network to make connections between travelers and the local communities they visit’) |
Silhouette Fitness Centres, Geneva, Switzerland |
09.2005 – 03.2009 |
LesMills Body Combat (aerobics) instructor |
Groupe SIDA Genève, Geneva, Switzerland |
04.2006 – 03.2009 |
Volunteer for AIDS prevention |
Create Switzerland, University of Geneva, Switzerland |
10.2003 – 02.2004 |
Entrepreneurship course |
Computer Science Department, University of Coimbra, Portugal |
06.2001 – 05.2002 |
Management Laboratory Board of Directors member |
06.2000 – 05.2001 |
Management Laboratory General Assembly Secretary |
06.2000 – 05.2001 |
Board member of Computer Science Student Representatives |
5th Management and Information Technology Meeting, Coimbra, Portugal |
2001 |
Organizer and media relations coordinator |
FREETIME
Adventure travel, cycling, ski touring, mountaineering
REFERENCES
Available upon request