INSPYR Solutions · 21 hours ago
Database Engineer
Charlotte, NC
Contract
Onsite
Senior Level
5+ years expINSPYR Solutions is a national expert in delivering flexible technology and talent solutions. They are seeking an experienced Database Engineer to support the modernization of data platforms, focusing on the migration of systems from Microsoft SQL Server to PostgreSQL.
Information TechnologyProfessional ServicesStaffing Agency
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
Qualification
Required
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
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
Company
INSPYR Solutions
INSPYR Solutions is a information technology staffing service providers.
501-1000 employees
H1B Sponsorship
INSPYR Solutions has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (54)
2024 (11)
2023 (2)
Funding
Current Stage
Late StageLeadership Team
Gregg Straus
Executive Vice President & Chief Financial Officer
Michelle Wren
Chief Operating Officer
Recent News
2025-09-12
Company data provided by crunchbase