彼特思方舟 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.
Job Overview
- We are looking for an experienced and highly skilled Senior Database Administrator (DBA) to join our growing Infrastructure team at BTSE. In this critical role, you will be responsible for managing, optimizing, and administering our hybrid database environment, which includes both on-premises PostgreSQL databases and AWS cloud solutions (RDS, Aurora, DynamoDB). Your primary goal will be to ensure the high availability, performance, and security of our database systems that power critical fintech applications across both retail (B2C) and institutional (B2B) platforms.
- As a Senior DBA, you will take ownership of the architecture, migration, optimization, and maintenance of database systems, working closely with software developers, system architects, and other key stakeholders. You will also have the opportunity to mentor junior DBAs, implement advanced performance tuning strategies, and be instrumental in shaping the future of BTSE’s database infrastructure.
Responsibilities
- Database Administration & Migration:
○ Manage and optimize PostgreSQL databases in both on-premises and AWS cloud environments (Amazon RDS, Aurora).
○ Lead the migration of legacy on-premises databases to AWS, ensuring minimal downtime and seamless integration with cloud infrastructure.
○ Collaborate with software engineers and architects to design and implement scalable, highly available database solutions tailored to BTSE's evolving business needs.
- Performance Tuning & Query Optimization:
○ Lead efforts to monitor and optimize database performance, addressing issues related to query execution, index efficiency, and overall system performance.
○ Conduct deep-dive performance analyses and use tools like EXPLAIN and pg_stat_statements to diagnose and resolve bottlenecks.
○ Implement advanced indexing strategies and refactor schemas to improve database scalability and response times for high-volume applications.
- High Availability, Backup & Disaster Recovery:
○ Design and maintain robust database backup, recovery, and disaster recovery strategies, ensuring the integrity and availability of critical data.
○ Implement high availability solutions such as PostgreSQL replication, AWS RDS Multi-AZ, and Aurora replication to ensure continuous uptime and failover capabilities.
○ Lead the development of comprehensive disaster recovery plans, ensuring minimal service disruption in the event of a failure.
- Cloud Database Management (AWS):
○ Oversee the management of AWS RDS instances, including performance tuning, scaling, backup strategies, and cost optimization.
○ Implement and maintain cloud-native services like Amazon Aurora and DynamoDB, ensuring the right database solutions are in place for different workloads.
○ Utilize AWS-specific tools such as CloudWatch and CloudTrail to monitor and optimize cloud database performance and security.
○ Implement and enforce best practices for database security, ensuring compliance with industry standards and protecting sensitive financial data.
○ Configure and manage roles, encryption, and audit logging to meet security and compliance requirements.
Requirements
○ Extensive experience in PostgreSQL database administration, including installation, configuration, performance tuning, and troubleshooting.
○ Deep understanding of AWS cloud databases (RDS, Aurora, DynamoDB), including experience with setting up, scaling, and managing cloud-based database instances.
○ Experience with PostgreSQL replication (streaming, logical), clustering, and high-availability solutions.
- Performance Tuning & Query Optimization:
○ Expertise in query optimization, including use of tools like EXPLAIN, pg_stat_statements, and pgAdmin for tuning slow queries and improving database performance.
○ Strong understanding of indexing strategies, query plans, and data modeling to optimize relational databases for large-scale applications.
○ In- depth knowledge of database backup strategies, point-in-time recovery, and disaster recovery plans for both on-prem and AWS-hosted environments.
○ Strong scripting skills (e.g., Python, Bash, Ansible) for automating routine database maintenance and operational tasks.
○ Experience with cloud automation tools and services to streamline database provisioning, scaling, and management.
○ Knowledge of database security practices, including encryption, IAM roles, RBAC, and audit logging for compliance with regulatory standards.
- Cloud & On-prem Environments:
○ Experience working in hybrid environments (on-premises and cloud) and managing the migration of databases to cloud platforms.
○ Familiarity with AWS services like CloudWatch, CloudTrail, IAM, and RDS snapshots for monitoring, security, and operational efficiency.
- Communication & Collaboration:
○ Strong collaboration skills and ability to communicate effectively with cross-functional teams (software engineers, systems administrators, etc.).
○ Ability to present complex technical issues and solutions in a clear, actionable manner.
Nice To Haves
- Bachelor's degree in Computer Science, Engineering, or a related field.
- PostgreSQL certifications (e.g., Certified PostgreSQL DBA) are a plus.
- Experience with database migration tools and strategies, especially from on-premises to cloud environments.
- Familiarity with monitoring solutions like Prometheus, Grafana, or else.
Perks And Benefits
- Competitive total compensation package
- Various team building programs and company events
- Comprehensive healthcare schemes for employees and dependents
- And many more! Apply and let us tell you more!