PostgreSQL Developer

JOB SUMMARY / DESCRIPTIONThe PostgreSQL developer utilizes their extensive knowledge of SQL and PostgreSQL to help design, implement, and maintain ECRS retail solutions. They develop solutions in the form of new structure, triggers, procedures, queries, or indices to support new or improved functionality. They also assist in tuning, backing up, or performing/automating maintenance tasks on the database cluster. Finally, they also act as a resource for other team members needing help efficiently developing applications built on top of PostgreSQL.

RESPONSIBILITIESDesign, implement, and document robust and performant database structure and logic in collaboration with software development and leadership teams.Monitor database performance and fine-tune queries for maximum efficiency.Develop strategies for backing up, upgrading, and recovering databases with minimal downtime.Provide proactive and reactive database support to developers and end users.Help design and implement automated testing and validation for database processes.Troubleshoot and resolve database-related issues.

QUALIFICATIONS5+ years' in-depth experience with the PostgreSQL database management system.Bachelor's degree or Master's degree in Computer Science or other related discipline.Experience creating and maintaining database objects such as triggers, stored procedures, and indices.Experience monitoring the performance of PostgreSQL databases and tuning them for optimum performance and functionality.Experience with large-scale database backup, recovery, security, and integrity within PostgreSQL.Knowledge of Java is a plus.

Key Skills

• SQL
• PostgreSQL