DBA Admin – Postgres

This is a fully remote position, open to applicants in Portugal.

📋 Description

• Oversee and manage PostgreSQL databases, ensuring peak performance, availability, and security in both production and non-production settings.

• Develop, implement, and oversee database backup and disaster recovery plans to reduce data loss and minimize downtime.

• Track database performance indicators, identify performance issues, and apply optimization techniques such as query tuning and index management.

• Manage user access controls, database permissions, and security measures to safeguard sensitive retail and customer information.

• Quickly troubleshoot and resolve database-related challenges, performing root cause analysis and taking preventive actions.

• Execute database migrations, upgrades, and patches with minimal disruption to business activities.

• Work in partnership with application development teams to assist in database design and address application-level database concerns.

• Implement and uphold high availability and replication solutions to guarantee business continuity.

• Document database configurations, processes, and runbooks to enhance operational efficiency and facilitate knowledge sharing.

• Keep up-to-date with PostgreSQL updates, security patches, and industry best practices.

⛳️ Requirements

• Bachelor’s degree in Information Systems, Computer Science, or a related field.

• Practical experience with open-source database engines such as PostgreSQL (experience with MongoDB is a plus).

• Experience with enterprise databases such as SQL and Oracle is advantageous.

• Proficient in database engine software lifecycle management and its related components.

• Skilled in Backup and Recovery (DR/HA): Designing, executing, and validating backup and recovery strategies (RTO/RPO), as well as configuring high availability/disaster recovery solutions (e.g., Data Guard, Always On, replication).

• Monitor disk space, memory, and CPU usage while planning for future hardware/cloud resource requirements (e.g., tablespace management, storage sizing).

• Manage database-level user accounts, roles, privileges, and access control for specific application components.

• Utilize specific tools (such as Explain Plan, AWR, or database-specific profilers) to identify slow queries and suggest code-level improvements.

• Oversee the deployment of database schema modifications and code updates in alignment with application releases, often via CI/CD pipelines.

• Collaborate with developers and architects on the logical and physical design of database schemas, tables, indexes, and views to meet application requirements.

• Troubleshoot operational issues and conduct root cause analysis.

• Participate in a 24/7 on-call rotation schedule.

• Enhance methods for monitoring and error prevention (e.g., diagnostic or corrective automation).

• Engage in and contribute to project activities related to this scope.

🏝️ Benefits

• Employees have the option to work remotely.