Experienced Oracle PL/SQL & Cross-Platform Systems Developer to build, optimize, and support critical backend databases, batch processing pipelines, and enterprise web applications.
Responsibilities
Design, write, debug, and tune complex Oracle SQL and PL/SQL objects (packages, stored procedures, functions, triggers, and views) to support high-volume transactional and batch workloads.
Develop, schedule, and maintain automated data pipelines and file-transfer jobs using Linux/Unix Shell scripts (bash/ksh) and Windows Batch/PowerShell scripts (.bat, .cmd, .ps1).
Manage, configure, and troubleshoot enterprise client-server applications hosted on Windows Server environments, utilizing Windows Event Viewer, Task Scheduler, Performance Monitor, and service management tools to ensure high availability.
Support, debug, and enhance internal and external web applications/APIs built on ASP.NET (with additional opportunities to contribute to Java services and React JS frontends).
Perform Level 2/Level 3 root-cause analysis on batch failures, database deadlocks, OS-level resource bottlenecks, and integration errors to minimize operational downtime.
Develops and implements applications and programs for the backend processing systems used in businesses and organizations.
Responsibilities
Execute full software development life cycle (SDLC)
Use Microsoft Visual Studio 2017 or higher and write code using MVC Architecture, .Net, JavaScript, Angular, Ajax, HTML, XML and WCF
Prepare scripts to create and modify existing Oracle tables, create indexes, constraints, triggers, views, etc., code stored procedures and packages, convert and migrate data when necessary
Diagnose and troubleshoot various rules, calculations, and data issues on application reports using Crystal Reports
Mentor and assist other programmers, both state and consultant, providing guidance for debugging, troubleshooting, securing and deploying applications, data access, data communications and system architecture configurations
Senior Java/AWS Power System Software Consultant designing, developing, and supporting enterprise-grade Power Systems applications for load forecasting, outage coordination, and energy operations.
Responsibilities
Design, develop, enhance, and maintain Java-based Power Systems applications.
Design scalable solutions using Java, Spring Boot, REST APIs, microservices, AWS Step Functions, and cloud native AWS services.
Build and support integrations between enterprise applications and data platforms.
Ensure application reliability, scalability, security, and performance.
Support modernization initiatives, including cloud migration and microservices adoption.
Requirements
Bachelor's or Master's degree in Electrical Engineering, Computer Science, or related field