SQL Developer

About LocoBuzz:Locobuzz is a SaaS platform that converges with technologies such as Artificial Intelligence,Machine Learning, Big Data Analytics, and Automation, to provide brands with a 360-degreeCustomer Experience Management Suite. Locobuzzs powerful analytics algorithms have helpedseasoned brands establish a strong foothold in the digital hemisphere and transformed theircustomer experience journeys.Visit our website LocoBuzz for more information on our CX management products and services

Position: SQL DeveloperLocation: MumbaiPosition Overview:We are seeking a highly skilled SQL Database Developer to join our dynamicteam. The ideal candidate will have a deep understanding of SQL and database concepts,experience with performance tuning, and the ability to optimize and manage both relational andNoSQL databases. You will be responsible for designing, developing, and maintaining databaseswhile ensuring high levels of performance, availability, and security.

Key Responsibilities:Design, develop, and maintain SQL databases.Write and optimize complex SQL queries to ensure efficiency and performance.Perform database normalization to eliminate redundancy and ensure data integrity.Implement indexing strategies to improve query performance.Manage database transactions and ensure the ACID properties are maintained.Conduct performance tuning and optimization of SQL queries and databases.Develop and maintain database schemas, tables, views, triggers, and stored procedures.Utilize various types of joins to retrieve and manipulate data.Use clauses for data aggregation and filtering.Work with subqueries.Implement database replication, mirroring, and backup strategies.Monitor database health and ensure high availability.Handle database deadlocks and resolve any concurrency issues.Collaborate with development teams to design and implement data solutions.

Required Skills and Qualifications:Bachelors degree in Computer Science, Information Technology, or a related field.Proven experience as a SQL Database Developer or similar role.Strong understanding of database concepts and architectures.Proficiency in SQL and experience with relational databases (e.g., SQL Server, MySQL,

PostgreSQL).

http://www.locobuzz.com

Knowledge of NoSQL databases (e.g., MongoDB, Cassandra) and their differences fromSQL databases.

Experience with database normalization and various normal forms.Strong understanding of primary and foreign keys.Ability to write and optimize complex SQL queries.Familiarity with indexing, transactions, and ACID properties in databases.Experience with SQL Server performance tuning tools and techniques.Understanding of database replication, mirroring, and backup strategies.Excellent problem-solving skills and attention to detail.Strong communication skills and ability to work collaboratively in a team environment.

Benefits:Medical Coverage:We care about your health and well-being. We offer comprehensive medical

coverage to ensure you and your family have access to quality healthcare.Opportunity to Work in a Fast-Paced and Dynamic Organization: At Locobuzz, we thrive on

innovation and agility. Youll have the chance to work in an environment where every day bringsnew challenges and opportunities for growth. Your contributions will make a real impact on ourdynamic organization.

Learning and Upskilling: At Locobuzz we believe in continuous learning and development. Youllhave access to resources and support for your professional development, which may includetraining, workshops, and opportunities to expand your skill set.

Collaborative Workplace: Collaboration is at the heart of our culture. Youll be part of a teamthat values open communication, knowledge sharing, and working together to achieve commongoals. Your ideas and insights will be heard and respected, fostering a sense of belonging withinour collaborative workplace.