Zoran Jankovic

Create, administration and maintenance data systems. Support of production databases (24/7 availability for customers, optimization of execution speed, identification and elimination of bottlenecks, etc.). Proactive way of working. Support and working with development teams in queries and optimization. Creation of procedures and queries for them. Support, monitoring of production databases (24/7 availability for customers, identification and elimination of bottlenecks, etc.). Migrate and ETL data.

Design, develop, maintain the Production and Reporting databases for banks in USA (clients). 24/7 support. Data availability, monitoring, security and optimization. Assistance in creating and maintaining queries and procedures for complex reports (ad hoc reports). Design, creation and development of reporting systems. Debugging and optimization of large queries and stored procedures. Create and maintain Backup-recovery and disaster recovery plan. Data migration, and all other DBA tasks.

Design, create, develop and maintain banking Core and Report databases (from developers and DBA side). 24/7 support. Create and maintain queries, stored procedures for complex reports (ad hoc reports and also SSRS) for the bank and also for National Bank and other. Design, create, develop OLAP reporting system (SSIS). Debugging and optimization large queries and stored procedures. Performance tuning from developers and from DB admin side. Data migration. Complex data analyze.

Pflege von Datenbanken zur Unterstützung des Berichtswesens für die Bedürfnisse des Unternehmens. Erstellung und Pflege von Berichtssystemen (statische Berichte, OLAP, Dashboards...). Pflege von Produktions- und allen anderen DB-Servern (24/7). Erstellung, Entwicklung und Wartung eines Backup-Recovery Plans. Betreuung von Optimierungsabfragen, Auffinden und Behebung von Datenbankengpässen, Datenmigration, Unterstützung des Softwareentwicklungsteams und vieles andere ....

Database programming