Database Developer - PostgreSQL (7-11 yrs)

Position : DB Design &Developer::

1. Strong development knowledge in DB Design & development with 6+ Years' to 10 Years experience (Postgres DB) - Mandatory

2. Strong hands on writing complex PGSQL, procedure and Functions & prevent blocking and Deadlocks

3. Conduct SQL objects code review & Performance tuning( Mandatory )

4. having hands on Microsoft SQL and MYSQL DB is an advantage.

5. Strong knowledge in RDBMS and NoSQL Concept with strong logical thinking and solutions (Highly required)

6. Expert in transaction databases (OLTP) and ACID property with handling large scale application databases(Mandatory)

8. Consult application developer to provide suggestion / SQL's / PGSQL's on DB with best solutions

9. Good Communications and written skills

Roles and Responsibilities :

Database Design & Development :

- Design and develop efficient database schemas using PostgreSQL.

- Create, optimize, and maintain complex queries, functions, procedures, and views.

- Ensure database design aligns with best practices for scalability and performance.

Performance Tuning & Optimization :

- Conduct code reviews for SQL objects to ensure optimal performance.

- Identify and resolve performance bottlenecks, optimize indexes, and enhance query efficiency.

- Monitor and troubleshoot database performance, ensuring minimal downtime and high availability.