Relational Databases

Hello everyone!



I'm Dmitry, an analyst with a passion for data analysis that dates back to my university days when I studied economic cybernetics.



Following my graduation, I delved into the analytical realm, gaining diverse experience in sectors such as retail, direct sales, and e-commerce. I've worn multiple hats during my career journey, serving as a sales analyst, marketing analyst, data analyst, product analyst, and currently, leading a team of analysts in an international IT company.



My analytical journey began in 2014, allowing me to accumulate and organize a wealth of practical skills in this field, which I'm eager to share.



No more time to waste—let's embark on the journey to enhance your skills!

I possess a broad spectrum of experience in the field of information technology, encompassing tasks ranging from system administration to the development and fine-tuning of applications for both Android and ERP systems. My role as a database developer has been ongoing since 2019.



Over this period, I have successfully administered various databases, including MySQL, MariaDB, Microsoft SQL Server, Advantage DB, Vertica DB, Oracle DB, and PostgreSQL.

I have about 20 years of experience in IT. During this time, I managed to work with different technologies.

In recent years, I have been actively working with C++ and databases (MS SQL Server, MySQL, Firebird).

In the past, I wrote video courses about MS SQL Server for one company.

I have experience working with big databases, where millions of records were collected in an hour.

I have experience in query optimization.

Using different tools, I created reports based on databases.

I am currently working as a C++/SQL developer to support and develop our company's product.

I have approximately five years of experience in software development and over two years of experience teaching JS and React.js to individuals of all ages, ranging from 12 to 99 years old. I hold a degree in computer engineering, demonstrating my technical and specialized education in the field. Additionally, I have successfully completed three professional development courses to enhance my skills further.



What sets me apart is my ability to explain complex programming concepts using relatable analogies such as brooms, fountains, apartments, cars, and more. I firmly believe in making information accessible and understandable to everyone, and I strive to communicate technical concepts using simple and clear language.

Throughout my career, I have worked in various environments ranging from outsourcing companies to startups, where my role involved managing complex development tasks and systematization. I have successfully maintained a balance between technical and managerial responsibilities. I have progressed from a regular teacher to the head of the Programming and Applied Mathematics departments.



Over the past 7 years, I have applied my skills and experience in the field of IT. I possess a wide range of technologies. Leveraging my PhD degree in engineering and technical sciences, I adeptly translate complex mathematical models into code. My technical expertise includes programming languages such as JavaScript, Python, as well as development on Node.js, database utilization, and other technologies. I am constantly driven to learn and develop, allowing me to stay at the forefront of the IT industry.



With over 25 years of teaching experience in universities and IT schools, I have developed and implemented teaching methodologies that have helped thousands of students learn programming. This teaching experience has allowed me to refine my skills in planning, growth strategies, building effective teams and business processes, as well as quality control.