System Analyst
Chennai, India · Full-time
- Posted 3d ago
- From SRM Technologies’s careers page
- Location
- Chennai, India
- Type
- Full-time
- Level
- Senior
- Experience
- 3+ years
- Department
- Information Technology
Opens the listing on careers.srmtech.com
Let the right jobs find you
In your inbox every Wednesday and SaturdayPersonalised suggestions from verified career pages, matched to your role, location, level and skills.
About the role
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 advantage.
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.
Skills they ask for
Pick one to see other roles that ask for it.
About SRM Technologies
Digital and mobility engineering partnerSRM Technologies is a global engineering partner delivering automotive embedded systems, digital platforms, AI, cloud and enterprise transformation solutions.
See all 29 roles at SRM TechnologiesMore roles at SRM Technologies
See all 29- Oracle Redwood ConsultantChennaiInformation TechnologyChennai, India2d
- Service Delivery ManagerChennaiInformation TechnologyChennai, India3d
- Database AdministratorChennai · Entry Level · On-siteInformation Technology · Entry Level · On-siteChennai, India3d
- Site Reliability EngineerChennaiInformation TechnologyChennai, India3d
Let the right jobs find you
In your inbox every Wednesday and SaturdayPersonalised suggestions from verified career pages, matched to your role, location, level and skills.