Database Administrator
Ontario Physiotherapy Association
Vancouver, CA
9d ago

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

  • Liaises with application owners, teams and vendors; translates business requirements into database design specifications and implements them as required;
  • provides database advice and information as required; resolves or assists in resolving database issues and problems.

  • Liaises with other technical support and architecture groups within the Information Technology department and in the broader University community towards the effective design, implementation and operation of University databases.
  • Plans installations and upgrades of and installs, upgrades and patches the database management system and other related software.
  • Keeps the database software versions current within database vendor, application vendor and application owner requirements.

  • Provides data modeling, logical database design and physical database design services. Designs and implements new databases and maintains existing databases.
  • Designs, implements and manages optimal high availability strategies for Oracle Database server environments.
  • Designs, implements and manages Oracle Standby databases and other types of replicated databases as required.
  • Designs and implements sound and effective database backup and recovery procedures. Provides on-going monitoring of these procedures to ensure continued effective operation and takes corrective action when required.
  • Assists in broader disaster recovery and business continuity planning.

  • Provides sufficient production database capacity; performs other database maintenance activities as required for the effective and efficient operation of production databases.
  • Performs all aspects of production database dictionary maintenance, including that for the schemas and access control, in a manner that preserves database security and integrity.
  • Performs ongoing database monitoring, tuning and problem resolution; monitors key database metrics and the database system logs;
  • resolves exceptional conditions in a timely manner.

  • Monitors production SQL execution and identifies suboptimal SQL statements; analyzes suboptimal SQL; resolves by tuning database configuration or structures or making recommendations to application owners if SQL statement tuning is required.
  • Develops and maintains documentation of database systems for the broader use of other members of the Database Administration unit.
  • Participates in strategic and tactical planning for the Database Administration unit.
  • Provides support for middleware software as required.
  • May be required to work on MySQL and or SQL Server database platforms.
  • Core Duties

  • Designs information flow and content solutions for existing systems to structure and access databases.
  • Advises on database concepts and functional capabilities and submits recommendations for solutions.
  • Monitors, evaluates, and maintains systems and procedures to protect the data systems and databases from unauthorized users and recommends corrective actions to ensure data security.
  • Implements data restore and recovery plans and procedures to protect and continue data system and database activities that support broader emergency or disaster recovery plans.
  • Collaborates with project teams and other individuals to ensure seamless workflow with quality handoffs.
  • Prepares specifications and flowcharts.
  • Coordinates installation of revised or new systems.
  • Participates in the establishment of policies and procedures pertaining to data management, maintenance, and utilization.
  • Performs upgrades of databases and adds new structures or elements.
  • Tracks and reports database performance metrics, monitors and analyzes database performance, and calibrates database management system parameters.
  • Performs regular maintenance and backup including monitoring disk space and maintaining database dictionaries.
  • Provides technical leadership, coaching, and mentoring to less-experienced individuals.
  • Maintains appropriate professional designations and up-to-date knowledge of current information technology techniques and tools.
  • Performs other related duties as required. Supervision Received Works with complete latitude within general policies and an administrative framework.
  • 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.

  • Very good understanding and working knowledge and experience of Oracle Database Server backup and recovery methods (experience with Oracle Recovery Manager desirable;
  • SQL performance analysis and tuning in an Enterprise Oracle Database Server environment, preferably in conjunction with PeopleSoft Financials;
  • Oracle Enterprise Manager DBA functions and / or Toad for Oracle (DBA module), particularly with respect to the monitoring and analysis of session and SQL performance;
  • 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.

    Step 2
    Apply
    Add to favourites
    Remove from favourites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form