Associate architect Development L3

• Strong in-depth work experience of RDBMS concepts and writing complex TSQL queries and procs.
• Good Experience in handling large database tables.
• Good understading of optimizing large complicated SQL statements.
• Experience in deployment of code in various environments.
• Must have worked in an ETL tool (SSIS or Azure Data Factory prefrred).
• Knowledge of either of these skills is a big plus: PBI/SSRS/SSAS/Synapse.
• Indepth understanding of indexes,Backups/Restore, Isolation levels,Database design.
• Knowledge of security best practices and oversight of secure database coding.
• Capable of troubleshooting complex database issues.
• Familiar with tools like SQL Profiler/Third Part tools like RedGate.
• Maintain SQL Coding standards.
• Communication and organisation skills are keys for this position along with a problem-solution attitude.
• Knowledge of Powershell is a plus.

Requirements

T-SQL, Database designing, Performance tuning, Deployment,SSIS, Azure Data Factory, Synapse,PowerShell