Database Administration Team Lead

This is not a job posting, it was created to allow a particular person(s) to enter their personal information and be appointed to a position at McGill University. If you have not been sent this URL directly by a university administrator/recruiter please do not apply. Position Summary : The Database Administration Team Lead is responsible for managing the workload of database administrators within the infrastructure team.. They also provide guidance, technical expertise, problem resolution and mentoring to other team members. The Team Lead is accountable for the suitability, reliability, stability and availability of IT technical solutions and services in their area of responsibility. They establish and maintain security integrity controls. They formulate and monitor policies, procedures and standards relating to database management. Primary Responsibilities: Manage workloads, schedules and day-to-day operations of the administrators. Oversees resource allocation and capacity planning to ensure team alignment with project demands and timelines. Act as the first point of contact for performance-related matters, both day-to-day and within project deliverables, assessing performance and delivering timely guidance to maintain adherence to timelines and quality standards. Ensure optimal availability of technical solutions and services that support business functions. Oversee the technical and maintenance activities within the team and coordinate those activities with relevant members of the larger McGill University IT Community. Works with vendors’ technical support staff as needed. Assist in developing and delivering a strategic integration of technical solutions within the IT infrastructure team, Work with the manager / director to improve IT technologies efficiency and effectiveness. Identify risks associated with services development activities by proactively evaluating potential impact to project and propose appropriate actions to leverage or mitigate risk opportunities. Scope, plan, develop and deliver technology components under own responsibility for end-to-end services, which meet or exceed quality standards in accordance with planned budget and schedule. Work with vendors’ technical support staff as needed. Identify risks and propose mitigation strategies for technical solutions and/or services. Stay abreast of related technologies and ensure solutions meet required technical design and specifications and that deliverables adhere to best practices and standards. Develop and support standards and physical data storage design, as well as maintenance, access, and security administration. Develop database strategies that support the organization’s needs and requirements. Optimize database access and allocate/reallocate database resources for optimum configuration, database performance, and cost. Develop and establish guidelines and processes to manage demand and performance, as well as work with peers across other departments to manage demand, performance, and capacity processes. Conceptualize, design, construct, test and implement business and technical IT solutions through the application of appropriate software development life cycle methodology. Participate in business and technical IT solution implementations, upgrades, enhancements, and conversions. Provide mentoring to less experienced team members. Advise Senior IT Management (Directors) on issues as they pertain to larger organizational issues/business initiatives. When required acts as a backup or represents the Portfolio Manager Physical Storage & Data Center Operations team Requirements: Education: Undergraduate Degree Experience: Five (5) years’ related experience Skills & Expertise: Strong leadership and demonstrated effective communication, writing, planning and coordination skills Ability to facilitate and lead technical discussions Ability to recognize priorities, meet deadlines, and work under pressure. Strong understanding of incident management Capable of working in short high stress environments Self-motivated, autonomous and ability to work well with multiple teams in cross functional set-up Strong Experience with Oracle databases Strong Experience with Microsoft SQL databases Strong Experience with MySQL, Postgres and other RDBMS Thorough understanding of high availability topologies such as database clusters and standby databases Expert level experience with performance tuning , benchmarking and load profiling Expert level experience with performance optimization including SQL tuning English (spoken and written), French (spoken) Should this be added: When required acts as a backup or represents the Portfolio Manager Physical Storage & Data Center Operations team. As one of Montreal's Top Employers, here is what we offer: Competitive benefits package (Health, Dental, Life Insurance) (if eligible) Defined contribution pension plan (with employer contribution up to 10%) (if eligible) Group Registered Retirement Savings Plan (RRSP) and Tax Free Savings Account (TFSA) Competitive vacation policy Two (2) personal days Two (2) floating holidays Nine (9) "Summer Fridays" - paid days off between the St-Jean Baptiste holiday and Labour Day Paid time off over the December holiday period Tuition waiver for regular employees and their dependents Up to two (2) days of remote work per week where the position permits Before applying, please note that to work at McGill University, you must be both authorized to work in Canada and willing to work in the province of Quebec at the campus where the position is based / located. Knowledge of English: McGill University is an English-language university where day to day duties may require English communication both verbally and in writing. The level of English required for this position has been assessed at a level # 3 on a scale of 0-4 . For a definition of our language proficiency levels, please click here . McGill University is committed to equity and diversity within its community and values academic rigour and excellence. We welcome and encourage applications from racialized persons/visible minorities, women, Indigenous persons, persons with disabilities, ethnic minorities, and persons of minority sexual orientations and gender identities, as well as from all qualified candidates with the skills and knowledge to engage productively with diverse communities. At McGill, research that reflects diverse intellectual traditions, methodologies, and modes of dissemination and translation is valued and encouraged. Candidates are invited to demonstrate their research impact both within and across academic disciplines and in other sectors, such as government, communities, or industry. McGill further recognizes and fairly considers the impact of leaves (e.g., family care or health-related) that may contribute to career interruptions or slowdowns. Candidates are encouraged to signal any leave that affected productivity, or that may have had an effect on their career path. This information will be considered to ensure the equitable assessment of the candidate’s record. McGill implements an employment equity program and encourages members of designated equity groups to self-identify. It further seeks to ensure the equitable treatment and full inclusion of persons with disabilities by striving for the implementation of universal design principles transversally, across all facets of the University community, and through accommodation policies and procedures . Persons with disabilities who anticipate needing accommodations for any part of the application process may contact, in confidence, [email protected] . All qualified applicants are encouraged to apply; however, in accordance with Canadian immigration requirements, Canadians and permanent residents will be given priority.