Oracle Developer (PL/SQL)

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Info Way Solutions, is seeking the following. Apply via Dice today!

Role: Oracle Developer

Job Overview:

In this role, you will work closely with a team of 8-15 people who are responsible for enhancing, evolving, and supporting large highly-available Electricity Market Management System (MMS). The team includes power systems, database, software, and optimization engineers. As a staff Database developer, you will contribute and lead advanced development in MMS Application software design, development, testing, integration and tuning to meet project and/or product commitments. Projects main deliverable is an overall customized system that s based on GE s next generation Market System, a cloud-based solution that hosts multi-state wholesale energy markets. End user customers are Electric Utilities, Independent System Operators (ISOs) and Transmission System Operators (TSOs). These markets are key to decarbonizing our power system by ensuring reliability while allowing increasing penetration of Solar, Wind and Storage technologies.

Basic Qualifications:

• Bachelor's Degree in Computer Science or STEM Majors (Science, Technology, Engineering and Math) from an accredited university or college.
• A minimum of Eight (8) years of experience in Oracle development in an on-prem or cloud-based enterprise environment
  
  

Technical Expertise:

• Oracle19c or higher.
• Experience programming with PL/SQL (min 6 years)
• Experience with advanced PL/SQL features including advanced queues, triggers, types, functions, reference cursors, pipeline functions, subquery factoring clauses
• Experience with built-in Oracle packages such as DBMS_SCHEDULER.
• Experience with both ANSI and Oracle join syntax.
• Understanding of programing changes needed for RAC vs non-RAC implementations.
• Ability to diagnose and remediate SQL performance issues.
• Ability to translate requirements into functional designs.
• Ability to implement code solutions from functional designs.
• Ability to work independently as well as with a remote team.
• Experience with tools such as GIT, TFS, Toad for Oracle.
  
  

Roles and Responsibilities:

• Collaborate with system engineers, frontend developers and software developers to implement solutions that are aligned with and extend shared platforms and solutions.
• Convert design documents into working applications.
• Apply principles of SDLC and methodologies like Lean/Agile/XP, CI, Software and Product Security, Scalability, Documentation Practices, refactoring, and Testing Techniques
• Writes code that meets standards and delivers desired functionality using the technology selected for the project.
• Build features such as web services and Queries on existing tables.
• Understand performance parameters and assess application performance.
  
  

Desired Characteristics:

Personal Attributes:

• Able to work well with global teams, including time-zone flexibility
• Excellent communication skills and the ability to interface with senior leadership with confidence and clarity
• Persists to completion, especially in the face of overwhelming odds and setbacks. Pushes self for results; pushes others for results through team spirit
  
  

Business Acumen:

• Experience working on software projects in the Energy domain (especially Bulk Power Energy Management)
• Able to understand how team and personal goals/objectives contribute to the organization vision
• Understands technology landscape, current and new technology trends, brings new ideas to the team.
• Skilled in breaking down problems, documenting problem statements and estimating efforts