Database Architect - PostgreSQL

Early Applicant

Exp: 5-7 Years

Job Description

Job Description

Should be able to provide advanced expertise in PostgreSQL internals, including storage, indexing, query optimization, and memory management.
Provide expert advice on PostgreSQL architecture, design, and best practices to internal teams and stakeholders.
Oversee the installation, configuration, upgrading, and maintenance of PostgreSQL databases and related applications.
Lead and mentor development and database administration teams in PostgreSQL best practices and advanced features.
Analyse and optimize database performance, including query tuning, indexing strategies, and hardware utilization.
Design and implement high availability and disaster recovery solutions, such as replication, clustering, and failover strategies.
Troubleshoot and resolve complex database issues, ensuring minimal downtime and optimal performance.
Develop and enforce database standards, security policies, and compliance measures.
Create and maintain detailed documentation on PostgreSQL database configurations, procedures, and architectural decisions.
Develop automation scripts and tools to streamline database operations, including backups, maintenance, and monitoring.
Mentor junior database professionals and provide training on advanced PostgreSQL topics.
Stay current with PostgreSQL advancements and incorporate relevant technologies and methodologies to improve database systems.
Actively participate in Postgres communities and forums for the contribution to the Postgres ecosystem.

Skills

Proven experience in designing and managing large-scale PostgreSQL databases.
In-depth knowledge of PostgreSQL architecture, replication, partitioning, and indexing.
Proficiency in SQL and PL/pgSQL programming.
Strong understanding of database performance optimization techniques.
Experience with database monitoring tools (e.g., pgAdmin, Datadog, Nagios).
Familiarity with automation tools (e.g., Ansible, Terraform).
Hands-on in data warehousing and ETL processes.
Knowledge of data security best practices.
Excellent problem-solving and analytical skills.
Strong communication and interpersonal skills.
Experience with cloud database platforms (e.g., AWS RDS, Azure Database for PostgreSQL).
Familiarity with other database technologies (e.g., MySQL, Oracle) and data warehousing solutions.
Knowledge of DevOps practices and CI/CD pipelines.
Experience with automation tools and scripting languages (e.g., Python, Bash, Ansible).

(ref:hirist.tech)