Stafnear
Senior Database Architect
Remote Senior $4.7k–$12.8k/moest.
Summary
Stafnear is seeking a Senior Database Architect to address analytics limitations, strengthen platform security and scalability, and support migration to a new cloud provider.
What you'll do
- Address analytics limitations identified in technical audit
- Strengthen platform security and scalability
- Support migration to new cloud provider
- Optimize database performance
- Design and manage database schema migrations
- Build and manage ELT pipelines
Requirements
- 5+ years of experience with Microsoft SQL Server including advanced performance optimization
- Strong expertise with 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: Upper-Intermediate (B2)