Pimcore/PHP Developer

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.

Senior Node JS developer

Job Description

- Working experience in Nodejs, MySQL, Postgres SQL

- Good knowledge of designing and writing restful API

- Working experience of GIT

- Will prefer candidates who have knowledge of GraphQL, Typescript

 - Well-versed and experienced with unit testing, code coverage.

- Well versed with SOILD design principles and their application

- Knowledge of AuthO, typeORM required

- Good to have – some experience with Azure DevOps and/or azure functions.

-Working experience on Docker- good to have

Architectural:

Design and implement a software architecture

Select a technology stack

Design and configure infrastructure

Select a development toolkit (IDE, etc.)

Design and implement a database design

Improve and optimise the application architecture

Ensure scalability of the application

Ensure scalability of the infrastructure

Explore new technologies and decide whether to implement them

Strategy, planning, and design:

• Take end-to-end ownership of the product, identify technology requirements, define the future product vision, create preliminary design concepts for add-on modules and shape overall technology and product roadmap by collaborating with the founders, business development, and marketing team.
• Ensure user oriented design is the primary approach to product development across multiple screens, based on user behaviour data and direct customer feedback.

Implementation and deployment:

• Manage Product Release, QA cycles, feature implementation and on time delivery through in-house team and vendors.
• Collaborate with team and customers to define use cases.
• Creation of wireframes/prototypes, site maps and user-flows for web and mobile platforms.

Operational management :

• Support marketing by implementing technical requirements for SEO/product analytics.
• Establish and supervise a quality assurance process, including integration & system testing.
• Rigorously monitor key performance metrics and coordinate with various teams to take corrective actions if needed.
• Establish and forecast ROI of features and succinctly articulate competitive advantage.
• Set-up data collection and analysis system in collaboration with CEO to track key performance.

metrics.

Strong fundamentals in computer science/engineering and algorithm design.

Practical knowledge of computer software algorithms in machine/deep learning, NLP, Computer Vision etc.

Personal Requirements:

• Min of 7+ years of Hands on experience in Web app development, payment gateways implementation, architecture design, product management, databases and UI/UX in consumer facing applications.
• Experience on projects involving engineering and algorithmic functions, machine learning, deep learning and artificial intelligence is very advantageous.
• Creative self-starter who is comfortable with both taking initiative and working in teams.
• Strong communication skills.
• Willingness to learn and utilise emerging technologies.
• Sincere passion to use disruptive technologies that can be globally significant

• Build robust & scalable web applications
• Participate in product design, development, verification, troubleshooting & delivery of web applications.
• Design and create relational database schema & application framework as needed
• Work with a worldwide team to integrate the product to meet the requirement

Required Qualifications:

• Degree in Computer Science from a top-tier institution
• Relevant full-time work experience of 4-8 years
• Strong foundation in computer science, with solid competencies in object-oriented software design patterns, software QA methodologies, processes, and test automation.
• Ability to self-teach.

Mandatory Technical Skills:

• PHP, Javascript/AJAX, SOAP/REST, GIT
• MySQL/NoSQL
• Linux
• Software development life cycle (SDLC)

Desirable Technical Skills:

• Linux scripting

• Support existing code of PHP webserver
• Proficient in PHP, JavaScript, jQuery, HTML, and MySQL
• Hands-on any PHP-based framework/CMS like Laravel, CakePHP, Zend, CodeIgnitor, Yii.
• Must write efficient code with documentation.
• Any Database: MySQL, MongoDB, NoSQL DBs, postgresql.
• Has experience debugging code.
• Analysis of current DB structure and change table structures as and when required
• Implementation of visual representation of DB data in the form of charts and graphs
• The eventual implementation of a new UI theme with customizations such as drop-down menu data, as well as linking the UI theme front-end with the back-end MySQL
• Implementation of new PHP web services for functions such as analytics, and new modules to existing services
• Ensure cross-platform compatibility of information retrieved from web services on
• Android and iOS platforms, in terms of Push Notifications, platform-specific issues, etc.
• Implementation of SSL security to all web services, logins, and API calls
• Familiar with XMPP would be a plus point.