Database management system specialist vs data modeler

Differences between database management system specialist and data modeler duties and responsibilities

Database management system specialist example responsibilities.

• Lead multiple infrastructure planning and implementation including instance strategy, technical platform selection, architecture design, backup and recovery strategy.
• Identify and troubleshoot oracle relate CPU, memory, I/O, disk space and other resource contention.
• Lead multiple infrastructure planning and implementation including instance strategy, technical platform selection, architecture design, backup and recovery strategy.
• Implement an ERP base inventory system and integration to provide total warehouse to customer fulfillment.

Data modeler example responsibilities.

• Lead efforts to analyze data for source/target mappings, create T-SQL scripts for data processing.
• Involve in data governance processes relate to data quality and information management, managing the metadata repository etc.
• Accomplish at designing dashboards and data summaries for technical and non-technical audiences and facilitating implementation of business strategies and missions.
• Design the data marts in dimensional data modeling using star and snowflake schemas.
• Develop data architecture prototypes and data models including ETL staging models, audit control models and traditional data warehouse dimension/fact models.
• Work extensively with XML schema generation.
Show more