Cake Job Search

我們正在尋找一位具備資料庫架構思維與穩定維運能力的 DBA， 負責公司多樣化資料庫系統的建置、監控與效能優化， 確保關鍵業務系統持續穩定、安全且高可用。 💼 工作內容 負責 Oracle、MySQL、ClickHouse 等資料庫系統之建置、管理與維運。 執行 資料備份、異地備援與災難復原 (DR) 機制，確保資料安全。 監控資料庫運作狀況，進行 效能調校、資源優化與容量規劃。 規劃並執行資料庫版本升級、遷移與架構調整。 參與專案導入與跨部門協作，提供技術建議與故障分析。 需配合 on-call 值班，負責突發事件的即時排除與系統修復。 維護資料庫主機、儲存設備與相關系統環境設定。

About BTSE:彼特思方舟 is a specialized service provider dedicated to delivering a full spectrum of front-office and back-office support solutions, each of which are tailored to the unique needs of global financial technology firms. 彼特思方舟 is engaged by BTSE Group to offer several key positions, enabling the delivery of cutting-edge technology and tailored solutions that meet the evolving demands of the fintech industry in a competitive global market.BTSE Group is a leading global fintech and blockchain company that is committed to building innovative technology and infrastructure. BTSE empowers businesses and corporate clients with the advanced tools they need to excel in a rapidly evolving and competitive market. BTSE has pioneered numerous trading technologies that have been widely adopted across the industry, setting new benchmarks for innovation, performance, and security in fintech. BTSE’s diverse business lines serve both retail (B2C) customers and institutional (B2B) clients, enabling them to launch, operate, and scale fintech businesses. BTSE is seeking ambitious, motivated professionals to join our B2C and B2B teams.About the opportunity:We are looking for a Database Site Reliability Engineer (SRE) with deep PostgreSQL expertise and hands-on experience automating database deployment, monitoring, and performance tuning on Data Center and AWS. You will be part of the core infrastructure team responsible for scaling and maintaining BTSE’s mission-critical database systems that power our trading and analytics platforms. This role offers the opportunity to design, automate, and optimize high-availability PostgreSQL clusters while ensuring reliability, minimal downtime, and strong observability across production environments operating 24/7.Responsibilities:Design, deploy, and maintain PostgreSQL clusters in AWS environments using Infrastructure as Code (IaC) tools.Develop automation for provisioning, configuration management, and monitoring of PostgreSQL databases.Perform regular database maintenance including vacuuming, reindexing, and analyzing statistics to ensure peak performance.Identify, analyze, and optimize slow SQL queries and workloads to improve efficiency and throughput.Build resilient, high-availability database architectures that minimize downtime during upgrades, maintenance, and failovers.Implement robust backup, recovery, and disaster recovery strategies to guarantee data integrity and uptime.Support and monitor 24/7 production systems, participating in incident response and root cause analysis when needed.Collaborate with SRE, DevOps, and engineering teams to improve scalability, performance, and CI/CD integration for database operations.Requirements:At least 4+ years of experience managing PostgreSQL databases in production environments.Strong knowledge of SQL query optimization, indexing strategies, and PostgreSQL performance tuning.Proven ability to design and maintain highly available, fault-tolerant systems with minimal or zero downtime.Experience supporting mission-critical 24/7 systems in production, with on-call or incident response participation.Hands-on experience with AWS services such as EC2, RDS, EBS, S3, and IAM.Solid understanding of PostgreSQL replication, PITR (Point-in-Time Recovery), and HA solutions (Repmgr,Patroni, ProxySQL, or similar).Experience automating infrastructure using Terraform, Ansible, or similar tools.Proficiency in Linux systems administration and scripting (Bash, Python, or Go).Nice to Haves:Familiarity with observability and alerting stacks (Prometheus, Loki, Grafana, CloudWatch).Exposure to additional database systems such as ClickHouse or TimeScale Postgres.Experience building internal automation or self-healing tools for query analysis and database management.Perks BenefitsCompetitive total compensation packageVarious team building programs and company eventsComprehensive healthcare schemes for employees and dependantsAnd many more! Apply and let us tell you more!#LI-MC1

