Position: Middle SQL/DB Engineer
Company: ELEKS
Experience required: 3y
Category: SQL
English level: upper
Published: 2022-08-01T00:00:00+03:00

**About Project**
Swiss company in commodity trading. We are helping out the customer with various applications that supports their business (chain management, risk management solutions). There are few streams in account: support team, development team, data migration and knowledge base.
We are looking SQL developer to enhance our data migration stream.
The employee needs to assess data (orders, contracts, invoices) from old system and prepare scripts for the migration to the new system. The plan of the migration is to be done by the end of 2023. The employee is going to communicate on the daily basis with the customer.

**REQUIREMENTS**
- Having at least 3+ years of experience in development and administration
- Experience with MS SQL Server 2008R2 or higher
- Deep Knowledge of RDBMS, MS SQL
- Basic Knowledge in queries optimization, scheduling, import/export routines
- Pentaho nice to have
- Upper-Intermediate English level

**RESPONSIBILITIES**
- Explore existing and desire solution, how it’s works, what is underlying DB model to store data
- Analysis of existing solution DB model and data quality
- Prepare data extracts from existing solution to make decisions on data migration
**MS SQL:**
- Create and update DB objects(Tables/Views /Stored Procedures)
- DB modeling
- Optional: improving performance of DB selects
**Pentaho:**
- Create and maintenance of the Pentaho jobs.
- Testing of the jobs output
- Performing upload of the data