Principal Software Engineer – Database Management, JAVA, Shell Scripting

Responsibilities

• Serve as a technical authority for SQL design and optimization across fraud transaction platforms.
• Design, analyze, and tune complex SQL and PL/SQL used in high volume transactional and analytical workloads.
• Partner with engineers to optimize database access patterns, indexing strategies, and schema designs.
• Diagnose and remediate SQL driven performance issues impacting real time fraud decisioning or batch processing.
• Develop and maintain Java based custom extensions, including Action Plugins, to enhance and extend Actimise platform functionality.
• Collaborate with fraud engineers to integrate custom logic into detection and processing flows while maintaining performance and stability.
• Ensure Java components are efficiently designed to minimize database contention and latency.
• Design and support integrations between fraud platforms and upstream/downstream banking systems.
• Work with ETL tools (e.g., Informatica), APIs, SOAP/REST web services, and message queues to enable reliable, performant data movement.
• Optimize data ingestion and extraction patterns to support fraud detection at scale.
• Leverage Unix/Linux shell scripting to automate operational tasks, support maintenance activities, and assist with diagnostics.
• Partner with platform and operations teams to improve automation, monitoring, and operational efficiency.
• Act as a Principal level technical mentor to engineers across Fraud Transactions Engineering.
• Provide design guidance and code reviews focused on performance, scalability, and maintainability.
• Collaborate with product, architecture, and operations partners to translate fraud requirements into technical solutions.
• Lead during high severity incidents, quickly isolating and resolving application or query level issues.

• Bachelor’s degree in Computer Science, Engineering, or equivalent experience.
• 5+ years of hands on software engineering experience in enterprise environments.
• Expert level SQL and PL/SQL skills, with experience supporting high volume, database driven systems.
• Strong Java programming experience, including building custom extensions or plugins for enterprise platforms.
• Experience with Oracle or Microsoft SQL Server in transaction intensive environments.
• Hands on experience with enterprise integration technologies (ETL, APIs, web services, messaging).
• Working knowledge of Unix/Linux environments and shell scripting.