Lead Software Developer

Job Summary

The Software Developer is accountable for the configuration, customization, administration, and maintenance of strategic ERP, document imaging and management, Customer Relation Management, Collaboration, and custom-developed solutions at the College.

The Lead 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.

Why choose the College of Lake County for your next opportunity? The College of Lake County (CLC) offers a competitive salary, excellent benefits that includes Blue Cross Blue Shield of Illinois health, Delta Dental and Superior Vision insurance plans, tuition support for employees and qualified family members, three retirement plans, disability, group and supplemental life insurance, health and dependent care flexible spending account plans, a compressed work week in the summer (Closed Fridays!!), generous vacation, sick and personal time off and 14 paid holidays each year.

Some benefits will not be available for part-time employees (ex : health insurance).

CLC is a comprehensive community college located in northeastern Illinois committed to being an innovative educational institution providing life-changing paths for our students by offering exceptional learning experiences.

CLC achieved a milestone in 2023 with its designation as a Leader College. This national recognition awarded by the Achieving the Dream Network is the result of improved student outcomes through the CLC’s relentless commitment to transformational change and the implementation of innovative practices within the student success model over the past few years.

CLC aspires to be a place where every student succeeds, every employee thrives, so that every business achieves and every community grows.

Our mission is to be innovative and value-driven in supporting student success through developing and encouraging employees of all backgrounds on their journey toward achieving personal and professional growth. Required Qualification(s)

• Master’s Degree with three years of experience in an Information Technology role, at least three years of which were in a role specific to this discipline OR Bachelor’s Degree with six years of experience in an Information Technology role, at least four years of which were in a role specific to this discipline OR Associates Degree with ten years of experience in an Information Technology role, at least six 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 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 Qualification(s)

• Bachelor’s degree or higher in an Information Technology-related field
• Experience working with Workday Technologies
• 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.
• Ability to manage projects as needed.
• Bilingual in Spanish / English

Summary of Essential 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, 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, Workday Technologies 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 DesignStakeholder communicationRisk managementQualities of service, such as Security, Accessibility, Performance, Availability, Disaster Recovery and Business Continuity, Manageability, and Monitoring.

Ongoing budgetEducation and trainingSupport

Identifies, categorizes, and prioritizes the College’s ERP and customized solution needs, and research, 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.
19 days ago