16 Oct
|
Advanced Solutions
|
Winnipeg
16 Oct
Advanced Solutions
Winnipeg
Job Title: Senior Database AdministratorClassification: IS27Department/Account: Technology ServicesJob Code: 90000665Work Unit: Managed Enterprise Platform ServicesJob Title: Info Systems Officer IS27Manager Title: Director, Managed Enterprise Platform ServicesLast Updated: May 15, 2025ResponsibilitiesProvisions of Technical Expertise:Analyze business requirements related to availability and performance to develop and implement operational strategies, migration approaches, and system policies tailored to diverse environments.Provide expert guidance in the development of physical database design standards and contribute to the creation and review of technical project plans, including risk and impact assessments during all implementation phases.Lead issue resolution efforts involving database systems, collaborate with infrastructure teams, and liaise with clients to ensure optimal performance and adherence to organizational standards.Offer technical consulting on best practices for database architecture, operating systems, security models, data loading processes, and conversion procedures, including the evaluation and integration of new technologies.Maintain continuous 24x7 availability and optimal performance of Oracle, MS SQL Server, PostgreSQL, MySQL, and MariaDB environments; coordinate with Oracle and Microsoft support teams as needed and participate in rotational on-call support and middleware deployment activities.Database Environment:Recommend and define physical database architecture to meet organizational standards for performance, backup, and recovery, ensuring optimal design for scalability and maintainability.Install, configure, and upgrade Oracle, MS SQL Server, and other RDBMS technologies to meet evolving application demands and compliance standards.Tune and adjust databases and associated infrastructure regularly for optimal performance, monitor usage trends, and forecast future resource needs.Manage change processes and scheduled outages; maintain rigorousdocumentation for standards, operating procedures, and client‑specific administrative guides.Respond promptly to database outages, conduct root cause analysis, lead recovery efforts, and document preventive strategies; support disaster recovery and data security planning, and provide guidance throughout the application lifecycle, from development through deployment.Business Relationships:Engage proactively with clients to assess needs,
gather requirements, and deliver customized solutions aligned with business goals.Evaluate existing service delivery models and operational processes, identifying opportunities to enhance efficiency and reduce costs.Other Related Duties:Share technical knowledge with DBA teams, participate in knowledge transfer sessions, track and report time, maintain technical skillsets, and perform other assigned tasks as required to support the database environment.Business Skills: Project Management – Contribute effectively to project teams by following through on deliverables and ensuring timelines are met.Collaboration – Foster strong working relationships through active knowledge sharing, teamwork, and innovation.Offer value‑added input, support enterprise‑wide communication, and work closely with multi‑disciplinary teams to troubleshoot and resolve complex performance issues (e.G., storage, networking, application integration).Supervisory Responsibilities: (No direct or indirect reports)Supervisory ResponsibilitiesDirect (directly supervises assigned staff): 0Indirect reports (supervises through subordinate supervisors): 0Project/Team Leadership and TrainingProvides formal training to other staff: YesLeads project teams: NoAssigns, monitors, and examines work of staff: NoFinancial ResponsibilityAssist with analyzing existing services and work practices and identifies and recommends potential areas of cost‑savings.Selection CriteriaEducation and Experience:Bachelor Degree in computer science and five years of related experience ORDiploma in Computer Science and six years of related experience OREquivalent combination of formal training and experience.Experience:Experienced in Oracle and Microsoft SQL Server, with a proven track record of managing large, complex environments featuring high availability and disaster recovery solutions.Skilled in supporting mission‑critical systems in a 24x7 operational model.Experience with other RDBMS platforms such as PostgreSQL, MySQL,
and MariaDB is considered a solid asset.Certifications in current Oracle, SQL Server, PostgreSQL, MariaDB, or MySQL platforms are strongly preferred.Related Experience Must Include:Minimum 5 years’ experience as an Oracle and MS SQL Database Administrator; Minimum 2 years’ experience as a PostgreSQL, MariaDB, or MySQL Database Administrator.Experienced working in a fast‑paced implementation environment.Extensive database performance tuning experience.Knowledge, Skills, and Abilities:Strong analytical and troubleshooting skills; Experience with UNIX/Linux troubleshooting, scripting and security.Ability to lead positive and effective client interactions and deal with highly sensitive and time‑bound client demands.Working knowledge of ITIL processes and tools; sound knowledge of incident and change, service availability and continuity management processes.Ability to work effectively in a fast‑paced environment; flexibility and teamwork.Pragmatic, result‑oriented, proactive; Excellent interpersonal, oral and written communication, and presentation skills.Strong organizational skills including demonstrated tenacity for following up with team members and leadership on outstanding items.Ability to multi‑task, work under pressure, meet deadlines, and effectively prioritize.Ability to establish strong and effective working relationships at all levels and participate effectively.Other Requirements:May require overtime work, including evenings and weekends.May require on‑call support on a rotational basis.Will be required to get enhanced background screening due to CRA file access.Required CompetenciesCustomer FocusIntegrity and TrustEthics and ValuesMotivating OthersDrive for ResultsBuilding Effective TeamsPriority SettingDecision QualityBusiness AcumenOrganizingCompensation and BenefitsSalary Package: Full time, Regular Union-BCGEU; Salary Grid Level27 (Level 27); Schedule 2; AnnualSalary $111,370.90 – $127,197.57.Office Location: Victoria, BC – Hybrid.Benefit Package:15 vacation days with entitlement increases with service.Maternity, Parental and Pre‑Adoption Leave with option for top‑up.Employee Assisted Program including paid counselling services for you and your family.Paid sick leave for when life happens.Extended health and dental.Public Service Pension plan, matched by Advanced Solutions.Excellent Rewards and Recognition Program.#J-18808-Ljbffr
📌 Senior Database Administrator, Is27 - C$111,370.9 - C$127,197.6 A Year (Winnipeg)
🏢 Advanced Solutions
📍 Winnipeg