Database Administrator Jr.

Georgia Department of Revenue•Lawrenceville, GA

3d•Hybrid

About The Position

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.

Requirements

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.
Experience may substitute for certifications on a year-for-year basis.
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
This position is a stationary position, often standing or sitting for prolonged periods with or without reasonable accommodation.
This position requires the ability to repeat motions that may include the wrists, hands and/or fingers with or without reasonable accommodation.
Assessing the accuracy, neatness and thoroughness of the work assigned.

Nice To Haves

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.
Requires operation, access, or control of financial resources.
Requires having a P-Card.
Driving is a responsibility of this position.
This position will have direct interaction or care of children under the age of 18 or direct patient care.
This position will have Security Access (e.g., public safety, IT security, personnel records, patient records, or access to chemicals and medications).
This position requires moving about to accomplish tasks or moving from one worksite to another with or without reasonable accommodation.
This position requires the ability to adjust or move objects up to 15 pounds in all directions with or without reasonable accommodation.
This position requires the ability to operate machinery and/or power tools with or without reasonable accommodation.
Operating motor vehicles or heavy equipment with or without reasonable accommodation.
Noisy environments.
Medium work that includes moving objects up to 50 pounds with or without reasonable accommodation.
Light work that includes moving objects up to 20 pounds with or without reasonable accommodation.
Heavy work that includes moving objects up to 100 pounds or more with or without reasonable accommodation.
Work in outdoor elements such as precipitation and wind.

Responsibilities

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