dreamwork_

We are looking for an Application Support Engineer with 4+ years of experience supporting business-critical applications, preferably in the Telecom/Billing domain. The candidate should have strong hands-on expertise in Oracle SQL/PLSQL, Unix/Linux, Shell Scripting, production support, and troubleshooting.

Key Responsibilities

  • Provide BAU/production support for telecom billing applications.
  • Monitor applications, batch jobs, interfaces, and system health.
  • Troubleshoot incidents using logs, database queries, shell scripts, and application code.
  • Perform Root Cause Analysis (RCA) and resolve data/billing discrepancies.
  • Develop and optimize SQL queries, PL/SQL procedures, functions, and triggers.
  • Develop Bash/KSH scripts for batch jobs, cron tasks, monitoring, and automation.
  • Support bug fixes, testing, releases, and production deployments following SDLC/change-management processes.
  • Work with development, database, infrastructure, and business teams to resolve production issues.

Required Skills

  • Oracle SQL & PL/SQL: Strong expertise in complex queries, stored procedures, functions, triggers, troubleshooting, and performance optimization.
  • Unix/Linux: Strong command-line skills, including log analysis, process/file management, and system health checks.
  • Shell Scripting: Strong Bash/KSH scripting for automation, batch processing, cron jobs, and operational health checks.
  • Telecom Billing: Good understanding of the Mediation → Rating → Billing/Invoicing lifecycle and usage/data reconciliation.
  • Application Support: Strong experience in incident management, log tracing, RCA, batch-job troubleshooting, and production recovery.
  • Java & C++: Ability to read and trace application code for production troubleshooting.
  • SDLC: Understanding of bug fixing, testing, release/change management, deployment, and post-production validation.

Key Competencies

  • Strong analytical and problem-solving skills.
  • Ability to trace billing/data discrepancies across database, application, and code layers.
  • Technical versatility across Oracle, Unix/Linux, Shell, Java, and C++.
  • Strong communication, ownership, and ability to work effectively in a production support environment.