PHP Developer

Key Responsibilities

Reporting & Analytics Development

• Design, develop, and maintain complex reporting solutions serving mission-critical emergency

response operations

• Build interactive dashboards and data visualizations that transform large datasets into

actionable insights

• Develop advanced analytics features including trend analysis, predictive metrics, and

operational intelligence

• Create self-service reporting capabilities enabling stakeholders to access critical data

independently

• Implement real-time and scheduled reporting systems with appropriate caching and

optimization strategies

SQL & Database Architecture

• Write and optimize complex SQL queries involving multiple joins, subqueries, CTEs, window

functions, and aggregations

• Review existing database architectures and identify performance bottlenecks and optimization

opportunities

• Design and implement database schema enhancements to support evolving reporting

requirements

• Develop and maintain stored procedures, functions, and views optimized for reporting

workloads

• Perform comprehensive query performance analysis and implement tuning strategies across

PostgreSQL and AWS Aurora environments

• Create efficient indexing strategies and data access patterns for large-scale datasets

• Establish data modeling best practices for dimensional and transactional reporting needs

Performance Optimization

• Conduct systematic performance analysis of reporting queries processing millions of records

• Implement query optimization techniques including execution plan analysis, index tuning, and

query refactoring

• Design and implement data aggregation strategies, materialized views, and summary tables for

improved performance

• Monitor and optimize database performance metrics including query response times, resource

utilization, and concurrency

• Develop ETL processes and data pipelines optimized for reporting and analytics workloads

• Implement caching strategies and data archival policies to maintain optimal system

performance

Technical Collaboration

• Partner with Product and stakeholder teams to translate business reporting requirements into

technical solutions

• Conduct code reviews focused on SQL quality, performance, and best practices

• Provide technical guidance to development teams on reporting architecture and database

optimization

• Document database schemas, reporting architectures, and optimization strategies

• Collaborate with DevOps on database infrastructure, monitoring, and scaling initiatives

Required Qualifications

Experience & Background

• 8+ years of software engineering experience with significant focus on reporting, analytics, or

business intelligence

• 5+ years of hands-on experience writing complex SQL in production environments

• 3+ years working with large-scale databases (millions+ records) and optimizing query

performance

• Proven track record developing enterprise reporting solutions and analytics platforms

• Experience conducting database architecture reviews and implementing performance

improvements

Technical Expertise - SQL & Databases

• Expert-level SQL proficiency including complex joins, subqueries, CTEs, window functions, and

advanced aggregations

• Deep PostgreSQL expertise with production experience in query optimization and performance

tuning

• Strong understanding of database internals including execution plans, indexing strategies, and

query optimization

• Experience with AWS Aurora or other cloud-based PostgreSQL solutions

• Proficiency in stored procedures, triggers, functions, and database programming

• Advanced knowledge of database design principles, normalization, and dimensional modeling

• Experience with database performance monitoring and profiling tools

• Strong programming skills in PHP (Yii framework or similar MVC frameworks preferred)

• Solid experience with Vue.js or similar modern JavaScript frameworks for building reporting

interfaces

What You'll Work With

• Databases: PostgreSQL, AWS Aurora, multi-tenant architectures

• Backend: PHP (Yii framework), RESTful APIs

• Frontend: Vue.js (Vue 2/3), modern JavaScript, data visualization libraries

• Infrastructure: AWS (RDS, Aurora, S3, Lambda), Postgres

• Tools: Git/GitHub, JIRA, Agile development workflows

Work Location

Hyderabad, India - On-site position with flexible working arrangements to accommodate both India

and onsite teams

• Understand fundamental design principles and best practices for developing backend servers and web applications  Gather requirements, scope functionality, estimate and translate those requirements into solutions.  
• Implement and integrate software features as per requirements. 
•  Deliver across the entire app life cycle.
•   Work in a product creation project and/or technology project with implementation or integration responsibilities, Improve an existing code base, if required, and ability to read source code to understand data flow and origin
• Design effective data storage for the task at hand and know how to optimize query performance along the way.  
• Follow an agile methodology of development and delivery  
• Strictly adhere to coding standards and internal practices; must be able to conduct review code  Mentor and possibly lead junior developers  
• Contribute towards innovation  Performance optimization of apps 
•  Explain technologies and solutions to technical and non-technical stakeholders  
• Diagnose bugs and other issues in products  
• Continuously discover, evaluate, and implement new technologies to maximize development efficiency

