Job Closed
This listing is no longer active.
ePATHUSA - eInnovation Delivered!
SQL / Oracle Programmer Analyst
Location
United States
Posted
43 days ago
Salary
$58 - $61 / hour
Seniority
Senior
Job Description
SQL / Oracle Programmer Analyst
ePATHUSA, Inc.
• Seeking a Programmer Analyst with strong experience in enterprise software development, SQL / Oracle programming, and cloud-based modernization initiatives. • Responsible for reviewing, refactoring, and migrating legacy application logic including PL/SQL code, store procedures, and Crystal Reports into a modern AWS-based architecture. • Document, review and understand existing business logic / application architecture, data models, workflows and stored procedures. • Collaborating with both internal teams and a third-party vendor to clarify requirements and support modernization efforts. • Supporting the redesign of core application functionality, including modules such as records, classification and sentence computation. • Ensuring accurate operation within the updated system. • Rewrite and optimize Oracle PL / SQL packages, functions, triggers, and views for migration to a cloud environment. • Extract, map, validate, and transform data to support ETL and database conversion activities. • Analyze, document, and refactor core logic modules such as sentence computation. • Convert legacy DHTML-based UI forms to modern formats as part of system redesign. • Understand and document scheduled jobs and backend automation processes.
Job Requirements
- Expert knowledge of Oracle PL/SQL (procedures, functions, triggers, packages, views).
- Strong SQL expertise including query optimization and performance tuning.
- Experience with data migration, ETL workflows, and schema transformation.
- Ability to understand logic from legacy applications and undocumented code.
- Familiarity with legacy front-end technologies (DHTML, HTML/JavaScript forms).
- Experience with task schedulers for data automation.
- Experience with AWS database and reporting services.
- Knowledge of BI/reporting tools such as Power BI or AWS QuickSight.
- Scripting experience (Python, PowerShell).
- Experience with Offender Management or enterprise justice systems.
- Experience working with external vendor teams on modernization projects.
Benefits
- Paid Sick Time
- Insurance for Medical, Dental, Vision and Life
- Available 401(k) including Employer Match
- HSA, Short-term & Long-term Disability Available
Related Guides
Related Job Pages
More Software Engineer Jobs
Junior Integration Developer / iPaaS Consultant
STI Deutschland GmbH"We surface your visions" - DIN ISO 9001 zertifiziert - DIN ISO 14001 zertifiziert - DIN ISO 50001 zertifiziert
• Design, implementation, and further development of integration and automation workflows using iPaaS platforms • Connecting external systems via APIs, webhooks, standard connectors, and middleware • Analysis and design of data flows, interfaces, data mappings, and integration logic • Contributing to integration scenarios between CRM, ERP, collaboration, and third‑party systems • Acting as the technical point of contact for integration and automation topics within projects • Close collaboration with CRM, architecture, and business teams to implement robust end‑to‑end processes • Supporting architecture and solution design for scalable integration scenarios • Monitoring, troubleshooting, and optimizing integration workflows • Implementing error handling, logging, and monitoring mechanisms • Documenting integration architectures, interfaces, mappings, and operational logic • Considering security, data protection, and governance requirements • Supporting API‑related questions as well as testing, rollouts, and handovers to operations
• Good communication with the team and with the client, providing clarity about daily activities; • Technical refinement; • Perform maintenance and development of COBOL applications, integrating with databases; • Anticipate opportunities and problems, acting quickly and effectively by developing preventive solutions.
Senior Mainframe Systems Programmer – z/OS
EnsonoEnsono delivers complete Hybrid IT solutions, from mainframe to cloud, tailored to each client’s journey.
• Provide support for on-going projects that require the installation, testing, and implementation of new z/OS operating systems and other ‘system’ software. • Maintenance and debugging of systems software. • Monitoring and tuning of systems software. • Participate in On-call Schedule. • Incident / Problem resolution • Incident, change and problem handling. • Configuration and customization. • Setup of parameters. • Communication with vendors. • Participation/contribution to technical projects. • Solid understanding of z/OS and related product software z/OS. • PARMLIB configuration and JES2 customization. • Ability to support in solving problems and implementing changes on z/OS environments. • Working knowledge of TSO/ISPF, SDSF, JCL. • Good written and verbal skills. • Strong analytical and problem-solving skills.
Profesor/a de Música - Clases Particulares Online o Presenciales
TusclasesparticularesArrêtez de payer pour trouver un prof particulier
En Tusclasesparticulares estamos buscando profesores/as de música y baile para dar clases particulares. Podrías dar clases de: Piano / Guitarra / Canto / Lenguaje musical / Violín / Batería / Salsa / Bollywood / Flamenco / Hip Hop / Tango / Ballet / Samba, etc. ¡Comparte tus conocimientos y gana un ingreso extra! Requisitos: - No se requiere experiencia previa como profesor - Compromiso con los estudiantes - Conocimientos de física y química Beneficios: - Flexibilidad horaria - Posibilidad de teletrabajo / trabajo desde casa - Salario: 15€ a 30€/hora
