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.