SQL Developer II

Key Responsibilities

• Designs, develops, and maintains Oracle PL/SQL procedures, functions, packages, and APIs to support enterprise applications.
• Analyzes and optimizes existing database code, including reviewing and documenting database objects such as tables, views, indexes, triggers, and sequences.
• Writes and tunes SQL queries to automate business and operational processes, improving efficiency and performance.
• Affords assistance in troubleshooting, testing, and performance tuning of database components to ensure system stability and reliability.
• Collaborates with software developers, business analysts, and technical teams to implement database enhancements and process improvements.
• Creates and maintains technical documentation for database processes, code changes, and data flows.
• Supports data analysis and report generation to meet business and operational needs within the utility domain.
• Participates in code reviews, follows development standards, and stays current with emerging database technologies, especially Oracle PL/SQL.

Required Qualifications

• 1–2 years of experience with Oracle PL/SQL development, including stored procedures, functions, and package creation.
• Proficiency in SQL query writing, optimization, and performance tuning.
• Experience with relational database concepts such as indexing, normalization, and schema design.
• Familiarity with database objects like triggers, views, sequences, and data modeling.
• Ability to work in a remote environment supporting enterprise systems in the utility sector.
• Work authorization to work in the US.

Preferred Qualifications

• Experience with real-time data processing and analytics in the energy or utility domain.
• Knowledge of network protocols such as TCP/UDP for real-time applications.
• Familiarity with version control tools like Git.
• Exposure to data visualization and reporting tools such as Power BI or SSRS.
• Understanding of scripting languages and web technologies (e.g., HTML, JavaScript) is a plus.

About the Role

This position involves maintaining and enhancing existing database code, automating processes, and supporting system reliability for electric grid operations and wholesale electricity markets.

Domain & Environment Context

This role supports critical utility infrastructure, focusing on electric grid reliability and wholesale market operations. The environment involves working with Oracle databases, PL/SQL development, and supporting automation and data reporting in a high-stakes, real-time setting.

About Delphi-US Peacemakers in the Talent War

Delphi-US is a national IT Services firm based in Newport, Rhode Island. Delphi attracts our nation's best and brightest Technical & Professional Talent and positions our nation's finest employers to further their competitive advantages. Delphi's core technical focus includes Data Sciences & Analytics, Modern AI/ML Model Monetization, Cloud Engineering, Cyber Security, ERP Rescue; serving domains from sensitive national energy sectors to critical financial services, biomed, life sciences & pharma, major government & municipal institutions, and much of the USA's Fortune 500 corporations. Delphi Associates are deployed on critical IT Projects where their consultative business acumen, comprehensive technical expertise, and committed service mission drives our client's success. Our proprietary skill-based and cultural matching process results in higher qualified project teams, custom curated for our client's specific technical & functional goals. We are supremely experienced, friendly, professional, and ready to advocate on your behalf. Delphi has an indelible understanding of employer expectations, a track record of project success and we deliver lasting results.