Infrastructure Engineer - SQL server

Job Summary:

As a member of the SQL Server Engineering Team under the Data and Analytics Technology Organization, the candidate will assist in building and enhancing secure on-premise and Azure cloud SQL Server infrastructures. The role focuses on seamlessly integrating these systems with existing firm systems and controls. The ideal candidate will have a strong engineering background working with the Azure cloud stack and Microsoft SQL Server, especially with Azure SQL Database, and will contribute to the growth and management of critical databases.

Key Responsibilities:

• Implement hardened and controls-compliant Azure SQL Database deployments using firm-approved standards and infrastructure-as-code best practices.
• Design, develop, test, debug, and document improvements to Azure SQL Database infrastructure configuration management using Terraform.
• Assist in researching, assessing, setting up PoCs, and analyzing new Microsoft feature enhancements to the Azure SQL PaaS offering.
• Stay up-to-date on the latest Terraform provider releases from HashiCorp and update IaC provider libraries to keep them current.
• Adhere to agile best practices to produce high-quality, secure, and maintainable code in an agile environment.
• Support engineering and DBA teams in troubleshooting, analyzing, and resolving issues related to Azure SQL Database and affiliated services.
• Develop a strong understanding of the downstream services and applications that are part of the Azure SQL ecosystem.
• Write clear and comprehensive documentation, guides, and procedures on new and existing processes related to the Azure SQL Database offering.

Required Qualifications:

• Strong experience in SQL Server data engineering, including Azure SQL Database and use of T-SQL.
• Strong experience in enterprise and cloud infrastructure engineering automation using PowerShell and Terraform (experience in Python is a plus).
• Experience with SDLC, agile practices, and related tools, particularly JIRA, GitHub, and GitHub Actions.
• Excellent problem-solving, analytical, and critical thinking skills (experience creating technical architecture documentation is a plus).
• Strong communication, written, and interpersonal skills to work effectively with cross-functional teams.

Preferred Qualifications (if any):

• Experience in cloud infrastructure automation and Azure cloud stack.
• Familiarity with Python for scripting and automating infrastructure tasks.
• Experience in creating technical documentation and diagrams to communicate infrastructure changes or issues.
• Knowledge of enterprise-grade SQL Server environments and cloud database architectures.

Certifications (if any):

Microsoft Certified: Azure Database Administrator Associate (preferred).

Microsoft Certified: Azure Solutions Architect Expert (preferred).

Other relevant certifications related to Azure, SQL Server, and cloud infrastructure.

Education: Bachelors Degree

Certification: Azure Database Administrator Associate , Azure Solutions Architect Expert