Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in pune
>
Rosemallow technologies
>
SQL Developer

SQL Developer

Rosemallow technologies

0 years

12 - 15 Lacs

pune maharashtra

Posted:13 hours ago| Platform: Indeed logo

Apply

Skills Required

sql developer database debugging reporting troubleshooting tuning query collaboration stability scalability reliability development optimization support design data architecture resolve reports joins indexes model documentation logic testing compliance governance security backup indexing statistics communication power tableau layers

Work Mode

Remote

Job Type

Full Time

Job Description

The Senior Database Application Associate is responsible for analysing, debugging, and optimizing complex SQL queries used in reporting environment. This role involves hands-on troubleshooting, SQL performance tuning, improving query runtime and collaboration with cross-functional teams to ensure the stability, scalability, and reliability of mission-critical business applications. The ideal candidate brings strong technical expertise, problem-solving skills, and experience managing production systems in a fast-paced environment.

Key Responsibilities

Database Development & Optimization

Develop, debug, and maintain SQL queries, stored procedures, triggers, packages, and functions.

Perform database performance tuning—index optimization, query rewriting to reduce execution time, and resource utilization improvements.

Support schema design, data modelling, and database architecture improvements.

Diagnose and resolve complex application and database-related issues.

Analyse large and complex SQL queries used in reports by identifying performance issues in joins, filters, CTEs, functions, indexes, and data model design.

Ensure optimized SQL returns the same data as the original queries.

Maintain accurate technical documentation, runbooks, and knowledge articles.

Cross-functional Collaboration

Work closely with application developers, system engineers, QA teams, and business stakeholders.

Provide technical guidance and mentorship to junior team members.

Work with team members to validate logic and resolve data or performance issues.

Support unit testing, QA testing, and user acceptance testing.

Share technical recommendations for improving query performance and structure with the team.

Ensure compliance with data governance, security, and backup policies.

Required Qualifications

Strong expertise in SQL (SQL Server— customize as needed).

Expertise in joins, subqueries, CTEs, window functions, aggregations.

Strong experience in analysing execution plans and tuning queries.

Understanding of indexing, partitioning, statistics, and database performance.

Experience troubleshooting and tuning large, complex queries and database operations.

Strong analytical, communication, and documentation skills.

Good communication skills and ability to articulate technical details clearly.

Good to Have

Knowledge/Experience with Cognos, Power BI, Tableau, or other reporting tools.

Understanding of BI concepts, metadata layers, and reporting models.

Job Type: Full-time

Pay: ₹1,247,664.04 - ₹1,508,888.96 per year

Work Location: Hybrid remote in Pune, Maharashtra (411048)

More Jobs at Rosemallow technologies

Python Architect

Chennai

8.0 - 8.0 yrs

INR 30 - 30 Lacs

DevOps Architect

Pune, Maharashtra

5.0 - 5.0 yrs

Salary: Not disclosed

DevOps Architect

Pune

5.0 - 5.0 yrs

INR 30 - 30 Lacs

Voice Process Executive

Saravanampatti, Coimbatore, Tamil Nadu

1.0 - 1.0 yrs

Salary: Not disclosed

Voice Process Executive

India

1.0 - 1.0 yrs

INR 2 - 2 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Rosemallow technologies

Login to

Please Verify Your Phone or Email

Confirm Action

SQL Developer