— 3 — 4 years of experience in SQL coding, in a commercial environment
— 2+ years of experience creating and maintaining complex SQL code and complex database structures
— Experienced with:
Relational tables
Memory-optimizing table
Experience with data modelling
Triggers, functions or procedures using tables, user defined types
Can handle XML, JSON or binary objects with functions to leverage them
Working with REST-API, JSON
Improving performance and quality of queries
— Ability to complete time-sensitive tasks, independently or as part of a team
— Proven experience working in a startup environment
— Self driven and eager to learn and grow your skills
— Ability to comply with project standards and internal policies about how to write
— SQL code, including formatting
— Strong in English and communication skills, both written and verbal
— Experienced, open-minded, professional teams
— Unique working environment where you communicate and work directly with client
— Nice work environment where you work with Friends
— Competitive salary
— Excellent benefits
— Fresh and Tasty Coffee, Tea and Cookies
— Five-days working week
— Health Insurance & Multisport Program
— Flexible Office hours, depending on the project
— Paid vacation (21 working days) and sick leave
— Create SQL stored procedures to load and manipulate data into production table structures
— Deliver high quality of database services, queries and database designs
— Work in a serviced manner with both internal and external clients, translating business requirements and ensuring proper functionality and requirements are delivered on time.
— Perform SQL data profiling, analysis and mapping to ensure data quality and reliability
— Handle new implementation, changes to existing layouts/data load code, automation development, performance optimization and database maintenance like indexing and fragmentation
— Create efficient and effective database structures assigned by Database Architect.
— Test mapping and code to ensure the data is loaded appropriately
— Ensure data loads are completed and quality checks are performed
— Support defect triaging, fixes and testing
We are looking for a data driven SQL specialist, who enjoys working with databases, optimizing performance and who can work on complicated queries, large data sets in a fast paced environment.
Working closely with the development team, you will be responsible for building efficient and high quality code in a large PostgreSQL environment. You will work closely with the database architect and build new features, optimize current codebase and ensure speed and quality in all your code.
The project is a feature rich API, used for an event management platform, where several types of front end client interact with the API to process all sorts of data.