Database Administrator II

Are you passionate about using your expertise to connect to an IT career with a difference? We are looking for a Database Administrator II to join our Enterprise Platform Operations team.

Are you a skilled DBA with hands-on experience managing enterprise-grade databases such as DB2 and Oracle, in addition to SQL Server? You'll assist the manager of Database Services to ensure the integrity of databases, lead and coordinate the work of project teams, and resolve complex technical database problems encountered by DBAs and developers.

Your role will be instrumental on a team that ensures data is available and secure for users across our organization - presenting the opportunity to advance your skills with exposure to supporting various mission applications like our Claims Management System and involvement in performance tuning of our mission critical applications.

How you'll make a difference: You'll use leading edge tech to connect people to healthy and safe workplaces.

Where you'll work
At WorkSafeBC, we offer a hybrid work model that combines working remotely, and in our offices based on the operational needs of the position.

• Collaborate with other team members on creation, maintenance, configuration and support of database instances
• Collaborate with software developers to set up the monitoring of production databases including availability, performance, deadlocks, as well as looking at real-time and historical performance.
• Respond to database system monitoring alerts and exceptions and provide database system problem recovery and resolution
• Manage database instance performance tuning and implementation of database system software tuning improvements
• Collaborate with software developers to perform application database performance tuning such as application query tuning, index creation, optimizer hints, and table and data model modifications
• Collaborate with the security team on developing database security standards and practices by developing scripts that will perform security health checks for review by security and the manager of database services
• Create, implement, and execute database cloning procedures to support application requirements and development and testing cycles
• Develop, plan and execute tasks in collaboration with other team members and service providers in the refresh and masking of nonproduction systems including provide problem resolution to support iterative application development and cycles
• Consistently models the appropriate level of organizational behaviours expected of all WorkSafeBC employees: responsive, respectful, fair, collaborative, accountable, and forward thinking.

We're looking for someone who can:

• Anticipate, organize and prioritize work to meet both short- and long-term goals and outcomes
• Take initiative to advise, persuade and motivate others to act in a recommended way in an environment of minimal supervision
• Lead by example by taking initiative, assuming responsibility for issues and following through to appropriate resolution
• Clearly document and convey, both verbally and in writing, a variety of technical information to technical and non-technical persons
• Listen, clarify and comprehend information
• Maintain personal and team effectiveness by adapting and adjusting to changes and difficult situations
• Implement an appropriate solution using judgement and resourcefulness in sometimes difficult circumstances
• Promote agile principles to assist the evolution and maturity of Agile and DevOps at WorkSafeBC
• Participate in Agile ceremonies and perform work using the team's Kanban board
• Provide 24x7 on-call procedures and support on a rotational basis
• This position requires regular and punctual attendance.

Your background and experience

• A degree in Computer Science or STEM (Science, Technology, Engineering, Math)
• A minimum of six years of experience working with Relational Database management systems such as DB2 and Oracle, in addition to SQL Server
• Knowledge of Agile and Scrum methodologies

We'll consider an equivalent combination of education and experience.

Important to know
Before we can finalize any offer of employment, you must:

• Consent to a criminal record check ****
• Confirm you're legally entitled to work in Canada

Who we are
At WorkSafeBC, we promote safe and healthy workplaces across British Columbia. We partner with workers and employers to save lives and prevent injury, disease, and disability. When work-related injuries or diseases occur, we provide compensation and support injured workers in their recovery, rehabilitation, and safe return to work. We're honoured to serve the 2.49 million workers and 263,000 registered employers in our province.

What's it like to work at WorkSafeBC?
It's challenging, stimulating, and rewarding. Our positions offer diversity and opportunities for professional growth. Every day, the work we do impacts people and changes lives. What we do is important, and so are the people we do it for.

Our ability to make a difference relies on building a team with a rich variety of skills, knowledge, backgrounds, abilities, and experiences that reflects the diversity of the people we serve. We are committed to fostering a welcoming, inclusive, and supportive work culture where everyone can contribute as their best, authentic self.

Learn more: Discover who we are .

Our benefits
As a member of our team, you'll have access to services and benefits that help you get the most out of work - and life. Along with a competitive salary, your total compensation package includes:

• Defined benefit pension plan that provides you with a lifetime monthly pension when you retire
• 3 weeks of vacation in your first year, with regular increases based on years of service
• Extensive health care and dental benefits
• Optional leave and earned-time-off arrangements
• Development opportunities (tuition reimbursement, leadership development, and more)

Learn more: Find out what we offer .

Salary : $48.47-$56.55/hourly

Want to apply?

• Applications are welcomed immediately, however must be received no later than 4:30 p.m. PST on the closing date.
• Please note that we will be starting assessments prior to the closing date.

We encourage all qualified applicants to apply. If you require an accommodation in the assessment process, please email Recruitment Testing Accommodation (SM) when you submit your application.

Any additional application materials must be received by email to P&C Talent Acquisition (SM) by 4:30 p.m. PST on the closing date of the competition.