Database Administrator Jr. – Banner Service

Georgia Power Company; Lawrenceville (GA); On-site; USD 64,000 - 86,000; Full time

Job summary

State of Georgia is seeking a Jr. Database Administrator to support the Banner SIS at the Lawrenceville campus, with potential travel to Alpharetta North-Fulton Campus. This 40-hour-per-week role reports to the Database Administrator Sr.

The position emphasizes DBMS design, implementation, and support using Oracle and Microsoft SQL. Minimum qualifications include a certificate or associate degree and one year of experience; preferred candidates have Banner experience, Linux proficiency, and

Qualifications

• Certificate or Associate degree in a related field and one year of experience with DBMS design, implementation and support using Oracle, Microsoft SQL or other industry standard DBMS.
• Two years’ experience with Ellucian Banner products such as Banner, Experience, Ethos, Banner Event Publisher, Degree Works.
• Experience with Linux and developing Oracle SQL queries.
• Ability to manage multiple projects and work with minimal supervision.
• Strong communication and ability to explain technical concepts to nontechnical users.

Responsibilities

• Develop deep understanding of the Banner SIS system.
• Assist in patches/upgrades to the Banner SIS.
• Assist with day-to-day Banner SIS operations and reporting.
• Communicate effectively with internal and external customers.

Skills

DBMS design

SQL queries

End-user support

Troubleshooting

Independent work

Education

Certificate or Associate degree

Tools

Ellucian Banner

Oracle

Microsoft SQL

Linux

Tableau

VMware Vsphere

Apache Tomcat

PowerShell

Ansible

PL/SQL

Job description

