PostGres database architect

PostGres database architect

Posted Today by 1756880604

Negotiable
Outside
Remote
USA

Summary: The PostGres database architect role involves designing and implementing scalable and secure PostgreSQL database architectures, optimizing performance, and integrating cloud solutions. The position requires expert-level proficiency in PostgreSQL and a strong background in database architecture and optimization. The architect will also advise on cloud adoption strategies and ensure high availability and security of database systems. This role is remote and classified as outside IR35.

Key Responsibilities:

  • Designing and implementing robust, scalable, and secure PostgreSQL database architectures, including schema design, data modeling, and indexing strategies.
  • Identifying and resolving performance bottlenecks, optimizing queries, indexes, and configuration settings.
  • Working with cloud-based PostgreSQL solutions and advising on cloud adoption strategies.

Key Skills:

  • Expert-level proficiency in PostgreSQL and relational database concepts.
  • Strong experience in database architecture, data modeling, indexing, and query optimization.
  • Proficiency in database security, backup and recovery, and high-availability solutions.
  • Experience with cloud platforms and their PostgreSQL offerings.
  • Strong SQL and potentially PL/pgSQL skills.
  • Excellent problem-solving, analytical, and communication skills.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

PostGres database architect

Key Responsibilities:

Database Design and Architecture:

Designing and implementing robust, scalable, and secure PostgreSQL database architectures, including schema design, data modeling, and indexing strategies, to meet business requirements and performance goals.

Performance Optimization:

Identifying and resolving performance bottlenecks, optimizing queries, indexes, and configuration settings to ensure high performance and efficient resource utilization.

Cloud Integration:

Working with cloud-based PostgreSQL solutions (e.g., AWS RDS, Azure Database for PostgreSQL) and advising on cloud adoption strategies.

Required Skills and Qualifications:

Expert-level proficiency in PostgreSQL and relational database concepts.

Strong experience in database architecture, data modeling, indexing, and query optimization.

Proficiency in database security, backup and recovery, and high-availability solutions.

Experience with cloud platforms and their PostgreSQL offerings.

Strong SQL and potentially PL/pgSQL skills.

Excellent problem-solving, analytical, and communication skills.

Thanks,

Akhil,

akhil dot macharla at adventglobal dot com