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.

We are looking for a PHP Developer to help us go global by building a world-class product.

spynPRO is a SAAS product for academy owners, event organizers and facility owners to manage and grow their business.
We are a small but growing team of 9 that is changing the way academies teach their students, organizers manage events and facilities manage slot booking. Take your career to the next level with us.

About our Engineering Department

We build new features on top of a stack using YII2 framework, consisting of web apps communicating through APIs, backed by MySQL databases and currently using Cordova for our Android and iOS apps
We don’t follow rigid Scrum or Kanban, but we do work in an agile, iterative way – we deploy changes multiple times a week to production and try to continuously improve and implement what works for us.

Here are some things you’ll be doing in the role (but not limited to):

Writing code, code reviews, fixing bugs, optimising server response, etc.
Understanding the problems to be solved, and breaking these down into small, actionable tasks.
Learning and helping others

So, what are we specifically looking for?

About 1-4 years experience in PHP framework, including both successes and failures, which help you make better decisions.
Good working knowledge of PHP MVC Frameworks, MySQL & HTML/CSS.
Significant experience in working on major systems in one or more languages: ideally you’ve built REST API endpoints on top of data storage layers, and understand concepts like authentication, caching, web security, and the way that frontends consume APIs.

What are we currently working on?

1. Developing a new webapp Workpod in Yii2 framework
2. Adding new features to existing product spyn
3. Developing cordova apps for above 2 products

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:

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

Position Overview

Oracle Apex Engineer with good experience building reports using the latest versions of Oracle Apex

and experience in Apex Upgrade. Should have a good working knowledge of Oracle

Applications(R12).

Skills

1-2 end to end implementation/development project

Strong detail, quality, and solution orientation

5+ years of experience designing and implementing technical solutions that are aligned with

business strategy

5 years of applications development experience with Oracle APEX, Oracle SQL, PL/SQL

5+ years of Oracle APEX experience

5+ years experience in Oracle Databases

5+ years experience using PL/SQL

5+ years of JavaScript, HTML, CSS, and REST services

Oracle APEX 4.2 experience is a must and ability to Upgrade to higher versions

Ability to work on SQL performance issues

Ability to think critically and solve complex issues

Ability to work independently, while engaging the customer and providing information to the team

Strong ability to communicate both verbally and in writing with internal and external teams

Ability to prioritize across multiple projects and meet deadlines

Experience adapting in a dynamic work environment

Experience working in a customer-focused environment

Ability to troubleshooting issue

Proficiency in analysis, design, development, testing, implementation, and maintenance of

applications in Oracle Application Express (APEX).

Excellent conceptual knowledge of Oracle 11g.

Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions,

packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor,

Dynamic SQL.

Good knowledge of using PL/SQL Wrappers to protect the PL/SQL procedures and packages.

Requirement:

• Min 2-3 Year Experience. Preferably in the E-commerce domain. 
• Proficient with both MySQL and NoSql Databases (Elastic, Mongo)
• Strong hold on PHP and preferably good knowledge of Python
• Experience with JavaScript/JQuery
• Ability to do software design for a enterprise web application
• Working knowledge of a MVC front-end framework
• Proficient in HTTP protocol, REST APIs, JSON
• Ability to do database design and modeling
• Proficient in OOPS concepts and writing code using classes
• Ability to write modular and clean code

Role:

• Software Development of various product line 
• Creation web-services and optimization for existing and new feature rollouts
• Collaborate with Product Managers and design solutions 
• Develop very high sense of ownership, the zeal to build scalable applications
• Build customer facing technology product 
• Individual Contributor