Lead PostgreSQL Architect - Remote, Performance & Security

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

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.