SQL Developer cum DBA

Job Title: SQL Developer Job Type: Full-Time | On-site Location: B-237, Block B, Sector 26, Noida, Uttar Pradesh 201301, India Overview: We are seeking a skilled SQL Developer to join our fast-growing team of developers. This role is ideal for someone passionate about writing efficient, well-structured SQL and solving complex data-centric challenges. The position primarily involves investigating production resource consumption issues and optimizing or redesigning SQL queries in a cloud-native Azure SQL Database (PaaS) environment. Responsibilities: Design and optimize complex SQL queries, stored procedures, functions, and views. Investigate and resolve performance issues in production environments (e.g., high CPU, I/O spikes). Collaborate with: Developers to ensure production system performance and scalability, Analysts to improve internal reporting metrics, Business stakeholders to translate requirements into efficient SQL solutions. Participate in data modeling, schema design, and database refactoring efforts. Perform code reviews and approve pull requests involving SQL objects (tables, procedures, indexes, etc.). Gain exposure to DBA responsibilities, including: Index tuning and maintenance Creating and managing Elastic Jobs Backup and recovery strategies Implementing and monitoring security and access controls Diagnosing performance issues using Extended Events and execution plans Monitoring via Azure Portal Alerts and diagnostics Requirements: 35 years of experience writing and optimizing queries in Azure SQL Database (PaaS) Strong understanding of relational database principles, execution plans, query hints, and JOIN behavior Experience handling large data sets (100k to 10 million+ rows per table) Proficiency in SQL Server Management Studio (SSMS) ; familiarity with Azure Data Studio is a plus Strong attention to detail and problem-solving skills Ability to explore data and identify quick wins in query performance Preferred but not required: Experience with SQL Server 2022 or earlier versions Familiarity with Git and Git Bash Exposure to ETL processes Interest in database internals, system performance tuning, and administrative operations Why Join Us: Accelerate your career in a hybrid DBA/Developer role Work directly with an experienced DBA in a collaborative, fast-paced environment Competitive compensation and benefits Long-term growth opportunities and advanced technical exposure