Principal Software Engineer – Database Management, JAVA, Shell Scripting

Role Overview

• 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 Actimize 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.

Requirements

• 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.

Tech Stack

• ETL
• Informatica
• Java
• Linux
• MS SQL Server
• Oracle
• Shell Scripting
• SOAP
• SQL
• Unix

Benefits

• medical/prescription drug coverage (with a Health Savings Account feature)
• dental and vision options
• employee and spouse/child life insurance
• short and long-term disability protection
• 401(k) with PNC match
• pension and stock purchase plans
• dependent care reimbursement account
• back-up child/elder care
• adoption, surrogacy, and doula reimbursement
• educational assistance, including select programs fully paid
• a robust wellness program with financial incentives
• maternity and/or parental leave
• up to 11 paid holidays each year
• 9 occasional absence days each year, unless otherwise required by law
• between 15 to 25 vacation days each year, depending on career level; and years of service