Database Administrator (DBA) – PostgreSQL

Description

Summary: Seeking a Database Administrator (DBA) – PostgreSQL to maintain, monitor, and optimize database engines, implement operational processes, and collaborate with developers. Highlights: 1. Implement operational processes and recommend improvements 2. Maintain, monitor, and optimize PostgreSQL and other database engines 3. Collaborate with developers on database design and optimization 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! \ Poderá encontrar o anúncio original publicado em: https://www.itjobs.pt/oferta/511736/database\-administrator\-dba\-postgresql