Sr Database Architect / Modeler

Title / Role : Sr Database Architect / Modeler

Location : San Antonio, TX

We need highly skilled and experienced Senior Database Architect / Modeler to join the team as the company migrates it 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 nd 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.

Collaboration with Engineers :

Work closely with software data engineers to ensure database standards are adhered to during development and migration.

Data Modeling : Design and implement 3NF normalization models and dimensional models.

Cloud Database Expertise :

Work with cloud-based databases such as urora PostgreSQL and analytical platforms like Snowflake .

Production Support :

Provide hands-on support during production outages, troubleshooting issues, and ensuring system stability.

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 urora PostgreSQL and analytical databases like Snowflake .

Proven track record of working with large engineering teams in a fast-paced environment.

Technical 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