19 Nov
|
SRM Technologies
|
Chennai
19 Nov
SRM Technologies
Chennai
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 effective, 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.
3.
Maintainable
Java source code, APIs, and database integrations.
- Test plans, test cases, and test results.
- Shell scripts, configuration files, technical documentation, and reports.
📌 System Analyst (Chennai)
🏢 SRM Technologies
📍 Chennai