Compass Group is seeking an experienced Database Engineer to support the modernization of our data platforms, including the migration of mission-critical systems from Microsoft SQL Server to PostgreSQL. This role will play a key part in improving scalability, performance, and long-term maintainability across applications that support our diverse portfolio of brands and business lines.
The ideal candidate has hands-on experience executing SQL Server to PostgreSQL migrations in complex, enterprise environments and can collaborate closely with application, infrastructure, and security teams.
Key Responsibilities

Design and execute database migrations from Microsoft SQL Server to PostgreSQL for enterprise-scale applications
Assess existing SQL Server environments and translate schemas, data models, and database logic to PostgreSQL best practices
Convert and refactor T-SQL (stored procedures, functions, triggers, views) into PostgreSQL-compatible SQL and PL/pgSQL
Identify and resolve differences in data types, indexing strategies, constraints, collations, and transaction behavior
Optimize PostgreSQL performance post-migration, including query tuning and indexing strategies
Support low-risk, low-downtime migration strategies for operational systems
Collaborate with application development teams (including .NET teams) to address database dependencies and refactor application queries as needed
Establish standards for PostgreSQL security, backups, monitoring, and operational support
Create and maintain documentation, runbooks, and migration playbooks
Participate in on-call or escalation support for database-related production issues as required

Required Qualifications

5+ years of experience as a Database Engineer, DBA, or similar role in an enterprise environment
Strong expertise in Microsoft SQL Server, including T-SQL, indexing, and performance tuning
Demonstrated experience migrating production databases from SQL Server to PostgreSQL
Solid understanding of PostgreSQL architecture, query planner behavior, and indexing
Experience working with large, transactional datasets and business-critical systems
Proficiency in SQL and relational data modeling
Experience operating databases in Linux-based environments

Preferred Qualifications

Experience supporting enterprise or multi-tenant platforms
Familiarity with cloud-hosted databases (AWS RDS/Aurora PostgreSQL, Azure PostgreSQL)
Experience with data migration tooling (pgLoader, AWS DMS, custom scripts)
Exposure to CI/CD pipelines for database changes
Experience supporting applications in regulated, audited, or high-availability environments

Nice to Have

Experience with Compass Group–style operational systems (point-of-sale, inventory, supply chain, finance, or workforce platforms)
Knowledge of PostgreSQL replication, high availability, or disaster recovery strategies
Experience retiring legacy SQL Server features such as SQL Agent jobs or CLR components
Background working closely with .NET application teams

About INSPYR Solutions
Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.

INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.

Database Engineer

Similar Jobs