Position: ORACLE PL/SQL - ANALYST PROGRAMMER.
Deadline: 30 Jun 2022.
Date posted: 21 Jun 2022.
Location:Dar es Salaam.
Description:
Job Summary
On behalf of our esteemed client, we are seeking a highly motivated Oracle PL/SQL
Developer to help design, develop, review and deploy complex solution. The successful candidate will be working
under a Team Leader, analysing challenging requirements, flying to client
offices, attending meetings and interacting with end users, preparing
specifications, undertaking development of complex application functions in
PL/SQL. You will additionally participate in code review and testing.
- Ability to work in a fast paced team environment with constantly changing priorities
- Ability to design, develop and implement multi threaded PL/SQL code for OLTP and reporting solutions to meet business needs
- Desire to learn about Oracle 19c new features, and apply and implement new features where relevant
Our client is a Singapore based Business
Solutions IT Services provider, which provides dedicated offshore software
development teams for Product Development, Application Maintenance and Testing
for Financial Services. They provide consulting,
deliver expertise, advanced technologies and accelerators in solution design,
development and integration.
This is a highly challenging
and exciting position and the successful candidate must demonstrate
self-initiative and inter personal skills working in a team.
Job Responsibilities
- Must have worked on oracle PL/SQL
- Must have experience in Packages, Procedures, Functions, Triggers, Views, Cursors, PL/SQL Table, Nested Tables, Arrays, Sequences, Indexes, synonyms, file handling, DBMS Scheduler, oracle text, Subqueries, Inline views, Materialized view in oracle database
- Experience in writing and tuning complex and large SQL queries with the help of explain plan, trace files, tkprof
- Good at debugging and testing code
- Experience in Database Design, Modeling And Normalization
- Experience with data flow diagrams, data dictionary techniques, Entity relation modeling
- Sound analytical, problem solving and trouble shooting skills
- Good spoken and written communication skills
- Ability to work well in both a team and individual environment
- Experience in data migration from legacy system to new system
- Sound Experience in Toad, SQL developer
- Knowledge of Windows Operating System
- Integral member of team, which is responsible for database development of various modules of core financial application
- Responsible for understanding the all aspects of systems and resolving numerous technical issues
- Developing and maintenance of PL/SQL codes
- Handling client side support
- Providing client support
- Understand, resolve, test and provide the proper solution of a problem occurred in the system
- Involved in writing procedures, functions, cursors, triggers and packages for new requirements
- Write and tune SQL Queries used in the application
- Export and import dump according to client requirement
- Support to client in specific situation
- Implementation of the product for the new client site
- Exception Handling
- Data migration for the client
Requirements & Technical Skills
- Work Experience: About 5 years of experience
- Job Functions: Design, Development, Documentation, Maintenance, Coordination, Support
- Languages: Oracle PL/SQL, Advanced PL/SQL
- Platforms: Windows
- Database: Oracle 12c
- Advance Tools/Technologies: Oracle 19c, Toad, PL/SQL Developer
- Domain Knowledge: Finance, Insurance, Music
NOTE
- We are looking for candidates who are immediately available to join the company and start working. For the immediate need, the successful candidates should be prepared to work from home using their computers. You should have internet and reasonable desktop computers loaded with Windows on a I7 or I5 computer.
- This position is ONLY for serious PL/SQL Developers who want to learn and apply best practices and advanced coding techniques in Oracle, SQL and PLSQL to real world problems.