About Me

(2009-current position) The followings are some of my current activities and responsabilities: 
-Responsible of the Oracle Real Application Clusters production environment for reservations of diagnostic screens on local public health units and hospitals (three nodes Oracle 10gR2 on Linux platform);
- Responsible of the Oracle Real Application Clusters production environment for the data warehouse of my company (four nodes Oracle 10gR2 on Linux platform);
- Developed several PL/SQL functions, stored procedures and packages used by the middleware infrastructure (JBoss) implementing optimistic locking and data integrity;
- Analysed and improved performances of the data loading nightly jobs;
- Installed a new Oracle Real Application Clusters production environment for the data mart of Business Intelligence (two nodes 10gR2 using ASM on Linux platform);
- Involved in the process of migrating a legacy “single instance” database into a Real Application Clusters solution formed by four multicore nodes with Cluster Interconnect RDS Infiniband and multichannel disk systems;
- Involved in the process of migrating several “single instance” Oracle development environments into Real Application Clusters solutions using Oracle VM as virtualization software;
- Involved in the process of introducing the Oracle Data Guard solution in the same location of production environment to achieve a highly available database using a logical standby database and maximum performance as protection mode;
- Database and CRS patching from Oracle 10.2.0.1.0 to 10.2.0.5.0;
- Database and CRS patching from Oracle 11.1.0.6.0 to 11.1.0.7.0;

(2006-2009) Main activities and responsabilities: 
- Responsible of Oracle Real Application Clusters production environment for the Voip and Mobile Virtual Network Operator platforms (three nodes Oracle 10gR2 on Linux platform);
- Responsible of Oracle Real Application Clusters production environment for the mediation MVNO platform (two nodes Oracle 11gR2 on Linux platform);
- Responsible of Oracle Real Application Clusters production environment for the data warehouse (two nodes Oracle 10gR2 on Linux platform);
- Integrated policies for backup and recovery through RMAN (on Solaris platform) and the media manager EMC Legato Networker, documenting the times of restoration and recovery of all the Oracle databases;
- Administrator and responsible of three Oracle AS installations for business intelligence (Oracle Discoverer) and migration to Oracle BI EE Plus (two clustered nodes on Linux platform);
- Database and CRS patching from Oracle 10.2.0.1.0 to 10.2.0.4.0;
- Database and CRS patching from Oracle 11.1.0.6.0 to 11.1.0.7.0;
- BI EE Plus patching from 10.1.3.3.3 to 10.1.3.4.1;
- Guaranteed availability service H24, as well as on the direct services of competence, even for the whole Infrastructure for MVNOs and VoIP (SCP nodes, applications for Service Exposure to and from TIM and to and from Intesa San Paolo bank, RADIUS and DIAMETER AAA services, USSD services, SMPP services, PLEX, IVR, VPN Concentrator, Asterisk, SIP agent, Jabber);

(2001-2006) Main activities and responsabilities: 
Installed and configured several development and testing Oracle databases for enterprise products, such as mediation, fraud and judiciary;
- Implemented policies for backup and recovery for every Oracle databases (Solaris, Linux and Windows platforms);
- Migrated and updated several Oracle databases from 8i to 9i and/or 10g version for various clients;
- Designed and installed for a primary customer based in India, a Oracle Real Application Clusters production environment (two nodes 10gR2 on Linux platform);
- Provided remote database assistance to Indian and Brazilian customers via VPN and Secure Shell;
- Provided consulting services for programming in PL/SQL for several banks;

(1998-2001) Main activities and responsabilities (as software developer):
- Team leader of Interconnection and Mediation products (using C, PRO*C and PL/SQL, shared memory, messages, queues, memory mapped files);
- Developed a complex Unix process able to analyze, verify and normalize million records of telephone calls per hour (C and PRO*C);
- Created a Unix Scheduler process highly configurable to automate daily, weekly and monthly billing tasks (C and PRO*C);
- Developed PL/SQL packages and Unix shell scripts for statistical calculations;
- Updated and maintained pre-existing Oracle databases (Solaris platform);
- Designed and developed a software for remote control and intrusion detection (Java, C, PRO*C);
- Developed a Watchdog process with a GUI interface (Motif, C on Solaris platform, TCP/IP, socket) able to redirect applications to different databases and networks in case of problems;
- Developed DLL using C (shortest paths, location of equipment, optimization of transport) and integrated into the MapInfo GIS (Geographic Information System) engine software;

2 comments:

Anonymous said...

Hi Marco,

I've read your question on oracle forum about setting up the Radius Server (https://forums.oracle.com/forums/message.jspa?messageID=4227574#4227574).

Did you manage to resolve the problem? I'm getting the same issue here.

Thank you.

Mallikarjuna Macharla said...

hai admin,your rman senarios are very usefull to me,
i want dataguard senarios also,can u post more senarios