This is an advanced level position with technical work to provide specialized database and application support using Oracle and other vendors’ database engines and products in an enterprise Unix or Windows environment supporting data warehouse information systems and services. This position will be part of a team that works with one or more of several databases, application servers, ETL systems and Business intelligence system. The software supported may include Ellucian Banner 8 and Banner 9, Oracle WebLogic and/or Tomcat Server, Oracle Database, MS SQL 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 that are providing the creation and maintenance of the collection and reporting applications.
This position will perform technical tasks independently in multiple operating systems environments and will work with senior level members to develop processes and procedures for new and updated information systems implementations using Oracle, MS SQL and other database applications. Tasks are varied in nature and often time critical. The successful candidate will possess a significant amount of experience in Oracle/Unix and some experience in MS SQL/Windows environments. They will be knowledgeable about issues related to the deployment of changes in a web-deployed, multi-tier environment.
Essential Duties and Responsibilities include:
• Assist in administering assigned databases; assist with backup and recovery operations, database patching, and upgrades.
• Maintain releases of Banner 9 applications, troubleshoot and fix errors in existing applications systems.
• Assist data warehouse team with development needs, query performance and tuning.
• Assist in troubleshooting and resolving a variety of problems and issues.
• Assist in developing software to automate processes.
• Prepare documentation of tools, procedures, diagnoses, repairs and requirements.
• Research requirements of potential new services.
• Evaluate the performance of existing services.
• Assist in managing user accounts.
• Assist in deploying server operating systems; assist in managing system configurations.
• Assist in building test environments to evaluate changes prior to production.
• Provide workstation support for end users.
• Perform related duties as assigned.