Vacancy description
infosys ltd
भारत
Role Overview :We are seeking a SQL and Unix professional to support application operations, database querying, batch processing, and production https://jobeax.com/link/hxC2Y7LHNm0eDZxg ideal candidate will have hands-on experience in SQL development, Unix/Linux commands, shell scripting, and analyzing application or batch-processing https://jobeax.com/link/ro46FkPxAnoyThW9 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 https://jobeax.com/link/MirvQRp3VJnXim2b 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 https://jobeax.com/link/XeQgkERVo2V2JtoS 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 (ref:hirist.tech)