PostgreSQL Database Developer/Administrator

Responsibilities: 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 Requirements: At least 2 years of experience in developing and administering PostgreSQL databases Strong understanding of database design principles and optimization techniques Proficiency in SQL and experience with query optimization Familiarity with backup and recovery strategies, and disaster recovery planning Knowledge of performance tuning and optimization techniques 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 Preferred qualifications: Experience with other database technologies such as MySQL Experience with cloud-based database platforms such as Amazon RDS or Azure Experience with Linux/Unix server administration Experience with programming languages such as Python