Senior Application Support Engineer (Java + SQL + Integrations)

Company description

Publicis Sapient is a digital transformation partner helping established organizations get to their future, digitally enabled state, both in the way they work and the way they serve their customers. We help unlock value through a start-up mindset and modern methods, fusing strategy, consulting, and customer experience with agile engineering and problem-solving creativity. United by our core values and our purpose of helping people thrive in the brave pursuit of next, our 20,000+ people in 53 offices around the world combine experience across technology, data sciences, consulting, and customer obsession to accelerate our clients’ businesses through designing the products and services their customers truly value.

Overview

We're seeking a Senior Application Support Engineer (Java & SQL) to provide L1/L2 production support for a portfolio of business-critical enterprise applications. This role focuses on incident resolution, root-cause analysis, production monitoring, SQL-based investigations, application troubleshooting, integration support, and release validation across complex distributed systems.

The ideal candidate has strong experience supporting Java-based applications in production environments, troubleshooting integrations and data issues, and collaborating with business and engineering teams to maintain system stability and service levels.

Responsibilities

Your Impact

• Monitor application health, batch jobs, integrations, and scheduled processes across enterprise platforms.
• Investigate and resolve production incidents within agreed SLAs.
• Perform root-cause analysis and implement sustainable solutions for recurring issues.
• Analyze application logs, interfaces, APIs, and database transactions to identify failures and data inconsistencies.
• Execute advanced SQL investigations, data reconciliation, and validation activities.
• Support production releases, deployment validation, smoke testing, and post-release verification.
• Collaborate with developers, infrastructure teams, and business stakeholders to restore services and improve operational stability.
• Create and maintain operational runbooks, knowledge articles, and troubleshooting documentation.

Qualifications

Skills & Experience (Must Have)

Candidates should demonstrate most or all of the following:

Application Production Support

• 6+ years of experience supporting enterprise applications in production environments.
• Strong experience in L2 support, incident management, problem management, and root-cause analysis.

Java Support Engineering

• Hands-on experience supporting Java-based applications.
• Experience troubleshooting Java, Spring Framework, REST services, application logs, exceptions, and backend processes.

SQL & Data Investigation

• Strong SQL skills including:• Complex query development
• Data validation
• Data reconciliation
• Stored procedures
• Performance analysis
• Production data troubleshooting

Integrations & APIs

• Experience supporting REST APIs and enterprise integrations.
• Troubleshooting data synchronization, interface failures, batch processing, and file-based integrations.

Monitoring & Observability

• Hands-on experience with at least one enterprise monitoring platform such as:• Splunk
• Dynatrace
• AppDynamics
• New Relic

IT Service Management

• Experience working within ITIL-based support organizations.
• ServiceNow, Jira, incident management, change management, and SLA-driven support processes.

Automation & Scripting

• Basic scripting experience using Shell, Bash, SQL automation, or related operational tooling.

Ramp-Up Skills (Not Required)

Experience with any of the following platforms is considered advantageous but is not required:

• Salesforce (Sales Cloud or Service Cloud)
• Salesforce integrations
• Incentive Compensation Management (ICM) platforms
• SalesConnect
• Sales Data Mart
• Data Warehouse support environments
• ETL platforms such as Informatica
• Power BI or Tableau
• Azure DevOps
• Kafka
• MQ
• Financial Services or Asset Management platforms

Additional information

• An inclusive workplace that promotes diversity and collaboration.
• Access to ongoing learning and development opportunities.
• Competitive compensation and benefits package.
• Flexibility to support work-life balance.
• Comprehensive health benefits for you and your family.
• Generous paid leave and holidays.
• Wellness program and employee assistance.

As part of our dedication to an inclusive and diverse workforce, Publicis Sapient is committed to Equal Employment Opportunity without regard for race, color, national origin, ethnicity, gender, protected veteran status, disability, sexual orientation, gender identity, or religion. We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact us at hiring@publicis.sapient.com