2 views
4Team
A company specializing in the development of a crypto-algorithmic trading platform and included in the top 50 Binance traders on tools, is looking for a DWH Oracle Developer to join its professional team. data models
• Organization and support of DWH, understanding of segmentation
• Understanding of relational databases, normalization, packet integrity, etc.
• Oracle Advanced Queuing debugging
• Skills of applying all types of connections and deep knowledge of PL/SQL
• Accuracy in writing code in accordance with Company standards
• Application of various approaches to code optimization, work with a query plan
• Newbie DBA on basic level
• Additionally - experience building OLAP systems
Main tasks:
• Work with SQL, Oracle PL/SQL
• ETL of stock data
• Writing SQL scripts of varying complexity
• Designing denormalized data models
• Working with large volumes of data (billion records)
• Building data showcases, materialized views, etc.
• Optimizing queries and adapting them to the load
• Data migration, working with the MQ transport layer
• Development and support of reporting systems
The company offers:
• Opportunity for development in a team of professionals
• Decent pay
• Work with modern technologies, highload information system
• Technological, modern office
• Absence of useless bureaucracy and routine