PostgreSQL Developer

Job Title: PostgreSQL Developer
Job Location: Phoenix - Arizona
Job Type: Contract

Job Description:

• Leads and mentors a team of PostgreSQL developers providing technical guidance and best practices

• Designs and implements efficient data models for the Mid Office application ensuring scalability and performance

• Develops and implements strategies for performance tuning including query optimization and index management

• Creates and maintains data retention and purging policies balancing regulatory requirements with system performance

• Collaborates with cross functional teams to align database design with application requirements and business needs

• Implements and manages database security measures ensuring data integrity and compliance with industry standards

• Develops and maintains documentation for database structures procedures and best practices

• Monitors database performance and proactively addresses potential issues

• Participates in code reviews and provides constructive feedback to team members

• Stays current with the latest PostgreSQL features and industry trends recommending improvements to our database infrastructure

What we are Looking For

• 7 years of experience in database administration and development with at least 3 years focused on PostgreSQL

• Proven experience leading and mentoring database development teams

• Strong understanding of database performance tuning query optimization and indexing strategies

• Experience with data modeling and database design in complex high transaction environments

• Familiarity with travel industry data structures and processes is a plus

• Proficiency in SQL PL pgSQL and experience with database migration tools

• Knowledge of data retention strategies and compliance requirements in the travel industry

• Experience with database monitoring tools and performance analysis

• Strong problem solving skills and ability to work under pressure in a fast paced environment

• Excellent communication skills both written and verbal with the ability to explain complex database concepts to nontechnical stakeholders

• Familiarity with Agile methodologies and DevOps practices

• Experience with cloud based database services particularly AWS RDS for PostgreSQL is a plus