SRM Technologies logo

System Analyst

SRM Technologies

3 - 4 years

Chennai

Posted:7 hours ago

Job Description

Job Information
  • Date Opened 11/19/2026
  • Job Type Full time
  • City Chennai
  • State/Province Tamil Nadu
  • Country India
  • Zip/Postal Code 600096
  • Industry Technology
Job Description

We are seeking a Senior System Analyst with 3-4 years of IT experience for a SQL-focused role supported by Java development expertise. The expected technical experience and responsibility mix is 60% SQL and 40% Java.

SQL DEVELOPMENT AND OPTIMIZATION - 60%
1. Develop, maintain, and optimize complex SQL queries, joins, subqueries, stored procedures, and scripts in MySQL and/or Oracle.
2. Analyze query execution plans, identify performance bottlenecks, and improve query performance through indexing, query rewriting, and appropriate database design.
3. Troubleshoot slow-running queries and database issues; validate data accuracy and measure performance improvements without compromising correctness.

JAVA DEVELOPMENT - 40%
4. Design, develop, and maintain efficient, reusable, and reliable back-end applications using Java 8, J2EE, and Spring MVC.
5. Develop and maintain APIs and database integrations; troubleshoot application issues and improve performance, quality, and responsiveness.

ADDITIONAL RESPONSIBILITIES
6. Prepare and execute test plans against requirements; document solutions and maintain code using version control.
7. Use Linux CLI and shell scripting for application support, troubleshooting, and routine automation.
8. Collaborate with stakeholders, apply analytical problem-solving skills, and communicate clearly in English. Japanese language skills are an advatage.

Experience

Experience: 3-4 years of IT experience, with a technical focus of 60% SQL and 40% Java. Hands-on SQL query optimization experience is required.
Employment Type: Permanent
Education: B.Tech/B.E. or BCA/MCA in any specialization

Skills Required

Required: SQL development and query optimization (60% focus); MySQL and/or Oracle; execution plan analysis, indexing, query tuning, stored procedures, and data validation.
Java development (40% focus): Java 8, J2EE, Spring MVC, APIs, and database integration.
Supporting skills: Linux CLI, shell scripting, version control, testing, troubleshooting, and strong English communication. Japanese language skills are an advantage.

Deliverables

1. Optimized SQL queries, stored procedures, and database scripts.
2. Query tuning documentation, including execution plan analysis and before-and-after performance measurements.
3. Maintainable Java source code, APIs, and database integrations.
4. Test plans, test cases, and test results.
5. Shell scripts, configuration files, technical documentation, and reports.

Skills Required

SQL Java Development Java SQL Development SQL Queries Stored Procedures Mysql Oracle Database Design Java 8 J2ee Spring MVC

Learn the skills this job asks for

Free courses, interview questions and practice for each skill.

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Java Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Java Skills

Practice Java coding challenges to boost your skills

Start Practicing Java Now
SRM Technologies logo
SRM Technologies

RecommendedJobs for You

SRM Technologies logo

System Analyst

SRM Technologies

Chennai

N

System Analyst

NEC Corporation

India

R

System Analyst

RightsLine

India

RSG Media Systems logo

System Analyst

RSG Media Systems

Noida

Rodic Consultants logo

System Analyst

Rodic Consultants

Guwahati