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
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!
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!