Database Developer - PostgreSQL

Key Responsibilities

• 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,
  

• 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.