Job Summary The Database Administrator designs information flow and content solutions for existing systems and advises on database concepts and functional capabilities in order to translate business requirements into environment specific databases.
Organizational Status The Database Administrator - Oracle - works independently and jointly within the Database Administration team, receiving operational and strategic direction from the Senior Manager, Database Administration and liaising closely with other Database Administrators, the Director, Teaching and Learning Services, and other UBC IT management and technical staff within the Infrastructure portfolio, as well as external vendors and various stakeholders.
The incumbent will act as an "expert" on Oracle Database systems on various committees and projects and as such will provide advice to stakeholders and staff with regard to issues and problems that may arise as well as development and strategy.
Additionally, the incumbent will provide advice to business decision makers, understand the impact of technical changes on business processes and leverage common approaches and resources between departments.
May be required to be on call and provide support outside of normal working hours. Work Performed Specific Duties
provides database advice and information as required; resolves or assists in resolving database issues and problems.
Keeps the database software versions current within database vendor, application vendor and application owner requirements.
Assists in broader disaster recovery and business continuity planning.
resolves exceptional conditions in a timely manner.
Work is reviewed in terms of achievement of specific strategic objectives.
The Oracle DBA receives operational and strategic direction from the Senior Manager, Database Administration and will liaise closely with Database Administrators, the Director, Teaching and Learning Services, and other UBC IT management and technical staff within the Infrastructure portfolio, as well as external vendors and various stakeholders.
Supervision Given Manages directly and indirectly through subordinates. Consequence of Error / Judgement Makes decisions regarding strategic solutions to business needs or decisions relating to the management of multiple project teams within a technical specialization.
Within the growing University community, all services supported by Information Technology require reliable systems in order to provide important functions such as eLearning, Student Services, Finance, HR and Research Services.
This infrastructure must be available on a near 24 x 7 basis.
Supervision, decisions and actions taken by the Oracle DBA will have a direct impact on how efficiently and effectively the systems infrastructure will perform and function.
Errors in judgment, poor planning, or failure to act decisively could have a detrimental effect on systems infrastructure.
Unreliable systems infrastructure or failure to meet contractual obligations for performance and availability will damage the reputation of Information Technology and UBC.
This could adversely impact the University community, including the large majority of students, faculty and staff, and could cost hundreds of thousands of dollars in lost productivity, funding and revenue.
Qualifications Undergraduate degree in a relevant discipline. A minimum of 5 years of experience, in-depth knowledge of applications and the business requirements supporting them or the equivalent combination of education and experience.
A minimum of 5 years experience with demonstrated progressive responsibility as programmer / analyst and / or database analyst / administrator using the Oracle Database enterprise-
scale product and with a minimum of 3-5 of these years in the database analyst / administrator role. In addition, 3 or more year's experience, in a Database administration role, with the MySQL and / or SQL Server Database platforms would be an asset.
Similarly, experience with tools that are used to administer MySQL and SQL server such as MEM and other third party products is an asset.
Extensive demonstrated direct experience using the Oracle Database enterprise scale product and related tools. Experience supporting enterprise level systems such as PeopleSoft Financials and / or PeopleSoft HRMS in a database analyst or database administrator role is preferred.
Experience should include most recent versions of enterprise applications, database and operating system platforms. Experience should include a solid understanding of the development process, an advanced knowledge of database management with emphasis on relational databases, and good understanding of operating systems and their relationship to database management systems.
Thorough understanding and experience with Oracle Database Server Enterprise Edition version 10G and above with respect to database support and administration.
Thorough understanding and experience in the core aspects of database administration including product installation, upgrades, patching, database design and implementation, backup and recovery, space management, database monitoring, tuning and problem resolution.
Good understanding and experience in the establishment, configuration and management of Oracle Standby databases.
the use of UNIX / Linux and its utilities (Red Hat Enterprise Linux Server environments preferred) in conjunction with managing Oracle Database Server enterprise-
scale databases;UNIX / Linux shell script reading and writing (Bash, Bourne and Korn shells preferred); Oracle replication methods and Oracle high-
availability methods is desirable.
Good understanding of the available functions and best practices in the use of NetApp storage area networks is desirable, and virtualized computing architectures in conjunction with the management of Oracle Database Server enterprise-
scale environments is desirable.
Good working knowledge of MS Windows and MS Office, and MS Windows in conjunction with supporting and troubleshooting the Oracle Database client software and other client programs accessing the Oracle Database Server enterprise databases.
Ability to effectively manage multiple tasks and priorities; work under pressure in time sensitive mission critical situations.
Ability to learn quickly and adapt easily to new situations.
Ability to mentor and coach staff, and act as a resource.
Ability to work well with management and non-management staff across the department and the University.
A good understanding of data networking and its application to enterprise scale applications.
Good knowledge of University-wide databases from a database administration perspective.
Collaboration - Actively solicits ideas and opinions from others to efficiently and effectively accomplish specific objectives targeted at defined business outcomes.
Openly encourages other team members to voice their ideas and concerns. Shows respect for differences and diversity, and disagrees without personalizing issues.
Utilizes strengths of team members to achieve optimal performance.
Communication for Results - Conducts discussions with and writes memoranda to all levels of colleagues and peer groups in ways that support troubleshooting and problem solving.
Seeks and shares relevant information, opinions, and judgments. Handles conflict empathetically. Explains the context of interrelated situations, asks probing questions, and solicits multiple sources of advice prior to taking action when appropriate.
Problem Solving - Applies problem-solving methodologies and tools to diagnose and solve operational and interpersonal problems.
Determines the potential causes of the problem and devises testing methodologies for validation. Shows empathy and objectivity toward individuals involved in the issue.
Analyzes multiple alternatives, risks, and benefits for a range of potential solutions. Recommends resource requirements and collaborates with impacted stakeholders.
Accountability - Sets objectives that meet organizational needs. Provides recommendations to individuals and teams on ways to improve performance and meet defined objectives.
Monitors and provides feedback on individual and team performance against defined standards.
Strategic Technology Planning - Supports research related to functional architectures and technology needs for a significant work area.
Provides input to strategic technology planning. Identifies and analyzes unit's strengths and weaknesses and proposes options for investment in and ongoing maintenance of a function or work process.
Thoroughness - Demonstrates operational agility. Uses organizational systems that result in multiple critical activities to be identified and completed on time.
Renegotiates priorities as necessary. Puts systems in place and uses them to monitor and detect errors and problems. Tests and inspects outputs and applies quality checks prior to work submission.