Position: Junior/Middle DB Engineer
Company: Proffiz
Experience required: 1y
Category: SQL
English level: intermediate
Published: 2022-05-01T00:00:00+03:00

**Who is on the Pit Wall**
Our customer is one of the world’s top 10 leading software publishers.
They develop Creativity and Learning softwares, Utilities and Multimedia, all featured with the latest cutting edge technology to provide consumers and businesses with an easy, relevant and secure user experience.
10 million customers rely on our client, every year 650,000 software products are sold. Every minute, 10 software products are sold worldwide. This is a sign of confidence that they are always working to sustain.
Would you be the one to join?

**🏎 The Race 🏎**
You are going to take part in a race for digitalization, in which you will have to move on two tracks.
Here you’ll work with the application that will empower users with a variety of photo editing possibilities, like background objects removal, separate elements, shapes cut, photomontage, one-click image correction. Also adding textures and frames and numerous adjustment possibilities like filter use, effects, and other image parameters.
The second route will be document management – a solution that allows you to create, convert, and edit your PDF documents, like Google Docs.
We are talking about products that the average person uses every day to make work and life easier and you have a chance to join this process!

**Your driving experience**
- 1+ year of experience with DBMS MS SQL Server
- Strong knowledge of T-SQL
- Understanding the principles of OLTP-system construction
- Experience with building ETL-processes
- Good performance of SQL-queries
- Experience with SSMS, MS Visual Studio, MS SQL Profiler
- English level at least intermediate

**Would be a plus:**
- Experience with large volumes of data and data warehouses

**Your Bolide**
- DBMS MS SQL Server;
- T-SQL;
- SSMS;
- MS Visual Studio;
- MS SQL Profiler.

**Track**
The race begins with a warm-up lap – you may call it –  onboarding. During the warm-up lap you meet the HR-manager who solves various organizational questions, guides you around the office, adds you to internal communication channels, provides you with the needed equipment, etc. Then meet the client, the team, drink a cup of tea or coffee and start exploring the project.
After a warm-up lap, you are ready for the race in which you should:
- Database architecture development, creation, and modification of existing business logic of Database, preparation of data for analysis and reports
- Database normalization, indexation, and optimization
- Writing triggers, stored procedures, and functions, the ability to analyze query plans, testing code
- Working with data arrays, extracting, transforming, and loading data
- Development and maintenance of query execution to the linked servers
- Technical documentation development and implementation
You will have the opportunity to enjoy development from scratch, in some application components while adhering to the company engineering standards, frameworks, and best practices.

**The Driver Assessment**
- HR Interview (30 minutes)
- Technical interview (30-40 minutes)
- Client interview (1-2 hours)
Let us know if you require any accommodations for the interview process, and we`ll do our best to assist.

**Pit-Stop**
- Flexible working hours
- You can work remotely, from the office, or mix both
- Spacious technically equipped workplace
- Regular Performance Appraisals
- Free English courses
- Medical Insurance
- Access to online courses
- Corporate events, tech talks and so on

**Ready, Steady, Go!)**