PostgreSQL Database Developer/Administrator

Job Purpose

We are seeking an experienced PostgreSQL Database Developer/Administrator to join our team. The ideal candidate will have at least 2 years of experience in developing and administering PostgreSQL databases, along with a strong understanding of database design and optimization principles. The successful candidate will be responsible for maintaining, optimizing and supporting our PostgreSQL database systems.

Duties & Responsibilites

  • Design, develop and maintain PostgreSQL databases and related applications
  • Develop and optimize SQL queries and stored procedures
  • Monitor database performance and optimize system performance
  • Ensure database availability, security and reliability
  • Backup and restore databases, and implement disaster recovery plans
  • Troubleshoot and resolve database-related issues
  • Collaborate with developers to design efficient and effective database structures
  • Develop and maintain database documentation and data dictionaries
  • Work with team members to implement best practices and standards for database administration
  • Stay up-to-date with the latest technologies and trends in database development and administration
  • Provide support to users to trouble-shoot and rectified data related issues
  • At least 2 years of experience in developing and administering PostgreSQL databases
  • Understanding of database design principles and optimization techniques
  • Proficiency in SQL and experience with query optimization
  • Familiarity with database backup and recovery procedures
  • Experience with database security and user management
  • Familiarity with database administration tools and utilities
  • Excellent problem-solving and troubleshooting skills
  • Strong communication and interpersonal skills
  • Minimum Diploma in Computer Science, Information Technology, or a related field
Optional Additional Qualifications
  • Experience with other database technologies such as MySQL
  • Experience with Linux/Unix server administration
  • Experience with programming languages such as Python