Echo IT Solutions, Inc.
Sr Database Architect & Modeler
Echo IT Solutions, Inc. - Farmers Branch, Texas, United States
Work at Echo IT Solutions, Inc.
Overview
- View job
Overview
Work Location: San Antonio, Texas (Onsite)
Job Title/Role: Sr Database Architect & Modeler
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 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 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. • Proven track record of working with large engineering teams in a fast-paced environment.
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 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 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. • Proven track record of working with large engineering teams in a fast-paced environment.