PHP Developer

JOB DESCRIPTION

1. Proficient in writing and optimizing SQL statements. - Join Queries and Sub Queries.

2. Strong knowledge of Core PHP and web server exploits and their solutions

3. Understanding the fully synchronous behavior of PHP Writing back-end code and building efficient PHP modules.

4. Knowledge of object-oriented PHP programming, and REST API.

5. Must be working on API, AJAX and API-based development knowledge is a must.

6. Troubleshooting application and code issues.

7. On-call support (If required).

Experience as a database administrator is an added advantage :

• Experience in creating, writing, and maintaining database tables, views, indexes, and triggers.

• Ability to write highly complex SQL queries as per client requirements.

• Experience and Knowledge of multiple databases like (Postgres/MySQL).

• Good attitude towards work and flexibility desired.

• Proficient in PostgreSQL database installation, upgrade, patching, maintenance, security, sysadmin functions, and administration

•Experience as DBA in high-load, large-sized production DB.

• Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, slave configurations, replication, etc.

• Must have strong knowledge of Linux operating systems and Knowledge of shell scripting.

• Monitor and optimize PostgreSQL database performance and capacity planning.