Database modeler vs database administrator

Differences between database modeler and database administrator duties and responsibilities

Database modeler example responsibilities.

• Involve in data governance processes relate to data quality and information management, managing the metadata repository etc.
• Develop and implement many cluster monitoring scripts using linux shell scripting.
• Analyze functional and non-functional data elements for data profiling and mapping from source to target data environment.
• Assist other data analysts and research scientists with data manipulation, presentations/big data visualization, information tracking, and projects.
• Provide system analysts with coding standards and capabilities of RDBMS.
• Streamline and reorganize the department's SharePoint's file repository enabling team members to locate procedural documents effortlessly.

Database administrator example responsibilities.

• Deploy and manage VMware horizon view on CISCO UCS for VDI deployemet.
• Create and manage database security, data encryption, and apply object level security.
• Resolve ASM errors, which lead to complete dysfunction of the ASM due to capacity issues.
• Fix grid control alerts on the database and monitor the database using grid control including managing of templates.
• Create and manage DTS and SSIS jobs to perform extra back up support for company's back up agent and procedure.
• Lead multiple infrastructure planning and implementation including instance strategy, technical platform selection, architecture design, backup and recovery strategy.
Show more