Job Description
- Database Design & Development:
- Design, implement, and maintain PostgreSQL databases.
- Develop efficient schemas, indexes, and stored procedures to optimize data performance.
- Backend Development:
- Develop RESTful APIs and backend services using Node.js.
- Integrate databases with backend applications for seamless data flow.
- Query Optimization & Performance Tuning:
- Optimize SQL queries for performance and scalability.
- Monitor database health and troubleshoot slow queries or deadlocks.
- Security & Compliance:
- Implement database security best practices, including role-based access control (RBAC) and encryption.
- Ensure compliance with industry standards like GDPR, HIPAA, etc.
- Data Migration & Backup:
- Develop and maintain data migration scripts between different PostgreSQL versions or other databases like mongodb.
- Set up and manage database backup and recovery strategies.
- Write efficient SQL queries and manage database schemas using PostgreSQL.
- Build RESTful APIs and integrate third-party APIs/services.
- Optimize application performance and troubleshoot production issues.
- Ensure data security and protection practices are followed.
- Write clean, maintainable code and participate in code reviews.
Skills:- NodeJS (Node.js), MongoDB and PostgreSQL
