Job Description Position Title: Senior Database Administrator Classification: IS27 Department/Account: Technology Services Job Code: 90000665 Work Unit: Managed Enterprise Platform Services Job Title: Info Systems Officer IS27 Manager Title: Director, Managed Enterprise Platform Services Last Updated: May 15, 2025 DEPARTMENT OVERVIEW Advanced Solutions Technology Services is responsible for providing cost-effective management, delivery, and support of IT operations to core government ministries, program managers and government employees. Technology Services is also responsible for understanding the business objectives, future directions, and unique requirements of the programs it supports. Technology Services provides services to core government ministries, Crown corporations and broader public sector organizations, and over 30,000 government employees. In support of government objectives to lower costs and improve service delivery, these clients have formed a partnership with Technology Services to receive reliable and cost-effective services for the benefit of the citizens and businesses they serve across British Columbia. DESCRIPTION Advanced Solutions provides the delivery and support of the BC Government’s hosting infrastructure. The provision of infrastructure services includes maintaining and enhancing the stability of the IT hosting infrastructure, including; database services; shared middleware application services and support. The Managed Enterprise Platform Services team is responsible for the management and operations of the shared infrastructure platform services. The Senior Database Administrator is responsible for planning and managing the database management services for a number of clients within multiple environments. The Database Administrator (DBA) position within ESIT Advanced Solutions is responsible for providing expert technical support in the development and implementation of client databases and infrastructure supporting the databases, ensuring interoperability with all related infrastructure components, adherence to standards, effectiveness and relevance to company and client programs. The DBA will follow IT industry developments, research program requirements, liaise with company Architects, Planners and Client Service Representatives, and clients as well as promoting the implementation and operations of the client database infrastructure. ACCOUNTABILITIES/DELIVERABLES 1. Provisions 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. 2. 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 rigorous documentation 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. 3. 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. 4. 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. 5. 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 Direct (directly supervises assigned staff): 0 Indirect reports (supervises through subordinate supervisors): 0 PROJECT/TEAM LEAD OR TRAINING RESPONSIBILITY Supervises students or volunteers: No Provides formal training to other staff: Yes Leads project teams: No Assigns, monitors, and examines work of staff: No FINANCIAL RESPONSIBILITY Assist with analyzing existing services and work practices and identifies and recommends potential areas of cost-savings. SELECTION CRITERIA Education and Experience Bachelor Degree in computer science and five years of related experience OR; Diploma in Computer Science and six years of related experience OR; equivalent combination of formal training and 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 strong asset. Certification in current Oracle, SQL Server, PostgreSQL, MariaDB, or MySQL platforms is strongly preferred and reflects technical proficiency across multiple RDBMS technologies. Related experience must include: Minimum 5 years’ experience as an Oracle and MS SQL Database Administrator; Minimum 2 years’ experience as an PostgreSQL, MariaDB, or MySQL Database Administrator; Experienced working in a fast-paced implementation environment; Extensive database performance tuning experience. Knowledge, Skills, and Abilities Experienced in all subject areas and professional practices with regards to all mentioned RDBMS systems 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 and experience in incident and change, service availability and continuity management processes Ability to work effectively in a fast-paced environment; Ability to be flexible within the work environment and work alone or as a team player; Pragmatic, result-oriented, pro-active; 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 COMPETENCIES Customer Focus Integrity and Trust Ethics and Values Motivating Others Drive for Results Building Effective Teams Priority Setting Decision Quality Business Acumen Organizing We take care of our people (what we offer): Salary Package Employment Type: Full time, Regular Union/Non-Union: Union-BCGEU Salary Grid Level: Level 27 Schedule 2 Annual Salary: $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 *An eligibility list may be created. Lesser qualified applicants may be under-implemented or appointed at a lower level. Why Choose Us? Where will a career with Advanced Solutions take you? To the leading edge of information technology, working with industry partners from around the world. At Advanced Solutions you will work with outstanding people in a challenging and dynamic environment. We strive to provide you with the tools, the training, and the opportunity to take charge of your future and take advantage of change to maximize client service and work within a centre of excellence. The Opportunity Advanced Solutions, a DXC Technology Company is a wholly owned subsidiary of DXC Technology. We are a unionized service delivery channel that delivers world-class business process and information technology services, collaborating with industry-leading partners to provide the best possible solutions for our customers. We combine our deep pool of experienced staff with cutting edge technology to deliver results. We have met the challenges of innovation many times and have a clear and confident vision for leading clients on their digital transformation journeys. Who You Are Display a high level of effort, commitment, and mature judgment Maintain a professional and confidential manner at all times Trustworthy and responsible behavior Eagerness to learn and a willingness to accept feedback and direction Customer Focus Adhere to Advanced Solutions Core Values Embrace and Champion Change: We enthusiastically participate, collaborate, innovate, and welcome change. Encourage and Take Initiative: We are an engaged and progressive workforce promoting personal and professional growth Personify Integrity: We are reputable and productive which builds the foundation of our success Flexible Work Arrangements - Schedules to fit your lifestyle - Flexibility in Location (Role Specific) - Hybrid work environments may be available to ensure that you feel supported Diversity, Inclusion & Workplace Information At Advanced Solutions, we care about our people and provide a workplace culture that supports a healthy work-life balance. Our workplace model supports both remote and hybrid work, offering employees the options to better align with their lifestyle and productivity. Whether working in Canada or collaborating in person at our Vancouver Island Technology Park office in beautiful Victoria, BC, we’re committed to fostering a culture that values balance, inclusivity, and wellbeing. We promote a diverse, equitable work environment and welcome employment applications from individuals of all backgrounds. Our employees enjoy competitive and comprehensive extended and group benefits and participate in a very progressive defined benefit plan through the BC Public Service Pension Plan. We care about our people and are leaning into a workplace culture that supports a healthy work-life balance. Advanced Solutions is proud to be pivoting to become a remote and/or hybrid workplace. Employee’s will have the option to work from anywhere within Canada, or from our Vancouver Island Technology Park Office in beautiful Victoria, BC, or a combination that suits their needs. To learn more about the Victoria Office, please visit the VITP Information Site. Submitting your Application Positions are open to all applicants eligible to work in Canada. Please ensure your application clearly identifies how you meet each of the stated qualifications, with particular emphasis on the education, training, and experience requirements. This information will be utilized in screening your application and determining whether you will be considered for the next stage of the recruitment process. Recruitment fraud is a scheme in which fictitious job opportunities are offered to job seekers typically through online services, such as false websites, or through unsolicited emails claiming to be from the company. These emails may request recipients to provide personal information or to make payments as part of their illegitimate recruiting process. Advanced Solutions does not make offers of employment via social media networks and Advanced Solutions never asks for any money or payments from applicants at any point in the recruitment process, nor ask a job seeker to purchase IT or other equipment on our behalf. More information on employment scams is available here. Welcome to Advanced Solutions, a DXC Technology Company Advanced Solutions is a British Columbia based IT company, employing more than 500 local employees and offering transformational services to the BC Public Sector. While being locally focused, we are backed by the strength of the world’s leading independent, end-to-end IT services company, DXC Technology. We lead clients on their digital transformation journeys, multiply their capabilities, and tailor world-class innovative solutions to meet the unique needs of the BC Public Sector. Working with our global partner network, we have met the challenges of innovation many times, and have a clear and confident vision for helping our clients harness the power of innovation to THRIVE ON CHANGE. Advanced Solutions, a DXC Technology Company (dxcas.com)