Investor Services Database Engineer

About the role

The Investor Services Database Engineer supports the development and evolution of enterprise applications from the database perspective, with a strong focus on Microsoft SQL Server. Working within the Engineering team, the role owns database changes, migration scripts, complex SQL development, schema evolution, upgrades and performance optimization. It suits someone who understands existing database structures and application behaviour, can troubleshoot complex database issues and collaborate across engineering teams.

Key responsibilities

• Design, develop, review and maintain SQL scripts, stored procedures, database functions and other database objects.
• Develop and maintain database migration and upgrade scripts for application releases and platform upgrades.
• Design schema changes while considering compatibility, data integrity, performance and upgrade requirements.
• Analyze and optimize complex SQL queries, stored procedures and functions; investigate database-related application issues and support Software Engineers.
• Monitor SQL Server performance, identify bottlenecks and tune queries, indexes and execution plans.
• Support database and application upgrades, including migration, reconciliation and validation.
• Ensure database changes are repeatable, testable, version-controlled and compatible with release processes.
• Collaborate with Software Engineering, QA, DevOps and Performance Engineering teams.

Required profile

• Bachelor's degree in Computer Science, Engineering or equivalent practical experience.
• 4+ years of hands-on database engineering or database development experience with enterprise applications.
• Experience in an application engineering team supporting complex enterprise software.

Required skills

• Strong expertise in Microsoft SQL Server and T-SQL.
• Complex SQL query, stored procedure and function development and optimization.
• Database schema design, migration scripts and upgrade scripts.
• Query execution plans, indexing, locking and performance tuning.
• Data migration, reconciliation and validation principles.
• Source control and structured software release and SDLC processes.

Nice to have: large-scale financial-services applications, Sybase to SQL Server migrations, SQL Server monitoring tooling, Azure SQL or cloud-hosted SQL Server, CI/CD and automated deployment, scripting with PowerShell or Python, and GitHub Copilot or AI-assisted engineering tools.