Job description

A project carried out for a client in the lottery industry.

Our expectations:

• In-depth knowledge of Microsoft SQL Server features, performance tuning, and best practices

• Familiarity with other SQL databases like PostgreSQL and its functionalities

• Proven track record of creating databases and systems from scratch

• Demonstrated experience in migrating databases, particularly from MongoDB to Microsoft SQL

• Knowledge of Database CI/CD processes, DACPAC, Flyway etc.

• Experience working in a microservices architecture

• Experience in migrating and modernizing legacy database systems

• Proactive and self-motivated with the ability to manage work independently and prioritize tasks effectively

• Excellent communication and collaboration skills

• Strong analytical and problem-solving abilities

• Strong attention to detail and commitment to quality

Welcome Skills

• Proficiency in one or more coding languages such as C#, C++, Java, or Python is a plus

Key tasks

• Design, develop, and optimize databases (primarily Microsoft SQL Server)

• Create database structures, stored procedures, indexes, and other database objects

• Administer databases – monitor performance, perform tuning, manage backups, and ensure security

• Migrate data and systems, including from MongoDB to SQL Server, and modernize legacy database solutions

• Collaborate with other teams in a microservices architecture to ensure effective database integration

• Maintain and automate CI/CD processes for databases (e.g., DACPAC, Flyway)

• Work with various database engines, including PostgreSQL

• Ensure data quality, consistency, and system integrity

• Take a proactive approach to problem-solving and manage tasks and priorities independently

• Create and maintain technical documentation