Hybrid Senior Technical Architect bei HCL Technologies
HCL Technologies · San Antonio, Vereinigte Staaten Von Amerika · Hybrid
- Senior
- Optionales Büro in San Antonio
Skill (Primary)
Data Governance-Data Modeling-Erwin Data Modeler
Location
Texas
Job Family
Architecture / Design
Employee Group
Business Line FT
Job
Senior Technical Architect
Job Description (Posting).
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 cloudbased 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+ softwaredata 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 databaserelated 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 softwaredata 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 Aurora 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 Aurora 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
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 cloudbased 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+ softwaredata 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 databaserelated 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 softwaredata 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 Aurora 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 Aurora 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
Entity
CSW
City
San Antonio
Skill Level 3 (Secondary Skill 1)
Domain Competencies (APPS)-SF-Technical Skill-Guidewire - Analytics
Skill Level 3 (Secondary Skill 2)
Tools and Standards (APPS)-Configuration Mgmt-Datadog
Skill Level 3 (Secondary Skill 3)
Data Fabric-ETL-Data Build Tool (DBT)
Skill Level 3 (Secondary Skill 4)
Data Fabric-Cloud Datawarehouse-Snowflake
Skill Level 3 (Secondary Skill 5)
Technical Skills (APPS)-Databases-RDBMS-ANSI SQL
