FREE ACCESS
5,000–10,000 jobs/day
See all jobs on JobTailor
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Tech Stack
Tools & technologiesAWSAzureCloudMS SQL Server.NETSQL
About the role
Key responsibilities & impact- Design, implement, and maintain logical and physical data structures within the MIR Data Layer
- Build and evolve metadata-driven schemas supporting: Document metadata, Transaction and workflow state, Event based and audit data, Reporting and analytics use cases
- Implement data solutions that support large-scale, concurrent workloads
- Optimize schemas, indexes, and access patterns to improve throughput and latency
- Leverage Memory-Optimized Tables (In-Memory OLTP) for performance-critical paths where appropriate, under architectural guidance
- Implement and support event-driven data processing within the MIR Data Layer
- Work with SQL Service Broker queues and services, including: Asynchronous processing, Status tracking and reconciliation, Retry and error-handling patterns
- Help ensure event processing is idempotent, traceable, and operationally reliable
- Build data structures that enable enterprise reporting and analytics without impacting transactional workloads
- Support snapshotting and reporting-friendly schemas for downstream consumers
- Assist in ensuring audit data is accurate, consistent, and compliant with regulatory expectations
- Contribute to cloud-readiness efforts for the MIR Data Layer
- Support migration and proof-of-concept work targeting: Amazon RDS for SQL Server, Azure SQL Database / Azure SQL Managed Instance
- Help adapt data designs to managed-platform constraints while preserving performance and correctness
- Participate in production readiness, stability, and incident resolution for the MIR Data Layer
- Debug and resolve complex production issues, including: Performance degradation, Blocking, deadlocks, and resource contention, Event based or Service Broker processing failures
- Partner closely with DBAs, SRE, and platform teams to improve monitoring and alerting, Support HA/DR and failover scenarios, Reduce repeat data-layer incidents
- Participate in on-call rotations or escalation coverage as appropriate for a senior-level role
- Ensure new data-layer implementations meet operability and supportability standards before release
Requirements
What you’ll need- Bachelor’s degree, or equivalent work experience
- 5 + years of relevant experience
- Strong hands-on experience with Microsoft SQL Server (SQL Server 2019/2022 preferred) in enterprise, high-volume environments
- Proven ability to design and implement complex, high-performance relational data structures, including metadata-driven and workflow-centric schemas
- Practical experience with SQL Service Broker, including queue usage and basic operational troubleshooting
- Working knowledge of Memory-Optimized Tables (In-Memory OLTP) and associated performance and concurrency considerations
- Medium-level experience with .NET / C#, specifically for: Data access and persistence patterns
- Efficient database interaction from applications
- Debugging data-access issues between application and database layers
- Demonstrated ability to debug and resolve production data issues, including: Query performance bottlenecks, Blocking and deadlocks, Failures in asynchronous or event-driven processing
- Experience supporting reporting and analytics sourced from transactional systems
- Solid understanding of database operations and maintenance, including indexing, statistics, and capacity considerations
- Exposure to cloud-managed SQL platforms (AWS RDS and/or Azure SQL) with awareness of differences from on-prem SQL Server.
Benefits
Comp & perks- Healthcare (medical, dental, vision)
- Basic term and optional term life insurance
- Short-term and long-term disability
- Pregnancy disability and parental leave
- 401(k) and employer-funded retirement plan
- Paid vacation (from two to five weeks depending on salary grade and tenure)
- Up to 11 paid holiday opportunities
- Adoption assistance
- Sick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by law
ATS Keywords
✓ Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Microsoft SQL ServerSQL Service BrokerMemory-Optimized Tables.NETC#data structuresmetadata-driven schemasevent-driven data processingdebuggingperformance optimization
Soft Skills
problem-solvingcollaborationcommunicationoperational reliabilityincident resolutionattention to detailadaptabilityanalytical thinkingtime managementteamwork
Certifications
Bachelor's degreeSQL Server certification