Database Developer
Overview
Short Summary
The candidate is an MS SQL DB specialist with a focus on complex problem solving. He has experience in various IT fields, including microelectronics, programming, testing, CAD/CAM, and CNC. He has been working with MIS DB (MS SQL) since 2001. In his free time, he enjoys technology, manual work, construction, and cars. He is motivated by learning about new and more effective solutions in his field and enjoys using analytical thinking to find answers to unclear assignments. He has worked on interesting projects such as supporting PC production on assembly lines and integrating repair planning systems. He has expertise in code analysis, T-SQL development, DB optimization, and data mining. He has worked with various clients, including Innogy Group, Hartmann Rico, and Ernst & Young. He has a university degree and postgraduate study in engineering. He is proficient in English and has passive knowledge of German, Polish, and Russian. His technical skills include MS SQL Server, T-SQL, and additional knowledge in C#, VB, and WPF. He is certified in MSSQL 2005 - TSQL. He has participated in various projects, including FT project for customer operations, auxiliary tool for database filling, and application support for FT applications. He has also worked on projects for ČSOB PFM, UPC CZ, E&Y, and Česká Pojišťovna. In addition to his IT work, he has also worked on solar applications and the development of a CNC universal lathe.
Work Experience
Role 1: MS SQL DB Specialist
As an MS SQL DB Specialist, I have been technically focused on complex problem solving in the field of database management. I have experience in various IT fields such as microelectronics, programming, testing, CAD/CAM, and CNC. My expertise in MIS DB (MS SQL) spans over 18 years. I have a passion for learning about new and more effective solutions in my field and enjoy using analytical thinking to find answers to challenging assignments. Some of the most interesting projects I have worked on include supporting PC production on assembly lines, integrating repair planning systems, and optimizing database performance. I have worked with clients such as Innogy Group, Hartmann Rico, and Ernst & Young.
Role 2: MS SQL DB Specialist
In my role at Capitol, I was involved in the development and support of a FT project for customer operations on the PXE/CDCP securities market. I provided support over MS SQL and played a key role in the development of the project.
Role 3: MS SQL DB Specialist
During my time at CMRZB, I worked on an auxiliary tool for database filling in JSON format. This project involved converting data from Excel to MS SQL and was completed within a span of 7 months.
Role 4: MS SQL DB Specialist
At Linet Group, I participated in a pre-pilot operation where I was responsible for mapping attributes to dimensions and facts, developing stored procedures and views for the data warehouse layer, and defining MDS code lists and data sources. I also handled application busy requests for exceptions or local conventions.
Role 5: MS SQL DB Specialist
In my role at ČSOB FT, I provided application support for FT applications and was involved in the maintenance and development of the FT infrastructure.
Role 6: MS SQL DB Specialist
At ČSOB PFM, I analyzed and provided solutions for data integrity issues, developed scripts for data cleaning, and performed housekeeping tasks. I also worked on the initial load of data and handled job automation.
Role 7: MS SQL DB Specialist
During my time at UPC CZ, I worked on the Fénix Expedition project. This involved developing required back-end supplements with an error message system and updating SOAP services for the messaging system. I also worked on the development of tables, stored procedures, and functions for working with data and XML.
Role 8: MS SQL DB Specialist
At E&Y LIC, I worked on the development of the banking tool LIC for external consultants of banks and financial institutions. This involved working with MS SQL 2008 R2 and MSRS to develop solutions for credit cards and the American mortgage industry.
Role 9: MS SQL DB Specialist
During my time at Česká Pojišťovna, I worked on the LPU Property project. I designed triggers for evaluating event status and integration with the existing Eurocalc system.
Role 10: MS SQL DB Specialist
At Datalan SK, I worked on the Ekoos and Evoting projects. This involved analyzing business requirements, designing process flows and databases, and optimizing the relational database model.
| Freelancer | 253 € / Per day |