我們的客戶是一間以數據與演算法為核心的專業技術團隊，長期專注於高穩定度、高效能系統的研發與優化。公司規模精實，技術導向明確，內部高度仰賴資料庫與系統穩定性來支撐關鍵業務運作。這不是制式分工的企業環境，而是一個重視專業、信任技術判斷，讓工程人才真正參與決策與架構演進的團隊。 -------------------------------------------------------------------------------------------- Responsibilities 與後端工程師密切協作管理 Oracle、MSSQL 等資料庫之效能、穩定性與可用性進行資料庫效能分析、瓶頸診斷與系統調校

Key Responsibilities● Work with product owners and other development team members to determine new features and user stories needed in new/revised applications or large/complex development projects● Participate in code reviews with peers and managers to ensure that each increment adheres to original vision as described in the user story and all standard resource libraries and architecture patterns as appropriate● Respond to trouble/support calls for applications in production in order to make quick repair to keep application in production● Participate in all team ceremonies including planning, grooming, product demonstration and team retrospectives● Mentor less experienced technical staff; may use high end development tools to assist or facilitate development process● Advanced proficiency in Object Oriented Design (OOD) and analysis. Advanced proficiency in application of analysis/design engineering functions. Advanced proficiency in application of non-functional software qualities such as resiliency, maintainability, etc. Advanced proficiency in advanced behavior-driven testing techniquesOur Stack● Application Framework: Java 8, Spring Boot● Microservices: Spring Cloud (Spring Cloud Config / Open Feign / Spring Cloud Hystrix / Spring Cloud Gateway)● Database: MySQL (Aurora / RDS)● Public Cache: ElastiCache, Redis (MS, Sentinel, cluster)● Message Queue: Apache RocketMQ, RabbitMQ, Kafka● Coordinator: Zookeeper● APM: Jaeger, opentracing● Documentation: Springdoc-OpenAPI● Search and Reporting: ElasticSearch● Log Real-time Visualization: ELK, Loki● Monitoring: Prometheus, Grafana, CloudWatch● Container: Docker, Kubernetes● CI/CD: Jenkins, ArgoCD

- Set up and execute extract, transformation, and load (ETL) functions to build a data pipeline.- Extraction and analysis of large data sets from MySQL.- Performance tuning for current and newly added queries to the databases, ensuring the database resources are fully utilized.- Delivering clear analysis and reporting of core business metrics to shareholders.- Creation and management of reports and dashboards.- Data management.- Enhance and optimize existing reporting processes.- Ad hoc analysis and reporting to clients and shareholders.- Aid in reconfiguring existing architecture and database structure to address our shareholder's evolving needs.- Daily maintenance and monitoring of all BI-related databases and dashboards, including proficient handling of emergencies.- Providing actionable insight to drive the growth of core products.Our Stack MySQL (Must)Python (Good to have)AirFlow (Good to have)AWS (Good to have)Metabase (Good to have)Redshift (Good to have)Linux (Good to have)

The candidate that will succeed in this position will be able to create all the testing and automation frameworks as required for their projects. Thus, the candidate may have to work on multiple projects once, also working to improve the company's best practices from a testing a standpoint.Responsibilities- Review software requirements and prepare test scenarios.- Analyzing test results on database impacts, errors or bugs, and usability.- Overseeing the drafting of testing documents.- Implementing testing procedures and overseeing the QA process.- Troubleshooting quality issues and modifying test procedures.- Participating in design reviews and providing input on requirements, product design, and potential problems.- Provide solutions for program flow Develop and edit design and production procedures- Document QA tasks with audits or reports

