Match score not available

Unlock Premium Benefits Today!
🚀 Elevate your career with priority access.
Stand out to top recruiters with Jobgether Priority Access:
  • ✅ Top Match: We help you identify job offers where you're a perfect fit.
  • ✅ Exclusive Referral Service: Connect directly with recruiters as a Jobgether Certified Premium User.
  • ✅ Personalized Feedback: Receive feedback and expert guidance on applications, and have your profile manually reviewed.

Start Your Free Trial Now!

Start my free trial

Application Support Engineer, SQL expert (West Coast)

Remote: 
Full Remote
Contract: 
Full time
Experience: 
Mid-level (2-5 years)
Work from: 
New Zealand, United States

Offer summary

Qualifications:

Advanced-level T-SQL experience, Advanced experience with SQL Server 2016/2019, Experience in Microsoft IIS, Background in multi-tier web applications, Financial services experience beneficial.

Key responsabilities:

  • Database administration and performance tuning
  • 2nd level incident resolution support
  • Client application upgrades coordination
  • Writing custom reports and data exports
  • Support software implementation projects
StarCompliance logo
StarCompliance Financial Services SME https://www.starcompliance.com/
201 - 500 Employees
About StarCompliance
StarCompliance is a leading provider of employee compliance technology solutions. Trusted globally by forward-thinking companies in 114 countries, Star's future-ready compliance platform delivers on-demand configurability, multi-jurisdictional integrity, and the actionable intelligence you need to monitor for conflicts, meet regulatory obligations and reduce risk. Compliance no longer needs to be complex. Check out Star's intuitive, straightforward UX and give your employees the multi-layered protection they need to comply with confidence. Our Employee Conflicts of Interest suite provides clients a single place for monitoring and mitigating potential employee conflicts, covering: personal trading activity; insider trading; private investments, gifts and entertainment spending; outside business activities; and political donations. The STAR Mobile app supports personal trading pre-clearance requests and gifts and entertainment spending submissions, and allows compliance officers and employee supervisors to review and approve those requests and submissions on-the-go. Compliance Control Room centralizes all firm deal-related activity—automatically surfacing critical data that might otherwise be missed—and allowing for easier conflict searches, so deals can be cleared faster and with greater confidence.
See more StarCompliance offers

Job description

Logo Jobgether

Your missions

POSITION DETAILS
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.

ROLE/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, and Experience
  • T-SQL – Advanced-level experience
  • SQL Server 2016/2019 – Advanced experience
  • Microsoft IIS
  • SQL Stored Procedures / Views / Functions

    • Transferable Skills, Knowledge, and 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 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

    • Required profile

    Experience

    Level of experience: Mid-level (2-5 years)
    Industry :
    Financial Services
    Spoken language(s):
    Check out the description to know which languages are mandatory.

    Hard Skills

    Performance TuningIncident ManagementAutomation

    Soft Skills

    • analytical-skills
    • Problem Solving
    • verbal-communication-skills
    • Critical Thinking
    • Time Management
    Are you interested?

    Technical Support Engineer Related jobs

    See more Technical Support Engineer jobs
    Sign in or sign up with Google or LinkedIn