Essential duties and responsibilities include the following.
- Design, create and maintain databases through multiple product lifecycle environments, from development to production systems
- Configure and maintain database servers and processes, monitor system health and performance, to ensure high levels of performance, availability, and security.
- Convert complex business requirements into technical specifcations to build scalable and reliable data solutions
- Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.
- Independently analyse, solve, and correct issues in real time on production, providing problem resolution end-to-end.
- Refine and automate regular processes, track issues, and document changes.
- Develop complex query, performance tuning, stored procedures and triggers, scheduled jobs, schema refinement.
- Flexibility to work after office hours for any production issue or production deployment.
- Perform scheduled maintenance and support release deployment activities after hours.
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
Qualifications include:
- 4+ years of database and backend development experience
- Good understanding of database systems and architectures
- Expertise in writing complex SQL queries and stored procedures
- Hands on experience with RDBMS and NoSQL data stores like MySQL and MongoDB
- Experience working with Python scripting and application development
- Experience working with Cloud applications and data stores like AWS RDS is a plus
- In-depth understanding of data management and ETL processes

About PowerSchool India
About
Connect with the team
Similar jobs
Key Responsibilities
• Analyze and understand business processes and requirements to develop effective technical solutions.
• Assist in the planning, designing, development, of new applications and enhancements to existing applications.
• Collaborate with IT team members, decision makers, systems owners, and end users to define business requirements and systems goals, and identify and resolve business systems issues.
• Prepare functional specification documents in accordance to new business requirements.
• Ensure compatibility and interoperability of business software applications.
• Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.
• Assist in the deployment of new applications and enhancements to existing applications.
• Identify, assess, and recommend software solutions and implementation partners to management.
• Perform cost-benefit and return on investment analyses for proposed systems to aid management in making implementation decisions.
• Participate and sometimes drive IT projects to ensure that system requirements and data engineering needs are addressed throughout the project life cycle.
• Create systems models including integration points, specifications, diagrams, and charts to provide direction to internal stakeholders and third parties.
• Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems.
• Provide orientation and training to end users for all modified and new systems.
Qualifications & Experience
• Minimum Bachelor’s degree in Information Technology, Computer Science, or related field.
• Minimum of 5 years of experience in related fields with 3 to 4 years in systems and/or functional analysis.
• Proven experience in analysing, designing, and implementing information systems.
• Strong understanding of business processes and technical systems.
• Hands-on skills in SQL and databases (e.g. Oracle, SQL Server).
Other Prerequisites
• Excellent problem-solving skills and the ability to work under pressure. • Good project management skills.
• Excellent written and oral communication and interpersonal skills.
• Ability to conduct research into systems issues and products as required.
• Ability to communicate ideas in both technical and user-friendly language.
• Highly self motivated and directed.
• Keen attention to detail.
• Proven analytical and creative problem-solving abilities.
• Strong customer service orientation.
• Experience working in a team-oriented, collaborative environment
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 3 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.
The ideal candidate is a highly resourceful and innovative developer with extensive experience in the Laravel framework. We use GIT for version control and the candidate must have experience in working in a team environment using tools like Github, Gitlab, etc.
- Perform a mix of maintenance, enhancements, and new development as required.
- Work cross-functionally to convert business needs into technical specifications.
- Help with database and backend architecture.
- Create API endpoints
Required Qualifications:
- 2+ years of experience in web development and software design
- Expertise in Laravel Framework, and MySQL databases.
- Working knowledge of GIT and Github.
- Experience with creating REST-based API endpoints
Qualifications and Skills
- Strong knowledge of Core PHP, Shopify, Magento.
- Good knowledge of any PHP framework ( CodeIgniter and CakePHP )
- Hands-on experience one PHP framework
- Good analytical & communication skills.
- Must be proficient in PHP, MySQL, CSS, HTML, Javascript, AJAX, XML
- Should have excellent written communication skills (English)
- Must have the capacity to work independently and also as a part of a team
- Must have dedication and commitment towards work.
| Job Description | Roles and Responsibilities Researching, designing, implementing and managing software programs Testing and evaluating new programs Write high quality source code to program complete applications within deadlines Perform unit and integration testing before launch Working closely with other developers, UX designers, business, Testing Team and systems analysts Find bugs and offer timely solutions Integration of user-facing elements developed by front-end developers Build efficient, testable, and reusable PHP modules Solve complex performance problems and architectural challenges 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 Good understanding of RESTful API development. Good knowledge of TDD (Test Driven Development). Good understanding of jQuery, Bootstrap. Knowledge of OOPS preferred. Develop and deploy new features to facilitate related procedures and tools if necessary |
|---|---|
| Ideal Candidate | Strong knowledge of PHP web frameworks like Laravel, CI, etc Knowledge of programming language such as Python/NodeJs will be preferred Understanding the fully synchronous behavior of PHP Understanding of MVC design patterns Understanding of front-end technologies, such as JavaScript, HTML5, and CSS3 Knowledge of object oriented PHP programming Understanding accessibility and security compliance Strong knowledge of the common PHP or web server exploits and their solutions Understanding fundamental design principles behind a scalable application User authentication and authorization between multiple systems, servers, and environments Integration of multiple data sources and databases into one system Familiarity with limitations of PHP as a platform and its workarounds Creating database schemas that represent and support business processes Familiarity with MySQL/Mongo DB databases and their declarative query languages Proficient understanding of code versioning tools, such as Git Cross-browser/platform experience. Ability to adapt to changing priorities and to thrive in a fast-paced work environment. Good analytical and debugging skills. Team-oriented and Self-motivated. |
- 5 +yrs of ITExperience
- A candidate with strong OOP skills as well as strong web front end skills(HTML, CSS, Javascript, jQuery etc.)and a lot of MySQL/MsSQL exposure and ideally stored procedureGood Experience in Core PHP and any PHP Frameworks (Laravel/Symphony/Zend).
- Experience in AngularJs & AWS is plus
- Experience in PHP & MySQLi, various open source frameworks,
- Strong knowledge in JavaScript, XHTML, CSS, AJAX, SQL,
- Strong Knowledge in Frameworks like Laravel
- Strong skills of APIs Creation & integration
- Knowledge of Cloud Servers like AWS, Digital ocean
- Know how to Secure the PHP Scripts from attacks or injections,










