SQL Server Platform Engineer

Lighthouse Technology Services is partnering with our client to fill their SQL Server Platform Engineer position! This is a 12-18 month contract opportunity and will be hybrid 3 to 4 days on site in Buffalo, NY or Wilmington, DE.

This role will be a W2 employee of Lighthouse Technology Services. No C2C or subcontracting arrangements will be considered.

What You’ll Be Doing:

• Architect and engineer enterprise-level SQL Server solutions across on-premises and cloud environments, serving as subject matter expert for complex database platform initiatives
• Deploy and manage SQL Server databases in Microsoft Azure using infrastructure-as-code tools including Ansible and Terraform
• Provide strategic direction and expert consultation to internal application owners on database design, optimization, and future-state architecture aligned with enterprise goals
• Lead analysis and implementation of complex database enhancements, migrations, and modernization projects from requirements through production deployment
• Design and recommend optimal database architectures based on business requirements, performance needs, and cloud-first strategies
• Mentor and develop less experienced database engineers, providing technical guidance and knowledge transfer on best practices
• Manage vendor relationships and represent the organization at executive advisory boards and industry conferences
• Troubleshoot and resolve complex production database issues while ensuring minimal business impact and maintaining high availability
• Oversee business continuity, disaster recovery, and audit compliance processes for database platforms
• Collaborate with Architecture, Application Development teams, and Technology leadership to evaluate new database technologies and establish platform standards

• This is a senior level role and requires senior-level experience with Microsoft SQL Server engineering and administration across enterprise environments
• Strong proficiency with infrastructure-as-code tools, specifically Ansible and Terraform for database deployment and configuration management
• Demonstrated experience engineering and managing databases in Microsoft Azure, including Azure SQL Database and related platform services
• Proven ability to design, implement, and optimize complex database solutions for both on-premises and cloud environments
• Experience leading multiple concurrent projects of varying complexity, including large-scale system enhancements, migrations, and conversions
• Excellent analytical and problem-solving skills with ability to translate business requirements into technical database solutions
• Strong communication and presentation skills with ability to serve as trusted advisor to technical and business stakeholders