Senior Database Administrator
Summary
Senior Database Administrator maintains and optimizes enterprise databases (Oracle, SQL Server, PostgreSQL, KDB+, vector DBs) for performance, security, and AI workloads in a 24x7 Singapore-based role.
Job Summary
We are seeking an experienced Senior Database Administrator to manage and support enterprise database platforms including Oracle, Microsoft SQL Server, PostgreSQL, KDB+, and modern AI Vector Databases. The candidate will be responsible for database availability, performance, security, automation, disaster recovery, and DevOps integration while supporting business-critical applications, analytics platforms, and AI initiatives.
Key Responsibilities
- Administer, maintain, and optimize Oracle, Microsoft SQL Server, PostgreSQL, and KDB+ databases in Production, DR, UAT, and Development environments.
- Design and support high availability and disaster recovery solutions using Oracle RAC, Data Guard, SQL Server Always On, PostgreSQL Replication, and KDB+ replication technologies.
- Perform database installation, configuration, upgrades, patching, migration, backup, recovery, and capacity planning activities.
- Monitor and troubleshoot database performance issues, identify bottlenecks, and implement tuning recommendations.
- Develop and maintain automation for database administration tasks using Python, Shell Scripting, PowerShell, Ansible, or similar technologies.
- Support AI and Data Science platforms by deploying and managing Vector Database technologies such as pgvector, Milvus, Qdrant, Weaviate, OpenSearch Vector Search, or similar platforms.
- Design and optimize vector indexing, embeddings storage, similarity search, metadata filtering, and Retrieval Augmented Generation (RAG) workloads.
- Implement and maintain database security controls including access management, encryption, auditing, vulnerability management, and compliance requirements.
- Build and support CI/CD, Infrastructure-as-Code (IaC), GitOps, and DevOps practices for database deployments and lifecycle management.
- Develop monitoring, alerting, observability, and operational dashboards to ensure proactive health management of database platforms.
- Partner with Application, Infrastructure, AI, Cybersecurity, and DevOps teams to deliver scalable and reliable database services.
- Participate in 24x7 on-call support and incident management activities.
- Prepare technical documentation, standards, SOPs, and architecture recommendations.
Required Qualifications
- Bachelor’s degree in Computer Science, Information Technology, Engineering, or related discipline.
- Minimum 8 years of hands-on Database Administration experience.
Strong expertise in:
- Oracle Database (11g/12c/19c/21c), Microsoft SQL Server (2016/2017/2019/2022) PostgreSQL, KDB+
Hands-on experience with:
- Oracle RAC, ASM, Data Guard, RMAN
- SQL Server Always On Availability Groups and Clustering PostgreSQL Replication, PITR, WAL Management, PgBouncer, KDB+ Tick Architecture and Real-Time Data Processing
Strong knowledge of:
- Backup and Recovery Database Performance Tuning Query Optimization Capacity Planning Database Security and Auditing High Availability and Disaster Recovery
- Experience with Linux and Windows Server administration.
- Strong scripting and automation skills using Python, Shell Scripting, or PowerShell.
- Experience with Git, CI/CD pipelines, Terraform, Ansible, or equivalent DevOps tools.
- Strong understanding of networking, storage, virtualization, and infrastructure fundamentals.
Preferred Qualifications:
- Experience with AI/ML, Generative AI, and Retrieval Augmented Generation (RAG) architectures.
- Hands-on experience with:
- pgvector, Milvus, Qdrant, TImescale, OpenSearch Vector Search Pinecone or similar Vector Database platforms
- Experience managing Kubernetes and containerized database platforms.
- Knowledge of Infrastructure as Code (Terraform) and GitOps practices.
- Experience supporting enterprise-scale databases exceeding multiple terabytes.
- Familiarity with cloud and hybrid database environments.
- Exposure to Data Lake, Data Warehouse, and Real-Time Analytics platforms.
- Experience in semiconductor, manufacturing, financial, or mission-critical environments.