SQL and Unix Scripting expert with Prod monitor

Tech Mahindra; Hyderabad; Hybrid; INR 1,000,000 - 1,800,000; Full time

Job summary

Tech Mahindra in Hyderabad seeks a skilled technical professional to manage problem resolution, write and tune SQL queries, and work across Unix/Linux environments to translate business needs into technical designs.

You will collaborate with product control stakeholders, handle overnight escalations, and contribute to configurations, reports, and data migration reviews, ensuring timely delivery.

Qualifications

• Experience understanding, writing and tuning SQL queries.
• Experience with Unix/Linux systems including command line navigation and scripting.
• Ability to synthesize business processes into technical specifications and application configuration.
• Excellent listening, oral and written communication skills.
• Ability to meet aggressive deadlines and quickly understand the existing framework and business requirements.
• Familiarity with Oracle technology including database, middleware and ERP products.
• Experience in ledger implementations is an asset.
• Familiarity with capital market products is an asset.
• Development experience with Database such as MS SQL Server and Oracle is an asset.
• Working experience with data structures, algorithms and OO design.

Responsibilities

• Manage and attend to problem logs to successful resolution on a timely basis.
• Identify, write and manage business requirements; contribute to design, prototyping and process design stages of implementations.
• Support configurations, customization, reports and interfaces, testing and user training.
• Work with Product Control users and stakeholders to gather information using interviews, sessions, storyboarding and prototyping.
• Understand project scope, goals, product functionality and desired features.
• Evaluate customer needs/issues and determine appropriate solutions with senior technical staff.
• Assist with system design and data migration reviews as needed.
• Work with senior developers and execute low complexity system configuration.
• Assist with development of test conditions, scripts and test cases.

Skills

SQL queries

Unix/Linux

Business requirements

Communication skills

Problem solving

OO design

Data structures

Prototyping

Capri/Capital markets familiarity

Oracle technology

MS SQL Server

Ledger implementations familiarity

Tools

Oracle Database

Oracle Middleware

ERP products

MS SQL Server

Job description

• Manage and attend to problem logs to successful resolution on a timely basis.
• Experience understanding, writing and tuning SQL queries.
• Good Experience with Unix/Linux systems, including basic command line navigation, scripting and commands.
• Ability to synthesize business processes into technical specifications and application configuration.
• Excellent listening, oral and written communication skills.
• Availability to manage overnight escalation if needed.
• Ability to meet aggressive deadlines and quickly understand the existing framework and business requirements.
• Ability to prioritize and work on multiple tasks.
• Very organized with attention to detail.
• Willing and able to work in different technical environments.
• Maintain excellent interpersonal relationships and demonstrate an ability to work effectively as part of a team.
• Systematically analyze and identify problems to determine the causes and propose solutions.
• Familiarity with capital market products is an asset.
• Familiarity with Oracle technology is an asset including database, middleware and ERP products.
• Experience in ledger implementations is an asset.
• Development experience in Oracle Financial products is an asset.
• Development experience with Database such as MS SQL Server and Oracle is an asset.
• Working experience with data structures, algorithms and principles of OO design.
• Identifying, writing and managing business requirements. Contributing to the functional and technical design, prototyping and process design stages of implementations (including scenario design, flow mapping).
• Supporting configurations, customization, reports and interfaces, testing and user training.
• Work with the Product Control users and other stakeholders to gather information utilizing a variety of techniques such as interviews, work sessions, storyboarding and prototyping.
• Understand project scope, project goals, product functionality and desired features.
• Evaluate customer needs/issues, analyze business processes, assist in evaluating alternatives and determine appropriate solutions with senior technical staff.
• Help determine the level of effort and time required for delivery.
• Ensure that business requirements are properly translated and satisfied with technical requirements and design.
• Assist with system design and data migration reviews as needed.
• Work with senior developers and execute low complexity system configuration.
• Assist with development of test conditions, scripts and test cases.
• Follow standard software implementation best practices relative to analysis, configuration, development and testing.
• Provide ad-hoc reporting, data gathering, and feasibility studies to support project business justification as required for management review.