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
Good understanding and experience of HTML / CSS / JavaScript.
Hands-on experience with ES6 / ES7 / ES8 features.
Thorough understanding of the Request Lifecycle (including Event Queue, Event Loop,
Worker Threads, etc).
Familiarity with security principles including SSL protocols, data encryption, XSS, CSRF.
Expertise in Web Services / REST APIs will be beneficial.
Proficiency in Linux and deployment on Linux are valuable.
Knowledge about ORM like Sequelize and ODM like Mongoose and the ability to handle
DB transactions is a necessity.
Experience with Angular JS / React JS will be an added advantage.
Expertise with RDBMS like MySQL / PostgreSQL will be a plus.
Knowledge of AWS services like S3, EC2 will be helpful.
Understanding of Agile and CI/CD will be of value.


What You’ll Do:
- Work closely with the core team to understand their needs and ensure that our products are meeting the needs of the market.
- Designing database structure that are easy to maintain, improves data consistency and are cost effective in terms of disk storage space
- Identify, prioritise and execute tasks in the software development life cycle
- Develop tools and applications by producing clean, efficient code
- Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code
- Build efficient, testable, and reusable PHP modules
What You’ll Bring
- Bachelor's in Computer Science, Software Engineering or a related field.
- A 5+ years of experience in developing desktop and mobile web applications
- Strong knowledge of core PHP with experience of working with MVC framework such as CodeIgniter & Laravel
- Experience with object-oriented PHP programming
- Experience with third party API integration
- Experience in managing AWS services
- Previous experience creating scalable applications
- Knowledge of multiple front-end languages and libraries (e.g. HTML/ CSS, JavaScript, XML, jQuery)


Requirements
• Extensive and expert programming experience in at least one general programming language (e. g. Java, C, C++) & tech stack to write maintainable, scalable, unit-tested code.
• Experience with multi-threading and concurrency programming.
• Extensive experience in object oriented design skills, knowledge of design patterns, and a huge passion and ability to design intuitive modules and class-level interfaces.
• Excellent coding skills - should be able to convert design into code fluently.
• Knowledge of Test Driven Development.
• Good understanding of databases (e. g. MySQL) and NoSQL (e. g. HBase, Elasticsearch, Aerospike etc).
• 4+ years of experience in the art of writing code and solving problems on a large scale.
• Open communicator who shares thoughts and opinions frequently, listens intently, and takes constructive feedback.


Must know MySQL & PostgreSQL
- Good Knowledge of HTML, PHP Frameworks (like CI, Laravel, YII), Core PHP, JavaScript and CSS coding.
- Knowledge of Bitbucket/GitHub.
- Strong hands-on Bootstrap.
- Knowledge of databases and database concepts.
- Strong knowledge of Laravel/ CodeIgniter and its extensive feature set.
- Working Knowledge of e-commerce frameworks like OpenCart, WordPress, cs-cart, and Magento.
- Working knowledge of API for Mobile Applications
- Experience in Cache, and search plugins in terms of optimization
- Developing plug-ins/add-ons in PHP for various CMS solutions.
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.

1. 6 months to 4 years hands on experience of PHP Laravel framework.
2. Candidates from Gujarat can apply.
3. Candidates can also apply if willing to relocate.
4. 5 days working from office only.
We are looking for a Java and Oracle SQL developer with experience in building high-performing, scalable, enterprisegrade applications. You will be part of a PwC utility team and will work on critical applications. Candidate roles and
responsibilities include managing Java/Java EE application development and SQL codes, while providing expertise in the
full software development lifecycle, from concept and design to testing.
Candidate responsibilities include designing, developing and delivering high-volume, low-latency applications.
Responsibilities
• Contribute in all phases of the development lifecycle
• Write well designed, testable, efficient code
• Direct dealing with client and understand their requirements
• Ensure designs are in compliance with client requirement and specifications
• Prepare and produce releases of software components
• Prepare report and presentation based on client requirement
Requirements
• B.E./B.Tech.
• Three years of experience after B.E./B.Tech.
• Proven hands-on Software Development experience
• Proven working experience in Java development
• Hands on experience in designing and developing applications using Java EE platforms
• Excellent knowledge of Relational Databases, Oracle SQL, PL/SQL and query development including server
maintenance
• Experience in developing reports by extracting data from database
• Experience in MS Excel, Word and Power Point
• Experience with test-driven development
• Experience in Power Utility (Discom) domain and Power BI will be preferred

- 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,


