Database modeler vs database systems administrator

Differences between database modeler and database systems 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 systems administrator example responsibilities.

• Manage project to design and implement Microsoft SharePoint for the company's Intranet to all locations.
• Create scripts (bash shell) to schedule and automate processes; and to monitor systems and critical applications.
• Manage physical volumes, volume groups and logical volumes using AIX LVM in IBM p-series/Power5 servers and replace failed disk.
• Configure TIVOLI and manage distribute monitoring alerts.
• Monitor disk usage and manage space allocation utilizing LVM.
• Administer and manage configurations for LAN-to-LAN and remote access VPN connections allowing for secure communications.
Show more