Data Engineer & Database Developer & MS SQL Developer

Der Kandidat ist seit 1997 im IT-Sektor in einer kaufmännischen Praxis tätig. In seiner Funktion als Senior SQL-Entwickler war er für die Zusammenarbeit mit Architekten und der Geschäftsleitung bei spezifischen Projekten verantwortlich und arbeitete eng mit dem Entwicklungsteam zusammen. Zu seinen Aufgaben gehörten Datenbankentwicklung, T-SQL-Code-Entwicklung, SSIS-Paketentwicklung und Datenzusammenführung. Er trug auch zur Berichterstellung mit SSRS bei und verwaltete Benutzer und Berechtigungen für den Datenbankzugriff. Seine Rolle als IT-Administrator, MS-SQL- und MS-NAV-Entwickler umfasste die Konfiguration und Codierung der MS-Dynamics-NAV-Software sowie die Verwaltung von SQL-Server-Instanzen und die Fehlerbehebung und Überwachung. Der Kandidat verfügt über Kenntnisse in einer Reihe von Programmiersprachen, darunter C#, Java, Visual Basic, HTML, CSS und JavaScript, sowie über Kenntnisse in der Verwaltung von Windows-Servern, LAN/WAN und Lotus Notes. Er verfügt über ausgezeichnete Kommunikationsfähigkeiten in Englisch, Deutsch, Russisch, Slowakisch und Tschechisch.

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