Postgre SQL Developer

Droisys; Phoenix (AZ); On-site; USD 100,000 - 130,000; Full time

Job summary

A technology solutions provider is seeking an experienced Database Administrator with a focus on PostgreSQL. The role involves designing data models, optimizing performance, and ensuring compliance with data policies. Candidates should have significant experience in database administration and development, strong problem-solving skills, and the ability to work effectively with cross-functional teams. This position offers a long-term opportunity with a remote option.

Qualifications

• Minimum of 7 years of database administration experience, 3 years with PostgreSQL.
• Experience in leading and mentoring teams.
• Strong problem-solving skills in fast-paced environments.
• Experience in data modelling and database design within complex, high-transaction environments.
• Proficiency in SQL and PL/pgSQL, along with experience in using database migration tools.
• Knowledge of data retention strategies and compliance requirements relevant to the travel industry.
• Strong problem-solving skills, with the ability to perform effectively under pressure in a fast-paced environment.
• Excellent written and verbal communication skills, capable of explaining complex database concepts to non-technical stakeholders.

Responsibilities

• Design and implement efficient data models for the application.
• Develop strategies for performance tuning and optimization.
• Maintain data retention and purging policies.
• Aligning database design with application requirements and overall business objectives.
• Implementing and managing robust database security measures.
• Developing and maintaining comprehensive documentation for database structures.
• Regular monitoring of database performance to identify and address potential issues.
• Participation in code reviews providing constructive feedback.
• Staying up-to-date with the latest PostgreSQL features and industry trends.

Skills

Database administration

PostgreSQL

Performance tuning

Query optimisation

Data modelling

SQL

PL/pgSQL

Documentation

Tools

Database monitoring tools

Database migration tools

Job description

Here are the job details

Location: Phoenix, AZ (Remote)

Duration: Long Term

Mandatory Responsibilities

• Data Model Design and Implementation
  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
  This covers query optimisation, index management, and the continuous enhancement of database performance to ensure smooth and efficient operations.
• Data Retention and Purging Policies
  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
  Align database design with application requirements and overall business objectives. Effective communication and teamwork are vital to ensure that database solutions meet stakeholder needs.
• Database Security and Compliance
  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.
• Documentation and Maintenance
  Developing and maintaining comprehensive documentation for database structures, procedures, and best practices. Clear and thorough documentation supports knowledge sharing and continuity within the team.
• Database Monitoring and Issue Resolution
  Regular monitoring of database performance is required, with a proactive approach to identifying and addressing potential issues before they impact operations.
• Code Review and Feedback
  Participation in code reviews is expected, providing constructive feedback to team members to uphold quality standards and encourage continuous improvement.
• Continuous Learning and 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

• At least 7 years of experience in database administration and development, with a minimum of 3 years focused specifically on PostgreSQL.
• Proven track record in leading and mentoring database development teams.
• Strong understanding of performance tuning, query optimisation, and indexing strategies.
• Experience in data modelling and database design within complex, high‑transaction environments.
• Familiarity with travel industry data structures and processes is advantageous.
• Proficiency in SQL and PL/pgSQL, along with experience in using database migration tools.
• Knowledge of data retention strategies and compliance requirements relevant to the travel industry.
• Experience with database monitoring tools and conducting performance analysis.
• Strong problem‑solving skills, with the ability to perform effectively under pressure in a fast‑paced environment.
• Excellent written and verbal communication skills, capable of explaining complex database concepts to non‑technical stakeholders.
• Familiarity with Agile methodologies and DevOps practices.
• Experience with cloud‑based database services, particularly AWS RDS for PostgreSQL, is considered a plus.>

Droisys is an equal opportunity employer. We do not discriminate based on race, religion, color, national origin, gender, gender expression, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by law. Droisys believes in diversity, inclusion, and belonging, and we are committed to fostering a diverse work environment.