eCommerce Senior Software Engineer

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.

Candidate Profile:

• Strong understanding of PHP and Laravel Framework.
• Produce high quality code and experience with security implementations Identifying application security risks and Implementing security patches procedures.
• Strong hold on MySQL and experience on other SQL/No SQL databases.
• Hands on experience in Architecture and Design with experience in UML and Work-flow diagrams.
• Good knowledge on coding standards, unit testing.
• Strong hold on Data Structures and Algorithms.
• Expertise in building scalable & reliable systems.
• Good Experience in working with technologies like AWS.
• Strong problem solving and analytical skills.
• Able to architect large software from scratch.
• Team building and resource allocation.
• Should be able to work with the management to identify and address any issues that may impact the project.

Key Responsibilities:

• Rewrite existing APIs in NodeJS.
• Remodel the APIs into Micro services-based architecture.
• Implement a caching layer wherever possible.
• Optimize the API for high performance and scalability.
• Write unit tests for API Testing.
• Automate the code testing and deployment process.

Skills Required:

1. At least 3 years of experience developing Backends using NodeJS — should be well versed with its asynchronous nature & event loop, and know its quirks and workarounds.
2. Excellent hands-on experience using MySQL or any other SQL Database.
3. Good knowledge of MongoDB or any other NoSQL Database.
4. Good knowledge of Redis, its data types, and their use cases.
5. Experience with graph-based databases like GraphQL and Neo4j.
6. Experience developing and deploying REST APIs.
7. Good knowledge of Unit Testing and available Test Frameworks.
8. Good understanding of advanced JS libraries and frameworks.
9. Experience with Web sockets, Service Workers, and Web Push Notifications.
10. Familiar with NodeJS profiling tools.
11. Proficient understanding of code versioning tools such as Git.
12. Good knowledge of creating and maintaining DevOps infrastructure on cloud platforms.
13. Should be a fast learner and a go-getter — without any fear of trying out new things Preferences.
14. Experience building a large scale social or location-based app.

We are looking for a skilled and experienced Node.js Developer with at least 4 years of professional experience to join our team. As a Node.js Developer, you will be responsible for developing robust and scalable web applications using JavaScript and various frameworks.

Roles and Responsibilities

• Production platform hands-on experience involving Node JS & REST API.

• Hands-on production platform experience working with micro-service back-end architecture.

• Working knowledge of GRPC, HTTPS, and GRAPHQ protocols.

• Well-versed in cloud deployment of code blocks.

• Experience with JS testing and code analysis frameworks such as Mocha.

• Utilize modern JavaScript frameworks such as Express.js and Sails.js to build efficient and scalable applications.

• Work with databases like MongoDB and PostgreSQL using Mongoose and Sequelize ORM.

• Integrate messaging systems like Kafka and RabbitMQ for reliable event-driven communication.

• Write unit tests using Mocha, Chai, and Jest frameworks to ensure code quality and reliability.

• Utilize AWS S3 bucket for secure and scalable storage of data and media files.

• Collaborate with QA engineers to perform thorough testing and bug fixes.

• Work with third-party APIs such as Postman, Twilio, SendGrid, Firebase, and KeyCloak for various integrations.

• Design and develop innovative, company impacting products and services to support infrastructure operations
• Design, develop and implement object-oriented PHP applications from prototype through implementation
• Integrate open source and commercial enterprise applications into an exposed API and web-based portal
• Create highly scalable and performant REST/SOAP web services
• Keep focus on end users and goals all through the development process
• Work closely with product management and stakeholders to ensure applications meet needs and expectations
• Adhere to the highest levels of technical discipline and excellence to set a standard for the larger development organization

Requirements

• Bachelor's Degree in Computer Science, related field, or comparable extra work experience
• Solid experience with SQL and relation databases
• Solid experience with Object Oriented Design and Development
• Experience Developing API Interfaces
• Experience with version control systems, preferably Git

Beneficial Skills

• Experience with non-relational data stores such as ZooKeeper or Memcache