Sr Database Architect & Modeler

TechDigital Group; San Antonio (TX); On-site; USD 120,000 - 150,000; Full time

Job summary

A leading technology firm in San Antonio is seeking an experienced Senior Database Architect & Modeler to lead the migration of its insurance application to a cloud-based platform. The ideal candidate will have over 10 years of experience, a strong background in database architecture, and proven leadership in large-scale projects. Responsibilities include establishing database standards and optimizing performance for millions of users.

Qualifications

• 10+ years of experience in database architecture, modeling, and administration.
• Successfully led 3+ large-scale database projects.
• Extensive experience with 3NF normalization and dimensional modeling.

Responsibilities

• Establish and enforce database design standards.
• Lead database-related aspects of development in Guidewire.
• Identify and resolve database performance issues.

Skills

Relational databases

Cloud-based databases

Data modeling

ETL development

Data integration

Modeling tools like Erwin

Database monitoring tools like Datadog

SaaS platforms (Guidewire)

Tools

Aurora PostgreSQL

Snowflake

Job description

Mandatory required skills

• Strong knowledge of relational databases, cloud-based databases, and data modeling concepts.
• Familiarity with ETL development and data integration processes.
• Experience working with modeling tools like Erwin.
• Experience working with database monitoring tools like Datadog.
• Experience with SaaS platforms like Guidewire platform is a plus.

Detailed Job Description

We need Highly skilled and experienced Senior Database Architect & Modeler to join the team as the company migrates its insurance application to a cloud-based Guidewire platform. This platform will support millions of users, and it needs a leader who can set database standards, ensure best practices, and support scalability, maintainability, and performance across the system. This role is a unique blend of Database Administration (DBA) and Data Modeler, requiring expertise in both 3NF normalization and dimensional modeling. The person will work closely with 200+ software/data engineers to ensure consistency in database design and implementation, troubleshoot performance issues, and support the migration to production environments.

Key Responsibilities

• Database Standards & Best Practices: Establish and enforce database design standards, ensuring consistency, scalability, and maintainability across the platform.
• Development Support: Lead database-related aspects of the development in Guidewire platform, ensuring high availability, low latency and scalability.
• Performance Optimization: Identify and resolve database performance issues, ensuring the platform can handle millions of users.

Experience

• 10+ years of experience in database architecture, modeling, and administration.
• Successfully led 3+ large-scale database projects, covering the key responsibilities outlined above.
• Extensive experience with 3NF normalization (dozens of projects) and dimensional modeling (2+ projects).
• Hands-on experience with operational databases like Aurora PostgreSQL and analytical databases like Snowflake.