PHP/MySQL Senior Software Engineer -Experience

About us :

Infosec Ventures incubates and scales cyber security innovators that solve for inefficiencies in cyber security, solve big problems and deliver exceptionally high return on investment for customers. We are on a mission to make the world cyber safe, by protecting systems and the 'human operating system'. Some notable current ventures include humanfirewall.io, emailauth.io, bugsbounty.com, securityrating.com among others. An idea is worth one dollar, it's the execution that adds the zeros at the end of it, to make it a billion dollars!

Job Description :

If you are a software developer, and have hands-on experience with

- Laravel and/or NodeJS

- Angular JS, VUE JS

- Mongo, MySQL

- You have built SaaS products

Roles :

- The person is responsible coding, designing and modifying web applications, from layout to -function and according to a product's specifications.

- Strive to create visually appealing applications that feature user-friendly design and clear navigation.

- Deep expertise and hands on experience with Web Applications and programming languages such as Laravel framework, Laravel 5 Framework, PHP 7, MySQL, HTML, CSS, JavaScript,

- JQuery, Angular JS, Node JS and REST APIs.

• Design, develop and manage data on various open-source SQL databases
• End-to-end performance tuning of Oracle, MariaDB, MySQL, PostgreSQL, and Aurora against very large data sets
• Database cluster connectivity and security
• Conduct database training
• Software installation and configuration
• Database patching and upgrading
• Using monitoring and management tools
• Troubleshoot various issues with other dba’s/developers
• Point of Contact for Vendor escalation
• Point of Contact for professional service to Customers
• Cross-platform migration from Oracle to MySQL/MariaDB/PostgreSQL/Aurora
• Support the creation, maintenance, and implementation of procedures regarding how problems are identified, received, documented, distributed, and corrected
• Ensures project documentation is complete, current, and stored appropriately
• Manages day-to-day project and scope changes
• Communicate and coordinate database changes, backups, and downtime to users
• Identifies potential security issues and recommend strategies to ensure database security
• Research and evaluate new technologies
• Proactively monitor systems for optimum performance and capacity constraints
• Establish standards and best practices for SQL
• Interact with and coach developers in SQL scripting
• Perform database backup and recovery
• Provides 24x7 support for enterprise database systems

• Must provide mentoring and training to other staff members
• Write procedural documentation including requirements for databases
• Develop and coordinate knowledge transfer
• Establishes enterprise-wide uniform infrastructure, including supporting defined departmental content processes and creating guidelines for content deployment
• Interacts with business units to gather, define, and organize the delivery of business solutions Data
• Modeling, design & implementation based on established standards
• Automate manual tasks

• Candidate with a college degree and relevant work experience
• 7+ years of hands-on DBA experience with Oracle, MySQL, MariaDB, and PostgreSQL and supporting tools
• Strong experience with Linux is required, including command-line editors, scripting (shell, Python, Perl, etc.)
• Experience in database performance tuning and strong SQL tuning skills
• Experience in database and cross-platform upgrades required Experience in all aspects of the software development lifecycle including requirements gathering, design, coding, testing and production support
• Must be familiar with RDBMS concepts, practices, and procedures
• Must have knowledge of network connectivity
• Extensive experience with Export/Import, Backup and Recovery
• Extensive experience with Database Replication Master/Slave, Master/Master (BDR)
• Extensive experience with MySQL (MariaDB, Percona) Galera cluster
• Experience with MaxScale
• Proficient in SQL Language
• Knowledge of ServiceNow, or similar Ticket Management Software
• Knowledge of SAN infrastructure including HP and NetApp
• Ability to work on projects at a time
• Knowledge of middle-tier application servers
• Strong troubleshooting and problem resolution skills
• Good knowledge of Data Modeling
• Knowledge of XML and JDBC

• Experience of NoSQL databases (Cassandra, Oracle NoSQL, MongoDB) is a plus
• Certifications on MySQL, PostgreSQL, and Aurora

Skills required:

1. PHP 7.x, MySQL 5.x

2. Must have experience of 5+ years with core OOP

3. Must have experience in MVC framework Laravel ( Must ) , CakePHP (2/3), CodeIgnitor, deep understanding of MVC architectures etc.

4. jQuery, BootStrap, JavaScript, CSS3, HTML5, AngularJS.

5. Must have Version Control knowledge of Git (preferred), SVN.

6. Must have experience in REST, SOAP API creation and integration for mobile applications.

7. Must be good in scalable programmng and coding PSR standards.

Responsibilities:

1. Ability to handle work independently.

2. Ability to work with large database, can create database and optimize.

3. Able to communicate easily with iOS and Andriod teams.

4. Can solve technical issues and have strong debugging skill.

5. Ability to build strong architecture and analytical skills.

6. Know SDLC and Agile development methodology.

7. Can use latest collaboration tools like Jira, BitBucket, Confluence.

8. Must have developed on SaaS base web applications and enterprise applications.

9. Must be knowing about current technology trends.

• 5+ years of software development experience including 4+ years of deep, hands on experience in building highly scalable web-based backend applications using Java and Spring ecosystem
• BE/BTech in Computer Science or a related field or equivalent practical experience
• Great problem-solving skills with solid data structures and algorithms knowledge
• Has extensively used the Spring ecosystem – Spring Boot, REST API Development, ORM tools like Hibernate
• Excellent knowledge of Relational Databases, SQL and ORM technologies (JPA2, Hibernate)
• Profound insight of Java and JEE internals (Class loading, Multi-Threading, Memory Management, Transaction management etc)
• Experience of coaching and mentoring junior developers with good delegation and time-management skills
• Implemented CI/CD in any of the projects done
• Strong understanding of Agile and Lean software development processes and practices
• Excellent knowledge and hands-on experience of Elastic Search
• Has designed relational databases; conversant with SQL
• Knowledge of Jenkins/ Docker and Devops
• Knowledge of Redis or similar technology
• Worked with some or all of these AWS services: EC2; lambda; SQS/SNS; Elastic Search, Transcoder
• Understanding and experience of building services and applications using principles of service-oriented architecture, preferable using REST or SOAP
• Contributed in the creation of end-to-end automation tests (functional or non-functional)
• Worked with WebSocket, Push notifications etc

• Experience in ELK stack
• Knowledge of Video tools like FFMPEG, Wowza / Node Media Streaming
• Understanding of different video formats, streaming, CDN etc
• Understanding of Machine Learning Models, Pipelines etc

• Work closely with the IT team in completing projects
• Troubleshoot and fix any issues relating to PHP programs
• Ensure smooth operations of web processes and infrastructure
• Create scripts to facilitate client systems to meet performance and objectives
• Test and develop software for client applications
• Create documentation for software created
• Utilize source debuggers and write or modify client software
• Produce results effectively and within the deadlines set

• Proven experience as a PHP developer in a competitive environment
• Strong knowledge of PHP coding and web-based applications
• Good understanding of website integration and software creation
• Excellent verbal and written communication skills
• Able to follow clear instructions according to client demands
• Strong analytical and problem-solving skills
• Creative ability to produce effective solutions to client problems
• Good team player that is enthusiastic about delivering results
• Able to work seated in front of a computer screen for long hours at a time

• Write 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

• Expertise in any MVC framework, RDBMS, JSON,PHP and Rest APIs.
• Good understanding of design patterns.
• Should be flexible to work on multiple technologies as per project requirements.
• Candidate should be able to handle given task independently with minimal help.
• He/She should be a team player and be able to complete assign tasks on time.