I am freelancing database engineer and ETL designer with more than 18 years of experience in designing, implementing and maintaining reporting solutions and data integration platforms for financial reporting systems.
My database stack consists of design, development and fine-tuning of data models, procedural code and data integration scripts across Oracle (17 years), MySQL (3 years), PostgreSQL (2 years).
My technology experience comprises following
• ETL jobs design and implementation (database VS database, sequential file VS database, database migrations) – ODI, Datastage, Talend;
• Scripting support of database migrations – Perl, Python;
• PostgreSQL and Oracle DB design and data modeling (logical and physical models, ER diagrams);
• 17 years of day-to-day experience in Oracle back-end development : PL/SQL, SQL incl. technical design, technical reviews, technical implementation and coaching works – the actual code will be queries, stored procedures / functions / packages, DBMS scripts;
• PostgreSQL and Oracle DBA activities incl. administration of tablespaces, data files, tracing actual memory distribution.
My latest projects with SQL Server and T-SQL:
1. Code conversionс from Oracle PL/SQL to T-SQL
2. Custom procedure design for timesheet management application with T-SQL
3. Integration tests scripting with T-SQL.
Happy to help you with Microsoft BI needs, run small POC and step in daily project work.