Ayan Infotech has an urgent and immediate requirement for a PL SQL Expert for a contract job opportunity in Sydney CBD.
All applicants must have full work rights in Australia.
Title: PL/ SQL Expert
Location: Sydney CBD
Type: Contract (3 months + extensions)
Required Skills and Experience:
- Solid Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle
- Strong SQL Background, with performance mindset ( Must have strong experience in performance tuning in Oracle database, cannot depend on DBA for that)
- Strong Unix Background, able to work and navigate on Unix environments.
- Experience in data migration/conversation using SQL*Loader
- Experience in Data migration using import and export.
- Proficient with version control tools Stash/Bitbucket and Source Tree (Must have worked in an environment where version control tools were used, should be able to explain the version control process and should have understanding of DevOps concept or at least able to explain how the build/deployment process worked from dev to other to prod environments)
- Strong understanding of BI data structures and Relational as well as Dimensional Data Models
Nice to have :
(these are not must but very important for the role so candidates with these skills/ experience will have an added advantage)
- prior experience or knowledge of integrating data extracted from ORacle DB with Restful API
- understanding of JSON
We will be able to contact only shortlisted candidates. We thank you in advance.