SQL Database Developer

As a SQL Database Developer at House of Anita Dongre in Rabale, Navi Mumbai, your role involves designing and developing database objects such as tables, views, indexes, and stored procedures. You will be responsible for writing efficient, scalable, and secure SQL queries for data extraction, transformation, and analysis. Additionally, optimizing SQL queries and database performance, including indexing, query tuning, and normalization will be a key part of your responsibilities. Collaborating with application developers to integrate SQL databases with business applications and integrating data from multiple sources into a centralized data warehouse are also crucial tasks. Familiarity with BI tools like Power BI and Tableau will be beneficial for querying data warehouses to enhance support and development. Ensuring data integrity, security, and backup procedures are in place and followed, troubleshooting database issues, debugging SQL code, and providing solutions, as well as maintaining documentation related to database structure, configurations, and standards are important aspects of the role. Key Responsibilities: - Design and develop database objects such as tables, views, indexes, and stored procedures. - Write efficient, scalable, and secure SQL queries for data extraction, transformation, and analysis. - Optimize SQL queries and database performance, including indexing, query tuning, and normalization. - Collaborate with application developers to integrate SQL databases with business applications. - Integrate data from multiple sources (ERP, Excel, APIs) into a centralized data warehouse. - Familiarity with BI tools (like Power BI, Tableau) query data warehouses improves support and development. - Ensure data integrity, security, and backup procedures are in place and followed. - Troubleshoot database issues, debug SQL code, and provide solutions. - Maintain documentation related to database structure, configurations, and standards. Qualifications Required: - 3-5 years of experience as an SQL Developer or similar role. - Proficiency in Microsoft SQL Server, MySQL, PostgreSQL, or other relational databases. - Understanding of database security, performance tuning, and indexing strategies. - Familiarity with data modeling tools and techniques. - Excellent analytical, problem-solving, and communication skills.,