Retail & E-Commerce | DBA Admin - Postgres

Devoteam; Lisboa; Presencial; EUR 45 000 - 62 000; Tempo integral

Resumo da oferta

Devoteam is seeking a Database Administrator to manage PostgreSQL databases across production and non-production environments. You will design backup and disaster recovery strategies, monitor performance, and tune queries for optimal efficiency. The role requires collaboration with development teams to support application releases and ensure high availability, with on-call rotation.

Qualificações

• Degree in Information Systems/Computer Science or related field.
• Hands-on experience with PostgreSQL and other open-source engines (MongoDB a plus).
• Experience with enterprise databases like SQL Server and Oracle is advantageous.
• Knowledge of backup and recovery design, DR/HA strategies, and high availability solutions.
• Ability to monitor and optimize DB performance (disk, memory, CPU) and tune queries.

Responsabilidades

• Administer and maintain PostgreSQL databases in production and non-production environments.
• Design and implement backup and disaster recovery strategies to minimize downtime and data loss.
• Monitor performance, identify bottlenecks, and optimize queries and indexing.
• Manage users, roles, and access control to protect data.
• Troubleshoot DB issues, perform root-cause analysis, and apply fixes.
• Coordinate with development teams for schema changes and application releases.
• Ensure high availability and replication to support business continuity.
• Document configurations, runbooks, and procedures for operations.
• Stay updated on PostgreSQL security patches and best practices.

Conhecimentos

PostgreSQL

MongoDB

SQL databases

Oracle

DB lifecycle management

Backup & DR/HA

Performance monitoring

Access control

Explain Plan

AWR

CI/CD for DBs

Collaboration with devs

On-call rotation

Monitoring & automation

Project participation

Formação académica

Bachelor's degree in Information Systems/Computer Science

Ferramentas

Data Guard

Always On

CI/CD tooling

Explain Plan tooling

DB profiling tools

Descrição da oferta de emprego

At Devoteam, we believe that technology with strong human values can actively drive change for the better. Discover how Tech for People unlocks the future, creating a positive impact on the people and the world around us. We are a global leading player in Digital Transformation for leading organisations across EMEA, with a revenue of €1B. We believe in transforming technology to create value for our clients, partners and employees in a world where technology is developed for people. We are proud of the culture we have built together. We are proud of our people at the service of technology. We are proud of our diverse environment. Because we are #TechforPeople. Join our multidisciplinary team of Cloud experts, Designers, Business consultants, Security experts, Engineers, Developers and other extraordinary talents, spread across more than 20 EMEA countries. Become one of our +10.000 tech and business leaders on cloud, data and cyber security. Let’s fuse creativity with technology together and build innovative solutions that actively change things for the better.

Job Description

• Administer and maintain PostgreSQL databases, ensuring optimal performance, availability, and security across production and non-production environments
• Design, implement, and manage database backup and disaster recovery strategies to minimize data loss and downtime
• Monitor database performance metrics, identify bottlenecks, and implement optimization solutions including query tuning and index management
• Manage user access controls, database permissions, and security protocols to protect sensitive retail and customer data
• Troubleshoot and resolve database-related issues promptly, conducting root cause analysis and implementing preventive measures
• Perform database migrations, upgrades, and patches with minimal impact to business operations
• Collaborate with application development teams to support database design and troubleshoot application-level database issues
• Implement and maintain high availability and replication solutions to ensure business continuity
• Document database configurations, procedures, and runbooks to support operational efficiency and knowledge transfer
• Stay current with PostgreSQL updates, security patches, and industry best practices

Qualifications

• Degree in Information Systems/Computer Science or related;
• Hands‑on experience with open‑source engines like Postgres (Mongo is a plus);
• Hands‑on experience with Enterprise databases like SQL and Oracle is a plus;
• Database engines software lifecycle management and related components;
• Backup and Recovery (DR/HA): Designing, implementing and testing backup and recovery strategies (RTO/RPO), and configuring high availability/disaster recovery solutions (e.g., Data Guard, Always On, replication)
• Monitoring disk space, memory, and CPU usage, and planning for future hardware/cloud resource needs (e.g., tablespace management, storage sizing).
• Managing database‑level user accounts, roles, privileges, and access control for specific application components.
• Using specific tools (like Explain Plan, AWR, or database‑specific profilers) to diagnose slow queries and propose code‑level fixes.
• Managing the deployment of database schema changes and code updates alongside application releases, often through CI/CD pipelines; Collaborating with developers and architects on the logical and physical design of database schemas, tables, indexes, and views to support application needs.
• Troubleshooting operational problems and root cause analysis;
• Participating in 24x7 on‑call rotation plan;
• Improving methods for monitoring and error‑prevention (e.g., diagnostic or corrective automation);
• Participate and develop project activities related to this scope.

Additional Information

The Devoteam Group works for equal opportunities, promoting its employees based on merit and actively fights against all forms of discrimination. We are convinced that diversity contributes to the creativity, dynamism and excellence of our organization. All of our vacancies are open to people with disabilities.