Physical Data Modeler (10+ Years) at San Antonio, Texas, USA |
Email: [email protected] |
Position Physical Data Modeler Location San Antonio, TX Duration Long-Term 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 non-technical stakeholders. Good to have Conceptual Data modelling and knowledge of Industry models such as IIW, BDW, FSLDM and Acord Keywords: Texas |
[email protected] View All |
01:12 AM 07-Mar-25 |