Master's degree with 3 years of IT experience, or Bachelor's with 6 years, or Associate's with 10 years in a relevant role.
Fundamental understanding of relational database design and administration.
Experience with SQL performance analysis, tuning, and related technologies.
Effective verbal and written communication skills.
Ability to work with diverse customers and maintain a focus on equity and inclusion.
Demonstrated organizational skills and attention to detail.
Ability to explain technical concepts to non-technical users.
Responsibilities
Develop and support ERP (Workday) and custom solutions for the College.
Utilize ASP.net and PeopleTools for creating secure and efficient solutions.
Collaborate with users to optimize processes through configuration rather than customization.
Monitor systems for integrity, performance, and availability.
Manage relationships with key users and provide infrastructure support.
Oversee project plans, ensuring timely execution and quality deliverables.
Document and maintain all support requests and solutions.
Benefits
Professional development opportunities.
Access to cutting-edge technology and tools.
Collaborative work environment focused on student success.
Flexible work hours as needed.
Participation in user groups for knowledge sharing.
Full Job Description
Position Title: Lead Software Developer
Job Summary:
The Software Developer is accountable for the configuration, customization, administration, and maintenance of strategic ERP (Workday), document imaging and management, Customer Relation Management, Collaboration, and custom-developed solutions at the College. The Software Developer understands ERP technology and software trends at a strategic level; is versant in implementing new technologies; architects, creates, maintains, upgrades, and monitors systems for optimal availability and performance; and troubleshoots systems issues at their root cause. This role reports to the Director, Application Development.
Job Description:
ESSENTIAL JOB FUNCTIONS
Independently performs all of the following tasks or supervises others in the performance of all of the following tasks:
Systems Development and Maintenance: 50%
Accountable for the development and support of ERP (Workday), document imaging, collaboration and customer relation management solutions and custom-built solutions at the College.
Uses the College's standard development tools, such as ASP.net and PeopleTools, to create sustainable, maintainable, secure, privacy-sensitive, efficient, and effective solutions.
Creates solutions that leverage enterprise database solutions through the use of SQL and other standard database interfaces.
Understands and, as needed, is able to reverse engineer ERP code in order to troubleshoot, customize, and integrate with other solutions in use at the College.
Creatively collaborates and consults with key users to find effective means to operate the College's processes through configuration rather than customization of solutions.
Creates and manages complex configuration of ERP-related solutions, with a creative ability to address the College's unique needs without resorting to customization.
As needed, is able to build customizations of solutions when configuration does not address the College's needs.
Uses the College's preferred scripting and job scheduling solutions to create automations and extracts from solutions that meet the needs of other departments.
Creates and maintains the strategy, standards, planning, and execution of solutions, including software, updates, patches, and licenses.
Maintains subject matter expertise in solutions, including the knowledge, skills, and desire to optimize the use of all features of the solutions to maximize their benefit to the College.
Accountable for the expert installation, configuration, and maintenance of the solution on servers along with images to be installed on desktops.
Administers user access to the solution or works with Technology Support team to create and maintain access according to the College's policies and procedures, creating, changing and deleting user access and accounts per request.
Monitors, responds to, and mitigates security threats related to solutions in collaboration with the College's cybersecurity experts.
Manages the backup, storage, and restoration of configurations, access, and data related to solutions in accordance with the College's policies and procedures.
Ensures restores from backed up systems are possible.
Creates and maintains solution documentation, such as systems diagrams and configurations, processes and procedures.
Consistently monitors systems for integrity, performance, and availability.
Support and Consulting: 20%
Creates, manages, and facilitates relationships with key users of ERP solutions and custom applications in use at the College.
Maintain application/web servers compatible with PeopleSoft and our Unix and windows environments.
Update web logic to newer version with patches and ensure that the application servers can communicate with each other using secure network protocols
Provide infrastructure support by troubleshooting application/web server issues and communication issues between application servers
Expertly consults with key users to create clear expectations and requirements documents prior to configuration or customization of solutions.
Addresses issues at their root level, using creative problem-solving techniques to achieve high-quality, highly efficient, highly effective resolutions.
Proactively identifies potential issues and resolves them before they become an issue.
Appropriately escalates issues to vendors and other College teams after an appropriate time or when issues require further expertise.
Able to interact positively with both internal and external partners to achieve high satisfaction in both consulting and problem resolution situations
Accurately documents and maintains all support requests and efforts in the ticket management system.
Ensures support tickets are appropriately transferred, escalated, and closed.
Keeps customers updated on the status of their open incidents.
Ensures that customers are satisfied upon ticket closure.
Project Management: 20%
Manages consultants and their performance on projects that make use of third party consultants. Able to manage multiple projects at once.
Executes project plans according to schedule, with attention to communication, risk management, training, and ongoing support and maintenance; setting and meeting expectations for project progress and completion; and ensuring that project deliverables are complete, sufficient, and of high quality.
Manages implementation of technology solutions, including the following elements: Architecture and Design Stakeholder communication Risk management
Qualities of service, such as Security, Accessibility, Performance, Availability, Disaster Recovery and Business Continuity, Manageability, and Monitoring.
Ongoing budget Education and training Support Identifies, categorizes, and prioritizes the College's ERP and customized solution needs, and researches, assesses, selects, acquires, and implements technology solutions that best satisfy those needs.
Other: 10%
Keeps track of and manages hardware and software maintenance agreements to ensure optimal value of solutions to the College.
Manages solution providers and vendors according to a balanced scorecard to ensure high levels of collaboration, performance, and value.
Participates in user groups associated with solutions administered by the position in such a way as to maximize knowledge of strategic leverage of the solutions, value from the solution and its provider, and skills for performing solution administration.
Fundamental level understanding of the administration, configuration, management, and troubleshooting of enterprise solutions, including, but not limited to those related to ERP, document imaging and management, and collaboration.
Maintains and shares subject matter expertise, staying current on industry trends and emerging technologies, identifying opportunities for further research, establishing and maintaining relationships with industry and professional colleagues, and attending conferences and seminars in order to recommend new solutions in service of student success and faculty and staff effectiveness and efficiency, while enhancing systems design, usage, security, performance, and availability.
Provides a consistent stream of new ideas to enhance the College's systems.
Assists in the development of IT processes and procedures.
Proactively works with members of other departments to identify and implement key opportunities for operational improvements, especially with regards to processes and leverage of data/information.
Performs other duties of a similar nature or level.
MINIMUM QUALIFICATIONS - The following qualifications are required:
Masters Degree with three (3) years of experience in an Information Technology role, at least three (3) years of which were in a role specific to this discipline OR Bachelor's degree with six (6) years of experience in an Information Technology role, at least four (4) years of which were in a role specific to this discipline OR Associate's degree with ten (10) years of experience in an Information Technology role, at least six (6) years of which were in a role specific to this discipline
Fundamental level understanding of the design, maintenance, and administration of relational databases.
Fundamental level understanding of physical and logical database design in an enterprise database platform.
Fundamental level understanding of of SQL performance analysis and tuning, log shipping, replication, SQL clustering, scalability and reliability issues, Transact-SQL scripting, SQL Server Integration Services (SSIS/DTS), SQL Server Reporting Services, bulk copy programs (BCP), and Open Database Connectivity (ODBC).
Knowledge of performance tuning, backup & recovery methods in DB2 & SQL Server platforms.
Effective and polished verbal and written communication skills
Ability to work effectively with a wide range of customers and a focus on diversity, equity, and inclusion
Committed to keeping up-to-date with the ever-changing technology landscape. Reflect a positive, high-energy and professional demeanor
Demonstrated ability to work well on and improve the performance of a team
Demonstrated ability to prioritize and deliver according to deadlines while handling multiple tasks, ability to exercise judgment, handle confidential information, and function with minimal supervision
Demonstrated excellent organizational abilities and attention to detail
Ability to cogently explain technical concepts and procedures to non-technical users
Ability to problem-solve, analyze information to make informed decisions and/or recommendations
Ability to apply principles of logical thinking to a wide range of intellectual and practical problems.
Ability to work nights and weekends as needed.
DESIRED QUALIFICATIONS - The following qualifications are desired:
Bachelors degree or higher in an Information Technology-related field
Experience administering databases in a PeopleSoft (9.2 or above) environment
Experience administering MS SQL Server, DB2, and Oracle databases
Ability to automate activities through the use of scripts in languages such as PowerShell, Python, and JavaScript.
Higher Education experience ideally in a community college setting
An innate focus on students and their success
Demonstrated ability to build and maintain strong relationships with internal and external stakeholders.
Strong analytical skills.
An interest in improving existing processes and procedures on a continual basis.