Oracle PL/SQL Developer

Full Time
  • Full Time
  • Canada

NLB Services

Hi, Position: Oracle PL SQL developerLocation: Remote Client: Innover Digital What you will be accountable for: As an Oracle PL/SQL Developer, you will be a member of the Data Services team and responsible for providing overall database support with concentration in back-end programming. The PL/SQL Developer will be responsible to properly maintain source code sets and necessary technical documentation and in the overall database maintenance.Responsibilities include: Provide clean and comprehensible data to the end-userMaintain or update table structures in the Datawarehouse and the processes used to populate them with data from internal and external sourcesCreates/maintains Extract, Transform and Load (ETL) packages and processes for migrating data from multiple data sources to data warehouse Pl/SQLMaintain stored procedures to cleanse and integrate data in an efficient and reusable manner and evaluating modeling results· Will be well versed with the latest T-SQL language features and have experience dealing with large volumes of data. Job Experience:· 3 or more years of IT development/programming/coding professional work experience or equivalent combination of transferable experience and education.· Must possess expert programming and troubleshooting skills· Must possess expert performance tuning skills and dynamic SQL skills· Must be able to reverse engineer anyone else’s code and be able to modify it to solve the problem in a better or more efficient way· Experience with Oracle Version 12c-19c· Strong experience with oracle functions, procedures, triggers, packages & performance tuning· Ensure that database programs are in compliance with V3 standards· Performance tune SQL’s, application programs and instances· Application programming experience in PL/SQL· Experience and understanding with unit testing, release procedures, coding design and documentation protocol as well as change management procedures· Proficiency using versioning tools like BitBucket.· Ability to communicate technical information clearly and articulately· Ability to adapt to a rapidly changing environment· Proficiency programming in more than one object-oriented programming language· Proficiency using debugging tools· High critical thinking skills to evaluate alternatives and present solutions that are consistent with business objectives and strategy· Experience with complex indexing strategies including column store indexingPREFERRED QUALIFICATIONS: · 3 years of IT development/programming/coding professional work experience using PL/SQL· Be able to review existing PL/SQL code and translate requirements and/or make enhancements as needed· Need someone who has experience with making modifications/enhancements to new or existing SQL code Thanks & Regards,Himanshu KumarNext Level Business Services, Inc.Talent Solutions | Digital Transformation | Data AnalyticsUS: 1 904-344-3863 |Fax: 1 (608) 646-8326E-mail: Himanshu.kumar1recruiter.nlbtech.comHangout : Himanshu.kumar1recruiter.nlbtech.comAn ISO 27001 and 20000-1 Certified & Minority Business Enterprise (CMBE)

Source

To apply, please visit the following URL: