Senior Database Department/Account: Work Unit: IMIT Operation Services Information Systems Officer ACCOUNT OVERVIEWAs a part of the consortium team which consists of PBC Solutions, Advanced Solutions provides IMIT services to support the Ministry of Health’s Health Insurance BC (HIBC) Services. Together, we are committed to the vision: “We empower British Columbians to achieve optimal health and wellness through effective, innovative and inclusive health benefits services.”The Shared Vision guides the work we do and our Guiding Principles of honesty, integrity, reciprocity, autonomy, loyalty and equity, and our Intended Behaviors inform our relationships and sets the tone for how we work together. DESCRIPTIONThe Senior Data Base Administrator (Application Middleware and DBA) is responsible for the design, development implementation and support of our open system database platforms ensuring the business needs of our clients are met.

The Senior DBA provides senior technical leadership and guidance to team members as well as tactical support for all database platforms that include Oracle, Sequel and supporting Middleware. The role is responsible for ensuring the integrity, security and performance of databases as well as providing strategic guidance on the implementation of the corporate data warehouse and corresponding data feeds. Ensures acceptable Oracle and Sequel database availability and response time by leading problem diagnosis and resolution in a high availability multi-datacentre environment.

Provides technical leadership and support to peers, leaders, and project teams.



Research emerging database technologies and trends to understand the future direction of database technology. Configure and install business-critical databases based on business requirements gathered from application development teams and business users.

Ensures compliance with audit, security, and regulatory requirements. Provide DBA support for complex software installation and maintenance, including major upgrades Proficient in evaluating and recommending software and hardware solutions, gathering opinions, and reaching consensus from a wide audience of stakeholders. Understanding of and commitment to protecting the integrity, security, and privacy of the firm's critical business data.

Support data replication, backup, and availability solutions. Provides after-hours and weekend support and participates in on-call rotation (24X7). Resolve database performance issues, database capacity issues, replication, and other distributed data issues.

PROJECT/TEAM LEAD OR TRAINING RESPONSIBILITYRole Y/N Role Y/N Provides formal training to other staffY Leads project teamsY FINANCIAL RESPONSIBILITYMay provide cost estimates for project budget plans.



Degree or diploma from an accredited college or university in Technology or Computer Science with 7 plus years’ experience in a systems administration setting; with structured training in DB2 Database Administration or an equivalent combination of education and experience.

Experience in providing advice and recommendations on the Mainframe direction of the Ministries.

Oracle Database

Administration (OCP) and Application Administration is an asset.

Experience leading technical teams. Demonstrated program development and application of evaluation methodologies. Demonstrated success in developing effective deployment plans and executing delivery. Hands-on experience with the management of DB2 applications and database. Basic network architecture knowledge. Basic understanding of system design, planning, and implementation.

Understand

Agile and Waterfall software development methodologies. Knowledge and understanding of ITIL process set and concepts is an asset. Knowledge of Scrum techniques and artifacts (such as user stories, definition of done, automated testing, backlog refinement). Knowledge of Agile frameworks and methods (i.Scrum, Kanban, XP), and understanding of software development life cycle models as well as traditional project management principles and practices.

Customer Focus Building Effective Teams Decision

Quality Senior Database Middleware Legacy Employment Type: Full Time, Regular Level 30, Schedule 2 Office Location: 15 Vacation days, with entitlement increases with service Maternity, Parental and Pre-Adoption Leave with option for top up Extended health and dental Public Service Pension plan, matched by Advanced Solutions

📌 Senior Database Administrator (SQL) (Winnipeg)
🏢 ESIT Advanced Solutions
📍 Winnipeg