Senior PostgreSQL Architect

**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 is an on-site position working at the clients’ site and with our team members.**

**What You'll Do**:
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 mínimal 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.
- Implement monitoring systems with tools like Grafana and Prometheus to track database health, detect issues early, and maintain optimal performance.
- 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.

**What You Have**:
- Minimum of 5 years of experience in 24/7 support for critical database environments.
- Strong knowledge of PostgreSQL and MongoDB cluster management.
- Proficiency in scripting languages and automation tools.
- Excellent communication skills in English.
- Experience in planning and executing database migrations with mínimal downtime.
- Strong problem-solving skills and the ability to work under pressure.
- Experience with advanced monitoring tools and high-availability solutions.

**What We Offer**:

- An international workforce to learn from and grow with - we have a diverse, multicultural workforce with Nordic values
- A fair compensation package and a considerable annual leave of 25 days per annum. We support our staff to be with family at the most important time. Partners with a newborn baby can have additional holidays.
- Opportunities for growth and enrichment through Grow with Oivan, our internal learning and development departments
- Line devices Mac or PC within a fixed company budget
- Team building activities, movie nights, events

**Oivan as an Equal Opportunity Employer**

(GDPR statement)

**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 pr