A joint venture company by ST Engineering and HTX (Home Team Science and Technology Agency), Codex Solutions is set up to be a dynamic and forward-looking technology company established to develop cutting‑edge software solutions that support and strengthen Singapore’s homeland security efforts.
As a mission‑driven organisation, we are focused on building strong in‑house capabilities that directly address the complex challenges faced by the Home Team.
With a strong emphasis on innovation, product excellence, and impact at scale, Codex Solutions offers a unique environment where purpose meets technology.
We are assembling a diverse and talented team of technologists and problem solvers who are passionate about making a real difference.
If you’re looking to shape meaningful solutions and be part of something bigger — Codex Solutions is where you’ll want to be.
Overview
We are seeking an experienced and versatile Database Administrator (DBA) to manage, optimise, and secure our database infrastructure across multiple platforms and environments.
The successful candidate will have a strong foundation in both traditional and emerging database technologies, with hands‑on experience in automation, performance tuning, and cloud‑based solutions.
Responsibilities
- Administer and maintain relational and distributed databases (e.g., PostgreSQL, HDFS) across multiple environments.
- Implement database configurations, replication, and backups to ensure high availability and data integrity.
- Participate in database design discussions — advising on schema, indexing, and partitioning strategies.
- Perform query optimisation and performance tuning to improve system efficiency.
- Support data ingestion pipelines and integration with modern frameworks such as Apache Iceberg, Apache Hudi, GraphDB, or VectorDB.
- Monitor and troubleshoot database performance and operational issues, escalating complex cases where needed.
- Automate administrative tasks using Python, PowerShell, or Bash scripts.
- Enforce security, access controls, and audit compliance in alignment with organisational policies.
- Collaborate closely with developers, DevOps engineers, and data analysts to support product and feature development.
Qualities We Value
- Minimum 4–5 years of experience in database administration, including hands‑on experience with PostgreSQL or similar RDBMS.
- Solid understanding of query tuning, indexing, and partitioning strategies.
- Experience with distributed data or data lake frameworks (e.g., HDFS, Apache Iceberg, Apache Hudi).
- Familiarity with scripting and automation tools (Python, Bash, PowerShell).
- Exposure to graph or vector databases (GraphDB, Neo4j, VectorDB) will be an advantage.
- Working knowledge of database security, access control, and backup/recovery best practices.
- Strong analytical mindset, good communication skills, and a collaborative team player.
Benefits
An environment where you will be working on cutting‑edge technologies and architectures.
Safe space where diverse perspectives are valued, and everyone’s unique contributions are celebrated.
Meaningful work and projects that make a difference in people’s lives.
A fun, passionate and collaborative workplace.
Competitive remuneration and comprehensive benefits.
#J-18808-Ljbffr