Principal Software Engineer – Database Management, JAVA, Shell Scripting

PNC

Software Engineer Principal in PNC's Fraud Technologies Group handling SQL optimization and Java platform extensions for fraud detection systems. Collaborating with engineers for technical solutions and performance tuning.

Posted 5/13/2026full-timePhoenix • Arizona, Colorado, Pennsylvania, Texas • 🇺🇸 United StatesLead💰 $106,000 - $165,600 per yearWebsite

Tech Stack

Tools & technologies

ETLInformaticaJavaLinuxMS SQL ServerOracleShell ScriptingSOAPSQLUnix

About the role

Key responsibilities & impact

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

What you’ll need

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.

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPL/SQLJavaETLUnixLinuxshell scriptingdatabase optimizationperformance tuningdata ingestion

Soft Skills

technical authoritycollaborationmentorshipdesign guidanceproblem solvingleadershipcommunicationoperational efficiencyscalability focusperformance focus