Back to professionals

Data Engineer & Database Developer & MS SQL Developer

Overview


Short Summary

This candidate has worked in the IT sector since 1997 in a commercial practice. In his role as Senior SQL Developer, he was responsible for working with architects and management on specific projects, working closely with the development team. His responsibilities included database development, T-SQL code development, SSIS package development, and data merging. He also contributed to report generation using SSRS and managed users and permissions for database access. His role as an IT administrator, MS SQL and MS NAV developer included configuration and coding of MS Dynamics NAV software, as well as managing SQL Server instances and troubleshooting and monitoring. The candidate demonstrated proficiency in a variety of programming languages, including C#, Java, Visual Basic, HTML, CSS, and JavaScript, as well as proficiency in Windows server administration, LAN/WAN administration, and Lotus Notes administration. He has excellent communication skills in English, German, Russian, Slovak and Czech.

Work Experience

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
Author
Data Engineer & Database Developer +1
6537d748b55a4a0001411097
Availability01/11/2023
Employee5261  / Per month
LevelEXPERT
Roles
Data Engineer Database Developer MS SQL Developer
Languages
English
Skillset
Application ServerArchitectAzureC#CSSCloudComputer networksDatabaseDelphiERPElasticsearchHTMLHyper-VIDEJSONJavaJavaScriptMicrosoft Dynamics NAVMicrosoft Hyper-VMicrosoft SQL ServerMicrosoft serversMonitoring ToolsOraclePL/SQLPrometheusReportsSQLSQL DeveloperSales RepresentativeSearch ToolsServer Virtualization SoftwareT-SQLToolsUIVisual StudioVisual basicWindows ServerXML
Localities
RemoteBratislavský krajBratislava
Hybrid Localities
Bratislavský kraj