PostgreSQL Database Engineer

Descrição da Vaga

Requisitos

• The right candidate will have extensive experience with PostgreSQL databases, both on-premise and in the cloud
• They will be comfortable working in a highly collaborative, DevOps culture working across the technology organization
• BS degree in Information Systems, Data Engineering, Data Sciences or equivalent
• 3+ years experience with relational database administration
• 3+ years experience administering highly-available PostgreSQL databases
• Proficiency in Linux-based PostgreSQL RDBMS database administration, architecture, concepts, features, and high-availability technologies
• Proficiency in data science principles such as warehousing, business intelligence reporting, and predictive analytics
• Proficiency in query optimization, indexing knowledge, modeling basics, materialized views, triggers, stored procedure development, and partitioning
• Proficiency in SQL and experience in any scripting language (e.g. PowerShell, Bash, Python)
• Proficiency with DevOps, Infrastructure as Code (IaC) strategies, and variable workload (container) orchestration
• Proficiency with ITIL and/or ITSM principles

Responsabilidades

• Responsible for implementing, and maintaining critical database systems (PostgreSQL) which support a growing 24x7 SAAS platform
• Supports the ongoing database ETL, warehousing, reporting and analytical needs of the organization
• Ensures the database design and operations support the availability, scalability, and recoverability needs of the business
• Performs tuning and capacity management to ensure the database meets the performance needs of the business
• Guides and provides direction to developers and engineers on database development, design principles, query optimization, and index management in a fully automated deployment pipeline
• Ensures all infrastructure solutions and operational activities adhere to the security and operating policies established by the organization
• Provides on-call coverage for production support and other duties as required

Benefícios