Good afternoon!
I am freelancing database designer and ETL professional with more than 17 years of experience in designing, implementing and maintaining production databases for financial application and DW systems.
My primary technology domains are PostgreSQL (3 years), MySQL (3 years), Oracle (17 years), SQL Server (2 year).
I have 17 years of day-to-day experience in designing / developing / testing of SQL and procedural code.
My database technology experience comprises following :
• Database design and data modelling - PostgreSQL, MySQL;
• Database re-engineering and re-factoring incl. audit of black-boxed apps - Oracle, SQL Server;
• Database integration layer modelling - SQL Server, PostgreSQL, Oracle;
• Procedural code development mainly with PgPL/SQL, PL/SQL and SQL at PostgreSQL and Oracle;
• Dynamic SQL development for data migration needs - Oracle, PostgreSQL, SQL Server;
• SQL queries re-engineering and fine-tuning - PostgreSQL, Oracle.
I have extensive experience in handling of XML data and integrating in to Oracle and SQL Serve DBs - please allow few questions to get more details of your case :
1. Do you store native XML type at your DB ?
2, Do you have of XML object to DB tables available ?
3. Is it to introduce sub-queries to your query (to use xpath and value to decompose XML file) ?
Look forward to hear from you.
Best Regards,
Evgeny Shebanin,