Job Title: Database Administrator Adv Entry Location: System Office-Athens Regular/Temporary: Regular Full/Part Time: Full-Time Job ID: 250380 About Us
The University System of Georgia (USG) is comprised of 26 higher education institutions as well as the University System Office (USO). Within the USO, our administrative operations are primarily housed in the Trinity Washington Building located in downtown Atlanta. Our Information Technology Services (ITS) division is located in Athens. The University System of Georgia Shared Services Center (SSC) is located in Sandersville. The Georgia Public Library System is located in Atlanta. The Georgia Archives is located in Morrow. The State of Georgia Records Center is located in Austell.
This is a professional position involving project and end user support of administrative information systems within a group of Database Administrators responsible for ensuring that service goals and objectives are accomplished within prescribed time parameters, within budget, while taking a holistic approach to the integration of the applications. This position will be part of a team that works with one or more of several databases, application servers and Business intelligence systems. The software supported may include Oracle WebLogic, Oracle Databases, as well as other products as required to support the enterprise systems and services. This position will interact with other teams that support associated integrated systems and will support the development and business analyst teams. Provide direct, hands-on support for the installation, integration, testing, and maintenance of other select administrative systems, in-house applications and/or related databases. This entry level position also provides support to the functional business analysts in resolving end-user issues at the 28 campuses on PeopleSoft.
Work closely with business system analyst to assist in the development of custom solutions, fixes, patches and securityDocument technical requirements, technical design requirements, use cases, workflow diagrams, and interface designsIdentify and implement appropriate unit testing strategies and prepare resulting test cases and scenariosWork with IT business analysts on the timing, testing, implementation, and documentation of upgrades and/or patches across test, development, staging, and production environments; escalate appropriate issues to vendor support on behalf of IT business analysts or end users.Assist in administering assigned databases¿ assist with backup and recovery operations, database patching, and upgrades.Work closely with business system analysts to diagnose causes and solutions to institutional application errors and issues.Utilize vendor provided diagnostic tools, higher education user groups and vendor product user groups to diagnose issues and implement solutions. Partner with systems and network administrators and other DBAs/application administrators to actively monitor and improve system performance; troubleshoot/solve database issues encountered by new and existing applications.Produce detail migration documentation for moving solutions from the development system through to the production systemAssist in troubleshooting and resolving a variety of problems and issues.Assist in developing software to automate processes.Keep track of industry and state of the art trends in the technology relating to the multiple environments supportedUnderstand basic performance testing tools and can apply those tools in unit testing developed solutions as well as institutional reported performance issuesCollaborate within the organization to ensure that third party software changes, updates are implemented correctly, any issues are addressed, and management notified in a timely mannerParticipate in vendor upgrades to ensure customizations are brought forward as needed as well as participate in extensive testing of upgradesParticipate and lead inter/intra departmental business process improvement initiativesCreate and submit weekly status reportsMonitor system notifications and tickets.Other duties as assigned
Required Qualifications Education and/or Experience Bachelor's degree or equivalent and a minimum of one year of technical hardware/software experience and/or training; or equivalent combination of education and experience.Knowledge, Skills, & Abilities Leadership
Maintain a consistent, high quality, customer-focused orientation when developing and supporting services for both internal and external users.Treat customers, staff and co-workers with respect, courtesy and tact; listen well and maintain a professional relationship.Provide clear, accurate information; explain procedures or materials or provide supplemental information; anticipate problems and questions.Maintain a high level of knowledge of current trends and developments in the field of administrative services and information technology by reading appropriate publications and attending related seminars, conferences, etc.Attend relevant training seminars as permitted by workload and budget constraints.Participate in organization or system-provided training regarding changes in administrative services law, rules, and regulations.
Requires good interpersonal communication skills to effectively present information and respond to questions from groups of managers, clients, customers and the general public.Requires good interpersonal communications skills to include advising, recommending, counseling, directing and delegating. Must have the ability to be a negotiator in resolving difficult issues such as shared resource availability with multiple groups within the organization. Good written communication skills are also required for writing reports and business correspondence.
Other Skills and Abilities
Knowledge of relational database management software.Knowledge of server operating systems.Knowledge of general networking environments.Must be flexible, well-organized, and team-oriented.Must be able to work on a schedule that includes nights, weekends or holidays when required to address escalated issues.
Other Information Other QualificationsMust be able to travel as needed, including several consecutive overnight stays where applicable, to support organizational objectives and initiatives
Pre-employment Background Check RequiredEmployment with the University System of Georgia will require a pre-employment background check. It will not include a credit check.
Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually quiet.