Database Administrator (DBA)

Collective; Massy; Sur place; Confidentiel; Plein temps

Résumé du poste

A digital solutions company in Île-de-France, Massy is seeking an experienced Database Administrator to manage and optimize database systems. The ideal candidate will have expertise in database architecture, performance tuning, and data security. Experience with vector databases and a bachelor's degree in a related field are required. The role includes 24x7 support for mission-critical databases and collaboration with cross-functional teams.

Qualifications

• 3–5 years of experience as a DBA in a production environment.
• Hands-on experience with vector databases.
• Strong knowledge of at least one enterprise database platform.

Responsabilités

• Design, deploy, and manage vector databases optimized for AI/ML workloads.
• Monitor database performance and implement optimization.
• Implement security policies and ensure compliance.

Connaissances

Database administration

SQL query optimization

Data security

Scripting and automation

Performance tuning

Formation

Bachelor's degree in Computer Science or related field

Outils

PGVector

Oracle

Microsoft SQL Server

MySQL

PostgreSQL

MongoDB

Description du poste

Database Administrator (DBA)

Job Summary

We are looking for an experienced Database Administrator to manage, maintain, and optimize our database systems, ensuring high performance, availability, security, and recoverability. The ideal candidate will have deep technical expertise in database architecture, backup strategies, performance tuning, and disaster recovery.

Key Responsibilities

Database Administration & Maintenance

Design, deploy, and manage vector databases optimized for AI/ML workloads, including support for LLMs, RAG pipelines, and semantic search.

Install, configure, and upgrade vector database and traditional database software (e.g., PGVector, Chroma, Pinecone, Oracle, Microsoft SQL Server, MySQL, PostgreSQL, MongoDB).

Collaborate with AI, DevOps, and data engineering teams to support model training, inference, and validation.

Monitor database performance, availability, and security.

Implement and maintain backup, recovery, and disaster recovery solutions.

Schedule and automate database maintenance tasks such as index optimization, statistics updates, and cleanup.

Performance Tuning & Optimization

Analyze and optimize SQL queries, indexes, and database configurations.

Troubleshoot database bottlenecks and slow‑running queries.

Collaborate with developers to optimize database design and queries for application performance.

Data Security & Compliance

Implement security policies, encryption, and access control for database systems.

Ensure compliance with data protection regulations (e.g., GDPR, HIPAA, ISO 27001).

Audit database activity and maintain security documentation.

High Availability & Replication

Configure and manage database replication, clustering, and fail‑over systems.

Support 24x7 availability for mission‑critical databases.

Monitoring & Reporting

Maintain monitoring tools for database performance, growth, and incidents.

Generate and present regular reports on database health, capacity planning, and performance trends.

Collaboration & Support

Work with application teams to design scalable, efficient, and secure databases.

Provide Level 2/3 support for database‑related incidents and requests.

Required Qualifications

Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience).

3–5 years of experience as a DBA in a production environment.

Hands‑on experience with vector databases such as PGVector, Chroma, Weaviate, Pinecone, Milvus, FAISS, or Qdrant.

Strong knowledge of at least one enterprise database platform (e.g., Oracle, SQL Server, MySQL, PostgreSQL).

Familiarity with embedding generation using LLMs and integration with RAG architectures.

Understanding of GPU‑accelerated indexing and retrieval techniques.

Proficiency in scripting and automation for data ingestion, transformation, and indexing.

Knowledge of data lifecycle management and compliance in AI/ML environments.

Exposure to Data Lakehouse platforms and federated query engines.

Proficiency in SQL and scripting languages (PowerShell, Bash, Python).

Experience with database backup/recovery tools and high‑availability architectures.

Familiarity with cloud databases (AWS RDS, Azure SQL Database, Google Cloud SQL).

Preferred Qualifications

Certifications such as:

Oracle Certified Professional (OCP)

Microsoft Certified: Azure Database Administrator Associate

AWS Certified Database – Specialty

MongoDB Certified DBA

Experience with database automation and DevOps integration.

Knowledge of big data platforms (e.g., Hadoop, Snowflake, Redshift).