Senior Database Administrator

WHO WE ARE

Apex Fintech Solutions (AFS) powers innovation and the future of digital wealth management by processing millions of transactions daily, to simplify, automate, and facilitate access to financial markets for all. Our robust suite of fintech solutions enables us to support clients such as Stash, Betterment, SoFi, and Webull, and more than 20 million of our clients' customers. 

Collectively, AFS creates an environment in which companies with the biggest ideas in fintech are empowered to change the world. As a global organization, we have offices in Austin, Dallas, Chicago, New York, Portland, Belfast, and Manila.

If you are seeking a fast-paced and entrepreneurial environment where you'll have the opportunity to make an immediate impact, and you have the guts to change everything, this is the place for you. 

AFS has received a number of prestigious industry awards, including:

• 2021, 2020, 2019, and 2018 Best Wealth Management Company - presented by Fintech Breakthrough Awards

• 2021 Most Innovative Companies - presented by Fast Company

• 2021 Best API & Best Trading Technology - presented by Global Fintech Awards

ABOUT THIS ROLE

Apex Fintech Solutions is seeking a highly motivated and experienced Senior Database Administrator (DBA) to join our team. This individual must have strong database engineering and problem-solving skills, with the ability to work independently in a fast-paced and high-volume SQL Server environment. The Senior DBA will play a critical role in administering, maintaining, optimizing, and supporting our database systems, ensuring data integrity, performance, and availability. This includes working on both physical and Google Cloud Platform (GCP) native infrastructures. The ideal candidate will have extensive experience with SQL Server, transactional replication, and working with modern cloud-native database solutions such as GCP CloudSQL Postgresql and BigQuery. In addition to hands-on technical expertise, the role also requires strong collaboration skills and the ability to provide operational support and contribute to strategic database initiatives.

Duties/Responsibilities

• Administer, maintain, and optimize high-volume SQL Server database systems in a highly available environment.

• Manage large transactional replication environments, ensuring low-latency data delivery to various target platforms.

• Review, implement, and deploy database changes with a focus on best practices for performance, security, and reliability.

• Address database security, audit-related tasks, support requests, and data changes promptly and effectively.

• Collaborate with development teams to review database schema changes and optimize queries for high performance.

• Support GCP CloudSQL Postgresql databases, working closely with a third-party Postgresql support provider to resolve issues and implement solutions.

• Implement and manage changes to cloud-native and self-managed database systems using Infrastructure as Code (IaC) tools like Terraform and GitHub pull requests.

• Work with GCP BigQuery as a replication target, assisting with performance tuning, usage optimization, and high-level administrative tasks.

• Assist in designing and building a database support plan to ensure reliability and high availability of key database systems.

• Provide on-call second-level escalation support during off-hours based on Central Time Zone, responding to critical database-related issues as needed.

• Participate in scheduled off-hours maintenance tasks, including server/system patching, large data script execution, VLDB (Very Large Database) index maintenance, and disaster recovery testing.

Education and/or Experience

• Bachelor's degree in Computer Science, Computer Engineering (or equivalent work experience) required

• 5+ years of prior work experience

• Experience in administering and optimizing SQL Server environments, including expertise in transactional replication.

• Experience with GCP CloudSQL Postgresql and knowledge of Postgresql database management.

• Experience with other cloud-based database technologi