Overview
Codex Solutions is a joint venture by ST Engineering and HTX (Home Team Science and Technology Agency), established to develop cutting-edge software solutions that support Singapore’s homeland security efforts.
The organization focuses on building in-house capabilities to address complex challenges faced by the Home Team, with emphasis on innovation, product excellence, and impact at scale.
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.
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 optimization 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 organizational policies.
- Collaborate closely with developers, DevOps engineers, and data analysts to support product and feature development.
Qualifications
- Bachelor’s degree in Computer Science, Information Systems, or a related discipline.
- 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.
Location
One-north
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Engineering, Information Technology, and Administrative
Industries
Software Development, Engineering Services, and IT Services and IT Consulting
#J-18808-Ljbffr