Develop conceptual, logical, and physical data models for SQL (e.g: OLTP & OLAP) and NoSQL Databases (e.g: MongoDB, Search Stores, GraphDB) to meet the needs of the business.
Work closely with domain experts, business stakeholders & key SMEs to understand business processes, use-cases, data requirements and translate them into data models.
Design and implement data structures, database schemas, tables, views, and indexes that support efficient storage, retrieval and management of structured, semi-structured and un-structured data.
Create data flow diagrams and entity-relationship diagrams to document data structures.
Work with ETL developers to ensure data transformations are correctly implemented.
Support data integration efforts by providing data models that facilitate data exchange between systems.
Collaborate with data architects and database administrators to ensure data models are implemented correctly.
Optimize database performance through efficient data modelling techniques.
Conduct regular reviews of data models and make necessary adjustments to improve performance and scalability.
Monitor and troubleshoot database performance issues.