Data Engineer & Database Developer & MS SQL Developer

Tento uchazeč pracuje v oblasti IT od roku 1997 v komerční praxi. Na pozici Senior SQL Developer byl zodpovědný za spolupráci s architekty a managementem na konkrétních projektech a úzce spolupracoval s vývojovým týmem. Mezi jeho povinnosti patřil vývoj databází, vývoj kódu v jazyce T-SQL, vývoj balíčků SSIS a slučování dat. Podílel se také na tvorbě sestav pomocí SSRS a spravoval uživatele a oprávnění pro přístup k databázi. Jeho role správce IT, vývojáře MS SQL a MS NAV zahrnovala konfiguraci a kódování softwaru MS Dynamics NAV, stejně jako správu instancí SQL Serveru a řešení a monitorování problémů. Kandidát prokázal znalost různých programovacích jazyků, včetně jazyků C#, Java, Visual Basic, HTML, CSS a JavaScript, a také znalost správy serverů Windows, správy sítí LAN/WAN a správy Lotus Notes. Má výborné komunikační schopnosti v angličtině, němčině, ruštině, slovenštině a češtině.

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