What are the responsibilities and job description for the Database Administrator position at Allvue Systems?
About Allvue
We are Allvue Systems, the leading provider of software solutions for the Private Capital and Credit markets. Whether a client wants an end-to-end technology suite, or independently focused modules, Allvue helps eliminate the boundaries between systems, information, and people. We’re looking for ambitious, smart, and creative individuals to join our team and help our clients achieve their goals. Working at Allvue Systems means working with pioneers in the fintech industry. Our efforts are powered by innovative thinking and a desire to build adaptable financial software solutions that help our clients achieve even more. With our common goals of growth and innovation, whether you’re collaborating on a cutting-edge project or connecting over shared interests at an office happy hour, the passion is contagious. We want all of our team members to be open, accessible, curious and always learning. As a team, we take initiative, own outcomes, and have passion for what we do. With these pillars at the center of what we do, we strive for continuous improvement, excellent partnership and exceptional results. Come be a part of the team that’s revolutionizing the alternative investment industry. Define your own future with Allvue Systems!
Job Summary
We are seeking a Microsoft SQL Server Database Administrator team member with 2-5 years of experience, and with knowledge of performance tuning SQL Server objects such as procedures, functions, and views, and preferably with AWS or Azure Cloud exposure. This person will join a small, experienced database team working in a fast-paced environment for a great company where your opinion and experience matters. We have both AWS and Azure production OLTP and DW BI databases that need to be maintained to keep our clients satisfied, as well as hundreds of development databases that need attention on a case-by-case basis. We have various SQL Server versions from 2014 to 2022.
Responsibilities
Allvue Systems provides equal employment opportunities (EEO) for all employees and applicants for employment. We recognize the real value of bringing people together from diverse backgrounds, experiences and perspectives - we don’t just accept difference, we celebrate and support it. We are committed to advancing these efforts through our strategies to hire, promote, create and support a diverse and inclusive environment throughout our workforce and workplace. It is our policy to prohibit discrimination and harassment of any type without regard to race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law. In addition, Allvue will provide reasonable accommodations for qualified individuals with disabilities.
We are Allvue Systems, the leading provider of software solutions for the Private Capital and Credit markets. Whether a client wants an end-to-end technology suite, or independently focused modules, Allvue helps eliminate the boundaries between systems, information, and people. We’re looking for ambitious, smart, and creative individuals to join our team and help our clients achieve their goals. Working at Allvue Systems means working with pioneers in the fintech industry. Our efforts are powered by innovative thinking and a desire to build adaptable financial software solutions that help our clients achieve even more. With our common goals of growth and innovation, whether you’re collaborating on a cutting-edge project or connecting over shared interests at an office happy hour, the passion is contagious. We want all of our team members to be open, accessible, curious and always learning. As a team, we take initiative, own outcomes, and have passion for what we do. With these pillars at the center of what we do, we strive for continuous improvement, excellent partnership and exceptional results. Come be a part of the team that’s revolutionizing the alternative investment industry. Define your own future with Allvue Systems!
Job Summary
We are seeking a Microsoft SQL Server Database Administrator team member with 2-5 years of experience, and with knowledge of performance tuning SQL Server objects such as procedures, functions, and views, and preferably with AWS or Azure Cloud exposure. This person will join a small, experienced database team working in a fast-paced environment for a great company where your opinion and experience matters. We have both AWS and Azure production OLTP and DW BI databases that need to be maintained to keep our clients satisfied, as well as hundreds of development databases that need attention on a case-by-case basis. We have various SQL Server versions from 2014 to 2022.
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.
- 2-5 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 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.
- Experience with Snowflake and/or MongoDB a major plus.
- Experience with AWS or Azure portals, configuration, and maintenance via the portal.
- Installation and Configuration of multiple instances and versions and components of SQL server, including SQL Reporting Services, Change Data Capture, and Analysis Services.
- Strong database design and schema refactoring experience.
- Working with, writing, managing, and deploying PowerShell scripts and modules
- Experience with Jira
- Experience with PostgreSQL
- Knowledge of SharePoint
- Knowledge of Microsoft Dynamics NAV
- Knowledge of MS Dynamics CRM
- Microsoft SQL Server Certification
- University Degree in related discipline preferred
- Health Coverage options along with other voluntary benefits
- Enterprise Udemy membership with access to thousands of personal and professional development courses
- 401K with Company match up to 4% or Employee Pension plan
- Competitive pay and year-end bonus potential
- Flexible PTO
- Charitable Donation matching, along with Volunteer and Voting PTO
- Numerous team building activities to promote collaboration in a fun and fast-paced work environment
Allvue Systems provides equal employment opportunities (EEO) for all employees and applicants for employment. We recognize the real value of bringing people together from diverse backgrounds, experiences and perspectives - we don’t just accept difference, we celebrate and support it. We are committed to advancing these efforts through our strategies to hire, promote, create and support a diverse and inclusive environment throughout our workforce and workplace. It is our policy to prohibit discrimination and harassment of any type without regard to race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law. In addition, Allvue will provide reasonable accommodations for qualified individuals with disabilities.
