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.
Requirements
• 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.
Licence no: 12C6060