Obiee developer vs sql developer

Differences between obiee developer and sql developer duties and responsibilities

Obiee developer example responsibilities.

• Create and manage TNS entries for various environments on the server using UNIX.
• Implement LDAP security, manage access to the reports through roles and permissions.
• Create groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements.
• Manage appropriate security privileges on subject areas and dashboards as it are indicated in the business requirements.
• Work with user groups in creating and modifying dashboards or worksheets in desktop and server.
• Perform major role in understanding the business requirements, designing and loading the data into data warehouse (ETL).
Show more

Sql developer example responsibilities.

• Manage migration of SQL 2005 databases to SQL 2008 R2.
• Work with dynamic T-SQL queries, DDL, DML statements for creating objects, making updates and managing user permissions.
• Coordinate with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
• Used subversion tools, SVN version management to manage various versions of the procedures and functions for of the application.
• Achieve significant performance improvement in reducing response time of queries by rewriting and tuning SQL statements embed in PhP code.
• Involve in DBA responsibilities such as managing users and permissions, creating audit triggers, and overlook the daily back up.
Show more