United States onlyJob Description
Fragomen is seeking a Database Engineer (DBE) to join the Database Engineering team within Technology & Innovation. This role is responsible for the reliability, performance, automation, and modernization of SQL Server platforms across on-premises and cloud-integrated environments.
The Database Engineer will partner closely with Reporting, BI, Infrastructure, and Platform teams to standardize operational processes, improve performance, reduce technical debt, and support enterprise-critical database workloads.
Database Platform Engineering & Operations
- Own and operate enterprise SQL Server environments across production and non-production tiers.
- Standardize and automate database operational workflows, including script execution intake, monitoring, and deployment processes.
- Participate in patching, deployment, and release management activities to ensure platform security and stability.
- Provide on-call and incident response support for mission-critical database systems.
SQL Server Performance & Optimization
- Diagnose and resolve complex SQL Server performance issues including blocking, deadlocks, replication latency, and high-write workloads.
- Analyze and tune slow-running queries and reports.
- Lead index analysis, consolidation, and cleanup initiatives to reduce write overhead, improve performance.
- Use DMVs, custom tooling, and historical metrics to proactively identify performance risks.
Configuration Management & Best Practices
- Gather and maintain configuration data across all SQL Server instances, including versioning, hardware, storage, network, and security settings.
- Evaluate environments against SQL Server best practices and implement improvements related to performance, security, and reliability.
- Develop and maintain standardized SQL Server configuration templates.
Automation
- Design and implement automation to reduce manual DBE effort and improve consistency.
- Develop scripts and frameworks to manage recurring operational tasks, compliance checks, and configuration validation.
Platform Modernization & Migration
- Support migrations off legacy SQL Server versions, including SQL Server 2016.
- Evaluate, implement, and support newer SQL Server versions (including SQL Server 2025).
- Support source control migrations and database deployment standardization efforts.
- Assist in modernization initiatives involving Microsoft Fabric and Power BI where database platform integration is required.
What we expect from our Database Engineers:
- Participate in technical design and operational decision-making.
- Build reliable, repeatable, and supportable database solutions.
- Apply strong engineering discipline to scripting, deployments, and automation.
- Collaborate effectively across teams in a fast-paced environment.
Let’s talk if you have:
Required
- 6+ years of experience administering and supporting SQL Server environments.
- Strong expertise in T-SQL, SQL Server performance tuning, and troubleshooting.
- Hands-on experience with automation and scripting for database operations.
- Experience supporting reporting and analytics workloads.
- Strong understanding of SQL Server architecture, indexing, and security.
Nice to Have
- Familiarity with Microsoft Fabric and Power BI integrations.
- Experience supporting cloud or hybrid environments (AWS, Azure).
- Exposure to NoSQL platforms such as Couchbase.
Core Competencies
- Ability to manage multiple priorities with minimal supervision.
- Strong operational ownership and accountability.
- Solid understanding of SDLC and controlled change management.
All offers and/or employment contracts are contingent upon the successful completion of the Firm’s pre-employment screening process. This process may include verifying the candidate’s identity, confirming legal authorization to work in the offered position's location, and conducting a comprehensive background check, where permitted by local regulations.
