Ionixx Technologies - SQL Server Architect - Database Administration

Description :

Job Title : SQL Server Architect (DBA)

Location : Remote

Experience : 10+ Years

Work timing : Rotational Shift (Night Shift)

Who we are looking for :

We are looking for an expert SQL Server architect, developer, and database performance engineer in an Azure environment. We would prefer candidates with the combination of SQL database performance engineering, T-SQL development, automation, administration, and Oracle to SQL Server migration skills, where the candidate will be responsible for identifying performance bottlenecks and performing query rewriting / tuning in Azure on SQL VM in IaaS and Azure SQL database. Candidates must possess a strong knowledge of SQL Server database internals and database design patterns and be able to provide insightful problem -solving.

What you will be responsible for as a Senior Azure data architect and performance engineer, will :

• Ensure the availability and optimization of MSSQL 2017, 2019, and 2022 in IaaS SQL VM in Azure. Experience with Azure SQL Database and Managed Instance in Azure. Snowflake experience is a big plus!
• Expert level experience with T-SQL and PowerShell automation.
• Monitor performance on application databases and queries and suggest / apply continuous tuning.
• The responsibilities include working closely with application teams and clients for tuning / rewriting queries for achieving optimal performance and experience with the Query Store, Extended Events, and other third-party tools.
• Must have experience in tuning database instances and suggesting architecture-level changes.
• Responsible for conducting POCs on new custom requirements with Platform Engineering, coming up with standards to ensure that all application design and code is produced with proper integrity, security, and performance.
• Perform reviews on the design and code frequently to ensure the site standards are being adhered to.
• Experience with Oracle to SQL Server migration in Azure Cloud is highly preferred.
• Assist in resolving priority incidents to quickly eliminate impacts, participate in root-cause analysis, and support subsequent corrective and preventative actions.
• Work closely with the SaaS Data team and the Onboarding team during the client

implementation phase, collaborating with various application support and engineering teams to optimize database performance and reliability.

Education & Preferred Qualifications :

(ref : hirist.tech)