Job Details: SunGard SCT Banner/Oracle DBA
| Job Title: | SunGard SCT Banner/Oracle DBA |
| Job ID: | RABCO63 |
| Company: | Istonish |
| Position Type: | Contract to Hire |
| Pay Rate: | Neg |
| Skills: | SunGard SCT Banner, Oracle |
| Date Posted: | Jun-04-08 |
Under the direction of the IT Director, the Oracle Database Administrator will have primary responsibility for the Oracle database implementation, performance-tuning and support on Linux operating system in a clustered configuration, including high-availability configuration such as RAC (Real Application Cluster), Security configuration such a Virtual Private Database, Interface and Integration configuration with Luminis portal and other third-party products. Major technical duties include installation and
upgrade of Oracle products and application system software, monitoring and tuning system performance, establishing user access controls, database security, defining new/modified database tables, and device configuration and planning. The DBA will also perform more complex analysis, programming, and implementation of scripts and programs needed in support of applications.
Major Functional Areas and Description of Duties:
Production Support:
Provide primary DBA design and support services for establishing, upgrading and maintaining the Oracle software environments, which support the client systems. These include SCT Banner Finance, HR, Financial Aid, Student Administration and Enterprise Portal systems, as well as other vendor-supplied and locally developed systems.
Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations.
In conjunction with the network security administrator, establish and manage user access, and design and implement security architecture.
Create, maintain and refresh required Oracle instances/databases for development, test and production environments.
As required, help resolve application problems. Act as liaison between application programmers and DBMS vendor to report and resolve problems.
Monitor security breaches, error log(s), database and log space, user activity and resource utilization of production environment. Work with application programmers to insure that application problems do not adversely affect production operations.
Monitor system resources of database servers to assure production systems meet performance & availability requirements and hardware enhancements are scheduled in a timely fashion.
Provide after hours on-call support for critical database issues.
Development, Tuning & Diagnostics:
Provide expert assistance in setting up instances, table-spaces, tables, indices and views.
In conjunction with programmer/analysts, define new objects or modifications to existing objects.
Provide expert assistance in SQL statement tuning to improve performance. This includes, but is not limited to, re-writing SQL statements, creating new indexes and altering existing indexes.
Using software packages (e.g., OEM, Diagnostics Pac, Tuning Pac) and/or local scripts, monitor performance, space, Oracle database parameters and tune as required.
Planning & Implementation:
Install, upgrade and maintain Oracle software products/versions for DBMS, server software and various tools software as appropriate for the project.
Following standards, write, maintain and document Linux scripts needed in support of applications.
Monitor disk usage; plan acquisition and replacement of disk devices as needed.
Act as project liaison and coordinate with Linux system administrators for application of OS patches and maintenance required for database servers.
Other tasks as needed:
Work with ERP project team (or other project teams as required) to determine needs, set priorities, create project plans and determine schedule for AIS installations/upgrades and other local AIS tasks.
Implement standards as defined by DBA team as applicable to the ERP and other systems.
Understand and maintain documentation of dependencies between versions of application vendor software, Oracle software, Linux Operating System and compilers.
Work independently to track outstanding tasks and projects, monitor progress, plan workload and dependencies, resolve resource conflicts and provide status reports to the IT Director.
Provide DBA training and support for other DBAs.
Qualifications:
MS degree in Computer Science, Mathematics or Physics preferred. BS degree required. Certification in Oracle highly desired. Relevant education and experience in the appropriate technical areas may be considered as a substitute for formal education.
Expert knowledge of and substantial experience with Oracle RDBMS:
1. Oracle database administration on servers for mission critical applications
2. Installation and upgrades of multiple Oracle software products/versions for DBMS, server software and various tools software
3. Development, maintenance and documentation of procedures and standards for effective database software use
4. Analysis and management of Oracle problems/defects using TARs and or Metalink with Oracle Corporation and installation of patches
5. Use of software and locally developed tools to monitor Oracle databases
6. Definition of entity and referential integrity constraints, stored packages, procedures and functions, database links, triggers, snapshots and other internal database objects
7. Management of role-based security
Expert hands on knowledge of and experience with Unix or Linux, preferably Red Hat Linux Enterprise
Version:
1. Write and modify complex Linux shell scripts to manage Oracle environment and application processes
2. Problem analysis involving interactions/dependencies between Linux and Oracle
3. Production support for Oracle running on Linux
4. Set up, testing and implementation of backup/recovery strategies using Oracle**s Recovery Manager (RMAN)
Experience in installing, upgrading and providing production support for Oracle on UNIX-based operating systems:
1. Ability to install and manage multiple versions of Oracle in a common Unix or Linux environment
2. Plan, document, coordinate and implement complex vendor upgrades to Oracle applications while protecting integrity of the production environment
3. Document upgrade problems and communicate/resolve with application vendor
4. Design and implementation of local table changes
Experience in Oracle DBA design and support for multiple, complex applications:
1. Management of technical tasks required to meet project goals (upgrades, enhancements, etc.)
2. Development and tracking of technical project timelines
Ability to:
1. Work effectively on concurrent, multiple tasks and projects
2. Work independently to coordinate, organize and track tasks effectively and meet project deadlines
3. Keep current on technology by identifying, reading and using technical manuals and other resources
4. Communicate and collaborate effectively with staff of varying technical expertise
5. Excellent oral and written communication skills
Preferred Qualifications:
1. Experience supporting 24x7 environments
2. Experience with other RBDMS such as MySQL and/or MS SQL Server installation, configuration & management.
3. Experience with SunGard SCT Banner, WebCT or Blackboard products.
| Location: [rss] | US-CO-Denver |
| Telecommute: | No (Onsite Position) |
| Contact Name: | Roxane Brock |
| Contact Phone: | 612-373-7041 |
| Contact Email: | rbrock@istonish.com |
| URL: | http://www.istonish.com |
Principals only. Recruiters, please do not contact this job poster.
View other jobs in US-CO-Denver »
View other jobs in US-CO »
View other Oracle DBA jobs, Oracle jobs, Database Administrator jobs, Tech jobs
View other jobs requiring these skills: SunGard SCT Banner,
Oracle
View other postings by Istonish »
