Oracle SQL & Unix Application Support Engineer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Purple Drive Technologies LLC, is seeking the following. Apply via Dice today!

Oracle SQL & Unix Application Support Engineer (Banking / AML / Production Support)

Job Summary

We are looking for an experienced Application Support Engineer with strong expertise in Oracle SQL, Unix, and Production Support to manage and support enterprise applications in a banking/financial services environment.

The ideal candidate will have hands-on experience in incident management, batch processing, and system monitoring, along with exposure to AML platforms and regulatory environments.

Key Responsibilities

Production Support & Incident Management

• Provide L2/L3 production support for enterprise applications
• Monitor systems, troubleshoot issues, and resolve incidents within SLAs
• Perform root cause analysis (RCA) and ensure permanent fixes
  
  

Database & SQL Operations

• Write and optimize Oracle SQL queries and stored procedures
• Perform data validation, reconciliation, and issue analysis
• Support data-related incidents and performance tuning
  
  

Unix & Batch Processing

• Develop and maintain Unix shell scripts
• Monitor and manage batch jobs and scheduled processes
• Handle failures in job scheduling systems (TWS, cron, etc.)
  
  

Application & Middleware Support

• Support applications running on IBM WebSphere (v9.x)
• Troubleshoot issues related to Java-based applications (Java 1.8)
• Work with integrated systems and upstream/downstream data flows
  
  

Monitoring & Debugging

• Use tools like Dynatrace for monitoring and debugging
• Analyze logs, performance metrics, and system alerts
  
  

Mainframe & Legacy Systems

• Work with Mainframe technologies including:
• JCL
• TWS job scheduling
• LCM deployments
  

Compliance & Regulatory Support

• Support systems under regulatory frameworks (AML/BSA/OFAC)
• Ensure audit readiness and compliance with banking standards
  
  

Required Skills

Core Technical Skills

• Strong experience with:
• Oracle SQL / PL-SQL / Stored Procedures
• Unix/Linux & Shell Scripting
• Production Support & Incident Management
• Batch Processing & Job Scheduling
  

Middleware & Tools

• IBM WebSphere (v9.x)
• Java (1.8)
• Monitoring tools (Dynatrace preferred)
  
  

Mainframe Skills

• JCL
• TWS Scheduler
• LCM (deployment/migration)
  
  

Domain Experience

• Banking / Financial Services / FinTech
• Experience in regulated environments