Vancouver - Point Grey Campus
Information Systems & Tech
Info.Sytems&Technlgy, Level D
VP Academic & Provost
UBC IT - Database Adminstrn.
$82,302.00 (minimum) - $102,877.00 (midpoint) - $128,597.00 (maximum)
Desired Start Date:
Job End Date:
"Midpoint" of the hiring salary range means the individual possesses full job knowledge, qualifications and experience.
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.
The Database Administrator - MS SQL Server - 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, Application Management Services, and other UBC IT management and technical staff within UBC IT and Office of CIO, as well as external vendors and various stakeholders.
The incumbent will act as an "expert" on MS SQL Server 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.
- 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 and implements optimal high availability strategies for MS SQL Server environments
- Designs and implements backup and recovery strategies for MS SQL Server environments.
- Designs, implements and manages MS SQL highly available 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 ongoing database monitoring, tuning and problem resolution; monitors key database metrics and the database system logs; resolves exceptional conditions in a timely manner.
- Designs and implements performance monitoring strategies for MS SQL Server database environments.
- Installs and works with applications such as SQL Server Management Studio and Database Engine Tuning Advisor.
- Installs and works with replication technology for Oracle, MySQL and MS SQL Server database platforms.
- Provides expert knowledge and advice to colleagues on departmental MS SQL Server deployments.
- Liaises with departmental System/Database Administrators.
- 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 and have intermediate level expertise with MySQL and or Oracle database platforms.
- 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.
Works with complete latitude within general policies and an administrative framework. Work is reviewed in terms of achievement of specific strategic objectives.
The MS SQL Server 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 Application Management Services portfolio, as well as external vendors and various stakeholders.
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 MS SQL Server 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.
Undergraduate degree in a relevant discipline. Undergraduate degree in Computer Science preferred. 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. Minimum of least five years experience with progressively more responsibility as a programmer analyst and/or database analyst/administrator, using MS SQL Server Database in enterprise-scale context 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 Oracle and/or MySQL Database platforms would be an asset. Similarly, experience with tools that are used to administer Oracle, MySQL and SQL server such as OEM, MEM, TOAD and other third party products is an asset.
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 MS SQL Server version 2008 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 MS SQL Server replicated databases.
Strong experience with database administration and database programming, and excellent troubleshooting skills.
Excellent knowledge and experience with MS SQL Server Administration, Transact-SQL and MS SQL Server Reporting Services (MS SSRS). Including installs, upgrades, patching, backup and recovery, high availability, replication, performance monitoring and fine tuning.
A thorough understanding and working knowledge of Windows operating systems in conjunction with managing enterprise scale MS SQL Server database environments.
A working knowledge of Windows PowerShell and Unix shell script reading and writing.
A good understanding of how to effectively use MS Windows work tool environments to access Unix and Windows hosts and run database management tools.
A good understanding of data networking and its application to enterprise scale applications.
Working knowledge of Windows Server, IIS6+ and Active Directory Services.
Good working knowledge of MS Windows and MS Office, and MS Windows in conjunction with supporting and troubleshooting database client software and other client programs accessing enterprise databases.
Good knowledge from both an application and database administration perspective of University-wide databases.
Good knowledge on how to use Microsoft Windows and/or Unix and its utilities in conjunction with managing an enterprise scale databases such as Oracle, MySQL and MS SQL Server.
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 Database Server enterprise-scale environments is desirable.
Ability to learn quickly and adapt easily to new situations.
Ability to effectively manage multiple tasks and priorities and work under pressure to meet time sensitive mission critical deadlines and 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.
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.
Equity and diversity are essential to academic excellence. An open and diverse community fosters the inclusion of voices that have been underrepresented or discouraged. We encourage applications from members of groups that have been marginalized on any grounds enumerated under the B.C. Human Rights Code, including sex, sexual orientation, gender identity or expression, racialization, disability, political belief, religion, marital or family status, age, and/or status as a First Nation, Metis, Inuit, or Indigenous person.
All qualified candidates are encouraged to apply; however Canadians and permanent residents will be given priority.