Data Engineer & Database Developer & MS SQL Developer

Tento kandidát pracuje v oblasti IT od roku 1997 v komerčnej praxi. Na pozícii senior SQL developer bol zodpovedný za spoluprácu s architektmi a manažmentom na konkrétnych projektoch, pričom úzko spolupracoval s vývojovým tímom. Medzi jeho povinnosti patril vývoj databáz, vývoj kódu T-SQL, vývoj balíkov SSIS a zlučovanie údajov. Podieľal sa aj na tvorbe zostáv pomocou SSRS a spravoval používateľov a oprávnenia na prístup k databáze. Jeho úloha správcu IT, vývojára MS SQL a MS NAV zahŕňala konfiguráciu a kódovanie softvéru MS Dynamics NAV, ako aj správu inštancií servera SQL Server a riešenie a monitorovanie problémov. Kandidát preukázal znalosť rôznych programovacích jazykov vrátane C#, Java, Visual Basic, HTML, CSS a JavaScript, ako aj znalosť správy serverov Windows, správy LAN/WAN a správy Lotus Notes. Má vynikajúce komunikačné schopnosti v anglickom, nemeckom, ruskom, slovenskom a českom jazyku.

Senior SQL Developer - Bratislava, Slovak Republic (JULY 2021 - SEP 2023)

• Worked as part of a development team on specific projects, including working directly with architects and management.
• Collaborated with the database developers, software developers, and Development Lead to architect and implement new features and solutions for customers, utilizing Visual Studio, SSMS, Devart Software, and Developer Tools for SQL Server and TFS.
• Performed database development functions, including database design, converting requirements to T-SQL code, managing the existing Database Platform, unit testing, and maintenance.
• Conducted T-SQL development (tables, stored procedures, functions, data types, etc.).
• Developed SSIS packages in MS SQL Server Integration Services (SSIS) with experience in ZappySys PowerPack.
• Contributed to DWH database and data merge.
• Utilized SQL Server Agent for job creation.
• Designed and developed reports using MS SQL Server Reporting Services (SSRS).
• Created users and assigned permissions based on the level of database access required.
• Handled index creation for ElasticSearch Server.
• Managed DB documentation using Devart Documenter.
• Troubleshot various problems that arose in day-to-day work and fixed issues.
• Conducted load-tests and analyzed results.
• Engaged in monitoring and performance tuning, including query tuning, database-level settings and options.
• Utilized SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Senior MS SQL Developer, Bratislava (OCT 2018 - JULY 2021)

• Similar to the role at PCP.COM, the candidate performed tasks including database development, T-SQL development, SSIS package development, SSRS report design and development, and more.

IT Administrator, MS SQL, MS NAV developer, Bratislava (JAN 2017 - OCT 2018)

• Configured, developed, and coded MS Dynamics NAV software and components in all functional areas.
• Created and modified customizations as requested by customers.
• Handled data conversions and debugged system problems.
• Installed and implemented service packs and new versions as needed.
• Developed adjustments and enhancements for the Microsoft Dynamics NAV business application software to optimize various modules and functions.
• Installed, administered, and maintained SQL Server instances.
• Managed user permissions and designed database backup and restoration strategies.
• Monitored the regular performance of database backups.
• Troubleshot various problems and resolved issues.
• Monitored and performed performance tuning at the physical server level, database level, and query level.
• Used SQL Server tools for various purposes.

Head of IT Department, Lviv (Ukrajina) (FEB 2014 - JUNE 2015)

• Performed supervisory and managerial tasks, overseeing technical projects, preparing financial budgets, installing and maintaining hardware and software, designing and maintaining computer networks, and responding to inquiries from various sources.

Head of IT Department, Kyiv (Ukrajina) (AUG 2004 - SEP 2013)

• Similar to the role at UNICOMBANK, this position involved supervising teams, directing the effective delivery of networks and systems, preparing financial budgets, installing and maintaining hardware and software, and more.

Senior IT Specialist, Kyiv (Ukrajina) (SEP 1997 - AUG 2004)

• This position involved regular monitoring of computer systems, documentation of operational procedures, installation of core system upgrades, new application development, and responding to email and help desk calls, among other responsibilities