Position: Senior Database Engineer
Company: Pine Software
Category: SQL
Experience required: 3y
English level: intermediate

Requirements:
- Experience with both relational and non-relational models
- Database architecture experience, familiarity with architecture patterns
- Expert level skills in specifying, developing, building and maintaining highly reliable
- PostgreSQL solutions
- Strong experience in stored procedures and functions, tuning queries
- Experience with large datasets
- Knowledge of Best Practices in database monitoring, maintenance, operation, updates, and security
- Ability to act as a teamplayer

Would be an advantage:
- Experience with TSDBs
- Understanding of problems of time series and large datasets
- Networking and hardware background

Responsibilities:
- Designing data architecture
- Building and troubleshooting data systems
- Monitoring and optimizing the performance of databases
- Modifying database structure, as necessary based on regular analysis
- Assisting application developers with DB-related optimisations

The main objective of the back-end software:
- Receiving online data streams from stock exchanges
- Processing, normalization and transmission to servers in data-centers
- Mathematical processing and delivery in the required form to customers

Priorities:
- Maximum reliability
- Top performance
- Low latency
We optimize everything: CPU load, size of transmitted data, number of network packets, amount of memory used
At peak input data flow reaches more than 10 Gbps

Stack of technologies used on the project:
- С++(17, 20), std, multithreading, Unix-sockets
- FIX protocol
- Redis, PostgreSQL
- С#, WPF

We use:
- Host: Linux (Centos)
- GitLab, Jira, Confluence, G-suite

About us:
- We create our own products: software for financial transactions on exchanges and multi-service ERP software. We work in close collaboration with end users
- Our team has 26 people now: 10 С++, 3 .Net, 3 Python, 1 Web Full Stack, 5 QA, 2 DevOps, PM, PO
- We have a creative, working atmosphere
- Between deadlines and quality we choose quality
- The projects are planned on the horizon of at least 5 years

In the office:
- Fresh and varied food(at own expense)
- Library
- Gym 24/7
- Massage
- Professional car racing simulator
- Table tennis

Our company values:
- Humanity
- Teamwork
- Development
- Innovation