Database Architect
We are looking for an experienced Database Architect on an outstaffing basis to address analytics limitations identified during the technical audit, help transform the platform into a secure, scalable, data-driven solution capable of handling increased daily opt-ins, and support its migration to a new cloud provider.
About the project: This project is a Customer Activation Platform (CAP) designed to capture high-intent customer opt-ins in real time and convert them into verified, actionable data. It enables users to engage through simple mobile interactions such as a tap, scan, or click — without requiring traditional forms or app downloads.
The platform focuses on activating customers at the moment of highest intent, capturing verified contact information, and instantly sending it to connected systems like CRM, CDP, or loyalty platforms. It supports seamless integration across digital and offline touchpoints, helping businesses drive real-time engagement and improve marketing performance.
Start Date: in 2 weeks
Employment type: 1 FTE for 2 months, next 2 months 0.5 FTE
Project Duration: 4 months
Location: Europe, Ukraine (remote)
Language: English B2 (upper-intermediate)
Requirements:
- 5+ years of experience in Data Engineering
- Experience with maintaining SQL Server database schemas
- Strong expertise in Entity Framework 6.x for ORM operations
- Solid experience in database schema design and migration management
- Hands-on experience with connection pooling and database performance tuning
- Strong knowledge of stored procedures and complex query design
- Experience with Cloud SQL for SQL Server and BigQuery architecture/design
- Practical experience building ELT pipelines using Cloud Data Fusion and Dataform
- Knowledge of dimensional modeling
Responsibilities:
- Design a robust database architecture
- Maintain SQL Server database schemas
- Write optimized SQL queries and stored procedures
- Implement database migrations and schema updates
- Monitor and optimize query performance
- Manage data integrity and referential constraints
- Implement backup procedures
- Work with multiple databases
Process Flow:
- HR pre-screen + English check (0.5 h)
- Professional interview (1 h)
- Interview with the Client (1 h)
Required languages
| English | B2 - Upper Intermediate |
| Ukrainian | Native |