Application Engineer
Grounded in safety, quality, and ethics, our experts lead their fields and guide our work with rigor, a creative spirit, and vision for growth. We draw from more than 20 technical specialties around the globe and are committed to fostering an inclusive community of diverse talents, backgrounds, and expertise. We are a place to apply your passion and collaborate with top environmental talents on work that’s critical to our clients and the communities they support. Join a team that has the environment down to a science.
Your Opportunity
Stantec is primarily a professional infrastructure and environmental services company, but we also offer Paragon, a cloud-based Facility/Asset Planning & Management system. Now there is a need for an Application Engineer to assist with deployments, data migration services, technical support, some testing and whatever else technical tasks need to be done to keep clients happy.
Paragon is a Software as a Service offering, hosted in Azure. The system is built on the .NET framework, hosted on IIS with a SQL Server backend. The mobile data collection app is ParagonDC that runs on iPads.
Your Key Responsibilities
- Become intimately familiar with the Paragon Capital Asset Planning & Management System in terms of usage, database schema, business process rules.
- Provide first-tier application support for customers' questions and issues in a timely fashion.
- Provide functional and technical support to ensure performance, operation, integrity and stability of applications and underlying databases.
- Work with developers, QA team, IT and security personnel to execute database projects according to internal and customer requirements.
- Collaborate on development of enhancements and new functionality from the database back- end perspective, SQL Server.
- Take an active role in database stability and performance optimization through database monitoring, SQL query tuning and/or changes to the database schema and other suitable approaches.
- Develop custom queries to support client-specific output requirements.
- Manage data exporting and importing projects across database systems for client-specific requirements.
- Testing of new Release Candidates to ensure specific issues are properly resolved, new features are fully functional.
Your Capabilities and Credentials
- Solid knowledge of Microsoft Excel, Word.
- Comfortable learning new software tools and techniques.
- Strong problem interpretation and solving skills.
- Ability to review and interpret technical information and translate for a less-technical audience.
- Analytic, Detail oriented.
- Team player, Good interpersonal skills and communication skills.
- As this is a remote position, this position requires a very clear voice and English articulation.
- Ability to multi-task and work independently.
- Position requires prolonged computer use.
- Ability to work from home (if not near a Stantec GS office)
- Preferred:
- Microsoft Certified Solutions Associate 'MCSA' or MCSE including SQL Server certifications or other formal and certified training:
- Exam 70-761 Querying Data with Transact-SQL
- Exam 70-762 Developing SQL Databases
- Exam 70-764 Administrating a SQL Database Infrastructure
- Exam 70-461 Querying SQL Server 2012/2014
- Exam 70-462 Administrating SQL 2012/2014 Databases
- Exam 70-464 Developing SQL Databases
- Exam 70-465 Designing Database Solutions for SQL Server
- Exam DP-300 Azure Database Administrator Associate
- Exam DP-900 Microsoft Azure Data Fundamentals
- Exam DP-203 Azure Data Engineer Associate
- Familiarity with C#, JavaScript, HTML, CSS, JSON and Visual Studio to be able to understand how the applications work and be able to trouble-shoot issues at the source code level.
- Experience developing or supporting C# applications and working with IIS
- Experience working with MS-Access.
- Experience supporting/developing database systems.
- Familiarity with the principles of Capital Asset Management is a plus, but not expected; you will be trained.
- Microsoft Certified Solutions Associate 'MCSA' or MCSE including SQL Server certifications or other formal and certified training:
Education and Experience
- Bachelor's degree in Computer Science, Mathematics, Physics, Engineering or MCSA / MCSE with SQL certifications.
- Minimum 3 years experience with SQL Server, SSMS, TSQL, Query tuning & optimization, Performance monitoring and troubleshooting OR MCSA/MCSE certification (see list below).
Employment is conditioned upon the following:
- Pass a pre-employment drug screening.
- Proof of legibility to work in the United States.
- US Citizenship required
- Reside in the United States.
About Stantec, a great place to build your career: https://www.stantec.com/en/about
This description is not a comprehensive listing of activities, duties or responsibilities that may be required of the employee and other duties, responsibilities and activities may be assigned or may be changed at any time with or without notice.
Stantec is a place where the best and brightest come to build on each other's talents, do exciting work, and make an impact on the world around us. Join us and redefine your personal best.