Senior Database Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Act as a trusted advisor to clients by proactively identifying risks related to performance, availability, and security.

• Provide guidance to clients on cloud database architecture, migration, and cost optimization within AWS and Azure IaaS and PaaS environments.

• Spearhead architecture design, disaster recovery planning, and capacity forecasting initiatives.

• Manage the complete database service lifecycle, including backup strategies, high availability/disaster recovery configurations, proactive tuning, and platform roadmap planning.

• Establish and monitor database availability and performance Service Level Objectives (SLOs).

• Implement automated remediation for recurring failure patterns.

• Lead root-cause analysis and conduct post-incident reviews for significant issues.

• Convert incident findings into automation or process improvements to prevent future occurrences.

• Design and execute scalable database structures, incorporating partitioning strategies and audit specifications.

• Create and maintain deployment and rollback scripts.

• Oversee version updates across various environments.

• Develop Python and PowerShell automation for backup validation, monitoring, alerting, and reporting integrations such as Power BI.

• Migrate and support SSIS packages and SSAS cubes.

• Create stored procedures for reporting purposes.

• Collaborate with client technical teams and executive stakeholders to translate technical insights into business-relevant recommendations.

⛳️ Requirements

• Extensive experience as a senior-level SQL Server specialist or Senior-level SQL Server DBA.

• Proficiency in T-SQL query optimization, including the ability to read and rewrite execution plans, resolve parameter sniffing, address statistics/cardinality issues, and perform Query Store-based tuning.

• Experience in rewriting and refactoring stored procedures and T-SQL code to enhance performance.

• Skill in designing and maintaining clustered, nonclustered, and covering indexes; evaluating columnstore indexes; and managing fragmentation and maintenance.

• Expertise in root-cause performance diagnosis, including wait-stats analysis, isolating CPU/memory/I-O bottlenecks, tempdb contention, and resolving blocking/deadlock issues.

• Hands-on experience optimizing Azure SQL Database, Azure SQL Managed Instance, and AWS RDS for SQL Server.

• Knowledge in Azure and AWS cloud database architecture, migration, and cost optimization across IaaS and PaaS.

• Capability for proactive performance baselining and monitoring.

• Experience in architecture design, disaster recovery planning, and capacity forecasting.

• Proficient in backup strategies and high availability/disaster recovery configurations.

• Ability to define and track SLOs for database availability and performance.

• Experience in root-cause analysis and conducting post-incident reviews.

• Competence in designing scalable database structures, including partitioning strategies and audit specifications.

• Experience in deployment and rollback scripting, as well as coordinating version updates across environments.

• Proficiency in Python and PowerShell automation.

• Experience with backup validation, monitoring, alerting, and reporting integrations such as Power BI.

• Familiarity with SSIS and SSAS.

• Proven ability to collaborate directly with client technical teams and executive stakeholders.

• Willingness to travel up to 20% domestically within the US for client onsite visits.

🏝️ Benefits

• Comprehensive medical benefits.

• Full-time employment.

• Opportunity for up to 20% domestic (US) travel for client onsite visits.