Role : PostgreSQL Lead Developer Location : Phoenix, AZ (Remote)
Mandatory Responsibilities
The role requires leading and mentoring a team of PostgreSQL developers. This includes providing technical guidance and ensuring adherence to industry best practices, fostering a collaborative environment, and supporting the professional growth of team members.
The individual will be responsible for designing and implementing efficient data models for the Mid Office application. These models must be crafted with a focus on scalability and optimal performance to meet the evolving needs of the business.
Developing and executing strategies for performance tuning is a key responsibility. This covers query optimisation, index management, and the continuous enhancement of database performance to ensure smooth and efficient operations.
Creating and maintaining data retention and purging policies is essential. The role involves balancing regulatory requirements with the need for optimal system performance, ensuring compliance while maintaining efficiency.
Collaboration with cross-functional teams is required to align database design with application requirements and overall business objectives. Effective communication and teamwork are vital to ensure that database solutions meet stakeholder needs.
Implementing and managing robust database security measures is necessary to ensure data integrity and compliance with industry standards. This includes proactively addressing security concerns and adhering to best practices.
The role includes developing and maintaining comprehensive documentation for database structures, procedures, and best practices. Clear and thorough documentation supports knowledge sharing and continuity within the team.
Regular monitoring of database performance is required, with a proactive approach to identifying and addressing potential issues before they impact operations.
Participation in code reviews is expected, providing constructive feedback to team members to uphold quality standards and encourage continuous improvement.
Staying up-to-date with the latest PostgreSQL features and industry trends is encouraged. The individual should recommend and implement improvements to the database infrastructure as appropriate.
Requirements and Desired Experience
Cloud Security Architect • CA, United States