Sr. Microsoft SQL Server Database Engineer, Remote

O'Neil Digital Solutions, LLC is a company that supports organizations across global equity markets and various sectors. They are seeking an experienced Senior SQL Database Engineer to design, optimize, and support high-performance Microsoft SQL Server environments for critical enterprise applications, collaborating with various teams to ensure reliable and secure database platforms.

Responsibilities:

• Design and optimize complex T-SQL queries, stored procedures, indexes, and database objects
• Analyze execution plans and troubleshoot performance bottlenecks
• Monitor and tune SQL Server environments using DMVs, Query Store, wait statistics, and enterprise monitoring tools
• Develop and maintain indexing strategies for high-volume transactional workloads
• Resolve issues related to CPU, memory, I/O, blocking, deadlocks, and storage latency
• Partner with engineering teams on schema design, query patterns, and database best practices
• Implement and support SQL Server Always On Availability Groups, clustering, replication, and log shipping
• Develop backup, restore, and disaster recovery strategies aligned with business RPO/RTO requirements
• Conduct failover and recovery testing to ensure operational readiness
• Support resilient database architecture across on-premises and hybrid environments
• Implement database security controls including encryption, access management, audit logging, and separation of duties
• Support compliance initiatives related to PCI, SOC 2, HIPAA, and other regulatory standards
• Manage technologies such as Transparent Data Encryption (TDE), Always Encrypted, and column-level encryption
• Support database deployments and schema changes using structured release processes
• Work with version control and CI/CD tools such as Flyway, SSDT, and GitLab
• Investigate production incidents, identify root causes, and implement preventative improvements
• Monitor database health and performance using enterprise observability platforms
• Plan and execute SQL Server upgrades and migrations
• Identify compatibility risks, deprecated features, and remediation strategies
• Contribute to modernization initiatives involving scalable database architectures and reduced technical debt
• Evaluate appropriate use cases for relational, object storage, and NoSQL platforms

Requirements:

• 5+ years of hands-on experience managing Microsoft SQL Server environments
• Strong expertise in: T-SQL development, Query optimization, Execution plan analysis, Indexing strategies, SQL Server architecture
• Experience troubleshooting production database performance issues
• Experience implementing SQL Server high availability and disaster recovery solutions
• Strong understanding of database security, encryption, and compliance best practices
• Experience supporting enterprise production environments
• Bachelor's degree in Computer Science, Engineering, or related field (or equivalent experience)
• Experience with PostgreSQL or other relational databases
• Experience with SSIS, ETL workflows, or data integration pipelines
• Experience supporting cloud-hosted or hybrid database platforms
• Familiarity with monitoring tools such as: SolarWinds DPA, Datadog, Grafana, Splunk
• Experience with automation, scripting, or infrastructure-as-code
• Familiarity with database CI/CD and deployment tooling
• Exposure to modernization initiatives involving microservices, NoSQL platforms, or service-aligned database design