職位描述
JavaPythonNoSQLPostgreSQLMySQL
Job Responsibilities 工作職責:
1. Core DBA Operations
核心數據庫管理操作
1) Install, configure, and maintain MySQL/Postgres across dev/qual/prod Environments.
在開發(fā)/測試/生產環(huán)境中安裝、配置和維護MySQL/Postgres數據庫;
2) Monitor health and performance, perform backup/restore, disaster recovery tests, and capacity planning.
監(jiān)控運行狀況和性能;執(zhí)行備份/恢復、災難恢復測試和容量規(guī)劃;
3) Implement indexing, partitioning, and query optimization to meet SLA/throughput targets.
通過索引、分區(qū)和查詢優(yōu)化確保滿足SLA/吞吐量目標的達成。
2. Schema & Data Management
模式與數據管理
1) Design and maintain normalized schemas for process, QC, BR, EM, and audit trail data.
為流程、QC、BR、EM和審計跟蹤數據設計和維護規(guī)范化模式;
2) Enforce constraints, keys, and data integrity checks; Manage migrations and versioning.
強制執(zhí)行約束、鍵和數據完整性檢查;管理遷移和版本控制;
3) Support data loads, ETL staging, and environment promotions (dev → qual → prod) with clear documentation.
支持數據加載、ETL暫存和環(huán)境升級(開發(fā) → 測試 → 生產),并提供清晰的技術文檔。
3. Security & Compliance
安全與合規(guī)
1) Implement roles/privileges (least privilege), LDAP integration, and credential rotation.
實施角色/權限(最小權限)、LDAP集成和憑證輪換機制;
2) Maintain audit trails and CRUD event logging aligned to GxP expectations and OpSec best practices.
維護審計跟蹤記錄和創(chuàng)建、讀取、更新、CRUD事件日志,并確保其符合GxP要求與OpSec實踐;
3) Support evidence collection for audits/inspections, keep permission hygiene and access reviews current.
支持審計/檢查所需要的相關證據收集;保持權限管理規(guī)范,并及時開展訪問權限審查。
4. CSV/GAMP Support
CSV/GAMP支持
1) Contribute to URS/FS/DS inputs for database components and data flows.
為數據庫組件和數據流貢獻URS/FS/DS輸入;
2) Execute/document IQ/OQ/PQ steps for DB changes, follow change control and SOPs.
執(zhí)行/記錄數據庫變更的IQ/OQ/PQ步驟;遵循變更控制和標準操作程序;
3) Maintain traceability of requirements to tests for regulated releases.
維護受監(jiān)管發(fā)布的需求到測試的可追溯性。
5. Operations Support & Collaboration
運營支持與協作
1) Troubleshoot locks, slow queries, failed jobs, and replication issues,
participate in on-call rotation.
故障排除鎖定、慢查詢、失敗作業(yè)和復制問題;參與值班輪換;
2) Partner with ETL developers, analysts, QA/QC, Manufacturing, and IT Infra to ensure reliable data availability.
與ETL開發(fā)人員、分析師、QA/QC、制造和IT基礎設施部門合作,確??煽康臄祿捎眯?;
3) Document runbooks, SOPs, and configuration baselines.
記錄操作手冊、標準操作程序和配置基線。
Qualification 任職資格:
1. BS in IT, Computer Science, Information Systems, Life Sciences (with applicable experience) or related field (or equivalent hands-on experience).
信息技術(IT)、計算機科學、信息系統(tǒng)、生命科學(需具備相關實踐經驗)或相關領域學士學位,或具備同等水平的實操經驗。
2. 1–3+ years as a DBA or data engineer with strong SQL and relational schema design.
1-3年以上DBA或數據工程師經驗,具備扎實的SQL和關系模式設計能力。
3. Familiarity with Linux administration and shell scripting basics.
熟悉Linux管理和shell腳本基礎;
4. Hands-on experience with backups/restores, monitoring and performance tuning (MySQL and/or Postgres).
具備備份/恢復、監(jiān)控和性能調優(yōu)(MySQL/Postgres)的實際操作經驗;
5. Exposure to GMP environments, CSV/GAMP 5 concepts and change control workflows.
6. 接觸GMP環(huán)境、CSV/GAMP 5概念以及變更控制工作流程。
7. Experience designing audit trails and secure CRUD patterns in regulated or enterprise systems.
在受監(jiān)管或企業(yè)系統(tǒng)中設計審計跟蹤和安全CRUD模式經驗;
8. Basic Python for admin scripting and ETL support; familiarity with common ETL tools/pipelines.
基本的Python用于管理腳本編寫和ETL支持;熟悉常見的ETL工具/管道;
9. Understanding of data lineage, cataloging, and interest in vector/RAG patterns.
理解數據血統(tǒng)、編目以及對向量/RAG模式感興趣;
10. Strong interest in growing into Applied Agentic AI within a regulated data ecosystem.
在受監(jiān)管的數據生態(tài)系統(tǒng)中發(fā)展成應用代理式人工智能的濃厚興趣。
11. Basic English listening skills for technical discussions.
基本的英語聽力技能。