GyanSys - SQL Performance Tuning Specialist

Role : SQL Performance Tuning Specialist.

Location : Bangalore (Work from Office).

Employment Type : Full time.

About Us 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

• Bachelors degree in Computer Science, Information Technology, or a related field.
• Minimum 7 years of experience in SQL database administration and performance tuning.
• Strong expertise in :
• SQL query optimization.
• Indexing strategies.
• Execution plans.
• Database design principles.
• 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. (ref:hirist.tech)