drjobs Data Base Architect Modeller

Data Base Architect Modeller

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Jobs by Experience drjobs

5years

Job Location drjobs

San Antonio, TX - USA

Monthly Salary drjobs

$ $ 45 - 45

Vacancy

1 Vacancy

Job Description

Job Title: Senior Database Architect & Modeler

Location: San Antonio TX or Plano TX (Onsite Preferred)

Start Date: ASAP

We are seeking a highly skilled and experienced Senior Database Architect & Modeler to join our team as we migrate our insurance application to a cloudbased Guidewire platform. This platform will support millions of users and we need 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. You will work closely with 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 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 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 cloudbased databases such as Aurora PostgreSQL and analytical platforms like Snowflake.

Production Support: Provide handson support during production outages troubleshooting issues and ensuring system stability.




Requirements


Qualifications:

Experience:

10 years of experience in database architecture modeling and administration.

Successfully led 3 largescale database projects covering the key responsibilities outlined above.

Extensive experience with 3NF normalization (dozens of projects) and dimensional modeling 2 projects).

Handson experience with operational databases like Aurora PostgreSQL and analytical databases like Snowflake.

Proven track record of working with large engineering teams in a fastpaced environment.


Technical Skills:

Strong knowledge of relational databases cloudbased 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


Soft Skills:

Excellent communication and collaboration skills.

Strong problemsolving skills and the ability to troubleshoot complex database issues.


Preferred Qualifications:

Experience in the insurance or financial services industry.

Familiarity with Agile/Scrum methodologies.

Familiarity with CI/CD pipelines DevOps
Familiarity with metadata management tools

Familiarity with event streaming platforms like Kafka.

Familiarity with modeling for structured and semistructured data.

Certifications in cloud platforms (AWS Azure etc. or database technologies.




Write, edit, review, and approve lifecycle documentation for computerized systems. URS, FRS, CDS, CS, ERES assessments, IA, IOQ Use both Veeva and Kneat to do the above Integrate equipment with DeltaV and PI historian using OPC, EtherNet/IP, PI interfaces and PI connectors Execute IQs and IOQs in Kneat on DeltaV

Education

Bachelors degree

Employment Type

Full Time

Company Industry

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.