The Database, Application & Web (DAW) Specialist is responsible for database management, application and web development and maintenance of web infrastructure, database design and applications. The DAW Specialist will design, maintain, and constantly improve our Drupal & database environments. This position will also collaboratively develop and train with the central Drupal & DBM teams to improve the overall end user and guest experiences.
This position will work closely with all departments of the Arboretum to support each department’s web presence and database needs. It will work closely with CFANS and central University of Minnesota Offices of Information Technology on various web projects and mass emails to continually build on and improve the performance of our site KPIs and ensure a positive user experience for staff, donors, visitors and guests.
The DAW Specialist is responsible for collaboratively implementing the Minnesota Landscape Arboretum’s online vision for outreach, research, and education via creative use and integration of University-supported tools and data.
Successful candidates must be self-motivated and creative problem-solver with experience and skills in backend CMS (Drupal) development, advanced web coding, database management and application development.
This is a full-time, 12-month position with benefits. Salary range: $58,000-$65,000, depending on qualifications.
Overview of Responsibilities
Web Manager (Full-Stack development and web design) (30%)
Responsible for designing and implementing new features and functionality, establishing and guiding the website’s architecture, ensuring high-performance and availability, and managing all technical aspects of the CMS. Works closely with Marketing team ensure an effective, visually appealing, and intuitive implementation.
Testing, maintenance and troubleshooting of existing organizational sites
Stays up-to-date on the U of M’s Drupal Platform, informs the Arboretum of relevant new technologies or changes, and passes feedback to central Drupal team on the Arboretum’s needs
Develops and maintains technical documentation for CMS implementation, applications, and relevant business processes. Train users and team members as necessary.
Evaluates, recommends, and implements web infrastructure/platform changes and improvements.
Conduct a full range of programming tasks which include program design, program coding, debugging, and documentation for the Arboretum’s websites; review application modules for quality assurance and checks compliance with application architecture standards.
Develop and collaborate on concepts, wireframes and prototypes for interactive/screen-based experiences based on organizational goals and audience insights; implement these concepts using strong design that presents content effectively.
Refine existing styles and tools or create new ones to fit user needs, provide ongoing maintenance of applications, systems, websites, and tools; make decisions to meet the needs of the individual site and work across the system to be sustainable and consistent.
Undertake special projects as they arise, such as special webpages and microsites to support Arboretum initiatives, interactive user features, and enhancement to increase search engine optimization.
Web Application Development & Support (30%)
Perform general server and database administration tasks (in collaboration with IT Manager).
Informs decisions on Arboretum’s web system architecture, configuration, web services, and applications infrastructure
Ensures Arboretum and University security and stability requirements are met regarding web and applications management.
Develop internal web applications to interact with and manage large databases and systems.
Monitor how the content and design is working on the overall college-wide system of websites, with a focus on effective web and visual design, web contributor needs, user experience, usability and accessibility.
Maintains specific online and business applications, primarily using the .NET framework.
Provides expertise to project teams on complex technical design and systems integration projects.
Fosters IT partnerships and relationships throughout the University to continue to streamline Arboretum operations by leveraging central resources.
Research new ideas and methods; stay aligned with best practices.
Improve the theme and suite of tools by listening to needs of digital team and people contributing content; identify and suggest solutions.
Complete other technology-related tasks as assigned.
Ensure responsive design is applied well across all Arboretum sites, including departments and centers.
Database Development & Maintenance (30%)
Developing and optimizing SQL statements, stored procedures and views using industry best practices for security and efficiency.
Interact with vendor to analyze source system data to understand the data structure, definitions and anomalies.
Performance optimization, including query tuning, process structuring / scheduling, schema adjustments, code refinements, and scaling analysis.
Support existing applications and databases and serve as a resource for customer questions and problem resolution.
Remediate failures of automated jobs quickly.
Monitor systems to ensure DMS applications and databases are running at peak performance.
Assist in the research and selection of tools, products and frameworks as necessary to support business initiatives.
Assist in ETL design and development efforts, making sure that the business rules are implemented correctly and clarifying issues as they arise.
Project Management (10%)
Develops strong relationships to aid in understanding the varying needs around a project. Applies gathered requirements to web and application based solutions.
Ensures the Arboretum’s application projects are developed effectively and efficiently, using unambiguous project goals and expectations, and ensuring input and feedback from all stakeholders
Manages any outsourced application and database development.
Document and test work, such as testing across multiple browsers and devices and other quality control efforts.
Communicate frequently with communication and design team members on the needs of the Arboretum web community; contribute to training development and documentation. For most Arboretum web contributors, their web role is a small part of their overall duties. The role of this position is to make the Arboretum system and tools easy to use and provide training as needed.
Provide user support and customer service, working with team members to troubleshoot issues when they arise.
Work to continuously improve and evolve how we deliver and manage our web presence and infrastructure, staying current with trends in web design and development; regularly assess processes, make recommendations to improve efficiency.
Engage in U of M web/Drupal community.
BA/BS degree in MIS, computer science, or a closely related field and two years of professional experience in web development, application development and database management (or equivalent experience) or four years experience in areas of application/web/systems development with a non related BA/BS Degree
Ability to Write SQL queries used to analyze data and to populate reports/dashboards.
Strong SQL (Structured Query Language) and data extraction skills
Experience with DMS Systems.
Demonstrated experience in prioritizing, following through, and working independently under tight deadlines.
Demonstrated excellent oral and written communication skills to include proofreading, spelling, and grammar on telephone, email, and face-to face.
Demonstrated commitment to the promotion of diverse and inclusive working and/or learning environments
Demonstrated ability to work effectively with individuals from diverse communities and cultures.
Experience developing for and contributing to a Drupal CMS.
Experience optimizing physical designs for maximum query performance.
Experience in SQL design and implementation.
Experience with Oracle 11
Experience with Financial Edge
Experience with Raiser’s Edge
Experience managing Github repositories for revision control and collaboration
Experience with XML, RSS feeds, social media APIs, REST
Experience with Designing and developing reports/dashboards
Demonstrable knowledge, understanding, and/or experience in web application development preferably using PHP.
Experience using task management applications such as ServiceNow.
Experience working in a botanical garden, higher education setting and/or other large public arts and entertainment destinations.
Experience or strong knowledge of the University policies and procedures related to Arboretum environment
Experience training colleagues, volunteers and/or student workers.
Experience providing guidance and advice to colleagues, asking questions to understand the situation, help prioritize the needs, and determine best path forward.
Proven ability to work independently.
Successful problem solving and decision making skills.
Internal Number: 327234
About University of Minnesota, Twin Cities
The University of Minnesota, founded in the belief that all people are enriched by understanding, is dedicated to the advancement of learning and the search for truth; to the sharing of this knowledge through education for a diverse community; and to the application of this knowledge to benefit the people of the state, the nation, and the world.