
Senior Staff Database Engineer
Posted 17 hours ago

Posted 17 hours ago
This is a fully remote position, open to applicants in United States.
• Design, develop, enhance, and modernize extensive SQL Server databases and data platforms.
• Analyze and refactor intricate T-SQL, stored procedures, functions, and database logic.
• Identify and resolve performance bottlenecks in databases through execution-plan analysis, indexing, query optimization, and database tuning.
• Lead schema enhancements and database modernization efforts.
• Formulate migration strategies and automation processes that ensure data integrity while minimizing disruption.
• Implement and refine data replication and synchronization methodologies.
• Apply event-driven database patterns, including Change Data Capture (CDC), outbox patterns, and event publishing.
• Create solutions for large, high-volume databases that support critical business applications and partners.
• Develop data pipelines and integration methodologies across SQL Server, PostgreSQL, Snowflake, and cloud data services.
• Support both OLTP and OLAP environments, optimizing data movement between systems.
• Utilize AI coding assistants to expedite development, analysis, debugging, and modernization efforts.
• Investigate and implement AI-driven approaches for analyzing stored procedures, documenting schemas, and automating database engineering workflows.
• Contribute to AI-native data infrastructure, including embedding pipelines, vector databases, semantic search, and retrieval systems.
• Develop data and retrieval capabilities that support AI applications and agentic workflows.
• Independently oversee complex database engineering projects from problem definition to production implementation.
• Collaborate with application engineering, SRE, operations, architecture, and AI/ML teams.
• Provide technical direction through code reviews, design discussions, and engineering standards.
• Mentor fellow engineers and contribute to the practices of database engineering.
• Engage in resolving high-impact production issues related to critical database systems.
• Diagnose intricate problems by utilizing logs, database metrics, CPU/memory utilization, execution plans, and observability data.
• Identify root causes, coordinate with technical teams, and facilitate issue resolutions.
• Balance incident resolution with long-term improvements to prevent recurrence.
• Over 15 years of experience in database engineering, data platform engineering, software engineering, or a related technical field.
• Extensive hands-on experience with Microsoft SQL Server and T-SQL, including complex stored procedures, query optimization, execution-plan analysis, indexing, and performance tuning.
• Proven experience in modernizing or refactoring legacy database systems.
• Experience with large-scale, business-critical databases and high-volume data environments.
• Strong programming proficiency in Python, C#, or a similar language.
• Knowledgeable in data pipelines, ETL/ELT, data integration, batch processing, and/or event-driven architectures.
• Strong understanding of database internals, transaction management, concurrency, locking, and performance optimization.
• Experience collaborating across engineering teams and independently spearheading complex technical initiatives.
• Familiarity with AI coding assistants like Cursor, GitHub Copilot, Claude Code, Augment, or similar tools.
• Knowledge of embeddings, vector databases, semantic search, or retrieval-augmented generation (RAG) concepts.
• Experience or willingness to develop AI-enabled data tooling and automation.
• Exposure to PostgreSQL, Snowflake, Azure SQL, Cosmos DB, AWS data services, or similar platforms.
• Proficiency in infrastructure-as-code tools such as Terraform, ARM/Bicep, or similar technologies.
• Familiarity with CI/CD, source control, database migrations, schema versioning, and deployment automation.
• Experience or willingness to build AI-enabled data tooling and automation.
• Preferred: experience in payments, financial services, healthcare, benefits, or other highly regulated sectors.
• Preferred: experience supporting highly available, customer-facing, or business-critical systems.
• Preferred: knowledge of Oracle PL/SQL in addition to SQL Server.
• Preferred: hands-on experience with RAG, semantic search, vector databases, or AI-agent data infrastructure.
• Preferred: experience developing internal engineering tools or automation utilizing AI.
• Health, dental, and vision insurance.
• Retirement savings plan.
• Paid time off.
• Health savings account.
• Flexible spending accounts.
• Life insurance.
• Disability insurance.
• Tuition reimbursement.
• Quarterly or annual bonuses based on role and applicable plans.
CI&T
dentsu Austria
Owens & Minor
Affirm
Get handpicked remote jobs straight to your inbox weekly.