Must have / Good to have:

• 4+ years experience with Core Python development  Design and implementation of high-availability, and performant applications on Unix environment  
• Good with multithreading and data structures  
• Develop back-end components to improve responsiveness and overall performance  
• Familiarity with database design, integration wiht applications and python packaging.  Familiarity with front-end technologies (like JavaScript and HTML5), REST API, security considerations  
• Familiarity with functional testing and deployment automation frameworks  
• Experience in development for 3-4 production ready application using Python as programming language  
• Experience in writing unit test cases including positive and negative test cases 
•  Experience of CI/CD pipeline code deployment (Git, SVN, Jenkins or Teamcity) 
•  Experience with Agile and DevOps methodology 
•  Very good problem-solving skills  
• Experience with Web technologies is a plus  
• Experience with ELK stack is a plus.

Full Stack Developer (Python, Javascript, HTML, API)

Job Overview

The SkillTurk Team is seeking a skilled Full Stack Developer with expertise in Python, JavaScript, HTML, and API functions to join our dynamic team. As a Full Stack Developer, you will be responsible for designing, developing, and maintaining web applications that seamlessly integrate front-end and back-end components. Your role will involve working on server-side development, utilizing your knowledge of Python, JavaScript, HTML, and API integration to deliver robust and scalable solutions.

Responsibilities:

·      Full Stack Development: Design, develop, and deploy feature-rich web applications using Python, JavaScript, HTML, and CSS technologies.

·      Front-end Development: Create responsive and intuitive user interfaces using HTML, CSS, and JavaScript frameworks, ensuring optimal user experience across different devices and browsers.

·      Back-end Development: Develop server-side logic and APIs using Python frameworks such as Django or Flask to enable smooth data flow and interaction between the front-end and the database.

·      API Integration: Understand and integrate third-party APIs and services to enhance the functionality and capabilities of web applications.

·      Database Management: Design and implement efficient database schemas, write optimized SQL queries, and ensure data integrity and security.

·      Testing and Debugging: Conduct rigorous testing and debugging to identify and fix issues, ensuring high-quality and bug-free code.

·      Collaborate with Teams: Work closely with the data engineer and stakeholders to gather requirements, provide technical insights, and ensure seamless integration of front-end and back-end components.

·      Continuous Learning: Stay up to date with industry trends, emerging technologies, and best practices in full stack development, and apply them to enhance the development process and deliver innovative solutions.

·      Troubleshooting and Issue Resolution: Identify and resolve technical issues, performance bottlenecks, and system failures, both during development and in production environments.

·      Code Maintenance and Version Control: Manage code repositories, version control systems (e.g., Git), and documentation to ensure efficient collaboration and codebase integrity.

Requirements:

·      Strong proficiency in Python programming language.

·      Proficiency in client-side web technologies including JavaScript, HTML, and CSS.

·      Experience with server-side frameworks such as Django or Flask.

·      Understanding of API design principles and experience with API integration.

·      Knowledge of database systems, SQL and the ability to write optimized queries.

·      Familiarity with version control systems like Git.

·      Solid understanding of web development principles, including responsive design, cross-browser compatibility, and accessibility.

·      Strong problem-solving and debugging skills.

·      Excellent teamwork and communication abilities.

Preferred Skills (not mandatory but beneficial):

·      Experience with cloud platforms such as AWS or Azure.

·      Understanding of Github deployments.

·      Understanding of security principles and best practices in web development.

If you are a highly motivated individual with a passion for full stack development and possess the required skills, we encourage you to apply for this position. Join our team and contribute to the creation of cutting-edge web applications that deliver seamless user experiences and drive innovation.

You will be a part of a full-stack creative team that is responsible for all aspects of the ongoing software development from the initial specification, through to developing, testing and launching.

• Strong knowledge of PHP, MySQL, JavaScript, jQuery, AJAX, HTML5, CSS3.

• Write clean , well-designed code

• Produce detailed specifications

• Troubleshoot, test and maintain the core product software and databases to ensure strong optimization and functionality

• Contribute in all phases of the development lifecycle

• Follow industry best practices

• Develop and deploy new features to facilitate related procedures and tools if necessary

• Proven software development experience in PHP

