Denis Herceg

Database and software developer

Podgorica, Montenegro +382-**-****** ac3d9c@r.postjobfree.com

linkedin.com/in/denis-herceg/

Database and software developer with 2+ years of experience in a high all-round IT knowledge environment. Tuned and modeled databases for various small size local projects and built reports using different technologies. Implemented backup strategy for local development and test database. Built various modules for Registry offices and Human resource managing solution. Certified microsoft solution expert in data management and analytics. Certified microsoft associate in development, administration and sql server 2012 with huge passion for databases. Highly work oriented and very persistent. Socially active on dba.stackexchange and stackoverflow with a goal to help other people and meet the new challenges. Nov. 2015 - Present

Feb. 2015 - Nov. 2015

Database and software developer

Čikom, Podgorica

Assisted in developing and modeling database for various national and local projects including software solution for managing Human Resources, Clerk`s office, Employment record book. Built website, logo and various graphical reports based on a surveys for Cloud4SME project which was focused on implementing cloud services in Montenegro. Tuned and built reports for Registry office, Building, Urban property & Tourism inspection. Part of job was also integrating reports within application which was built on ASP. NET (MVC & WebForms) framework.

Designed database and Web application in a team of two, for a Registry Office which was later improved with adaptive functionalities and implemented in 4 cities in Montenegro. Assisted in modeling software solution for managing Human Resources, i have also implemented a calendar module where tasks, notifications and holidays would be graphically posted/displayed on a calendar with dynamic state change. Tuned and wrote complex queries and reports for Registry office, Building, Urban property & Tourism inspection which were mostly ad-hoc unoptimized queries which had to be changed to meet maximum time execution (10 seconds). Designed database for Unformal education module, which is part of Human resource managing software solution where accent is mostly put on managing acquired certifications, incoming exams, and progress toward completing certain certificate. Implemented reports on a production database

Assisted in writing tender and making critical decision in choosing SQL Server edition, and HA/DR solution on a Standard edition.

Mentored three interns in half of a year span whos task was to learn SQL and build a database for a fictional Registry office system.

Application tester

Čikom, Podgorica

Worked on testing application which most of Montenegrin ministries were using for their office operations. Finding "holes" in an application,reporting bugs and maintaining stable version was part of a daily job. Knowledge gained in this area was quite useful for further development where i learned how to find and avoid bugs. While bugs were being fixed by the development team located in Serbia, i worked as a computer repair technician and would switch being applicaton tester whenever that was needed.

Database tuning

Query tuning, Indexing, Table partitioning,

Analyzing wait stats, FIle placement and

allocation

Database security

Implementing TDE (Transparent Data

Encryption), Always Encrypted, Column-

Level Encryption, Schema design, Role

and User/Login rights managing.

Microsoft Azure

IaaS, PaaS, SaaS, Managing AD

Backups

Planing Simple/Full backup strategy,

Filegroup backups, Partial backups

SSRS & SSIS

ETL (Extract transform load) jobs, Report

building, Graphically designing reports

using Report builder, Tableau.

HA/DR

Log Shipping, Winodws Failover

Clustering, Replication, Mirroring,

AlwaysOn Availability, Microsoft Azure

Languages

C#, Javascript, jQuery, HTML, CSS,

Summary

Work experience

Skills

https://www.visualcv.com/hafioghibt0

Jan. 2015 - Nov. 2015

Jan. 2015 - Apr. 2015

Computer repair technician

Čikom, Podgorica

Before started as a web developer and tester, had an intern job as repair technician where i learned a lot about repairing computers and diagnosing problems. Repairs included basic repairs from cleaning and diagnosing software issues up to repairing GPUs, HDDs, restoring OS using linux, retrieving data from damaged disk. Regardless of knowledge in other areas going through a process being repair technician, application tester was essential in this company. Intern

International Bridge

In off hours saw a chance for a new experience and applied for an internship in a newly opened US company in Podgorica, which main focus was on shipping items between US-China and Europe. Was working on back-end of a test application where got introduced to Visual Studio and ASP.NET MVC framework. Main job was designing database and implementing it, using database first approach and implementing email-application synchronization where agents would using application reply to a customers and customers would write them back using email.

Bachelor2013 of Information Technologies 2009 -

MEDITERRANEAN UNIVERSITY, Podgorica

Data modeling and database design.

Performance management and

tuning

Backup and recovery

Schema creation & management

Database security

Ensuring data integrity

High availability & Disaster

recovery

ETL

Microsoft Azure

Data Quality Service

Procedural skills

Web-specific technology expertise

Microsoft Certified Solutions Expert: Data Management and Analytics Microsoft Certified Solutions Associate: SQL 2016 Database Administration Microsoft Certified Solutions Associate: SQL 2016 Database Development Microsoft Certified Solutions Associate: SQL Server 2012 (MCSA) Microsoft Certified Professional

Long time water polo and jiu jitsu practicioner. Before started working full time i competed on semi-professional level in jiu jitsu. Enjoy playing basketball and soccer with my coworkers twice a week. Traveling and exploring a new places has always been fun, and during summer and winter i always try to find some spare time to go swimming or skiing. Depending on a mood some days i would take a guitar and play it for hours. Sometimes would come up with a new song, but would eventually forget it. Recently created an account on stackexchange and stackoverflow where i find it very interesting and sometimes challenging to help other people. Biggest achivement being active on dba.stackexchange was number one most influential member for a week.

Education

Core Competencies

Certifications

Hobbies & Interests

https://www.visualcv.com/hafioghibt0

Contact this candidate