Database Administrator Jr. – Banner Service

Georgia Department of Revenue•Lawrenceville, GA

5d•Onsite

About The Position

This full-time, benefitted position is in the Technology and Operations Division at Gwinnett Technical College and reports to the Database Administrator Sr. The role works primarily at the Lawrenceville campus and may occasionally work at the Alpharetta North-Fulton Campus. The position manages one or more projects with departments across the college and tracks progress toward established goals and objectives. It assists with managing databases to meet institutional information needs, including designing, securing, implementing, and maintaining the Ellucian Banner Student database management system. The employee is expected to maintain a consistent, high-quality, customer-focused approach when serving internal and external customers. The role supports Banner SIS operations, integrations, patches and upgrades, reporting, user assistance, and project work. It elicits requirements for automation tasks, helps develop and maintain database queries and procedures, and uses operating system and database tools to troubleshoot operational and integration issues. The position also maintains documentation, communicates with stakeholders, and contributes to the development and implementation of policies and procedures related to Banner Staff and Faculty Forms. Travel may be required for meetings and training. The position is scheduled for 40 hours per week.

Requirements

Certificate or associate degree in a related field and one year of experience working with DBMS design, implementation, and support using Oracle, Microsoft SQL, or another industry-standard DBMS; alternatively, one year of such DBMS experience without the listed credential.
Experience may substitute for certifications on a year-for-year basis.
Experience working with Windows Server, Linux, Oracle, SQL, and PL/SQL.
Ability to use operating system and database tools to troubleshoot and resolve operational and integration issues.
Ability to use SQL to build and maintain complex queries and procedures for data analysis and data extraction.
Ability to perform database and application builds in production and non-production environments using established methods and procedures, including SQL, PL/SQL, Ansible, and Shell Scripts.
Strong problem-solving skills and a self-starter attitude.
Excellent oral and written communication skills.
Excellent interpersonal relations and effective problem-solving methods.
Experience analyzing data and situations for accurate assessment.
Knowledge of the college philosophy and objectives as they relate to performance.
Ability to work effectively with minimal supervision.
Ability to provide direct support to users with varying technical abilities and explain technical concepts clearly to nontechnical users.
Ability to troubleshoot collaboratively, communicate effectively, identify and communicate issues proactively, and bring problems and potential risks to management's attention in a timely manner.
Ability to manage multiple and time-sensitive projects simultaneously.

Nice To Haves

At least two years of experience with Ellucian products such as Banner, Experience, Ethos, Banner Event Publisher, or Degree Works; experience obtained while a student does not count.
At least two years of experience using Linux.
At least two years of experience developing Oracle SQL queries.
Familiarity with current versions of Mac OS and Windows.
Familiarity with web application servers such as Apache Tomcat.
Familiarity with virtualization software such as VMware vSphere.
Familiarity with business intelligence tools such as Tableau.
At least two years of experience developing scripts in Linux Shell and/or Windows PowerShell.

Responsibilities

Develop a deep understanding of the Banner SIS system.
Assist with integrating third-party software solutions into the Banner SIS.
Assist with applying patches and upgrades to the Banner SIS.
Communicate effectively with internal and external customers.
Assist the Database Administrator with day-to-day Banner SIS operations.
Elicit requirements for Ellucian Banner automation tasks using interviews, business process descriptions, use cases, scenarios, and analysis.
Assist with generating scheduled and ad-hoc reports from Banner SIS.
Assist with training and providing technical assistance to users.
Participate in implementing project work plans and schedules for systems development and support.
Conduct research and prepare, assemble, process, or generate reports, processes, documentation, and responses to inquiries or requests concerning Banner and Blackboard.
Maintain knowledge of current developments in the field and apply relevant knowledge to job responsibilities.
Develop, maintain, and foster effective working relationships.
Manage one or more complex projects with accountability for outcomes.
Prepare project timelines, reports, and other documents for management, staff, and external customers as requested.
Assist in developing, reviewing, revising, interpreting, and implementing policies, procedures, standards, and guidelines related to Banner Staff and Faculty Forms.
Act as a liaison among multiple parties to identify solutions to problems.
Analyze data, identify gaps between plans and actual results, and recommend or implement solutions.
Oversee project efficiency and implement changes as needed to meet goals.
Maintain required documentation.
Travel as required for meetings and training.