Application Support Engineer - SQL Expert

2 days ago

Apply Now

Receive Emails with Similar Jobs

StarCompliance

WebsiteLinkedInAll Job Openings

We are Reputation Guardians, on a mission to make compliance simple and easy.

Insider Trading • Political Activity • Gifts & Entertainment • Outside Activity • Reporting

201 - 500

💰 Venture Round on 2020-12

Description

• Database administration of SQL Server Production and UAT instances • Experience with Microsoft SQL Server 2016/2019 • Database authentication modes, creation of users, configuring permissions and assigning roles to users • Transact-SQL – Strong understanding of views, stored procedures and scalar / table functions • Experience in creating SQL agent jobs, alerts, scheduling DTS and SSIS Packages • Indexing, statistics and performance tuning • Experience in using Performance Monitor, Microsoft SQL Profiler and optimizing queries, tracing long running queries and identifying/resolving deadlocks • Provide 2nd level major and minor incident resolution support • Demonstrate critical thinking to identify, troubleshoot and resolve technical issues • Coordinate, execute and verify client application upgrades (outside of US and UK core hours as required) • Writing and modifying custom reports and data exports using T-SQL skills • Deployment of customer application specific patches • Handle escalations around receiving daily and intraday file feeds • Categorization / reporting of incidents to an agreed scale of impact/severity/priority • Deliver agreed SLAs for uptime for servers • Being pro-active on resolving operational alerts • Strong understanding of SAML to assist clients with single sign-on authentication setup and testing • Test files transmissions and importing into application • Investigating application server issues including performance • Able to investigate and implement automation of production service delivery • Support business analysts on software implementation projects, from sales demo and proof of concept through to UAT and production systems

Requirements

• T-SQL – Advanced-level experience • SQL Server 2016/2019 – Advanced experience • Microsoft IIS • SQL Stored Procedures / Views / Functions • Experience in a similar technical role • Experience implementing and supporting multi-tier web applications on a Microsoft technology platform (SQL Server and IIS) • Exceptional strong time management skills toward managing priorities effectively • Strong critical thinking, attention to detail, methodical and organized approach • Strong analytical skills • Ability to develop working relationships with offshore team members • Good written and verbal communication skills • Financial services experience beneficial