PL/SQL Developer
Remote
Duration: 24 Months
*PLEASE NOTE: Our Client Does Not Accept C2C
Our top-tier client is looking for a PL/SQL Developer that is familiar with Oracle to assist with customer projects.
**Experience with Oracle 19 is preferred.
Overview/Essential Responsibilities:
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 Sr 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 our organizations 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.
Primary Skillset:
• A Bachelor’s degree in “STEM” major (Science, Technology, Engineering & MATH) from an accredited university or college.
•A minimum of four (8) years of experience in Oracle 19 development in an on-prem or cloud-based enterprise environment.
• Hands-on experience with PL/SQL development including triggers, types, procedures, functions
• Expert on writing and modify extremely complex SQL queries.
• Strong knowledge of Oracle Advanced Queues, Oracle Job Scheduler.
• Strong knowledge of programming changes needed for RAC vs non-RAC implementations
• Prior work experience in an agile environment and experience with DevOps
• Experience with 'Security by Design' and the 10 security principles (Defense in depth, Secure by default, Least privilege, Separation of duties, Minimize attack surface, complete mediation, open design, isolated compartments, Evidence production, and Application coding best practices).
MWResource does not discriminate based on race, gender, color, religion, national origin, age, disability, veteran status, or anythine else that makes you a part of any group.
MWResource offers medical, dental and vision coverage through Capital Blue Cross, short- and long-term disability coverage, employer paid life insurance, and participation in the MWResource 401K plan for US based consultants.
Candidates must be authorized to work in the United States.
Candidates will be required to pass a background check and drug screening.
Please note we are not open to outsourcing our recruitment needs.
Top Skills
What We Do
MWResource provides our customers with the experienced energy industry experts to assist you with designing, implementing, and maintaining successful critical energy infrastructure systems. MWResource specializes in utility SCADA, Energy Management Systems (EMS) and energy market systems.
MWResource is also helping its other customers in both the US and Canada fill their permanent and project related openings with experienced SCADA, EMS, and energy market systems professionals.
Our company offers a pool of experienced energy industry experts who have worked with data acquisition, plant and grid control, energy markets, settlements and IT technologies used by power generation companies, power cooperatives, municipal utilities, investor owned utilities, and major energy markets.
MWResource experts provide a variety of services including:
- Consulting
- Project Management
- System Design Assistance
- Applications Development
- Database and Display Development and Migration
- System Configuration and Integration
- Systems and Communications Commissioning
- Software Configuration Management
- OSIsoft PI Project Support
- Auditing and Compliance
- Software Quality Assurance
- Training
- Permanent Employee Recruiting
- Temporary Project and Support Staffing
Some of the major systems areas where we have expertise are:
- CIP/Control Center Systems especially Energy Management Systems (EMS) and Distribution Management Systems (DMS)
- SCADA/RTU/Relay communications
- OSI PI Historian
- Power System Modelling and Planning Support
- ISO/RTO market systems
- ISO/RTO settlement and web systems
- Market participant interfaces
- Enterprise Application Integration