System Analyst
Srmtech · Chennai, Tamil Nadu, India
- First seen
- 19 November 2026
- Reposted
- Not since September 2026
- Last checked
- Today · still on the employer's board
All reasons
In its favour
- Posted yesterday
- Still listed on the employer's own board
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%
- Develop, maintain, and optimize complex SQL queries, joins, subqueries, stored procedures, and scripts in MySQL and/or Oracle.
- Analyze query execution plans, identify performance bottlenecks, and improve query performance through indexing, query rewriting, and appropriate database design.
- Troubleshoot slow-running queries and database issues; validate data accuracy and measure performance improvements without compromising correctness.
JAVA DEVELOPMENT - 40%
- Design, develop, and maintain efficient, reusable, and reliable back-end applications using Java 8, J2EE, and Spring MVC.
- Develop and maintain APIs and database integrations; troubleshoot application issues and improve performance, quality, and responsiveness.
ADDITIONAL RESPONSIBILITIES
- Prepare and execute test plans against requirements; document solutions and maintain code using version control.
- Use Linux CLI and shell scripting for application support, troubleshooting, and routine automation.
- 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
- Optimized SQL queries, stored procedures, and database scripts.
- Query tuning documentation, including execution plan analysis and before-and-after performance measurements.
- Maintainable Java source code, APIs, and database integrations.
- Test plans, test cases, and test results.
- Shell scripts, configuration files, technical documentation, and reports.
More jobs at Srmtech
All 32- Cloud NOC LeadSrmtech · Chennai, Tamil Nadu, Indiayesterday
- Senior Database AdministratorSrmtech · Chennai, Tamil Nadu, Indiayesterday
- Junior Database AdministratorSrmtech · Chennai, Tamil Nadu, Indiayesterday
- Site Reliability EngineerSrmtech · Chennai, Tamil Nadu, Indiayesterday
- Sr. Backend Developer 2 (Batch & Integration)Srmtech · Chennai, Tamil Nadu, India3d ago
Similar roles
- Senior Business Systems AnalystAkamai · India18d ago
- Subcontractor - System AnalystPerficient · India1mo ago
- Principal Systems Analyst - GenevaFidelity · EMBASSY MANYATA BUSINESS PARK, BLD F2, Bangalore India · Chennai, Tamil Nadu25d ago
- Sr Associate Business Systems Analyst, Commercialization TechnologyAmgen · India - Hyderabad1mo ago
- Associate Business Systems Analyst, Commercialization TechnologyAmgen · India - Hyderabad1mo ago
- Specialist IS Business system analystAmgen · India - Hyderabad1mo ago