← Back to list
senior
Registration: 27.09.2022

Ivan Tsatsarov

Portfolio

Coretech

Database Manager

Xogito.com

MS SQL Server Expert

SBtech.com

SQL Server Database Expert

Skills

Access
ASP
Assembler
Basic
BigQuery
C#
dBase
Delphi
MongoDB
MS SQL Server
.Net Framework
Oracle
Postgres
VBA
Visual Basic

Work experience

Database Manager
08.2019 - 07.2022 |Coretech (www.coretech.bg)
Responsible for all company database servers –SQL server 2016 with terabytes of data, Postgres databases and Mongo DB shards and replicas .Support Datawarehouse and ETL processes using SQL server integration service , create reports for management using SQL server Reporting Service, Create ETLs to import data into BigQuery.
MS SQL Server Expert
10.2015 - 07.2019 |Xogito.com
SQL Server DWH Development and support . C# Applications for XML, TXT ,X12 files transformation and for monitoring of folder content. Support for client SSAS cubes, creation and maintenance of SSIS packages for report generation and transfer via email. Administering of the clients SQL server , Lotus Notes and Postgre Databases.
SQL Server Database Expert
05.2011 - 09.2015 |SBtech.com
Support production and test servers of company, write store procedures, SSIS packages, Jobs, design new tables, optimize store procedure and configurations, create cubes and support SSAS databases, upgrade and patching the environments. Training of new DBAs.
Database DTS (Deep Technical Support) Engineer (Senior DBA)
10.2010 - 04.2011 |Hewlett Packard Global Delivery Centre ,Sofia
Support client SQL Server databases – installations ,configurations ,backups ,restores, high availability (clustering ,mirroring) ,replications ,performance tuning. Using ITIL methodology. Version supported- SQL 7.0,2000,2005,2008.
Database programmer
12.2005 - 09.2010 |Fincore Ltd ,Plovdiv – UK based software company (www.fincore.com)
Support and development of SQL Server Database for Workware5 planning product (SQL 2000,SQL 2005) . Development of Business Portal site - http://www.fincore.bg/pages/portfolio.htm#colloboration, creation of store procedures ,triggers, jobs, SSIS packages (SQL 2005) ,DBA tasks ,performance tuning.
Application Software Supervisor
06.2001 - 11.2005 |Hebrosbank, Plovdiv
Leader of Software group for Databases ,Client-Server and Web Applications. Design and programming SQL Server 2000 databases, ASP Web applications, designing Crystal Reports and Business Objects reports ,Local Intranet sites,.NET Projects for XML data exchange.
Expert IT
02.1998 - 06.2001 |Hebrosbank , Plovdiv
Creation Applications for data processing :MSACESS 2.0 Database for Currency Balance sheet , Money Report , MS ACCESS 2000 database for serving budget accounts ,Clipper 5.2 application for daily spot operations. Borland Pascal application for statistics of upcoming files. Intranet site based on Active Server Pages , SQL Server and Oracle 8 for reporting. ASP web site for online loan application based on MS ACCESS 2000 database. Database migration from Access to SQL Server 2000
Technolog data processing
12.1995 - 02.1998 |Hebrosbank,Plovdiv
Collecting information from all bank branches using Clipper 5.2 , FoxPro 2.6 applications for append in database, summarising ,report generation and file transfer to National Bank. Creating part of applications for data processing.

Educational background

Faculty: Mathematics and Informatics (Masters Degree)
1989 - 1994
Sofia University "St. Klement Ochridski”

Languages

BulgarianNativeEnglishProficient