L2 Customer Support Analyst

Experience: 1-3 years work experience in operations and support of cloud environments with focus on request fulfilment, incident response, escalation procedures and knowledge management while adhering to service-level requirements 5+ years experience managing SQL servers with a focus on MS solutions, such as SQL Server and Azure Search. Knowledge of platforms such as Postgres and MySQL is a plusExperience creating, maintaining, backing up and restoring data and complete databasesAbility to design distributed database and manage database synchronization and consistencyWorking knowledge to monitor and optimize database performance and generate recommendations for improvements 5+ years creating SQL queries that would include: Understanding of SQL syntax and ability to create quality queries for, but not limited to, managing databases, tables, indices, constraints, foreign key constraints, optimizations, stored procedures and JSON data structuresUnderstanding of more complex SQL queries, including inner and outer joins, temporary table use and nested SQL queriesAbility to create and manage supporting database scripts, such as bash scripts to perform database activities or tasks within a cloud platformExperience with data security and access control, and include knowledge in areas such as salting and hashing, as well as an understanding of MS database security, such as column encryption