• Demonstrable knowledge of web technologies including HTML, CSS, JavaScript, AJAX

• Good knowledge of relational databases, version control tools and of developing RESTful web services

• Web application development experience in HTML5, CSS3, Javascript (including new ES features), Python
• Hands-on experience in any one of the python-based backend frameworks like Django or Flask or Pyramid along with end to end testing
• Hands-on experience in building high performant React applications
• Hands-on experience working with Object Oriented JavaScript (OOJS), JavaScript libraries and their practical uses in building complex interactive experiences
• Hands-on experience working with TDD in JS with the help of frameworks like Mocha, Chai, Jest, Enzyme, React Testing Library etc.
• In depth knowledge of SQL is a must. SQL Technologies that are desired are MySQL, PostGres, Oracle
• Experience in state management libraries like Redux and MobX
• Good understanding of asynchronous request handling, partial page updates, and AJAX
• Familiarity with various component libraries and design systems
• Proficient in using media queries and CSS frameworks like bootstrap or foundation for implementing responsive web design patterns in the applications
• Knowledge of common JavaScript design patterns
• Experience in owning Code Quality and Code Review processes
• Experience on Node.js is an advantage
• Work "in the trenches" with junior developers to implement large features that wow our clients
• Partner with Managers, Business Analysts, and test analysts to develop realistic implementation plans with a focus on quality, sustainability, and delivering value to our clients
• Stand up for coding best practices that ensure quality products: automated testing, unit testing, agile development, continuous integration, code reviews, and technical design
• Improve technical skills of self and the team
• Research industry trends and web technologies, and promote adoption of best-in-class web tools and technologies
• Understand client business issues and actively participate in designing solutions and features that meet client needs
• Take initiative to advance the quality, responsiveness, architecture, or design of our solution, if you want to make it happen you can.
• Excellent organizational and task management skills
• Strong oral and written communication skills
• Ability to work in global cross-office teams
• Fluency in English is required

Job Summary

• BS/BE/BCA/MSC/MCA degree in Computer Science, Engineering or a related subject
• Hands on experience is preferable in designing and developing applications using Java EE platforms
• Object oriented analysis and design using common design patterns.
• Profound insight of Java and J2EE internals
• Excellent knowledge of Relational Databases and SQL
• Experience in developing web applications using at least one popular web framework (JSF, HTML5, MVC)
• Knowledge on Micro services, Containers / Docker would be added advantage.
• Knowledge on data science would be preferred.
• Exposure to building API, rest service and webservices.
• Exposure to open source like Tensor flow, NIFI, Stream pipes etc.,
• Experience with test-driven development
• Good communication skills and client-oriented attitude
• Organized and detail-oriented person
• Problem solving skills, analytical mind and positive attitude
• Results oriented and focused on meeting deliverable timelines
• Availability to travel, if needed
• Fluency in English is a must

Responsibilities and Duties

• Design and develop features and modules for mission-critical applications
• Build modules on MES products like (SAP, Apriso, Rockwell etc.,)
• Contribute in all phases of the development lifecycle
• Write well designed, testable, efficient code
• Ensure designs are in compliance with specifications
• Prepare and produce releases of software components
• Support continuous improvement by investigating alternatives and technologies

Required Experience, Skills and Qualifications

2 - 5 years of hands-on Software Development experience using the below mentioned Technologies

• Java / J2EE
• EJB, JSF, Servlets
• HTML, HTML5
• SQL server / Oracle
• Json, webservice and etc.

Benefits

• Candidate would be Trained on SAP modules.
• Industry best pay.

Job Description

• Hands on Experience of More than ​2+ Years with Core PHP, Laravel, Vue js
• Developing user-facing applications using Vue.js.
• Experience in Datastores like Mysql, Redis.
• Utilize backend data services and contribute to increasing existing data services API.
• IT Service based Projects with international client handling.

Desirable skills:

• Experience in developing the clientside application Vue.js.
• Indepth knowledge of objectoriented PHP and Laravel 5.
• Good knowledge of Cloud computing technologies.
• PHP Framework.
• Handson experience with SQL schema design, SOLID principles, REST API design.
• MySQL query optimization.
• Creative and efficient problem solver.
• Good team player.
• Strong Communication skills.
• Ability to write emails and should be able to chat with the client.
• PM tools knowledge like JIRA, trello, basecamp would be a plus.