What are the responsibilities and job description for the Senior Database Engineer position at Shield Compliance?
We’re seeking a Principal / Senior Database Architect who deeply understands how relational databases behave under real production workloads — and who enjoys helping teams and systems evolve as scale and complexity increase.
This is a hands-on engineering role, not a traditional DBA position. You’ll design, tune, and operate data platforms that support financial transactions, analytics, and applications, while also guiding and mentoring junior database engineers and report writers.
What You’ll Do
Database Architecture & Performance
- Design relational data models that reflect real-world business processes
- Optimize complex queries and large batch transformations
- Analyze execution plans, indexing strategies, and query planner behavior
- Support both transactional (OLTP) and analytical workloads
- Ensure database systems remain performant, reliable, and maintainable as they scale
Data Platform & Analytics Engineering
- Architect and operate enterprise Snowflake environments
- Design databases, schemas, and virtual warehouses
- Optimize compute usage for performance and cost
- Implement secure access models (RBAC, SSO, OAuth, key-pair auth)
- Integrate Snowflake with orchestration tools such as Azure Data Factory
- Support BI and reporting tools including Power BI
Microsoft Data Ecosystem & Azure Fabric
- Work with SQL Server and SQL Managed Instance environments
- Build on an existing Azure Fabric proof-of-concept to determine where it provides the most value
- Design hybrid data patterns that intentionally leverage SQL Server, Snowflake, and Fabric
- Ensure Fabric-based integrations and reports meet expectations for performance, security, and data integrity
Technical Leadership & Mentorship
- Mentor and support junior database engineers and report writers
- Review SQL, data models, and reporting logic for correctness, clarity, and performance
- Reinforce strong practices for query design, data modeling, and reporting
- Act as a technical escalation point for complex database and reporting issues
- Help sustain and evolve the quality, reliability, and security of the data platform as the business scales
What We’re Looking For
Required
- 8 years working with enterprise relational databases in production
- Deep expertise in SQL performance tuning and query optimization
- Strong understanding of relational modeling and data integrity
- Hands-on experience with Snowflake
- Experience supporting financial or highly structured transactional data
- Experience mentoring engineers or analysts
Nice to Have
- Experience with Azure Fabric or Microsoft analytics platforms
- Experience designing hybrid SQL Server / Snowflake architectures
- Python for automation or integration work
- Experience with AI development tools to accelerate development and testing
Salary : $135,000 - $165,000