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 等資料庫之效能、穩定性與可用性進行資料庫效能分析、瓶頸診斷與系統調校

Candidate Profile:● The successful candidate will be a self-driven MySQL DBA with proven experience in large-scale systems● The candidate will have a deep understanding of MySQL ● The candidate will be following the latest industry trends and be passionate about database administration for large-scale systemsKey Responsibilities● Database / table schemas deployment; Accounts, privileges management● Monitor and maintain the existing database infrastructure via autoscaling, automated alerts and Zabbix dashboards● Take ownership and responsibility for all of our database infrastructure● Liaise with external security agencies for annual audits as well as perform our own internal security sweeps● Aid in reconfiguring existing architecture and database structure to allow for rapid deployment to new countries to allow for rapid deployments to new countriesOur StackCore:● Database: MySQL, MongoDB● PaaS: AWS RDS, RedshiftPlus:● Business Monitoring: PMM● Cloud Services: AWS EC2, Cloudwatch etc.● Server Operating System: CentOS

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

If you● Are a self-driven DevOps Engineer with proven experience in large-scale micro-service systems hosted on AWS● Have a deep understanding of cloud architecture, AWS technologies and cloud security best practices● Are following the latest industry trends and are passionate about cloud computing for large-scale systems Key Responsibilities● Work in a team of DevOps and DBA professionals – initially 3 people, although this will expand throughout the country expansion● Improve existing infrastructure and CI/CD procedure● Holistically improve all aspects of our infrastructure, including reducing costs, improving build and deployment times, streamlining environment provisioning, lowering load times, incorporating the latest techniques and technologies, and more● Monitor and maintain the existing cloud infrastructure via autoscaling, automated alerts● Take ownership and responsibility for our cloud operation activities● Liaise with external security agencies for annual audits as well as perform our own internal security sweeps● Aid in reconfiguring existing architecture to allow for rapid deployments to new countries● Report to DevOps Leader/DirectorOur Stack● Backend Application Framework: Spring Boot (Java Config + Embedded Tomcat)● Frontend Application Framework: VueJS● Micro Service Framework: Spring Cloud Dalston (Netflix Eureka + Netflix Eureka + Netflix Ribbon + Feign)● Database: AWS RDS, RDS Proxy, MONGODB● Public Cache: AWS ElastiCache + Redis● Message Queue: Apache RocketMQ, RabbitMQ● Distributed Scheduling: Dangdang Elastic Job● Data Index and Search: ElasticSearch● Log Real-time Visualization: ElasticSearch + Logstash + Kibana, Grafana Loki● Business Monitoring: Prometheus + Grafana● Reverse Proxy: Nginx● CDN: Cloudflare● Server Virtualization Container: AWS EKS + AWS EC2● Server Operation System: CentOS● Static File Storage: AWS S3● Inner DNS Resolution: AWS Route 53● Network Management: AWS VPC● Cluster Management and Scaling: AWS OpsWorks● Cluster Monitoring: Prometheus + AWS CloudWatch● HTTPS Certificate Management: AWS Certificate Manager● Malicious Attack Defending: AWS WAF Shield● Cluster Alert: AWS SNS + Slack● Continuous Integration/Deployment: Jenkins, Rancher, ArgoCD● Configuration Tool: Ansible, Chef, Sal

- 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

Established in 1987 and headquartered in Taiwan, TSMC pioneered the pure-play foundry business model with an exclusive focus on manufacturing its customers’ products. As of 2024, TSMC serves more than 500 customers and manufactures over 11,000 products for high-performance computing, smartphones, the Internet of Things (IoT), automotive, and digital consumer electronics. It is the world’s largest provider of logic ICs, with an annual capacity of 16 million 12-inch equivalent wafers. TSMC operates fabs in Taiwan as well as manufacturing subsidiaries in Washington State, Japan and China, and the Company began construction on a specialty technology fab in Dresden, Germany, in 2024. In Arizona, TSMC is building three fabs, with the first starting 4nm production in 2025, the second by 2028, and the third by the end of the decade. The Facility Computer Integrated Manufacturing Department (FDCIM) is part of the Intelligent Manufacturing Center (IMC) at TSMC. It is primarily responsible for the development and maintenance of the following products: Development and maintenance of manufacturing-related report products for wafer fabs.Development and maintenance of engineering-related report products for wafer fabs.Development and maintenance of digital operation system products for facility management.Development and maintenance of big data application system products for facility management.Development and maintenance of facility management AI and machine learning related algorithm development and application system products. Responsibilities: FDCIM also employs software engineering and modular development techniques, combined with high-performance database application technologies, to develop systematized software with a unified version control system that accommodates different time zones and languages globally.In addition to its regular software product development work, FDCIM is also engaged in the research and development of new technologies, including the application of DevOps, Microservices, MLOps, AIOps, and more. Develop and maintain AI/ML systems and algorithmsCollaborate with cross-functional teams to identify and solve business problems using AI/ML techniquesDesign and implement machine learning models and data pipelinesTest and validate AI models for accuracy, scalability, and efficiencyDeploy AI solutions to production environmentsStay up-to-date with the latest advancements in AI technologies and industry trendsWrite clean and efficient code using HTML, CSS, and JavaScriptOptimize web applications for speed and scalabilityTest and debug web applications across multiple browsers and devicesStay up-to-date with the latest front-end development trends and best practices

【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.