Database Developer (DB2 Developer)

26 Nov 2024

Vacancy expired!

Requirements:

  • 5-10 years experience in DB2, Oracle or SQL Server backend database development utilizing packages, procedures, function, triggers and user defined types.
  • Strong DB2/SQL, Oracle PL/SQL and/or SQL Server T-SQL skills.
  • Strong Data Warehousing experience, partitioning and collection objects.
  • Strong knowledge of common database tools (PL/SQL Developer, TOAD, SQLPlus, SQL Server Management Studio etc.).
  • Strong ability to write complex stored procedures, functions using PL/SQL to optimize processes performance with the goal to reduce processing time.
  • Strong ability to tune complex queries utilizing Indexes, Hints, and Explain Plan to improve the performance of the application.
  • Proficient in working with: Collection objects, Nested Tables, Record types, Cursors, Ref Cursors, Views, Materialized Views, Partitions, FORALL, Bulk Collect, Regular Expressions, Autonomous Transactions.
  • Strong ability to use Python scripts for data transfer and manipulation.
  • Strong working knowledge with XML and JSON data format.
  • Strong data analysis skills to debug, trace and fix problems.
  • Experience interfacing with other databases and operating systems such as Linux, Windows, MEMSQL, MySQL is preferred.
  • Experience supporting web applications and servers in the areas of Apache, IIS or Cloud is preferred.
  • Have excellent written and oral communication skills.
  • Bachelor's degree required. BS in Engineering, Computer Science or a Business related developer degree such as MIS is preferred.
  • Oil and Gas Experience is preferred.
  • Required to be on-call during work and off-hours as necessary.
  • May travel when necessary for system implementation and training.
  • Experience with the following is a plus:
  • Familiar with Postman and Swagger for testing and documentation.
  • Experience with ACS, RDI.
  • Change Management and Source Control Products Aldon, Arcad, GIT.
Interested, please send me your resume rupa@zenaide. com or call me on

  • ID: #23510876
  • State: Texas Houston 77086 Houston USA
  • City: Houston
  • Salary: USD TBD TBD
  • Job type: Contract
  • Showed: 2021-11-26
  • Deadline: 2022-01-25
  • Category: Et cetera