PostgreSQL Developer

JOB SUMMARY / DESCRIPTION

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

RESPONSIBILITIES

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

QUALIFICATIONS

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

ALL APPLICANTS MUST BE AUTHORIZED TO WORK IN THE UNITED STATES.

ABOUT ECRS:

ECRS is a fast-paced, progressive technology company with a wide range of opportunities for quality-oriented, career-minded individuals. Geographically situated in the heart of the Blue Ridge Mountains, ECRS offers the unique opportunity of a high-tech career in a resort college town setting. The ECRS family is made up of energetic, outgoing professionals who love what they do for a living. They are courteous, knowledgeable people who strive for excellence in everything they do. ECRS employees work together in dynamic teams to create, sell, install, and support our best-in-class retail automation solutions.

We believe that acceptance of diversity is a key reason as to why we're successful. All qualified applicants who can demonstrate integrity and competence will receive consideration for employment and advancement without regard to race, color, religion, gender, sexual orientation, disability, age, political affiliation, or national origin.