KWAN

KWAN is a 100% Portuguese company that is part of the Rupeal Group, dedicated to IT Staffing, consulting, and outsourcing. KWAN exists because a developer believed in a different way of recruiting: treating people with the respect they deserve. Our goal is to be your go-to place for career advice and help you reach your dream job.

About company

Database Administrator (DBA) – PostgreSQL

On-site

location Porto

date April 1, 2026

types Full-time

Apply here apply

View all jobs

We are looking for a Database Administrator (DBA) – PostgreSQL to work in Porto who's eager to embark on an exciting new opportunity!

Apply here

https://form.typeform.com/to/PYqxT8NO?opportunity=Filipa%20Almeida&channel=ITJobs

About KWAN

We connect IT professionals with projects that match their skills, professional experience, and goals, then we offer a career progression program, delivered by in-house specialists - our People Experience Partners - to guide them through our journey with us.

What is this challenge about

- Implement operational processes and proactively recommend improvements aligned with database best practices;

- Maintain, monitor, and optimize PostgreSQL and other database engines for performance, reliability, and scalability;

- Plan, implement, and test backup and recovery strategies, including high availability/disaster recovery solutions;

- Monitor database capacity and plan for future hardware or cloud resource needs;

- Ensure database and system-level security, including authentication and access management;

- Collaborate with developers to design and optimize database schemas, indexes, tables, and queries;

- Analyze and resolve slow-running queries or other performance issues;

- Manage deployment of database changes in coordination with application releases and CI/CD pipelines;

- Develop and improve diagnostic, monitoring, and error-prevention processes;

- Participate in project activities related to database administration, upgrades, and migrations;

- Provide support in 24x7 operational on-call rotation.

What we are looking for

- Degree in Information Systems, Computer Science, or related field;

- Hands-on experience with open-source database engines like PostgreSQL (on-premises and cloud); MongoDB is a plus;

- Hands-on experience with enterprise databases like SQL Server and Oracle is a plus;

- Knowledge of database software lifecycle management and related components;

- Experience with backup and recovery (DR/HA) strategies, including RTO/RPO design, high availability, and disaster recovery solutions (e.g., Data Guard, Always On, replication);

- Knowledge in capacity planning, including monitoring disk space, memory, CPU usage, tablespace management, and storage sizing;

- Understanding of system-level security, including OS and network security, instance/user access, and authentication;

- Knowledge of application-level security, including user accounts, roles, privileges, and access control for application components;

- Experience in query analysis, using tools like Explain Plan, AWR, or database-specific profilers to diagnose and optimize slow queries;

- Familiarity with deployment and change management, including CI/CD pipelines for database schema and code updates;

- Experience collaborating with developers and architects on logical and physical database design, including tables, indexes, and views;

- Strong problem-solving skills for troubleshooting operational issues and performing root cause analysis;

- Willingness to participate in 24x7 on-call rotation;

- Experience improving monitoring and error-prevention methods, including automation of diagnostics or corrective actions;

- Fluency in English (minimum B2).

Do you meet most of the position requirements? Then grab this opportunity and apply now!

Apply now!

What we offer

- A project that matches your skills and ambitions, as well as your preferences for working policies and culture;

- A competitive salary with awesome benefits and opportunities to leverage your knowledge and network to earn additional income;

- An empowering and respectful work culture enriched with social and learning events;

- A People Experience Partner specially assigned to you - your go-to career guide, responsible for supporting your growth, facilitating training, and ensuring your work-life balance at KWAN.

Some Words From Our Colleagues

“At KWAN, they make sure that I feel comfortable with the client I’m working for and that what I’m doing aligns with my career aspirations.” - Luis Caldeira, DevOps @ KWAN

Does it sound exciting? Apply now!

Apply now!