DBA

GORAN MANCEVSKI

Address: St.Hristo Uzunov **A Skopje, MK zip code: 1000

Work tell: +389 (0)70 298022 Private tell: +389 (0)78 313475

Private e-mail: *********.*****@*****.***

Date of birth: 10/11/1970

Senior Database Relational/Business Intelligence/Document-oriented Administrator & Developer

Database and Data Warehouse administrator/SQL- MDX developer (expert level) with extensive experience in designing, coding, testing, maintaining and supporting next-generation database solutions in Microsoft SQL Server 2000/2005/2008/2012/2014 environments. Proficient in an assortment of MS technologies, cloud and on-premise instances, familiarized with managed and unmanaged programming languages according to CLRs creation, spatial data and scripting languages. Extensive experience with Database Systems in Oracle 9i, MySQL, Access, Sybase, Sql AnyWhere, Informix, MongoDB, RavenDB, Couchbase, ElasticSearch, MapServer, DB2, on Windows and UNIX platforms altogether. DBA skills include:

MS SQL HADR, backup/recovery strategies

Relational, dimensional and data vault modeling, SSIS, SSAS and SSRS components

MS SQL Server Database Development & Administration

Performance Tuning & Capacity Monitoring

SQL/CLR advanced and complex routines design

Complex ad-hoc and custom reports creation

Oracle RAC & ASM Administration/Installation

Oracle Forms and Reports Development

Database-Backed Web Solutions

SQL Tuning in an Oracle Environment

MySQL Replication and Automate Failover

MongoDB designing, config. and JS backend

MS SQL Server HADR

Experience

LifeWatch/BioTelementry Inc., SK MK office

Senior Database Administrator/Sql Developer

2014-Present

- As a lead of the DBAs team I am working on daily tasks on multi-database farm. I am serving in dB architecture, data modeling and development of existing and new functionalities, refactoring and performance tuning, index strategy, consulting, dB architecture improvements, monitoring and alerting, load balancing, user management, QA/Dev environment data redundancy + backup and restore strategy, HADR, ETL process and migration, dB versioning, dB deployment and packages preparation, reviewing and approving other dB code, testing, data formatting, capacity planning, support to the team for SQL and programming coding, documentation, solutions for dB improvement, resolving bottlenecks and issues in dB, meetings and releases etc.

IT Labs Skopje office /FL USA

Senior Database Administrator/Developer

- Amazon storage architect, Sql Server 2012 Administration, database development, Relational Data Storage, Peer to peer replication HADR and Data Redundancy, design and modeling, developing advanced T-Sql routines and reports. Served as DBA on various projects simultaneously (GetCubed, TalkMarkets, Codengo, Deloitte and Touché, Emergenetics, Pet channels, DecisionInsite …)

- Created advanced custom text search engine and google like graph search.

Solaborate Social Network Platform, LA USA 2013 -2014

Senior Database Administrator/Developer

- Sql Azure storage architect, Sql Server 2008/2012 Administration, database development, Azure database federation, AlwaysOn HADR, design and modeling, advanced T-Sql routines and reports. Migration to NoSql environment and on-premise instances, parallel application bidirectional.

- Created advanced custom text search engine.

Novatec Software Solutions, Labin Cro

Database Administrator/Developer

2011–2013

- Manage Sql Server / MySql /MongoDB /MapServer databases administration assignments for diverse touristic and industry clients. Design, enhance existing databases performance, perform restores, implement recovery procedures, handle performance tuning, spatial data deployment/visualization and conduct regular system backups. Ensure technical and functional designs meet business requirements.

Key projects:

- Served as BI DBA/Developer (CHBIS – health care system on national level) and DBA on tourism project lead backend in the completion of 80+ medium- to large-scale implementations, developing subprojects from business requirements analysis to solutions delivery and support in tourism services area. PHP, MySQL and document oriented MongoDB were married.

Aton Solutions, FL USA

Database Administrator/Developer

2007– 2011

- Backend contributed in a data-integration project for financial services firm that consolidated information from accounting applications, third-party market data and internal equities/fixed income applications. Microsoft technology –.NET, JS, C# & SQL Server 2008 R2 Enterprise.

- Contributed to BI project pharmacy’s 15% revenue growth in 2011 by standardizing content from disparate databases, enabling sales and support staff to quickly respond to customer requests. Legacy systems were Informix and file system. Data migration via SSIS into data warehouse.

- Contributed Web-enabled, group-scheduling system for a large university, allowing students to register, view and print schedules for current and future semesters. Data migration in new environment. Improved functionality and new web portal. Delivered solution on time, on spec and on budget. MySQL and PHP.

- Developed and tested storage strategies (Molap and Rolap) in twelve member’s team for Big Data, as well as implemented a disaster-recovery plan, for large health care company’s operational databases, transforming them via SSIS into UDM storage for further geospatial analysis. Data delivering solution that guaranteed performance and high availability for analyzing and quick decision making. SQL Server 2012 Enterprise Denali.

- Enhanced end users understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training guide materials.

Commercial Bank AD, Skopje, Macedonia

Database Administrator 2002/2007

- Administering SQL Server and Oracle Databases in financial environment.

Freelancer as Database Administrator 1999/2002

- Administering DB2, Access

Education & Training

Bachelor of Electrical Engineering, University “St. Cyril & Methodius” Sk MK

1989/1993

IT Workshops: Oracle Database Administration (2004), Advanced Oracle DBA (2005)

IT Trainings: MS SQL Server Pro Design DB Solutions and Data Access using SQL Server 2008 (2011), TS-MSSQL Server 2008 DB Development (2011).

Contact this candidate