Senior Database Architect
Senior 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 with Microsoft SQL Server, including advanced performance optimization
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)