Apply on Kit Job: kitjob.in/job/4k5zsv

Job Title:

SQL Developer

Department:

Information Technology

Reports to:

Global Director of IT

FLSA

• Exempt

• Non-Exempt

Summary:

The Senior SQL Developer to own the design, performance, and reliability of SQL Server–based data solutions. This role is responsible for architecting and optimizing complex database systems, leading performance tuning initiatives, and ensuring the stability and integrity of production data environments. The Senior SQL Developer partners closely with business and technical stakeholders, mentor colleagues, enforces best practices, and takes end-to-end ownership of database development, reporting, and data integration solutions.

Duties and Responsibilities:

Database Architecture & Development

• Design, develop, and maintain complex SQL Server databases, schemas, tables, views, stored procedures, and functions.

• Lead database architecture decisions to support scalability, performance, and long-term maintainability.

• Establish and enforce SQL development standards, naming conventions, error handling, and documentation.

• Participate in solution design discussions and provide technical guidance on database-related initiatives.

Performance Optimization & Production Support

• Own SQL Server performance tuning efforts, including execution plan analysis, indexing strategies, statistics management, and query optimization.

• Proactively identify and resolve performance bottlenecks, deadlocks, blocking, and concurrency issues.

• Monitor and support production databases, participating in incident resolution and root-cause analysis.

• Collaborate with infrastructure and DBA teams on capacity planning, high availability, disaster recovery, and upgrades.

Reporting & Analytics

• Design, develop, and maintain SSRS reports, shared datasets, and subscriptions.

• Translate business requirements into efficient reporting solutions with strong performance and data accuracy.





• Optimize existing reports and datasets to improve reliability, usability, and execution time.

• Support reporting modernization initiatives as needed (e.g., migration planning, integration with BI tools).

ETL & Data Integration

• Design, build, and maintain ETL processes using SSIS or equivalent tools.

• Integrate data from multiple internal and external sources, ensuring data quality and consistency.

• Implement robust error handling, logging, auditing, and monitoring data pipelines.

• Optimize ETL performance and support scheduled and near–real-time data loads.

Leadership, Mentoring & Collaboration

• Serve as a technical leader for SQL and database development within the team.

• Mentor junior and mid-level developers through code reviews, knowledge sharing, and best practice guidance.

• Collaborate closely with application developers, analysts, and business stakeholders to deliver effective data solutions.

• Contribute to continuous improvement of development processes, deployment practices, and system reliability .

Required Qualifications

Education

• Bachelor’s degree in computer science, Information Systems, or a related field, or equivalent practical experience.

Experience

• 7+ years of hands-on SQL Server development experience in production environments.

• Extensive experience writing and optimizing complex T-SQL.

• Proven track record of SQL Server performance tuning and troubleshooting.

• Strong experience developing and supporting SSRS reports.

• Experience building and maintaining ETL solutions using SSIS or similar tools.





Technical Skills

• SQL Server (indexing, execution plans, transactions, locking, isolation levels)

• Data modeling (relational and dimensional concepts)

• ETL and data integration best practices

• Version control (Git or equivalent) and deployment processes

• Database security, permissions, and data protection practices

Preferred Qualifications

• Experience with Azure SQL, Managed Instance, or other cloud-based data platforms

• Familiarity with CI/CD pipelines for database deployments

• Exposure to contemporary BI tools (e.g., Power BI)

• Experience supporting high-availability and disaster recovery environment .

Professional Competencies

• Strong analytical and problem-solving skills

• Ability to take ownership of complex systems and drive solutions independently

• Excellent communication skills with both technical and non-technical audiences

• Proven ability to mentor and lead by influence

• Detail-oriented with a focus on quality, performance, and reliability

Work Environment & Physical Requirements

• Primarily office or remote-based work.

• Occasional on-call or after-hours support may be required.

Job Requirements: SQL Server, T-SQL, SSRS, ETL, SSIS, execution plan analysis, indexing strategies, statistics management, query optimization, performance tuning, deadlock resolution, concurrency control, incident resolution, root-cause analysis, capacity planning, high availability, disaster recovery, reporting modernization, data integration, error handling, logging, auditing, monitoring data pipelines, data modeling, relational concepts, dimensional concepts, version control, Git, database security, permissions, data protection practices, Azure SQL, Managed Instance, cloud-based data platforms, CI/CD pipelines, Power BI, analytical skills, problem-solving skills, communication skills, mentoring, leadership, code reviews

Apply on Kit Job: kitjob.in/job/4k5zsv

📌 SQL Developer (India)
🏢 HIRESTAR JOB BANK
📍 India