TechOps - Database Engineer

Are you a SQL-savvy person passionate about troubleshooting and fixing data and performance in complex production databases?

Do you like to be part of a core team that works directly with customers and solves their critical problems live?

High-level Requirements For This Position

Highly skilled in SQL Development.
Customer Support Experience or Capability to talk to Customers and understand the context.
Work directly on production SQL systems.
Good communication and documentation skills.
Must work in US business hours. (8 AM to 5 PM Pacific Time)
5+ years of work experience in SQL development.

What You Will Do

Are you a motivated SQL expert with demonstrated experience working on SQL databases to troubleshoot data and performance problems? If so, Trimble Viewpoint seeks people like you to join our highly skilled and talented group. You will be a SQL support specialist responsible for resolving SQL data-related and reports-related issues, monitoring, and tuning performance in self-hosted and cloud-deployed Trimble Viewpoint environments. In addition, this role serves as a support liaison between Trimble Viewpoint, third-party vendors, and our customers.

Provide telephone and Internet support to customers with questions or issues related to configuration/setup, product functionality (attachments, scanning, printing, exporting), performance, and hosted software services, including SQL data and reports-related problems.
Troubleshoot and solve technical issues, including system performance, permissions, data inconsistency, and application errors.
Provide expertise in SQL Data Manipulation and Administration (back-ups, maintenance plans, user administration) for all Viewpoint product suites.
Assist customers with software upgrades, migration, and transformation.
Assist other departments with technical issues.
Monitors, tracks, and documents customer support calls and activities in the CRM system.
Effectively document issues/feedback from customers for use by Development in research and resolution of defects.
Develops Knowledge Base articles to document troubleshooting steps and standard solutions to frequent calls for use by customers and peers.
Implement performance optimizations suggested by the engineering personnel.
Respond to alerts and help monitor, tune, and configure Non-Production and Production monitoring for the best sustainable performance.
Follow documented processes for troubleshooting, engagement, escalation, and others with 3rd-party hosting partners.
Research and diagnose issues independently or as a team.
Support after-hours and on-call duties as required.

What Skills & Experience Should You Bring

Demonstrated experience troubleshooting SQL, including tables, triggers, views, stored procedures, performance tuning, and ability to write complex SQL queries in Microsoft Transact SQL. 
Demonstrated experience with Crystal Reports, including sub-reports, running totals, linking tables, and troubleshooting.
Deep understanding and working knowledge of Microsoft Reporting Services or Financial Statements Reporting applications.
Sound knowledge of SQL Server Database Administration and relational database concepts.
Experience in cloud-based environments such as AWS, Azure, or IaaS-based providers.
Experience with remote desktop takeover tools (Example: Zoom, WebEx, GoToMeeting, Bomgar).
Soft Skills include communication, teamwork, adaptability, problem-solving, creativity, work Ethics, interpersonal skills, and time management.
Familiarity with the commercial construction industry (Job costing, Payroll, Accounts Payable, Accounts Receivable, Equipment Tracking, and Project Management) is an asset for this position but optional.
Bachelor’s degree, preferably major in computer science or relevant experience.