Oracle PL/SQL Developers/Database Specialist

- Developing, testing implementing and supporting systems
- Development and maintenance of views, code, stored procedures triggers package
- Developing customised reports and system generated documents
- Coding in adherence to the clients and Oracle standards
- Performing preventative maintenance activities
- Provision of User Support
- Preparation and maintenance of technical documentation
- Managing project source code and documentation
- Effort estimation &Quality control of code and other deliverables
- Version control of application code
- Database tuning and performance monitoring
- Troubleshooting and resolving complex database problems
- Advising on Oracle features and on best practice and optimal approach in the use of PL/SQL
- Conducting developer code reviews
- Management of DBA routine tasks eg roles, privileges, synonyms, schemas objects, tablespaces across multiple environments
- Development on multiple concurrent projects to strict deadlines
- Datamodelling and database design
- Issues analysis, diagnosis and resolution
- Writing complex PL/SQL for Oracle 10g or higher Databases

Oracle PL/SQL coding

- Dynamic SQL -literal and bind variables,
- Ref Cursors,
- Oracle Built-in Packages,
- Application Tuning,
- Views, Procedures, Functions and Triggers
- Creation of Index/Trigger/Constraint scripts
- Producing Reports
- SQL tuning and Oracle query optimisation using cost based optimiser and other query optimisation tools
- Running and interpreting explain plans
- Building of and maintaining a large scale database in a technical environment
- Building Context and composite indices
- Understanding of how Service Requests are raised/resolved with Oracle via Metalink/My Oracle Support
- SQL tuning and Oracle query optimisation using cost based optimiser and other query optimisation tools
- Oracle database design & implementation of logical and physical data model
- Data model creation and maintenance in Oracle Designer
- DBA routine tasks eg roles, privileges, synonyms, schemas objects, tablespaces across multiple environments
- Working with Oracle Reports
- Working with Oracle Discoverer