Jobs

Courses

Resources

Companies

Placements

Community

Home >

Jobs >

Software Engineer - Java PL/SQL

Karnataka, India (Hybrid)

Software Engineer - Java PL/SQL

1 Month ago • 5-8 Years • Full Stack Development • Research & Development • Undisclosed

About the job

5 skills required for this role

Add these skills to join the top 1% applicants for this job

java

github

sql

svn

git

Job Description

This role involves maintaining, enhancing, and optimizing a Sybase ASE database using T-SQL. Responsibilities include analyzing, modifying, and enhancing existing code (stored procedures, functions, triggers); identifying and resolving performance bottlenecks; diagnosing and resolving complex database issues; refactoring code for improved maintainability; participating in code reviews; maintaining technical documentation; collaborating with developers, business analysts, and stakeholders; and mentoring junior developers. The ideal candidate will have 5-8 years of experience in database development using T-SQL or PL/SQL, a strong understanding of database design principles, and experience with performance tuning and optimization. Experience with Sybase ASE is a plus but not required for candidates with strong PL/SQL backgrounds.

Must have:

5-8 years exp in T-SQL or PL/SQL
Strong SQL skills (complex queries, stored procedures)
Experience with large, complex codebases
Performance tuning & optimization
Database design principles
Code review participation

Good to have:

Sybase ASE experience
Database security best practices

About the Role:

We are seeking a highly skilled and experienced Senior SQL Developer with a strong background in either PL/SQL/T-SQL to join our team. You will play a critical role in maintaining, enhancing, and optimizing our extensive existing database codebase. While our primary database environment is Sybase ASE using T-SQL, we recognize and value the transferable skills of experienced PL/SQL developers. If you have a proven ability to adapt to new technologies and a passion for working with complex database systems, we encourage you to apply.

This role will focus primarily on understanding, modifying, and improving our current T-SQL code. You will be responsible for implementing bug fixes, performance tuning, adding new features to existing systems, and ensuring the continued stability and integrity of our critical database applications.

Responsibilities:

Code Maintenance and Enhancement: Analyze, modify, and enhance existing code (stored procedures, functions, triggers) to meet evolving business requirements and address issues.

Performance Optimization: Identify and resolve performance bottlenecks within the existing codebase. Optimize queries, stored procedures, and database design for maximum efficiency.

Troubleshooting and Debugging: Diagnose and resolve complex database issues in development, test, and production environments.

Refactoring: Proactively identify areas of the codebase that can be improved through refactoring, leading to increased maintainability and efficiency, and implementing said refactoring.

Code Reviews: Participate in code reviews to ensure code quality, adherence to coding standards, and best practices.

Documentation: Maintain and update technical documentation related to the database schema, code logic, and system functionality.

Collaboration: Work effectively with other developers, business analysts, and stakeholders to understand requirements and implement solutions within the existing codebase.

Mentorship: Provide guidance to junior developers, sharing your knowledge and experience.

Stay abreast of database development best practices and propose improvements to our current processes.

Qualifications:

Experience: 5-8 years of professional experience in database development using either T-SQL or PL/SQL.

Education: Bachelor's degree in Computer Science, Information Technology, or a related field.

Technical Skills:

Strong proficiency in either T-SQL or PL/SQL: You should be highly skilled in writing complex queries, stored procedures, functions, triggers, and using advanced features of your chosen language.

Proven experience working with large, complex existing codebases: Demonstrated ability to understand, modify, and improve existing code rather than solely focusing on new development.

Solid understanding of database design principles and normalization.

Experience with performance tuning and optimization techniques.

Familiarity with version control systems (e.g., Git, SVN).

Exposure to Sybase ASE is a plus, but not required for candidates with strong PL/SQL background.

Experience with database security best practices.

Soft Skills:

Excellent problem-solving and analytical skills.

Strong communication and collaboration skills.

Ability to work independently and as part of a team.

Proactive attitude and a strong desire to learn and adapt to new technologies.

Ability to explain complex technical concepts clearly to both technical and non-technical audiences.

undefinedundefinedundefined