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 3 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.
This is an on-site position working at the clients’ site and with our team members.
Please note: For this project we are currently looking for Saudi nationals only.
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 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.
What You Have
Our ideal candidate will fulfill the following requirements:
- Strong PostgreSQL DBA experience and skills and the technical ability to
assist, take over, and even manage very in-depth escalated PostgreSQL
DB support tickets - Hands-on operational expertise as a PostgreSQL DBA on Account
administration, Always ON, Replication, Log shipping, clustering, backups
and recovery, audit reporting, Performance tuning as well as proactive
environment health checks - PostgreSQL Cluster environments experience: Installations, High
Availability, Load Balancing, Replication, Clustering, and Connection
Pooling , Replication and Failover - Hands-On experience finetuning PostgreSQL performance for scalable
PostgreSQL database cluster - Strong experience in automating regular work using TSQL, PowerShell
etc - Must have hands on experience and sound knowledge in cloud
technologies and SQL architecture/HADR setups - Active learner passionate about new technologies to meet technical
requirements and keep up with industry trends and innovations - Strong problem-solving skills to conceptualize and analyze complex
technical issues - Skilled at working effectively with cross functional teams in an agile
organization - Excellent written and verbal communication skills for internal alignment
and external presentations.
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 EmployerAt Oivan,
we appreciate different lifestyles and cultural backgrounds. We welcome diversity as a strength. We consider all applications equally regardless of race, color, ancestry, religion, national origin, age, citizenship, marital status, disability, orientation or gender identity. We strongly encourage individuals from groups traditionally underrepresented in tech to apply. ****
Please note: For this project we are currently looking for Saudi nationals only. (GDPR statement)
By submitting your application and CV, you give us consent to handle and store your personal information in our HR information systems according to GDPR compliancy and full confidentiality.
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.
