About the role
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
Nice to have
- Proficiency in one or more coding languages such as C#, C++, Java, or Python is a plus
Main responsibilities
- 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
