Database Architect

Kozak Agency is seeking an experienced Database Architect on an outstaffing basis to transform a Customer Activation Platform into a secure, scalable, data-driven solution. The role involves addressing analytics limitations, supporting cloud migration, and enabling the platform to handle increased daily opt-ins.

• 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

• 5+ years of experience in Data Engineering
• Experience 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
• English B2 (upper-intermediate)

Employment Type: 1 FTE for 2 months, next 2 months 0.5 FTE

Project Duration: 4 months

Location: Europe, Ukraine (remote)

Start Date: In 2 weeks