Database Administrator Jr. – Banner Service# Team Georgia Careers## Database Administrator Jr. – Banner ServiceApply: Lawrenceville: Full time: Posted Today: JR0000007531Explore a World of Opportunity with the State of Georgia!We are the force that drives Georgia! Georgia State Government is a large enterprise, composed of various agencies and entities with a common goal to improve the lives of Georgia's more than 10 million citizens! Join Team Georgia and impact lives everyday while receiving a robust benefits package designed for every stage of your career! **Job Title:**Database Administrator Jr. – Banner Service**Agency:**Gwinnett Technical College**Job Requisition ID:**JR0000007531**Shift:**Not Applicable (United States of America)**Compensation Details:**$74,880.00/YR**Job Description:****Employment Terms:** This job is a **full-time** benefitted position in the Technology and Operations Division that reports to the Database Administrator Sr.**Schedule:**This is a 40hr position that works primarily at the Lawrenceville campus but may occasionally work on the Alpharetta North-Fulton Campus. **Minimum Qualifications (Job Code A1706):** Certificate \\*OR\\* Associates degree in a related field \\*and\\* one (1) year of experience working with DBMS design, implementation and support using Oracle, Microsoft SGL, or other industry standard DBMS \\*OR\\* one (1) year of experience working with DBMS design, implementation and support using Oracle, Microsoft SQL or other industry standard DBMS. Note: Experience may substitute for certifications on a year-for-year basis.**Preferred Qualifications:*** A minimum of two years’ experience with Ellucian products such as Banner, Experience, Ethos, Banner Event Publisher, Degree Works (not including any experience obtained while a student)* A minimum of two years’ experience using Linux* A minimum of two years’ experience developing Oracle SQL queries* Ability to manage multiple and time sensitive projects simultaneously* Demonstrated ability to work independently with minimal supervision, proactively identify and communicate issues, and take initiative to ensure problems and potential risks are brought to management’s attention in a timely manner.* Demonstrated technical proficiency combined with experience providing direct support to end users of varying technical abilities. Ability to explain technical concepts in clear, understandable terms, troubleshoot issues collaboratively, and communicate effectively with nontechnical users.* 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* A minimum of two years’ experience developing scripts (Linux Shell and/or Windows PowerShell) **Job Description Summary:** This position manages one or more projects in collaboration with departments across the college and tracks progress toward established goals and objectives. Assists with management of multiple databases to meet the information needs of the institution including designing, securing, implementing, and maintaining the Ellucian Banner Student database management system (DBMS). Employee is responsible for maintaining a consistent, high quality, customer-focused orientation when conducting business and providing services to all internal and external customers. **Competencies:*** Demonstrate strong problem-solving skills and self-starter attitudeUse operating system and database tools to troubleshoot and resolve operational and integration issues.* Use SQL to build and maintain complex queries/procedures for data analysis and data extraction.* Perform database and application builds in various production and non-production environments using established methods and procedures (SQL, PL/SQL, Ansible, Shell Scripts).* Experience working with Windows Server, Linux, Oracle, SQL, PL/ SQL.* Excellent Oral and written communication.* 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 **Duties/Responsibilities****Percentage of Time**· * Develop a deep understanding of the Banner SIS system.(10%)* Assist in the integration of solutions using third party software into the Banner SIS. (10%)* Assist in applying patches/upgrades to the Banner SIS. (20%)* Communicate effectively between internal and external customers. (5%)* Assist Database Administrator with Banner SIS day-to-day operations. (10%)* Elicit requirements using interviews, business process descriptions, use cases, scenarios, and analysis for automation tasks involving Ellucian Banner. (20%)* Assist with generating scheduled and ad-hoc reports from Banner SIS. (10%)* Assist with training and technical assistance to users. (2%)* Participate in implementation of project work plan and schedules for the development and support of systems. (1%)* Conduct complex and/or comprehensive research using a variety of resources to complete, prepare, assemble, process and/or generate reports, processes, and other documentation, or to respond to inquiries, questions, problems, or requests for Banner and Blackboard. (1%)* Maintain knowledge of current trends and developments in the field by reading appropriate books, journals, and other literature and attending related seminars and conferences; applies pertinent new knowledge to performance of responsibilities. (1%)* Develop, maintain, and foster effective working relationships. (1%)* Manage one or more complex projects with full accountability for outcome. (1%)* Prepare project timelines, reports and other documents for management, staff, and outside customers as requested. (1%)* Assist in the development, review, revision, interpretation, and/or implementation of policies, procedures, standards, and guidelines as they pertain to Banner Staff & Faculty Forms. (1%)* Act as liaison between multiple parties to identify solutions to problems. (1%)* Analyze data, identifies gaps in plan verses actual, and recommends or implements solutions. (1%)* Oversee efficiency of projects and implements changes as needed to meet goals. (1%)* Maintain required documentation. (1%)* Provide user training and technical assistance (1%)* Travel as required for meetings and training. (1%) **Physical Demands:** **Frequency**(N)Never, (O)Occasionally or (C)Constantly* Requires operation, access, or control of financial resources.(N)* Requires having a P-Card.(N)* Driving is a responsibility of this position.(O)* This position will have direct interaction or care of children under the age of 18 or direct patient care. (N)* This position will have Security Access (e.g., public safety, IT security, personnel records, patient records, or access to chemicals and medications).(O)* This position is a stationary position, often standing or sitting for prolonged periods with or without reasonable accommodation. (C)* This position requires moving about to accomplish tasks or moving from one worksite to another with or without reasonable accommodation. (N)* This position requires the ability to adjust or move objects up to 15 pounds in all directions with or without reasonable accommodation. (N)* This position requires the ability to repeat motions that may include the wrists, hands and/or fingers with or without reasonable accommodation. (C)* This position requires the ability to operate machinery and/or power tools with or without reasonable accommodation. (N)* Operating motor vehicles or heavy equipment with or without reasonable accommodation. (N)* Noisy environments. (N)* Medium work that includes moving objects up to 50 pounds with or without reasonable accommodation. (N)* Light work that includes moving objects up to 20 pounds with or without reasonable accommodation. (N)* Heavy work that includes moving objects up to 100 pounds or more with or without reasonable accommodation. (N)* Work in outdoor elements such as precipitation and wind. (N)* Assessing the accuracy, neatness and thoroughness of the work assigned. (C) **Applications are reviewed on a rolling basis, and Human Resources may begin scheduling interviews as applications are received. This position will remain open until a successful candidate has been selected and hired. Applicants are encouraged to apply as early as possible, as the interview process may begin before all applications are reviewed. Only candidates selected for further consideration will be contacted for an interview. Submission of an application does not guarantee an interview.***As set forth in its student catalog, Gwinnett Technical College complies with the Technical College System of Georgia (TCSG). The TCSG State Board prohibits discrimination on the basis of an individual’s age, color, disability, genetic information, national origin, race, religion, sex, or veteran status (“protected status”). No individual shall be excluded from participation in, denied the benefits of, or otherwise subjected to unlawful discrimination, harassment, or retaliation under, any TCSG program or activity because of the individual’s protected status; nor shall any individual be given preferential treatment because of the individual’s protected status, except the preferential treatment may be given on the basis of veteran status when appropriate under federal or state law. The following person has been designated to manage inquiries regarding the non-discrimination policies: Lisa Richardson, Title IX, and Section 504 Coordinator, 5150 Sugarloaf Parkway, Building 100/A, Room 515, Lawrenceville, GA 30043, 678-226-6691,* *[e-mail]**.***Minimum Qualifications:**Certificate \\*OR\\* Associates degree in a related field \\*and\\* one (1) year of experience working with DBMS design, implementation and support using Oracle, Microsoft SGL, or other industry standard DBMS \\*OR\\* one (1) year of experience working with DBMS design, implementation and support using Oracle, Microsoft SQL or other industry standard DBMS.--Note: Experience may substitute for certifications on a year-for-year basis.