Job Title: PostgreSQL Database Developer Job Summary: We are seeking an experienced PostgreSQL Database Developer to join our team. The ideal candidate will have at least 3 years of relevant experience in developing 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.
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
- Stay up-to-date with the latest technologies and trends in database development
Requirements: - Minimum Diploma in Computer Science, Information Technology, or a related field
- At least 3 years of relevant experience in developing 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 tools and utilities
- Excellent problem-solving and troubleshooting skills
- Strong communication and interpersonal skills
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
- Experience with programming languages such as Python
