SQL Developer

GyanSys Inc.; Bengaluru; On-site; INR 2,500,000 - 3,500,000; Full time

Job summary

GyanSys seeks a skilled SQL Performance Tuning Specialist to optimize SQL database environments. The role emphasizes performance tuning, troubleshooting, and collaboration with DBAs and developers to ensure peak database efficiency.

The ideal candidate holds a Bachelor's degree in CS/IT and 7+ years in SQL administration and tuning, with strong skills in indexing, execution plans, monitoring, and security best practices. This position is on-site in Bengaluru and offers growth opportunities.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 7+ years of experience in SQL database administration and performance tuning.
• Strong expertise in indexing strategies.
• Execution plans.
• Hands-on experience with database monitoring and performance tuning tools.
• Solid understanding of database security, data integrity, and best practices.
• Proven ability to troubleshoot and resolve complex database performance issues.
• Strong analytical, problem-solving, and debugging skills.
• Excellent communication and cross-functional collaboration abilities.
• Ability to work independently as well as in a team-oriented environment.

Responsibilities

• Analyze SQL database performance and identify areas for optimization and improvement.
• Design and implement strategies to enhance database performance, scalability, and efficiency.
• Monitor database health and performance, proactively addressing potential issues.
• Troubleshoot and resolve complex SQL performance bottlenecks and database issues.
• Collaborate with developers, DBAs, and system administrators to optimize queries and system performance.
• Participate in database design and development to ensure performance optimization from inception.
• Conduct regular performance testing and provide actionable recommendations.
• Assist in capacity planning and ensure database scalability for future business growth.
• Implement and promote best practices, standards, and governance for database performance.
• Maintain detailed documentation for performance tuning processes and procedures.
• Provide technical guidance and mentoring to team members on SQL performance tuning.
• Stay current with industry trends, tools, and best practices in database performance optimization.

Skills

SQL Performance Tuning

SQL Database Administration

Indexing Strategies

Execution Plans

Database Monitoring

Troubleshooting

Cross-functional Collaboration

Independent Work

Education

Bachelor’s degree in Computer Science / IT or related field

Tools

Performance Tuning Tools

Job description

GyanSys is a global mid-tier systems integrator company for over 20 years headquartered in the US with 3000+ employees across 12 countries serving 160+ active enterprise customers across Manufacturing, Industrial, Consumer, Life Sciences and High-Tech industries.

GyanSys provides Digital Transformation services leveraging SAP, Salesforce, Databricks, Snowflake, Application Modernisation and various AI projects.

Overview

We are seeking a highly skilled SQL Performance Tuning Specialist to join our team and drive optimization across our SQL database environments. The ideal candidate will bring strong expertise in SQL database administration, performance tuning, and troubleshooting, with a passion for ensuring databases operate at peak efficiency. This role is critical to our business operations, as our systems rely heavily on high-performing, scalable, and reliable databases.

Key Responsibilities

• Analyze SQL database performance and identify areas for optimization and improvement
• Design and implement strategies to enhance database performance, scalability, and efficiency
• Monitor database health and performance, proactively addressing potential issues
• Troubleshoot and resolve complex SQL performance bottlenecks and database issues
• Collaborate with developers, DBAs, and system administrators to optimize queries and system performance
• Participate in database design and development to ensure performance optimization from inception
• Conduct regular performance testing and provide actionable recommendations
• Assist in capacity planning and ensure database scalability for future business growth
• Implement and promote best practices, standards, and governance for database performance
• Maintain detailed documentation for performance tuning processes and procedures
• Provide technical guidance and mentoring to team members on SQL performance tuning
• Stay current with industry trends, tools, and best practices in database performance optimization

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field
• Minimum 7years of experience in SQL database administration and performance tuning
• Strong expertise in:
• Indexing strategies
• Execution plans
• Hands-on experience with database monitoring and performance tuning tools
• Solid understanding of database security, data integrity, and best practices
• Proven ability to troubleshoot and resolve complex database performance issues
• Strong analytical, problem-solving, and debugging skills
• Excellent communication and cross-functional collaboration abilities
• Ability to work independently as well as in a team-oriented environment