Role Responsibilities

Reporting to the Team Lead Database Administration, the Database Administrator (DBA) position ensures the smooth operations, security, and reliability of an organization's databases. 

This position is responsible for managing the day-to-day operations of databases, ensuring their performance and security, and developing and implementing backup and recovery procedures. The main objective of this position is to ensure the availability, accuracy, and integrity of the data stored in the databases.
By performing tasks such as reviewing database design and implementing database configuration, performance tuning, and security management, this position helps the organization make the most of their data resources and ensure that critical data is protected. This position plays a key role in developing and maintaining database infrastructure, including storage capacity planning and disaster recovery planning.
 

This position provides direction to a combination of GoA staff, contractors and external service providers. Work performed will utilize IT Incident, Problem, Change, Project, Service and Capacity Management principles to achieve innovative solutions to a variety of complex problem.  

Responsibilities: 
Some of the responsibilities of this position include, but are not limited to:

• Managing the day-to-day operations of databases, ensuring their performance and security, and developing and implementing backup and recovery procedures, and ensuring a smooth operation.
• Ensuring the availability, accuracy, and integrity of the data stored in the databases.
• Developing and maintaining database infrastructure, including storage capacity planning and disaster recovery planning.
• Reviewing database design and implementing database configuration, performance tuning, and security management.
• Assisting and supporting Senior DBA Team Leads in implementation of changes.
• Collaborating with development teams to integrate new systems and applications with the database.
• Liaising with branch resources and business to ensure client priorities and issues are dealt with in a timely manner.
• Creating, implementing and managing new Information management technology (IMT) services which includes business analysis, technical design, implementation, operations, monitoring, troubleshooting and interfacing between IMT systems.
• Implementing changes to services following proper incident, problem, and change management practices.
• Overseeing daily operations to ensure compliance with IMT policies and audit requirements.

To be successful in this position, you will demonstrate:

• High level of analytical thinking, creativity, and problem-solving skills.
• Good discretion when making decisions, with minimal direction.
• Excellent communication skills, both written and oral, including strong presentation skills.
• Ability to handle high stress situations.
• Ability to work effectively on a team as well as independently.

Please click on this link to view the job description for this position.

APS Competencies

Competencies are behaviors that are essential to reach our goals in serving Albertans. We encourage you to have an in depth understanding of the competencies that are required for this opportunity and to be prepared to demonstrate them during the recruitment process.

This link will assist you with understanding competencies:
https://www.alberta.ca/system/files/custom_downloaded_images/psc-alberta-public-service-competency-model.pdf.

• Systems Thinking: Integrates broader context into planning. Plans for how current situation is affected by broader trends. Integrates issues, political environment and risks when considering possible actions. Supports organization vision and goals through strategy. Addresses behaviors that challenge progress.
• Creative Problem Solving: Creates the environment for innovative problem solving. Generates new ways of thinking; ensures right questions are being asked about a problem. Eliminates barriers to creativity and innovation. Encourages a culture of innovation.
• Develop Self and Others: Plans according to career goals and regular development. Aligns personal goals with career goals. Leverages strengths: attempts stretch goals. Provides feedback and openly discusses team performance. Values team diversity and supports personal development.
• Agility: Proactively incorporates change into processes. Creates opportunities for improvement. Is aware of and adapts to changing priorities. Remains objective under pressure and supports others to manage their emotions. Proactively explains impact of change on roles and integrates change in existing work. Readily adapts plans and practices.
• Drive for Results: Takes and delegates responsibility for outcomes. Uses variety of resources to monitor own performance standards. Acknowledges even indirect responsibility. Commits to what is good for Albertans even if not immediately accepted. Reaches goals consistent with APS direction.

Qualifications

Required:

• University degree in a related field such as Computer Science, Information Technology. 
• Two (2) years of progressively responsible related experience in supporting application infrastructure and/or software development.
• Experience with project planning and superior technical abilities to manage implementation of services with both software and hardware components.
• Experience in and a comprehensive understanding of the technical environment and the linkages between systems.
• Proficiency with database with a strong background in Microsoft SQL Server 2019 & 2022.

Equivalencies:

• A related two-year diploma in related discipline from a recognized post-secondary institution and four (4) years related experience; or
• A related one-year certificate from a recognized post-secondary institution and five (5) years related experience.

Assets:

• ITIL Foundation knowledge.
• Expertise in utilizing analytical, planning, organization, evaluation and problem-solving skills. 
• Ability to communicate effectively to staff with a varying degree of systems understanding (none to expert).
• Experience with Microsoft SQL Azure; with a background in cloud database administration and optimization. 
• Expertise to detect and repair problems, independently and quickly, is paramount to this position.
• Strong leadership skills to support project-based work and support in identifying/implementing operational efficiencies.

Minimum recruitment standards outline the minimum education and experience required for appointment to a job classification. 
Refer to https://www.alberta.ca/alberta-public-service-minimum-recruitment-standards
 

Notes

Term of Employment: Permanent, Full-time position    

Hours of Work: Monday to Friday, 36.25 hrs/week 
Location: Greater Edmonton or Calgary area (Remote) 

This position is eligible for remote work. You must reside in the Greater Edmonton or Greater Calgary area, Alberta to work remotely.

Please note that there is a requirement to attend in-person meetings at the Edmonton office once a month. The travel cost to and from Edmonton will not be covered. 

Final candidates will be required to undergo a security screening.

A written assessment may be required as part of the interview process. 

This competition may be used to fill future vacancies, across the Government of Alberta, at the same or lower classification level. 

Applicants are advised to provide a cover letter summarizing information that clearly and concisely demonstrates how their qualifications meet the advertised requirements, including education, experience, and relevant examples of required competencies. 

Any costs associated with obtaining the required documents/checks as noted or interview travel expenses, will be the responsibility of the candidate. Out-of-province applicants can obtain the required documents/checks from the province they currently reside in. 

Links and information on what the GoA has to offer to prospective employees.

• Working for the Alberta Public Service - https://www.alberta.ca/advantages-working-for-alberta-public-service.aspx
• Public Service Pension Plan (PSPP) - https://www.pspp.ca
• Alberta Public Service Benefit Information - https://www.alberta.ca/alberta-public-service-benefits
• Professional learning and development - https://www.alberta.ca/professional-development-support-directive
• Research Alberta Public Service Careers tool – https://researchapscareers.alberta.ca
• Christmas closure directive – https://www.alberta.ca/christmas-closure-directive.aspx 
• Special leave directive – https://www.alberta.ca/special-leave-directive
• Positive workplace culture and work-life balance
• Opportunity to participate in flexible work arrangements such as working from home up to two days per week and modified work schedule agreement
• Leadership and mentorship programs