SQL Developer

Position Overview:

We are seeking a highly skilled SQL Developer with deep expertise in SQL query performance tuning and database optimization. This role demands a strong command of SQL and focuses on improving the efficiency and speed of queries, stored procedures, and overall database performance. The ideal candidate will be responsible for ensuring fast, reliable access to both real-time and historical data through rigorous analysis and optimization techniques.

Key Responsibilities:

1. SQL Development & Optimization

• Develop, enhance, and maintain complex SQL queries and stored procedures to meet business requirements.
• Analyze and tune underperforming queries using best-in-class optimization techniques.
• Design efficient data retrieval strategies for large-scale, time-sensitive datasets (both real-time and historical).

2. Performance Tuning & Database Optimization

• Perform detailed analysis of SQL execution plans to identify bottlenecks and suggest improvements.
• Implement indexing strategies, partitioning, and schema design changes to optimize query execution.
• Ensure scalable database solutions to support high-volume, low-latency environments.

3. Troubleshooting & Root Cause Analysis

• Diagnose and resolve SQL and database performance issues in collaboration with DBAs, developers, and support teams.
• Proactively address potential performance degradation and implement preventive measures

4. Data Architecture & Platform Understanding

• Work with modern database engines and understand underlying data pipeline architectures (e.g., Plx).
• Support robust, scalable processing of streaming and batch data workloads.

5. Support & Monitoring

• Adhere to SLAs for issue response and resolution, ensuring minimal system downtime.
• Continuously monitor performance and suggest tuning opportunities based on metrics and usage trends. Required

Qualifications:

1. Mandatory Technical Skills

• Expert-level SQL knowledge with a deep understanding of query structuring, optimization, and performance tuning.
• Strong expertise in execution plan analysis, indexing strategies, and database performance diagnostics.
• Proven ability to tune high-complexity queries and optimize data access patterns for large volumes of data.

1. Experience

• Minimum of 3 years of hands-on experience in SQL development and query optimization for performance-critical systems.
• Experience working with large datasets and real-time/historical data processing systems. • Prior success in resolving complex SQL-related performance bottlenecks.

1. Additional Skills

• Strong communication skills and ability to collaborate with cross-functional technical teams.

• Familiarity with support processes, SLAs, and performance monitoring tools.