Retail & E-Commerce | DBA Admin Postgres

Lisbon - Portugal

Monthly Salary: Not Disclosed

Posted on: 5 hours ago

Vacancies: 1 Vacancy

Job Summary

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 opensource 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.

Remote Work :

Yes

Employment Type :

Full-time

Administer and maintain PostgreSQL databases ensuring optimal performance availability and security across production and non-production environmentsDesign implement and manage database backup and disaster recovery strategies to minimize data loss and downtimeMonitor database performance metrics id...

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 opensource 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 :

Remote Work :

Yes

Employment Type :

Full-time

Key Skills

Apply Now

About Company

Devoteam

Devoteam is a AI-driven tech consulting firm specialised in cloud platforms, cyber, data, and sustainability. Tech native for almost 30 years, Devoteam guides businesses through sustainable digital transformation to deliver value. With over 11,000 tech architects in more than 25 co ... View more

View Profile View Profile

AI AutoApply

Apply to 100+ jobs with one click