Description

You will resolve SQL data and reporting issues while monitoring and tuning performance across self-hosted and cloud environments.

Responsibilities

• Troubleshoot SQL data, permissions, system performance, and application errors.
• Manage SQL Data Manipulation and Administration, including backups, maintenance plans, and user administration.
• Assist customers with software upgrades, migrations, and data transformations.
• Document customer issues and feedback in the CRM for development teams to use in defect resolution.
• Develop Knowledge Base articles detailing troubleshooting steps and standard solutions.
• Monitor and tune production and non-production environments to implement engineering-suggested optimizations.
• Act as a technical liaison between customers and third-party vendors.

Required Skills

• 7+ years of experience in technical support or database troubleshooting.
• Expertise in Microsoft Transact SQL, including tables, triggers, views, stored procedures, and complex queries.
• Proven experience with SQL performance tuning.
• Deep knowledge of SQL Server Database Administration and relational database concepts.
• Experience with Crystal Reports, specifically sub-reports, running totals, and linking tables.
• Working knowledge of Microsoft Reporting Services or Financial Statements Reporting applications.
• Experience in cloud environments such as AWS or Azure.
• Proficiency with remote desktop tools like Zoom, WebEx, GoToMeeting, or Bomgar.
• Ability to work 8am-5pm Pacific Standard Time.

Preferred Skills

• Familiarity with commercial construction industry processes like job costing, payroll, or project management.

Key Skills

Education

Bachelor's degree in Computer Science