always ready for new challenges
(updated May 2021)
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 |
Blogs |
https://anjo.pt |
|
|
Location |
Bern |
SUMMARY OF SKILLS AND STRENGTHS
Databases |
18-year experience Oracle DBA (8i-19c, RAC, Cloud, DataGuard, GoldenGate, Security), PostgreSQL, MySQL |
Programming |
Shell scripting, web programming |
Platforms |
Linux, AIX, Solaris, Windows |
Languages |
English, French – fluent/C1; German, Spanish – work knowledge/B1; 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 RAC Certified Expert Oracle Security Certified Implementation Specialist |
PROFESSIONAL EXPERIENCE
09.2010 – present |
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