Senior Database Engineer in Temy

Direct message the member who posted the job from Temy Yevhenii Mots Yevhenii Mots Looking for Senior Data Engineer We are looking for a Database engineer for a US startup. The product is a platform based on artificial intelligence, which ensures the creation of full-fledged models of interiors and sets of furniture.  Key functions include: setting the budget, the production and assembly period of the furniture. The style and palette of the interior will be determined based on the customer's preferences. Customers will also be able to personalize all furniture options, including materials, upholstery, color, size and design details. It will be possible to create an interior catalog based on the uploaded room plan, zoning and room size. The service will offer the selection of furniture and the purchase of the entire selected set directly from suppliers. The company has been on the market since 2023. We have Database, ML and 2D/3D engineers on our side. We are currently looking for another Database Engineer.  The team works according to an agile methodology, combining Scrum and Kanban. Sprints of 2 weeks and planning once a week. Stages of the interview: Recruitment interview (25 min +/-) Technical interview (60 minutes +/-) Acquaintance with the client (60 minutes +/-) Team: CTO (on the client side) Project Manager (on the side client)Database Engineer (at Temy)ML/AI Engineer (at Temy)2D/3D Developer (at Temy)2 part-time ML/AI Engineers (client side)Requirements: 4+ years of experience as a Database EngineerPostgreSQLT-SQL (window functions, views, stored procedures, functions, partitioning, indexes, JSON-functions)PythonAWSCI/CDExperience in designing and creating data pipelines, ETL using PythonUnderstanding methods for optimizing database performance, indexing, query optimization and caching strategiesExperience in working with dynamic data structures and heterogeneous data sources Experience in database administration and support, including backup and recovery procedures English Upper-Intermediate and above Will be a plus: SnowflakeApache AirflowMongoDBTechnology stack: PostgreSQLT-SQLPythonAWSCI/CDApache AirflowMongoDBResponsibilities: Designing, creating data pipelines and ETL using Python, SQL and AWS Design, implementation and integration of database architecture to support an automated platform for furniture location and specification using AWS infrastructure Ensure data integrity, security and performance through design and implementation of effective data management strategies including backup, recovery and access control Design and implementation of data migration strategies for seamless transition of information from old systems to a new database Development of new tools or use of existing toolsdatabase automation to automate tasks related to databases Cooperation with software developers to integrate the functionality of databases at the application level, ensuring uninterrupted data flow and efficient information retrieval Creation and maintenance of technical documentation, description of processes Cooperation with the team We offer: 18 days of paid vacation, 10 days of paid sick leave. The possibility of taking additional days off at your own expense. Competence center for knowledge exchange and professional development. Compensation for courses and certification. English lessons in small groups. Access to the company library. Medical insurance or compensation for sports. amount of bureaucracy You can work in the office: Lviv: Haydamatska 9a Kyiv: Prospekt Beresteyskyi 24 Or remotely (from any city in Ukraine) About our company We are an outsourcing company Temy.  Since 2014, we have been providing software development services for companies seeking to implement their ideas. During this time, we have grown to 100+ specialists and currently have about 20 active projects. Our clients are startups and mid-sized companies in various industries - IoT, FinTech, E-commerce, Security, Real Estate, EdTech. Our offices are located in Kyiv and Lviv, and our employees are located throughout Ukraine and abroad. More details on our website temy.co. Temy is a flexible schedule, a Competence center for sharing experience, creating pet projects, attending workshops and meetups, bonuses from the IT Cluster, your own library and much more that you can get by becoming part of our team. You can find out more information about us here: https://instagram.com/temy.co https://www.youtube.com/@temyco We are all different, but everyone will find their place in Temy! Show more Show less Position level Senior secondary level Type of employment Full time Job duties Information technologies Industries Software development