Lead Technical Services Analyst (SQL Expert) West Coast

Role Technical Services Analysts are an integral function within StarCompliance and work directly with Client Services, Professional Services, Development, Relationship Management and Sales. Technical knowledge is paramount for this position alongside critical thinking and an ability to methodically assess and resolve issues which may not have been encountered previously. Successful candidates will need to be passionate about the StarCompliance brand identity and understand the solutions that the company provides. 

Responsibilities

• Database Operations (40%)
•        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.

Technical Services (60%)

•        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.

Mandatory Skills, Knowledge or Experience

•        T-SQL – Advanced-level experience
•        SQL Server 2016/2019 – Advanced experience
•        Microsoft IIS
•        SQL Stored Procedures / Views / Functions
 

Transferable Skills, Knowledge or Experience

•        Experience in a similar technical role.
•        Experience implementing and supporting multi-tier web applications on a Microsoft technology platform (SQL Server and IIS).
•        Exceptional 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.

Integrity and Ethics ·       All StarCompliance employees are expected to commit to a high standard of personal integrity and carry out their responsibilities in an ethical manner.
StarCompliance Background Checks
All positions require pre-employment screening due to employees potentially having access to highly sensitive and confidential information involving finance and compliance; candidates must be trustworthy and have a heightened sensitivity to protecting confidential financial, professional information.  To be eligible for employment with StarCompliance, candidates must undergo a rigorous background investigation with checks including, but not limited to, criminal record history, consumer credit, employment history, qualifications, and education checks.  

Equal Opportunity Employer Statement
We prohibit discrimination and harassment of any kind based on race, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, gender identity or expression, marital/civil union/domestic partnership status, veteran status or any other protected characteristic as outlined by country, state, or local laws.
This policy applies to all employment practices within our organisation, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. StarCompliance makes hiring deci