Database Administrator Jr.

Gwinnett Technical College; United States; On-site; USD 70,000 - 82,000; Full time

Job summary

Gwinnett Technical College seeks a Database Administrator Jr. to support the Banner SIS and related DBMS environments. The role reports to the Database Administrator Sr. and is based at the Lawrenceville campus with occasional travel to Alpharetta North-Fulton.

Responsibilities include assisting with patches, upgrades, reports, user support, and day-to-day Banner operations while developing skills in SQL, Linux, and system administration in a busy educational setting.

Qualifications

• Certificate or Associates degree in a related field and one year of experience with DBMS design, implementation and support.
• OR one year of experience with DBMS design, implementation and support using Oracle, Microsoft SQL or other industry standard DBMS.

Responsibilities

• Develop deep understanding of the Banner SIS system.
• Assist in applying patches/upgrades to the Banner SIS.
• Support day-to-day Banner SIS operations and queries.
• Assist with generated reports and user training as needed.
• Collaborate with multiple departments to meet information needs.

Skills

Problem solving

Communication

Time management

Teamwork

Education

Certificate or Associates degree in related field

Tools

Ellucian Banner

SQL

Linux

Windows

PowerShell

Job description

Explore 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.

Agency: Gwinnett Technical College

Job Requisition ID: JR0000006547

Shift: Day (United States of America)

Compensation Details: $74,880.00/YR

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

Preferred Qualifications:

• Technical or functional experience with Ellucian Banner Student Information System
• A minimum of one year experience using Linux
• A minimum of one year experience using SQL
• Ability to manage multiple and time sensitive projects simultaneously
• Familiarity with current versions of Mac OS and Windows
• Experience developing scripts (Linux Shell or Windows PowerShell)
• A minimum of three years' experience assisting end-users in a technical or functional capacity.

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 attitude.
• Use 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 (5%) Develop a deep understanding of the Banner SIS system.
• Percentage of Time (5%) Assist in the integration of solutions using third party software into the Banner SIS.
• Percentage of Time (20%) Assist in applying patches/upgrades to the Banner SIS.
• Percentage of Time (5%) Communicate effectively between internal and external customers.
• Percentage of Time (10%) Assist Database Administrator with Banner SIS day-to-day operations.
• Percentage of Time (5%) Elicit requirements using interviews, business process descriptions, use cases, scenarios, and analysis.
• Percentage of Time (5%) Assist with generating scheduled and ad-hoc reports.
• Percentage of Time (5%) Assist with training and technical assistance to users.
• Percentage of Time (1%) Participate in implementation of project work plan and schedules for the development and support of systems.
• Percentage of Time (5%) 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.
• Percentage of Time (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.
• Percentage of Time (5%) Develop, maintain, and foster effective working relationships.
• Percentage of Time (5%) Manage one or more complex projects with full accountability for outcome.
• Percentage of Time (5%) Prepare project timelines, reports and other documents for management, staff, and outside customers as requested.
• Percentage of Time (1%) Assist in the development, review, revision, interpretation, and/or implementation of policies, procedures, standards, and guidelines.
• Percentage of Time (5%) Act as liaison between multiple parties to identify solutions to problems.
• Percentage of Time (5%) Analyze data, identifies gaps in plan verses actual, and recommends or implements solutions.
• Percentage of Time (1%) Oversee efficiency of projects and implements changes as needed to meet goals.
• Percentage of Time (5%) Maintain required documentation.
• Percentage of Time (5%) Provide user training and technical assistance.
• Percentage of Time (1%) Travel as required for meetings and training.

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.
• (C) Assessing the accuracy, neatness and thoroughness of the work assigned.

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.

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.

Equal Employment Opportunity Employer

The State of Georgia does not discriminate based on race, color, national origin, sex, religion, age, disability, or other protected categories in employment or the provision of services. Qualified applicants may request reasonable accommodation when needed during the application and/or screening process by contacting the appropriate agency Human Resources department.

Georgia State Government is a large enterprise, composed of various agencies and entities with a common goal to improve the lives of Georgia's 10 million citizens. With nearly 62,000 employees, we are one of the single largest employer in the state. Public service opportunities stretch across the state as employees live and work in all 159 counties. From traditional fields such as accounting, nursing, and engineering to unique fields like forestry and natural resources management, Georgia state government provides a world of opportunity.