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.