Database Administrator Jr

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!

This job is a full-time benefitted position in the Technology and Operations Division that reports to the Database Administrator Sr.

This is a 40hr position that works primarily at the Lawrenceville campus but may occasionally work on the Alpharetta North-Fulton Campus

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.

• 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 Power Shell)
• A minimum of three years’ experience assisting end-users in a technical or functional capacity.

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

• 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

• Develop a deep understanding of the Banner SIS system. (5%)
• Assist in the integration of solutions using third party software into the Banner SIS. (5%)
• 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. (5%)
• Assist with generating scheduled and ad-hoc reports. (5%)
• Assist with training and technical assistance to users. (5%)
• 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. (5%)
• 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…