Agio is a hybrid managed IT and cybersecurity provider servicing the financial services, health care and payments industries. The company has extensive experience supporting the alternative investment space, specializing in hedge funds, private equity firms and asset managers. Agio offers technology hosting, monitoring, management, helpdesk, disaster prevention and recovery, as well as managed security, 360° cybersecurity programs, virtual CISO (vCISO) support and cybersecurity consulting.
About Agio
Agio is a hybrid managed IT and cybersecurity provider servicing the financial services, health care and payments industries. The company has extensive experience supporting the alternative investment space, specializing in hedge funds, private equity firms and asset managers. Agio offers technology hosting, monitoring, management, helpdesk, disaster prevention and recovery, as well as managed security, 360° cybersecurity programs, virtual CISO (vCISO) support and cybersecurity consulting. With over 250 employees, the company is headquartered in New York, NY with a diverse remote-first organization around the globe. For more information, please visit https://agio.com/.
We have team members in the US, UK, Canada, and India. Our remote work policy allows us to accommodate our employees’ need for flexibility. Our family forward mentality and work-life balance focus empower our employees to live their best life at Agio.
RELEVANCE & IMPACT
The Database Administrator is directly responsible for integrity and security of data for our clients. Ensuring databases are running at their peak performance allows our clients to have the most up to date information when they need it, where they need it, in order to make the most accurate decisions possible. Communicating with the client when there is an issue is the highest priority, so the client knows when their data might not be at it’s best. Your ability to work closely with the team will allow us to keep each other on the same page and to motivate each other to continue to improve. The ability to work without supervision will ensure we maintain our high quality service to the clients while allowing the team their turn to train and improve the team as a whole.
RESPONSIBILITIES
Reporting to the Associate Director of Database, you will:
Deliver Excellent Customer Service
- Addressing automated incidents and client requests as they come in
- Communicate clearly and efficiently to clients
- Document and detail work performed in tasks
Be an Owner of the DBA team
- Actively work to improve the service by automation and identifying ways to improve upon our processes
- Support your teammates in achieving team goals
- Consistently work to improve your knowledge of Data technologies
Advanced DB Work
- Assist in designing, implementing, and testing all available HA/DR topologies in SQL Server
- Hands-on experience writing and optimizing TSQL
- Experience in working with Distributed Always on Availability Groups
- Experience handling databases which participate in both replication and always on together.
- Create reports, monitoring, and alerts to better support our clients
- Troubleshoot and resolve server, DB and query performance issues
- Understand and fix anti-best practices in DB design.
REQUIREMENTS
Applicants must possess:
- 7+ years of MS SQL Server experience
- Good to have PostgreSQL, MongoDB, Azure SQL DB, AWS RDS administration experience
- Extensive experience in designing, implementing, troubleshooting and fixing various HA/DR topologies with special focus on Transactional Replication and Alwayson Availability groups.
- Extensive experience in handling server, DB and query performance issues.
- Hands-on experience writing and optimizing TSQL
- Related formal database education or DBA certification
- Excellent written, verbal and interpersonal communication skills
- Strong analytical and problem solving skills
- Strong understanding of database platforms in an enterprise infrastructure with the ability to utilize database administration tools
The strongest candidates will also have:
- Industry certifications (MCSA, MCSE, DP-300)
- Ability to meet stringent deadlines and handle multiple tasks
- Familiar with Change Management and ITIL processes
- Ability to provide timely and informative follow-up to end-users
- Ability to efficiently prioritize and organize competing work demands with little oversight
Agio is a blend of who we are and what we aspire to be. As an equal opportunity employer, we embrace diversity and are committed to creating an inclusive culture that allows each of us to do our best work and be our best selves.
We welcome all interested individuals to apply and encourage applications from people with disabilities, diverse ethnic and cultural origins, veteran status, and people from all races, religions, gender identities, sexual orientations, and expressions. We encourage you to apply if you see a fit between you and the opportunity.