【Key Responsibilities】1. Perform required operations to comply with laws, rules and regulations.2. Troubleshoot application deployments. Reproduce, discuss and resolve issues related to service stability and avoid problem recurrence.3. Communicate and collaborate with front-end, back-end developers and project managers to design efficient SQL programs and ensure stable online service performance and security.4. Maintain Monitor database architecture in good shape proactively.5. Develop DB scripts for operational tasks, such as De-identification and Auto-Backups.6. Provide support for government audit tasks as needed.

【Responsibilities】Technical Leadership & Development: Design and develop backend systems to support business needs, ensuring high performance, availability, and security.Lead efforts in architectural design, performance optimization, database tuning, and advanced caching strategies.Collaborate on the creation of key features, providing technical guidance and ensuring code quality, scalability, and adherence to best practices. People Management: Manage and mentor engineering teams, fostering a collaborative, high-performance culture.Guide team growth and align efforts with company goals, while promoting individual and team excellence. Development Workflow: Lead the design and implementation of CI/CD pipelines, emphasizing automated testing and deployment to improve efficiency.Oversee code reviews, resolve complex technical issues, and ensure adherence to coding standards. Knowledge Sharing & Innovation: Foster a culture of continuous learning by sharing knowledge and introducing new tools and technologies.Actively participate in product and business strategy discussions, providing technical insights to align with company objectives.

If You Are● The successful candidate will be a self-driven person with proven experience inlarge-scale RDBMS and data warehouse● The candidate will have a deep understanding of MySQL and MongoDB● The candidate will be familiar with data model, schema and ETL processes design pattern.Who We AreOpenNet is one of the best companies to work for in Taiwan; we offer a dynamic and rewarding environment for high-achievers looking to work and learn alongside like-minded individuals. We are currently in a period of rapid growth as we expand to make our technology available in over 20 countries.We believe our employees are the company’s most valuable asset and are invested in seeing our employees grow in their careers and strike a work-life balance. We do our best to attract top talent and create a great workplace where people feel engaged, inspired, challenged, and respected.Our StackCore:● Database: MySQL, MongoDB● PaaS: AWS RDS, Redshift, MongoDB AtlasPlus:● Business Monitoring: PMM● Cloud Services: AWS EC2, Cloudwatch, Secrets Manager, etc.● ETL presentation: airflow, metabase.● Server Operating System: CentOSKey Responsibilities● Manage MySQL MongoDB databases● Refine data model ETL processes in Redshift data warehouse● Cowork with developer to optimize the schema design queries

介紹 GNTC 團隊 Dcard GNTC 團隊致力於打造企業級 AI 工作平台，讓企業都能透過 AI 提升工作效率、創造更高價值。我們相信 AI 不只是工具，更是每個團隊成員的智能助手，能夠深度整合企業資料與流程，協助團隊做出更精準的決策、產出更高品質的成果。我們提供全方位的企業 AI 工作平台，使企業夥伴可以提升決策與洞察 、加速企劃產出 ，並且能透過 Agent 自動化處理例行任務，讓團隊專注於更具創造性與決策價值的工作。為了達成這個目標，我們需要 Senior Backend Engineer 加入我們，負責 Dcard GNTC 企業 Agent 平台的後端架構設計、AI 模型整合與系統開發。你將專注於打造穩定、可擴展的生成式 AI 後端服務，為企業客戶提供強大的技術支撐。 你將在團隊參與⋯ 設計與開發 Dcard GNTC Agent 平台的後端系統設計並實作 MCP Server、API、AI Workflow整合 LLM、Vector Database、RAG 等 AI 技術優化系統效能、可靠性與可擴展性根據產品規劃與客戶需求，設計並實作技術方案參與技術方案討論，根據時程、成本、技術可行性提出建議將產品需求轉化為清晰的技術架構與實作持續改善平台架構與開發體驗全面瞭解整體系統架構，識別並優化架構建立可復用的技術元件與最佳實踐改善 CI/CD、監控、部署流程技術研究與知識分享持續學習 Agent 相關知識與新技術，評估並導入適合的技術在團隊內部進行技術分享與文件撰寫