DBA professionals

Job Description

Job Description: Novaya is seeking for a solid Senior SQL Server Database Developer. Were looking for a Senior SQL Server Developer to join our Hyderabad team. This role is ideal for someone who thrives in a collaborative environment, enjoys solving real-world problems, and has hands-on experience in working with SQL Server on Azure. Responsibilities Design scalable database schema for high-transaction and high-volume applications. Build complex queries, views, stored procedures, functions and triggers, optimized for high performance. Analyze and improve slow running SQL queries. Resolve database-related issues and provide solutions in a timely manner. Ensure performance, security, and availability of databases. Develop procedures and scripts for data migration. Build scripts for data archiving and purging. Build nightly jobs to handle batch activities. Support data encryption, masking and compliance and implement access controls to safeguard data. Work closely with backend engineers, DBAs, DevOps Engineers and BI analytics. Required Skills Experience 8+ years of experience working with any relational and NoSQL databases and applying it in various applications, including within the Microsoft Azure platform. 5+ years of experience in Microsoft SQL Server, including designing, developing, and implementing complex SQL queries, stored procedures, and functions. Deep knowledge of T-SQL, performance tuning, and query optimization. Proficiency with SQL Server security models, backups, restores, and HA/DR strategies. Experience using Azure Monitor, Log Analytics, and SQL Insights. Expertise in packaging and deploying SQL changes across 100s of databases as part of product releases. Experience with Data archiving and data purging. Hands on experience with NoSQL databases. Nice to Have Knowledge of SQL Server licensing and cost optimization strategies in Azure. Exposure to Redis Cache and MongoDB. Familiarity with Agile/Scrum development environments. Education: B.Tech/B.E - Computers, MCA - Computers, MS/M.Sc(Computers)