Colorgenics Marketing Services Pvt Ltd

Job Summary: We are looking for a skilled SQL Developer to join our team. The ideal candidate will have a strong understanding of database management systems, experience in writing complex SQL queries, and a solid understanding of data structures and algorithms. The SQL Developer will be responsible for designing, developing, and maintaining SQL databases, ensuring their performance, availability, and security.

Key Responsibilities:

• Design, develop, and optimize SQL databases, tables, views, stored procedures, and triggers.
• Develop efficient and complex SQL queries for data extraction, transformation, and loading (ETL).
• Create and maintain database schema designs, data models, and ER diagrams.
• Analyze and optimize complex SQL queries for better performance.
• Implement indexing strategies, query optimization techniques, and other performance tuning practices.
• Ensure data integrity and security by designing and implementing database constraints, data validation rules, and security policies.
• Work with software developers, data analysts, and system administrators to integrate SQL databases with other applications and systems.
• Collaborate with business stakeholders to understand data requirements and provide solutions.
• Document database designs, stored procedures, and other database-related activities.
• Maintain accurate records of database changes, optimizations, and configurations.

Eligibility Criteria:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 3 to 5 years of experience as an SQL Developer or in a similar role.
• Proven experience in database design, development, and management.
• Experience with SQL Server, MySQL, PostgreSQL, or other relational database management systems.
• Proficiency in writing complex SQL queries, stored procedures, functions, and triggers.
• Strong understanding of indexing, query optimization, and performance tuning.
• Familiarity with database security best practices.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Attention to detail and commitment to quality.
• Ability to work independently and in a team environment.
• Experience with cloud-based databases (e.g., AWS RDS, Azure SQL Database).
• Experience with NoSQL databases.

What We Offer:

·        Competitive salary and performance based incentives.

·        Comprehensive benefits package, including health

·        Opportunities for professional growth and career advancement.

·        A collaborative and innovative work environment.

Job Overview: We are seeking a skilled MERN Stack Developer responsible for designing and developing robust and scalable web applications. The ideal candidate will have a strong understanding of the entire web development process (design, development, and deployment) and be proficient in the MERN stack: MongoDB, Express.js, React.js, and Node.js.

Key Responsibilities:

• Full Stack Development: Design, develop, and deploy full-stack web applications using the MERN stack (MongoDB, Express.js, React.js, Node.js).
• API Development: Build RESTful APIs and integrate them with front-end components.
• Database Management: Design, manage, and optimize MongoDB databases for high-performance and scalability.
• UI/UX Collaboration: Work closely with UI/UX designers to implement responsive and user-friendly interfaces.
• Code Quality: Write clean, maintainable, and efficient code, following best practices and coding standards.
• Testing and Debugging: Perform unit testing, debugging, and integration testing to ensure the quality and functionality of the application.
• Version Control: Use Git for version control and collaborate with other developers on code management.
• Continuous Learning: Stay up-to-date with emerging technologies and best practices in web development and apply them to projects.

Required Skills and Qualifications:

• Proficiency in:
• React.js: Strong understanding of React.js and its core principles, including hooks, state management, and component lifecycle.
• Node.js & Express.js: In-depth knowledge of Node.js and Express.js for server-side development.
• MongoDB: Experience with MongoDB for database design, development, and optimization.
• JavaScript/ES6+: Proficiency in modern JavaScript (ES6+) and understanding of asynchronous programming.

The ideal candidate is a highly resourceful and innovative developer with extensive experience in the layout, design, and coding of websites specifically in PHP format. You must also possess a strong knowledge of web application development using PHP programming language and MySQL Server databases. 

Requirement:

·        3-4 years of experience in web applications/full stack development using PHP, Ajax, Linux, MySQL, Apache

·        Good experience with PHP frameworks CodeIgniter (Laravel, symphony etc. would be a plus)

·        Hands on experience with SQL schema design, REST API design, API integrations

·        Working knowledge of cron jobs

·        Familiarity with modern libraries and frameworks. ie: Bootstrap, jQuery, etc

·        Expertise in developing highly scalable and performant web applications.

·        Proficient in debugging and diagnosing production systems

·        Experience in preparing design specifications/documents.

Good to have:

·        Familiar with Payment Gateways/Wallet integrations is a plus.

·        Experience working with JIRA, Bitbucket, Git, etc.

·        Good written and technical communication skills.

·        Working knowledge of WordPress with plug-in development.

Responsibilities:

·        Adhere to best practices in software development on PHP technology.

·        Deliver high-quality, unit-tested code that follows good coding principles.

·        Maintain a positive influence on your associate team members.

·        Excellent communicator and possess the ability to robust articulation.

·        Show high ownership and is self-driven.

·        Provide support on troubleshooting systems when issues are escalated.

·        Help deliver as a team, verifying that completed user stories meet business expectations.