SRM Technologies Technology/Software

System Analyst

Chennai, India In person Full-time
  • 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

1.

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.

Free tool / Resume tailor

Tailor your resume for this job

Paste your resume and get 3 to 8 of your own lines rewritten in the words this posting uses, with the reason for each change. The job is already filled in, and you don't need an account.

Job description provided by SRM Technologies.
View the original posting