PHP Developer

• Excellent knowledge of working with PHP Symfony / Laravel / CodeIgniter
• Must possess a strong understanding of Object-Oriented technology
• Knowledge of any PHP CMS or Framework will be a plus – Laravel / Symfony / CodeIgniter, Zend Framework
• Excellent communication (written and oral) and interpersonal skills.
• Work primarily with PHP, object-oriented design, dynamic content retrieval, Unit testing techniques, debugging techniques, HTTP, MySQL and Apache

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.

• Strong proficiency in MySQL database administration, migrations /up-gradation, patching, cloning, capacity planning, designing, and automation of database tasks.
• Good experience with the latest versions of the database
• In-depth experience configuring database replication on multiple versions
• Strong experience in Monitoring, DB Performance Tuning, DB Availability, DR, Security, Storage
• Analyzes and provides recommendations to optimize the database for improved performance, manageability, and scalability
• Expertise in enterprise backups, recovery, and performing point-in-time recovery Experience in deploying and integrating PM tools
• Experience in data partitioning and encryption
• Knowledge of de-facto standards and best practices in MySQL and MongoDB
• Proficient in writing and optimizing SQL statements and Knowledge of MySQL features, such as its event scheduler
• Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc.
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
• Proficient understanding of code versioning tools such as Git / Mercurial / SVN

• Integration of user-facing elements developed by front-end developers
• Build efficient, testable, and reusable PHP modules
• Solve complex performance problems and architectural challenges
• Integration of data storage solutions.
• Maintaining social media and admin panel accounts.

• Strong knowledge of PHP web frameworks.
• Understanding the fully synchronous behavior of PHP
• Understanding of MVC design patterns
• Basic 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 SQL/NoSQL databases and their declarative query languages
• Proficient understanding of code versioning tools, such as Git.
• Website development and API integrations. Database and password security.