Infosys - Support Engineer - SQL/Unix

Role Overview :

We are seeking a SQL and Unix professional to support application operations, database querying, batch processing, and production troubleshooting.

The ideal candidate will have hands-on experience in SQL development, Unix/Linux commands, shell scripting, and analyzing application or batch-processing issues.

Key Responsibilities :

- Write, execute, and optimize SQL queries to retrieve, validate, and analyze data.

- Develop complex queries involving joins, subqueries, aggregations, and common table expressions.

- Perform data reconciliation, integrity checks, and database troubleshooting.

- Execute and monitor batch jobs, scheduled processes, and application workflows in Unix/Linux environments.

- Use Unix commands to navigate file systems, process files, inspect logs, and troubleshoot errors.

- Develop and maintain shell scripts to automate repetitive operational activities.

- Analyze application logs and job failures to identify root causes.

- Support production incidents, perform initial diagnosis, and coordinate issue resolution.

- Monitor batch execution, identify processing delays, and ensure timely completion of scheduled jobs.

- Collaborate with development, database, infrastructure, and operations teams.

- Prepare technical documentation, operational procedures, and incident reports.

- Follow change management, incident management, and production support processes.

Required Skills :

- 4-6 years of experience working with SQL and Unix/Linux environments.

- Strong proficiency in SQL queries, joins, subqueries, functions, and data validation.

- Hands-on experience with Unix commands, file handling, permissions, and process monitoring.

- Knowledge of shell scripting using Bash, KornShell, or equivalent.

- Experience analyzing application logs and troubleshooting batch jobs.

- Understanding of relational databases and database performance fundamentals.

- Familiarity with scheduling tools and job monitoring processes.

- Strong analytical, debugging, and problem-solving abilities.

Preferred Skills :

- Exposure to Oracle, PostgreSQL, MySQL, or other relational databases.

- Experience with production support and incident management tools.

- Knowledge of Control-M or similar enterprise job schedulers.

- Familiarity with ITIL processes and service management practices