Senior Database Developer, Oracle (PL/SQL)

Role Description

In this role, you will work closely with a team of 8-15 people who are responsible for enhancing, evolving, and supporting a 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.

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.

Requirements

• Oracle 19c 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 programming 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 Source Code tools such as GIT, TFS.

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.
• Write 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.
• Perform unit testing and write test procedures for the code developed.

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.

Company Description

Kaleidoscope, an Infosys Company, is an equal opportunity employer, and all qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, spouse of protected veteran, or disability.