Senior Database Administrator

At HedgeServ, we’re redefining what’s possible in fund administration. With more than $700 billion in assets under administration, we partner with the world’s most forward-thinking investment managers – across private equity, private credit, endowments, hedge funds and more – to deliver seamless, tech-enabled solutions that drive performance.

Our proprietary platform, enhanced by machine learning and robotic process automation, gives clients real-time insights and unmatched control over their operations. Alongside our technology, we offer award-winning service through our team-based approach -- led by a deeply experienced team of industry experts. Our solutions span the full investment lifecycle, including fund accounting, middle office, risk, compliance, tax, and investor services.

We’re a future-focused company, empowering our people through a robust career development framework, clear career trajectories with structured learning paths, training, and progression plans. We invest in leadership development and in our collaborative culture, creating space for talent to grow. Our corporate values – Relationships, Support, Innovation, and Expertise – create a sense of shared purpose and belonging, and we recognize our employees sit at the core of our success. We continue to innovate and evolve through our employees, working together to achieve our shared vision and mission.

HedgeServ supports employees through a variety of offerings, including remote and hybrid working arrangements, and fully paid comprehensive health and well-being benefits. We’ve been recognized as an employer of choice, earning a top 100 workplaces designation.

Founded in 2008, HedgeServ has grown into a global organization with over 2,000 experts across the globe, with offices in the United States, Grand Cayman, Ireland, Poland, Bulgaria, Luxembourg, the Philippines, and Australia. We’ve earned numerous accolades, including Top Overall Administrator, along with #1 rankings for providing alternative asset services in Accounting, Technology, Client Service, Investor Services, Alternative Fund Expertise, Reporting, and Regulatory Expertise.

Department Overview

Database Services team, a vital component of the Application and Infrastructure Support division, plays a crucial role in ensuring the company`s data ecosystem is robust, secure, and optimized for performance. This team, responsible for the backbone of HedgeServ's data landscape, is structured into three key areas: DB Architecture, DB Engineering, and DB Operations (DB Ops).

DB Architecture: The Blueprint for Data Excellence

The DB Architecture team serves as the visionary arm, responsible for designing, planning, and modelling HedgeServ's database systems. Database Design and Modelling: Creating logical and physical database models, ensuring data integrity, efficiency, and scalability. Technology Evaluation and Selection: Researching and recommending appropriate database technologies based on performance, scalability, and cost considerations. Best Practices: Defining and enforcing database standards, naming conventions, and security protocols across the organization. Capacity Planning: Predicting future storage and performance requirements and planning for necessary infrastructure upgrades. Data Governance: Contributing to overall data governance strategies, ensuring data quality, consistency, and compliance with regulatory requirements.

DB Engineering: Building and Maintaining the Data Infrastructure

The DB Engineering team is the hands-on builder, responsible for implementing and maintaining the database infrastructure designed by the architecture team.

Database Installation and Configuration: Setting up and configuring database servers, ensuring optimal performance and security. Performance Tuning: Monitoring database performance and implementing optimizations to improve query speeds, resource utilization, and overall system responsiveness. Backup and Recovery: Implementing and testing backup and recovery strategies to ensure data resilience in case of failures. Security Implementation: Configuring and maintaining database security measures, including user access controls, encryption, and vulnerability patching. Automation and Scripting: Developing scripts and automation tools to streamline database administration tasks and reduce manual errors.

 DB Operations (DB Ops): Keeping the Data Flowing 24/7

The DB Ops team provides operational support for database systems, responsible for the continuous operation and maintenance of the database environment.

Incident Management: Responding to and resolving database-related incidents, minimizing downtime and impact on business operations. Monitoring and Alerting: Monitoring database performance and health, identifying and addressing potential issues before they escalate. Change management: Implementing database changes following established procedures, ensuring minimal disruption to users. User Support: Providing technical support to users, troubleshooting database-related issues, and assisting with data access requests. Patching and Upgrades: Applying security patches and upgrades to database servers to maintain a secure and stable environment.

Collaborative achievement:

The success of HedgeServ's Database Services team lies in the constructive collaboration between these three core areas. The DB Architecture team sets the strategic direction, the DB Engineering team builds and maintains the infrastructure, and the DB Ops team ensures its continuous operation. 

Job Description

We are seeking a Database Services Senior Engineer with deep knowledge and proven experience of SQL Server, both in administration and development. Knowledge and experience with cloud platforms like AWS, Infrastructure as code and orchestration tools such as Terraform and Ansible, DHW and NoSQL solutions like Snowflake or MongoDB, ITIL and Agile framework would be considered huge advantage.

This role requires you to work on shifts including Sat and Sun

Key Responsibilities

• Operational Support all facets of Database Services systems in hybrid environment encompassing SQL Server HA Always On clusters built using Terraform and Ansible.

• Monitoring and identifying potential issues in advance of SQL Server performance and BAU operations. Blocking, deadlocks, multithreading, long running queries, resource consumption and availability.

• Monitoring Weekend maintenance activities including automated OS patching, Software Releases and Updates, DB Reindexing.

• Building new systems and adding/removing resources using Terraform and Ansible.

• Developing new scripts and tools to automate routine tasks.

Job Requirements for the role

Education:

• Minimum Batchelor Degree in Computer science

• SQL Server and Cloud certification is beneficial

Experience:

• Expertise with Microsoft SQL Server Always-ON 2019 - 2025

• Proficiency in scripting languages, such as TSQL and PowerShell.

• Working experience with Terraform, Ansible, Packer in Cloud (AWS, Azure, Google) would be considered an advantage

• Experience with NoSQL DBMS – MongoDB would be considered an advantage

• Experience with DHW - Snowflake would be considered huge advantage

• ITIL and Agile framework

• Ability to demonstrate analytical thinking, ability to learn new technologies and consistent delivery of responsibilities