- Collaborate closely with front-end developers to gather and understand their database requirements.

- Design and develop complex and dynamic queries, stored procedures, cursors, Indexes, views, functions,

transactions and triggers to ensure efficient database performance.

- Understanding systems architecture and design and translating into functional applications

- Optimize the performance of stored procedures and SQL queries to handle large datasets within seconds.

- Perform thorough code reviews to maintain high standards of quality and efficiency in database development.

- Monitor and troubleshoot database performance issues, ensuring minimal disruption.

- Identify and implement scalable solutions to handle high workloads and large user bases.

- Provide solutions for existing and new applications by understanding project requirements from inception to implementation and maintenance.

- Performing code reviews, advocating code quality and engineering best practices

- Being involved with R & D, being aware of technology trends and managing a small-sized development team and providing mentorship.

Background and Experience :

- Development and maintenance of complex database solutions using PostgreSQL, ensuring scalability, performance, and maintainability.

- 4+ years of experience working as a Database Developer (PostgreSQL and MS SQL / PL SQL)

- Proven experience with database design, development, optimizing stored procedures, SQL queries and performance tuning in PostgreSQL and database schemas.

- Hands-on experience with indexing, partitioning, and query optimization techniques.

- Familiarity with database monitoring and performance tuning tools.

- Demonstrate expertise in working with data structures such as XML and JSON, implementing efficient data manipulation and storage solutions.

- Knowledge of database security best practices and policies.

- Proficient with Project Management tools like JIRA and Agile methodology.

- Communicate effectively with stakeholders, including designers, product managers, and senior management, to gather requirements and provide project updates.

- Proactively identify technical challenges and propose innovative solutions to address them, leveraging strong problem-solving skills and industry best practices.

Other competencies :

- Problem Solving - Has a solution-oriented mindset, provides effective solutions for key challenges.

- Strategic Thinking - Identifies with the company vision to meet the short, medium, and long-term goals.

- Communication - Able to understand and articulate with clarity, presents well-reasoned arguments.

- Sporting knowledge - Follows or participates in sport in any capacity, is familiar with basic rules, awareness of major sporting events and sports persons.