Senior pl-sql developer vs sql developer

Differences between senior pl-sql developer and sql developer duties and responsibilities

Senior pl-sql developer example responsibilities.

• Manage all phases of the SDLC from analysis, design, development, testing, implementation and maintenance.
• Create shell scripts to automate the process of generating the XML's after successful verification by the business analysts.
• Develop custom interface for executing and managing SSIS packages.
• Involve in developing, testing, compiling, debugging and maintains the data using oracle, PL/SQL, UNIX, LINUX.
• Create test cases and test reports and work with QA team to validate the data and scenarios.
• Involve in debugging various defects relate to implementation of business logic.
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