DBA 資料庫管理師 DBA (Database Administrator)
工作內容：
數據庫規劃與設計：
負責企業數據庫架構的規劃、設計與優化，確保高可用性與擴展性。
根據業務需求設計合理的數據庫表結構、索引、視圖、存儲過程等。
參與數據庫選型（如 MySQL、PostgreSQL、Oracle、SQL Server、MongoDB 等），並制定數據庫標準與規範。
數據庫管理與維護：
負責數據庫的安裝、配置、升級與遷移。
實施備份與恢復策略，確保數據的安全性、完整性與可靠性。
定期執行數據清理、歸檔以及數據庫性能優化。
性能優化：
監控數據庫性能，分析慢查詢、鎖爭用、I/O 瓶頸等問題。
編寫並優化高性能 SQL 語句，提高查詢效率。
優化數據庫架構，如分區、分表、索引策略、緩存機制等。
安全與合規：
實施數據庫安全策略，管理用戶權限與訪問控制。
監控數據庫的異常行為，防範 SQL 注入、惡意攻擊等安全隱患。
確保數據庫符合公司內部及行業合規標準（如 GDPR、ISO27001）。
高可用性與容災：
設計並實施數據庫高可用（HA）和災備（DR）解決方案，如主從複製、雙活架構、分佈式數據庫。
熟悉常見的高可用技術，如 MySQL MHA、Galera、PostgreSQL Replication、Oracle RAC 等。
監控與警告：
配置並維護數據庫監控工具（如 Zabbix、Prometheus、Grafana 等），實時跟蹤數據庫運行情況。
設置合理的監控指標與告警規則，及時發現並處理潛在問題。
團隊協作與文檔管理：
撰寫數據庫設計文檔、運維手冊和故障排查文檔。
與開發、運維、產品等團隊緊密合作，確保數據庫的穩定性與性能滿足業務需求。
任職要求：
學歷與經驗：
計算機、軟體等相關專業。
3 年及以上數據庫管理經驗，有大型分佈式數據庫管理經驗者優先。
Job Description:
Database Planning and Design:
-
Responsible for planning, designing, and optimizing the architecture of enterprise databases, ensuring high availability and scalability.
-
Design efficient database table structures, indexes, views, stored procedures, etc., based on business requirements.
-
Participate in database selection (e.g., MySQL, PostgreSQL, Oracle, SQL Server, MongoDB, etc.), and establish database standards and guidelines.
Database Management and Maintenance:
-
Responsible for the installation, configuration, upgrade, and migration of databases.
-
Implement backup and recovery strategies to ensure data security, integrity, and reliability.
-
Regularly perform data cleanup, archiving, and database performance optimization.
Performance Optimization:
-
Monitor database performance, analyze issues such as slow queries, lock contention, I/O bottlenecks, etc.
-
Write and optimize high-performance SQL queries to improve query efficiency.
-
Optimize database architecture, such as partitioning, sharding, indexing strategies, and caching mechanisms.
Security and Compliance:
-
Implement database security policies, manage user permissions and access control.
-
Monitor abnormal database behavior and prevent security risks such as SQL injection and malicious attacks.
-
Ensure the database complies with internal company and industry regulations (e.g., GDPR, ISO27001).
High Availability and Disaster Recovery:
-
Design and implement high availability (HA) and disaster recovery (DR) solutions for databases, such as master-slave replication, active-active architecture, distributed databases.
-
Familiarity with common high-availability technologies like MySQL MHA, Galera, PostgreSQL Replication, Oracle RAC, etc.
Monitoring and Alerts:
-
Configure and maintain database monitoring tools (e.g., Zabbix, Prometheus, Grafana) to track the database's operation in real-time.
-
Set reasonable monitoring metrics and alert rules to identify and resolve potential issues promptly.
Team Collaboration and Documentation Management:
-
Write database design documentation, operation manuals, and troubleshooting guides.
-
Work closely with development, operations, product, and other teams to ensure the database's stability and performance meet business needs.
Requirements:
Education and Experience:
-
Degree in Computer Science, Software Engineering, or related fields.
-
3+ years of database management experience, with experience in managing large distributed databases preferred.
加分項：
有 PB 級數據量的數據庫管理經驗。
熟悉分佈式數據庫（如 TiDB、GaussDB、Oracle 等）。
具備 DevOps 環境下的數據庫自動化管理經驗（如 Ansible、Terraform 等）。
持有數據庫相關認證證書（如 OCP、MySQL DBA、AWS Certified Database 等）。
技術能力：
精通至少一種主流數據庫（如 MySQL、PostgreSQL、Oracle、MongoDB、GaussDB）。
熟悉 SQL 性能優化、索引設計、事務管理、鎖機制等。
掌握數據庫高可用方案（如主從複製、分片、集群等）。
熟悉 NoSQL 數據庫（如 Redis、Elasticsearch）和大數據平台（如 Hadoop、Hive、HBase）者優先。
熟悉 Linux/Unix 環境下的數據庫管理及 Shell 腳本編寫。
工具與框架：
熟悉常用的數據庫監控工具（如 Zabbix、Prometheus、Grafana）。
掌握數據庫備份與恢復工具（如 Xtrabackup、RMAN）。
具備雲數據庫（如 AWS RDS、HUAWEI GaussDB）管理經驗者優先。
軟技能：
邏輯思維清晰，擅長問題分析與性能瓶頸排查。
具有高度責任心，對數據安全與穩定性有強烈關注。
具備團隊協作精神與良好溝通能力，能高效與開發及運維團隊合作。
良好的文檔編寫習慣，能整理詳細的數據庫運維手冊與問題解決記錄。
Preferred Qualifications:
-
Experience in managing databases with PB-level data.
-
Familiarity with distributed databases (e.g., TiDB, GaussDB, Oracle, etc.).
-
Experience in database automation management in a DevOps environment (e.g., Ansible, Terraform).
-
Holding relevant database certifications (e.g., OCP, MySQL DBA, AWS Certified Database, etc.).
Technical Skills:
-
Proficient in at least one mainstream database (e.g., MySQL, PostgreSQL, Oracle, MongoDB, GaussDB).
-
Familiar with SQL performance optimization, index design, transaction management, locking mechanisms, etc.
-
Mastery of high availability database solutions (e.g., master-slave replication, sharding, clustering, etc.).
-
Familiarity with NoSQL databases (e.g., Redis, Elasticsearch) and big data platforms (e.g., Hadoop, Hive, HBase) is a plus.
-
Proficient in database management and shell scripting in Linux/Unix environments.
Tools and Frameworks:
-
Familiar with commonly used database monitoring tools (e.g., Zabbix, Prometheus, Grafana).
-
Proficient in database backup and recovery tools (e.g., Xtrabackup, RMAN).
-
Experience in managing cloud databases (e.g., AWS RDS, HUAWEI GaussDB) is a plus.
Soft Skills:
-
Clear logical thinking, adept at problem analysis and performance bottleneck troubleshooting.
-
Highly responsible, with a strong focus on data security and stability.
-
Team player with strong communication skills, able to collaborate effectively with development and operations teams.
-
Good documentation habits, able to organize detailed database operation manuals and troubleshooting records.
公司地址:
臺北市大安區敦化南路二段2號3F-1其他:
一面為業務/技術面，由業務負責人直接面談。二面為HR面，HR主要針對公司願景、文化、薪酬、福利等項目進行告知和協商。Interview Process:First Round: The first interview focuses onbusiness/technical aspectsand is conducted by the business manager. It will assess your technical skills, experience, and alignment with the role's responsibilities.Second Round: The second interview is withHRand will cover topics such as the company'svision, culture, compensation, and benefits. This round also involves negotiating terms and clarifying any questions you might have regarding the company’s policies.-2025-04-01