Lead Database Administrator

The Lead Database Administrator is accountable for the maintenance of the College’s enterprise-wide data. The Lead Database Administrator understands database technology and 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., Independently performs all of the following tasks or supervises others in the performance of all of the following tasks:

Systems Development and Maintenance: 50%

\u2022 Administers, configures, tunes, and maintains both enterprise-wide and solution-specific database systems for the College, including MS SQL Server, DB2, and Oracle.

\u2022 Administers both locally and cloud-based databases with a focus on highly performing, highly available, and highly secure solutions.

\u2022 Uses the College’s standard development tools, such as ASP.net and PeopleTools, to create sustainable, maintainable, secure, privacy-sensitive, efficient, and effective solutions.

\u2022 Creates solutions that leverage enterprise database solutions through the use of SQL and other standard database interfaces.

\u2022 Uses the College’s preferred scripting and job scheduling solutions in both databases, such as MS SQL Server, DB2, and Oracle, and operating systems, such as Windows Server and Unix, to create automations and extracts from solutions that meet the needs of other departments.

\u2022 Administers operating systems, including Unix and Windows Server, to achieve the database needs of the College.

\u2022 Creates and maintains the strategy, standards, planning, and execution of database solutions, including software, updates, patches, and licenses.

\u2022 Maintains subject matter expertise in databases, including the knowledge, skills, and desire to optimize the use of all features of the solutions to maximize their benefit to the College.

\u2022 Accountable for the expert installation, configuration, and maintenance of databases on servers along with images to be installed on desktops.

\u2022 Administers user access to data 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.

\u2022 Monitors, responds to, and mitigates security threats related to data in collaboration with the College’s cybersecurity experts.

\u2022 Manages the backup, storage, and restoration of configurations, access, and data related to database solutions in accordance with the College’s policies and procedures.

\u2022 Ensures restores from backed up systems are possible.

\u2022 Creates and maintains database documentation, such as systems diagrams and configurations, processes and procedures.

Support and Consulting: 20%

\u2022 Creates, manages, and facilitates relationships with key users of database solutions in use at the College.

\u2022 Expertly consults with key users to create clear expectations and requirements documents prior to configuration or customization of databases.

\u2022 Addresses issues at their root level, using creative problem-solving techniques to achieve high-quality, highly efficient, highly effective resolutions.

\u2022 Proactively identifies potential issues and resolves them before they become an issue.

\u2022 Appropriately escalates issues to vendors and other College teams after an appropriate time or when issues require further expertise.

\u2022 Able to interact positively with both internal and external partners to achieve high satisfaction in both consulting and problem resolution situations

\u2022 Accurately documents and maintains all support requests and efforts in the ticket management system.

\u2022 Ensures support tickets are appropriately transferred, escalated, and closed.

\u2022 Keeps customers updated on the status of their open incidents.

\u2022 Ensures that customers are satisfied upon ticket closure.

Project Management: 20%

\u2022 Manages consultants and their performance on projects that make use of third party consultants.

\u2022 Able to manage multiple projects at once.

\u2022 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.

\u2022 Manages implementation of technology solutions, including the following elements:

o Architecture and Design

o Stakeholder communication

o Risk management

\u2022 Qualities of service, such as Security, Accessibility, Performance, Availability, Disaster Recovery and Business Continuity, Manageability, and Monitoring.

\u2022 Ongoing budget Education and training Support Identifies, categorizes, and prioritizes the College’s database needs, and researches, assesses, selects, acquires, and implements technology solutions that best satisfy those needs.

Other: 10%

\u2022 Keeps track of and manages hardware and software maintenance agreement to ensure optimal value of database solutions to the College.

\u2022 Manages solution providers and vendors according to a balanced scorecard to ensure high levels of collaboration, performance, and value.

\u2022 Participates in user groups associated with database 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.

\u2022 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.

\u2022 Provides a consistent stream of new ideas to enhance the College’s systems.

\u2022 Assists in the development of IT processes and procedures.

\u2022 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.

\u2022 Performs other duties of a similar nature or level.

u2022 Masters 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 Bachelors 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 Associate’s 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

\u2022 Fundamental level understanding of the design, maintenance, and administration of relational databases.

\u2022 Fundamental level understanding of physical and logical database design in an enterprise database platform.

\u2022 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).

\u2022 Knowledge of performance tuning, backup & recovery methods in DB2 & SQL Server platforms.

\u2022 Effective and polished verbal and written communication skills

\u2022 Ability to work effectively with a wide range of customers and a focus on diversity, equity, and inclusion

\u2022 Committed to keeping up-to-date with the ever-changing technology landscape.

\u2022 Reflect a positive, high-energy and professional demeanor

\u2022 Demonstrated ability to work well on and improve the performance of a team

\u2022 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

\u2022 Demonstrated excellent organizational abilities and attention to detail

\u2022 Ability to cogently explain technical concepts and procedures to non-technical users

\u2022 Ability to problem-solve, analyze information to make informed decisions and/or recommendations

\u2022 Ability to apply principles of logical thinking to a wide range of intellectual and practical problems.

\u2022 Ability to work nights and weekends as needed.

MINIMUM QUALIFICATIONS - The following qualifications are required:

\u2022 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 Bachelors 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

\u2022 Fundamental level understanding of the design, maintenance, and administration of relational databases.

\u2022 Fundamental level understanding of physical and logical database design in an enterprise database platform.

\u2022 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).

\u2022 Knowledge of performance tuning, backup & recovery methods in DB2 & SQL Server platforms.

\u2022 Effective and polished verbal and written communication skills

\u2022 Ability to work effectively with a wide range of customers and a focus on diversity, equity, and inclusion

\u2022 Committed to keeping up-to-date with the ever-changing technology landscape.

\u2022 Reflect a positive, high-energy and professional demeanor

\u2022 Demonstrated ability to work well on and improve the performance of a team

\u2022 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

\u2022 Demonstrated excellent organizational abilities and attention to detail

\u2022 Ability to cogently explain technical concepts and procedures to non-technical users

\u2022 Ability to problem-solve, analyze information to make informed decisions and/or recommendations

\u2022 Ability to apply principles of logical thinking to a wide range of intellectual and practical problems

DESIRED QUALIFICATIONS - The following qualifications are desired:

\u2022 Bachelors degree or higher in an Information Technology-related field

\u2022 Experience administering databases in a PeopleSoft (9.2 or above) environment

\u2022 Experience administering MS SQL Server, DB2, and Oracle databases

\u2022 Ability to automate activities through the use of scripts in languages such as PowerShell, Python, and JavaScript.

\u2022 Higher Education experience ideally in a community college setting An innate focus on students and their success

\u2022 Demonstrated ability to build and maintain strong relationships with internal and external stakeholders.

\u2022 Strong analytical skills.

\u2022 An interest in improving existing processes and procedures on a continual basis.

\u2022 Ability to manage projects as needed.

\u2022 Bilingual in Spanish and English.

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 or Part Time Staff Under 20 Hours (ex: health insurance).

We value candidates who bring language skills that help us better serve and connect with our diverse community. Bilingual English/Spanish proficiency is preferred but not required.