always ready for new challenges
(updated June 2019)
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 |
| |
|
Address |
Bern |
SUMMARY OF SKILLS AND STRENGTHS
| Databases |
16-year experience Oracle DBA (8i-19c, RAC, Cloud, DataGuard, GoldenGate, Security, OEM), 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 Certified Professional – Database Administrator 9i, 10g, 11g; 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 (current, 75-100%): 40-50% performance improvements on critical applications; Upgrade project 11g-19c; Support team replacement;
- Nespresso (past 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
| 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 |
REFERENCES
Available upon request
|