Database Architect

Vista Equity Partners - San Diego, CA

Full-time

San Diego, CA

Funds, Trusts, and Other Financial Vehicles

About the position

Allvue Systems is seeking a Database Architect to join our dynamic team, which is at the forefront of providing software solutions for the Private Capital and Credit markets. As a Database Architect, you will play a crucial role in supporting our database infrastructure across all environments, from Development through Production. Your primary responsibility will be to ensure that our database systems are reliable, robust, and secure, enabling us to meet the needs of both internal and external customers effectively. You will be involved in troubleshooting urgent production database escalations and assisting with the vision, design, deployment, and support of our database operations. In this role, you will architect our database infrastructure to support current and expected business growth. This includes ensuring that appropriate technology and security controls are designed and implemented to meet customer, compliance, and regulatory requirements. You will also be tasked with optimizing database platforms for cost, speed of delivery, and target performance. Additionally, you will help define company-wide database standards and best practices, fostering opportunities for cross-team effectiveness and removing organizational barriers to strong teamwork. You will define and implement critical KPIs/OKRs, SLAs, and metrics necessary to manage and monitor the performance of overall operations. Your expertise will be essential in managing incident, problem, and change management processes, ensuring that our database systems operate smoothly and efficiently. This position offers a unique opportunity to work with pioneers in the fintech industry, where innovative thinking and a passion for continuous improvement are highly valued. Join us in revolutionizing the alternative investment industry and define your future with Allvue Systems!

Responsibilities

• Provide DBA support across all environments (from Development through Production) to meet the needs of internal and external customers.
• Troubleshoot urgent production database escalations.
• Assist with the vision, design, deployment, and support of our database infrastructure and operations.
• Architect our database infrastructure to ensure reliable, robust, and secure infrastructure to support current and expected business growth.
• Ensure appropriate technology and security controls are designed and implemented to meet customer, compliance, and regulatory requirements, and optimize database platforms for cost, speed of delivery, and target performance.
• Help define company-wide database standards and best practices.
• Develop opportunities for cross-team effectiveness and remove organizational barriers for strong teamwork.
• Define and implement critical KPIs/OKRs, SLAs, and metrics necessary to manage and monitor the performance of overall operations, and manage incident, problem, and change management.

Requirements

• 3+ years' experience as a Microsoft SQL Server Database Administrator
• Experience with supporting SQL Server Always On Availability Groups.
• Experience with performance troubleshooting and monitoring within Production environments using High Availability solutions.
• Experience with Windows Server platforms in relation to SQL installations and upgrades.
• Experience with the implementation and maintenance of SQL Server including security, backup/restoration, logging, reporting and recovery procedures.
• Ability to tune queries to improve database performance.
• Ability to develop stored procedures, views, functions, tables, jobs, DML scripts, security enhancements, other scripts.
• Excellent communication skills to maintain cohesiveness globally across all our teams.
• Self-motivation to pick up new work and assist with tickets and able to work with minimum supervision.
• Collaborative team player with a positive attitude to achieve initiatives together as a team.
• High attention to detail, thorough in validating work to ensure successful deployments.
• Ability to organize and prioritize work and meet deadlines.
• Knowledge of agile/scrum processes.
• Ability to work under pressure and in a fast-moving environment.
• Document work effectively and coherently in user stories and tickets, so that work can be passed between team members where needed. Additionally create knowledgebase articles for technical documentation.