Database Developer - Vista Viewpoint
Database Developer This role is full remote - work from home.
Required Skills:
Vista database; Viewpoint ERP; T-SQL; data management; SQL permissions; data modeling
Job Duties:
- Perform requirements gathering, design, development, testing and implementation functions
- Develop scripts, procedures and triggers for legacy ERP conversions and data migrations
- Create or modify database objects such as views, functions, stored procedures and triggers
- Writing optimized queries for integrations with other applications
- In-depth understanding of data management including SQL permissions, security, monitoring and data modeling
- Coordinate with the Development Manager and System Administrators to maintain stable and reliable databases
- Work with developer team to establish best practices for database storage and organization
- Respond to support requests for bugs & issues reported
- Evaluate and recommend changes to current and future database products and services
Job Requirements:
- 3+ years of demonstrated work experience as a Database Developer
- Extensive experience writing code in T-SQLExperience with Viewpoint Vista database required
- In-depth understanding of data management including SQL permissions, security, monitoring and data modeling
- Bachelor's degree in management information systems, Computer Science/Engineering, or a related discipline
Desired Skills & Experience:
Experience with other construction ERP databases (SAP, JDE, Sage, Spectrum, CMiC) - NOTE: does not negate the required experience with Vista Viewpoint Heavy construction related experience
Required Skills: SSIS, Oracle