Proficiency with schema object development ( table, index, stored procedure, trigger, function, partition ) .• Proficiency reading SQL execution plan and being able to optimize SQL and indexes design. • Proficiency with troubleshooting performance issues (example: slow query, bad indexes design, bad TSQL, bad transaction process(deadlock or long blocking) ). • Script development for automating maintenance tasks (powershell, Python, etc) • Archiving, restoring & migrating existing data. • Work on shift and support off-hours urgent call. • Positive attitude to learn the product design and data flow.• Linux...
Updated about 2 months ago