Database Administrator

About the Company At Omise, we believe the digitalization of the economy has opened up the world and offers endless opportunities to grow and make meaningful connections with one another. Omise connects people, businesses and society in innovative ways to provide fair and open access to a growing economic ecosystem under its vision of enabling access to the digital economy for everyone. We are on a mission to make digital finance seamless and borderless for people and businesses. Our solutions are used by thousands of companies worldwide including Toyota, ByteDance, ICBC, Siam Commercial Bank, True Money, Worldline, Allianz, Bank of Ayudhya, McDonald’s, BMW, King Power and Pomelo. As a value-driven organization, we are committed to selecting and retaining the sharpest minds across all functions. Join us in our global efforts to make digital finance seamless and borderless for people and businesses. About the Team Omise Engineering teams have a strong focus on innovation and staying at the forefront of technological advancements. This involves a commitment to continuous learning and experimentation with new tools and methodologies. We foster a collaborative environment where team members can openly communicate and share ideas. Omise engineering follows agile methodologies i.e. iterative development process, frequent feedback, and adaptability to changes, allowing teams to respond quickly to evolving requirements. We promote a sense of ownership and accountability and a healthy work-life balance. Why we need you We are looking for an experienced Database Administrator who has a strong understanding of PostgreSQL database management on AWS cloud infrastructure, while also working with NoSQL solutions like MongoDB, DocumentDB, and DynamoDB. The role will lead database operations, including implementing database lifecycle operations, backup and recovery strategies, performance optimization, and mentoring junior team members as well as managing infrastructure-as-code using Kubernetes and Terraform. You will collaborate with cross-functional teams to support application scaling, evaluate emerging database technologies, and ensure data models align with business requirements while maintaining security standards (PCI DSS) and compliance for payment systems. What you will be doing Lead the DBA team in responding to database-related alerts & escalation, as well as working with other teams to come up with strategic solutions to recurring problems Lead and mentor junior database administrators, providing technical guidance and critical decision-making support Responsible for implementing, managing, and optimizing high-availability PostgreSQL databases on AWS cloud infrastructure Design, implement, and verify database backup and recovery strategies, ensuring data integrity and business continuity Execute and manage database lifecycle operations including creatings, configurations, upgrades, and migrations Monitor database performance proactively and implement optimization strategies Responsible for capacity planning and develop long-term database infrastructure strategies Collaborate with cross-functional teams (data, development, and architecture) to support application scaling and growth Create and Maintain comprehensive documentation for database procedures, schemas, and troubleshooting guides Research and evaluate new databases, technologies, and trends to provide innovative ideas and solutions to improve the existing infrastructure and support new projects and requirements Ability to review schemas, implement partitioning tables and sharding ,and other changes to improve scalability and performance. Review proposed software design solutions, providing advice on data models required to support solutions To be aware of and uphold the security responsibilities as stated in the company's Information Security Policy Manage infrastructure-as-code using Kubernetes and Terraform Be part of the on-call rotation to respond to emergencies during off-work hours You A minimum of 5 years working experience in Information Technology and Database Administration Experience in PostgreSQL database administration Strong proficiency in English communication (verbal and written) Able to effectively lead a team Knowledge of underlying database architecture - schemas/products, database objects, file system structure, tables, views, procedures, functions, triggers, sequences, indexes, and constraints. Extensive hands-on experience in database management, including: creating and maintaining databases, applying patches and system upgrades, database cloning and migration, advanced troubleshooting, implementing database security measures and performance optimization, and tuning In-depth knowledge of PostgreSQL concepts including vacuum, logical & physical replication, native partitioning, and sharding The capability to design, build, and deploy database and application server technology to support software solutions in line with current and future strategy. Work closely with developers and DevOps supporting Omise codebase to improve SQL queries, joins, and database structure Strong analytical skills and ability to solve complex issues in a timely manner Strong teamwork, decision-making, documentation, and analytical skills Strong experience of working with high availability, scalability environments Experience in OS system engineering and administration, Linux, Unix, and Windows Experience in system scripting, such as PERL, PYTHON, Shell, etc Experience in Kubernetes, Terraform, and Ansible a plus Autonomous, and with the ability to work independently Open-minded and eager to learn new things Comfortable in a rapidly changing environment and working with a fast and agile team Ability to deal with emergency situations in a calm, efficient, and prompt manner Nice to Have Experience with AWS Aurora, including multi-region deployments and Global Database architecture Advanced PostgreSQL expertise, particularly in replication strategies and native partitioning NoSQL database management (MongoDB Atlas, AWS DynamoDB, AWS DocumentDB) Connection pooling optimization, especially with PGBouncer Database sharding implementation and management Infrastructure as Code experience using Terraform & Kubernetes AWS database cost optimization and resource management Understanding of Ruby on Rails and ActiveRecord ORM Experience with Datadog for database monitoring, logging, and alert management Familiarity with PCI DSS compliance requirements in database environments How to apply If you liked what you read and believe to be up for the challenge, we'd be pleased to welcome you to the recruitment process for this position. Simply click on apply and submit your contact info. Afterward, this will happen next: The hiring team will review your application 2-3 Interviews with the hiring team, People Operations team and all stakeholders involved in the process Why you’ll love it here Work with other talented, ambitious international colleagues who love their craft A modern and well-equipped work environment Flexible working hours A medical healthcare plan and annual health check-up A friendly bunch of colleagues What we believe in We cultivate teamwork and a trust-based working culture We celebrate diversity and continuous improvement Giving our employees the opportunity and create for their own success About Omise Founded in 2013, 500 people Headquartered in Japan, with operational headquarters in Bangkok and offices in Singapore, Indonesia, and Malaysia. Raised over $236M of funding to date from institutional investors including SCB10X, SPARX Group Co. Ltd., Toyota Financial Services Corporation, JIC Venture Growth Investments, MUFG Bank, Mars Growth Capital, Ascend Venture Group, and more Won Digital Startup of the Year at Digital Thailand Big Bang 2017 Won Forbes Japan Startup of the Year 2018 Won 3 awards from International Business Magazine Award 2020 Most Innovative Electronic Payment Platform for Singapore Most Innovative Seamless Transactions Provider for Singapore Best Payment Solutions Provider in Singapore Won Mizuho Innovation Award 2022 (Q2) Life at Omise Nearly 500 employees work from our six office locations as well as remotely from home or co-working spaces. While we are a global company, a lot of our thinking goes into how to solve payment problems at the hyper-local level to help businesses scale and reach their customers. Our core values — simple, real, and beautiful serve as our North Star and are integrated into how we work and the results of our work. At Omise, we empower people to embrace project-ownership and take initiative. We love to see our employees act as the owner of the outcome and confidently provide solutions to each challenge, taking a collaborative teamwork approach. Our fellow employees are encouraged to discuss and share ideas, and are given the freedom to explore all areas of their work, in order to achieve the expected results. People at Omise are from different backgrounds and together, we contribute to creating an inclusive, friendly, and safe working environment. As a company, we embrace diversity and value open discussions, a learning mindset, professionalism, and respect. “Growing with us” means to celebrate the challenges and to always look for opportunities to learn, develop your skills, and move one step forward each day. If this is the work environment you are looking for, then get in touch with us. We look forward to hearing from you. Omise embraces diversity and nourishes an open and inclusive work environment. We are home to over 27 nationalities and all decisions to hire, promote or discharge are based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other applicable legally protected characteristics. * Discover how Omise prioritizes and protects your privacy and data by clicking HERE to explore our Human Resources privacy policy before you embark on your journey with us.