drjobs Physical Data Modeler

Physical Data Modeler

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

Position Physical Data Modeler

Location San Antonio TX
Duration LongTerm Contract


Job Description:

  • Translates or convert a logical data model into a physical data model.
  • Defining the physical table columns primary keys foreign keys data types constraints and relationships within a chosen database.
  • Tune the physical data model considering factors like indexing strategies etc.
  • Generate database schema creation scripts (DDL) to deploy the physical database design for the target database.
  • Experience on reverse engineering to generate physical models from a existing database or database scripts.
  • Analyse existing data structures to identify areas for improvement and optimization.
  • Understanding of different data modelling techniques (relational dimensional hierarchical) and their application in different scenarios.
  • Proficiency in using data modelling tool (Erwin) to visualize and document the physical database design.
  • Collaborate with database administrators to implement data models in database systems and optimize performance.
  • Good communication skills to effectively communicate complex technical concepts to both technical and nontechnical stakeholders.


Requirements

Good to have Conceptual Data modelling and knowledge of Industry models such as IIW BDW FSLDM and Acord

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.