Senior PostgreSQL Architect (Database Administrator)

at  Oivan Group Oy

WHAT WE NEED

Oivan is looking for an experienced and highly skilled Senior Database Architect (PostgreSQL, MongoDB) to join our team. We are seeking a highly skilled Senior Database Administrator with at least 5 years of experience providing 24/7 support to critical database environments. This role involves managing PostgreSQL and MongoDB clusters, ensuring high availability, scalability, and performance, while maintaining stringent security standards.
This candidate will work with the engineering and DevOps teams to ensure that the most appropriate and well-designed database environment are drafted and that the appropriate set of architectural and design decisions is made.

WHO WE ARE

At Oivan we create and operate human-centric digital services for our clients worldwide. With offices in Helsinki (Finland), Riyadh (KSA), Khon Kaen (Thailand), Bangkok (Thailand), Dubai (UAE), our international team executes a diverse array of projects. Based in our office located in Riyadh office, you’ll support our 220+ headcount workforce across 5 countries.
Oivan’s official language is English and fluency is necessary for success on the job. A strong dedication to teamwork and excellent cross-cultural communication skills are a must.
Oivan company culture is reflective of our core values: Responsibility, Reliability, and Fellowship. The decisions we make today influence our tomorrow. We are sincere in our responsibility towards our employees, customers and the environment. Fellowship unites us as an international community of thinkers and doers. Throughout our hiring process, you’ll have access to a broad representation of the Oivan team in order to get to know us as we learn about you

In this role, you will have the opportunity to work on various high-level client projects, and you will become one of our Senior Database Administrator matter experts. You will be in charge of the following responsibilities:

• Set up, configure, and manage PostgreSQL and MongoDB clusters, utilizing tools like Patroni for PostgreSQL and MongoDB’s native clustering capabilities.
• Plan and execute the migration of PostgreSQL and MongoDB databases between data centers with minimal downtime and complete data integrity.
• Design and refine the architecture of PostgreSQL and MongoDB databases for optimal performance, scalability, and reliability.
• Identify and resolve performance bottlenecks through configuration tuning, indexing, query optimization, and resource utilization.
• Automate tasks such as backups, monitoring, and deployments with scripting languages like Shell, configuration management tools like Ansible, and CI/CD pipelines integrated with GitHub.
• Apply security measures including access controls, encryption, and auditing to safeguard data. Ensure high availability through replication and failover strategies.
• Implement monitoring systems with tools like Grafana and Prometheus to track database health, detect issues early, and maintain optimal performance.
• Plan and execute database upgrades, apply patches, and ensure compatibility with the latest features.
• Conduct periodic disaster recovery drills to test backup and recovery procedures, ensuring business continuity.
• Respond to change requests and incidents within agreed SLAs, diagnosing and resolving database-related issues promptly.
• Continuously evaluate and enhance the performance, scalability, and reliability of PostgreSQL and MongoDB environments.
• Familiarity with HAProxy, pgBouncer for load balancing and connection pooling, and pgBackRest for backup and restore operations in PostgreSQL environments.
• Effectively communicate with team members, stakeholders, and clients. Contribute positively to team dynamics and foster a collaborative work environment.
• Create comprehensive documentation, including installation guides, configuration manuals, and operational procedures. Prepare presentations and reports to convey technical information and project status to clients and stakeholders.
• Analyze complex database issues, identify root causes, and implement effective solutions while maintaining service levels and minimizing business impact.
• Willingness to adapt to evolving technologies and best practices in the database management field. Stay updated with the latest advancements in PostgreSQL and MongoDB ecosystems.