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.

• PHP / Laravel developer duties and responsibilities

• Develop, record and maintain cutting edge web-based PHP applications on portal plus premium service platforms

• Build innovative, state-of-the-art applications and collaborate with the User Experience (UX) team

• Ensure HTML, CSS, and shared JavaScript is valid and consistent across applications

• Prepare and maintain all applications utilizing standard development tools

• Utilize backend data services and contribute to increase existing data services API

• In depth knowledge of object-oriented PHP and Laravel 5 PHP Framework

• Hands on experience with SQL schema design, SOLID principles, REST API design

• MySQL profiling and query optimization

Job description

Strong experience with Laravel Framework

Experience in databases like MySQL

Experience in HTML, JavaScript, CSS, Angular/ReactJS/VUEJS, JQuery, Bootstrap, JSON

Requirement

Minimum 3+ years of Laravel Experience - building database-driven applications

Knowledge of Event Driven Architecture, Microservices, etc

Basic knowledge of Dev-ops - AWS, Github- Familiarity

• Coding and creating functional web applications and optimizing code for increasing response time and efficiency.
• Coordinating with front-end developers and providing server-side algorithms of user-facing web application elements.
• Analyzing the goals and requirements, handling bugs and errors and providing solutions for the same.
• Interacting with the database for storing data and ensuring that every user has access to what they search.

• Accomplishing the projects and goals within the deadline.
• Managing APIs that are executed across the devices.
• Participating in defining the architecture of the system.

Required skills

• Proven knowledge of front-end technologies, such as Angular, React, HTML, CSS, and JavaScript will be preferred.
• In-depth knowledge of PHP and related frameworks. Knowledge of Ruby, Python, NodeJs, and Java will be an added advantage.
• Good Communication, Analytical, Logical, and Leadership skills.
• Knowledge of front-end technologies such as Angular, React, HTML, CSS, and JavaScript will be preferred.
• Ability to manage a hosting environment along with database administration such as MySQL, Oracle.
• Excellent knowledge of APIs (REST, SOAP) and Web services.
• Capable of scaling applications to handle the load changes.
• Knowledge of version control, such as GIT.
• Knowledge of accessibility and security compliance.

Location – Pune, Gandhinagar (Currently Work from Home till 2022)

Educational Qualification - B.E / B.Tech, MCA, M.Tech, or any equivalent IT graduation or post-graduation

• J2EE - Sprint Boot Microservices.
• At least 8+ years of experience in Java development (J2EE, J2SE 8).
• Extensive experience with Spring, Spring Boot Micro Services, JPA, Hibernate.
• Extensive experience in REST and SOAP Webservices Services.
• Excellent knowledge of databases( PostgreSQL, MySQL).
• Experience in testing tools (JUnit, SOAP UI, Postman).
• Experience in build tools – Maven, Gradle. Knowledge of modern authorization mechanisms, such as JSON Web Token.
• Experience in web application servers - Tomcat, etc.
• Understanding of Agile Development methodology – SCRUM.
• Understanding of continuous integration - Jenkins, and Code versioning tools- Git