Database Administrator 2
Top Benefits
About the role
If you are committed to public service, enjoy collaborating with others, share our values and have a desire to learn and grow, join The City of Calgary. City employees deliver the services, run the programs and operate the facilities which make a difference in our community. We support work-life balance, promote physical and psychological safety, and offer competitive wages, pensions, and benefits. Together we make Calgary a great place to make a living, a great place to make a life.
The City is committed to fostering a respectful, inclusive and equitable workplace which is representative of the community we serve. We welcome those who have demonstrated a commitment to upholding the values of equity, diversity, inclusion, anti-racism and reconciliation. Applications are encouraged from members of groups that are historically disadvantaged and underrepresented. Accommodations are available during the hiring process, upon request.
As a Database Administrator 2 reporting to the Leader of Database Administration and working as a member of a team, you will assist in developing and managing The City's database management systems. Primary duties include:
- Deploy database solutions, manage database backups and access, and keep databases secure and operational.
- Create and maintain all databases required for development, testing and production usage.
- Administer all database objects including tables, indexes, views, sequences, packages and procedures.
- Plan and implement backup and recovery for all new databases.
- Monitor database usage and alerts, take actions to avoid future database problems, security issues and vulnerabilities.
- Monitor database environment, make changes to data structures and Database Management Systems (DBMS) subsystems to optimize performance.
- Plan and upgrade the database to enhance product features and technologies, and to maintain vendor support.
- Work with application developers to ensure success of new development roll out.
- Troubleshoot on matters pertaining to database access, performance, integrity and security.
- Create and maintain technology standards, guidelines and best practices for databases.
- Assist with new DBMS technology evaluations and implementations.
- Communicate clearly and positively with clients, key partners and management in formal and informal settings. Always maintaining a professional demeanor as a representative of the Database Support team.
Qualifications
- A degree in Computer Science, Commerce, Engineering, Math or related field with at least 3 years of Information Technology experience including 1 year of Database Administrator (DBA) experience; OR
- A completed 2 year technical diploma with at least 5 years of Information Technology experience including 3 years of DBA experience.
- Preference will be given to individuals with experience in Oracle, Microsoft SQL Server and Azure, and MySQL database administration in a large data centre, Oracle Enterprise Manager Cloud Control, Oracle Recovery Manager, Dell Spotlight, Remedy, ESRI ArcSDE, Vmware and UNIX/Linux/Windows operating systems.
- Working knowledge on Open-Source NoSQL Database and strong Project Management skills will be assets.
- You are independent, well-organized and self-motivated individual who has strong teamwork, excellent organizational, communication and customer service skills.
Pre-employment Requirements
- A security clearance will be conducted.
- Successful applicants must provide proof of qualifications.
Workstyle
- This position may be eligible to work from home for at least part of the time as one of several flexible work options available to City employees. These arrangements depend on the operational requirements of the role, employee suitability, and are subject to change based on operational needs and corporate direction.
Union: CUPE Local 38
Business Unit: Information Technology
Position Type: 1 Permanent
Location: 133 6 Avenue SE
Compensation: Pay Grade 11 $46.21 - 61.78 per hour.
Out-of-Schedule Rates: $57.27 - 69.67 per hour.
This position is presently paid at an Out-of-Schedule rate
to reflect current market conditions. Should market
conditions change, the salary may be reviewed and
may revert to the base rate.
Days of Work: This position typically works a 5 day
work week, with 1 day off in each 3 week cycle.
Hours of work: Standard 35 hour work week
Audience: Internal/External
Apply By: February 26, 2026
Job ID #: 313496
About City of Calgary
City of Calgary employees deliver the services, run the programs and operate the facilities that support a city of over one million people. If you are committed to public service, enjoy collaborating with others, and have a desire to learn and grow, join us and make a difference in the lives of Calgarians. We offer competitive wages, comprehensive health benefits and insurance, defined benefit pension plan, work-life balance, flexible work options, health-spending account, diverse and inclusive workplace, learning and development opportunities, wellness programs and more.
A common purpose guides all our choices and decisions - to make life better every day. We anticipate the future and are committed to fostering a culture of innovation, creativity and best practices. We are at our best when we take responsibility for our actions and work together for the benefit of the people of Calgary. Together we make Calgary a great place to make a living, a great place to make a life.
Make working for The City work for you, apply today at www.calgary.ca/careers.
To speak with a City recruiter, connect with Ashu Gandhi, David Fletcher or Jaci Spence-Eising on LinkedIn.
Database Administrator 2
Top Benefits
About the role
If you are committed to public service, enjoy collaborating with others, share our values and have a desire to learn and grow, join The City of Calgary. City employees deliver the services, run the programs and operate the facilities which make a difference in our community. We support work-life balance, promote physical and psychological safety, and offer competitive wages, pensions, and benefits. Together we make Calgary a great place to make a living, a great place to make a life.
The City is committed to fostering a respectful, inclusive and equitable workplace which is representative of the community we serve. We welcome those who have demonstrated a commitment to upholding the values of equity, diversity, inclusion, anti-racism and reconciliation. Applications are encouraged from members of groups that are historically disadvantaged and underrepresented. Accommodations are available during the hiring process, upon request.
As a Database Administrator 2 reporting to the Leader of Database Administration and working as a member of a team, you will assist in developing and managing The City's database management systems. Primary duties include:
- Deploy database solutions, manage database backups and access, and keep databases secure and operational.
- Create and maintain all databases required for development, testing and production usage.
- Administer all database objects including tables, indexes, views, sequences, packages and procedures.
- Plan and implement backup and recovery for all new databases.
- Monitor database usage and alerts, take actions to avoid future database problems, security issues and vulnerabilities.
- Monitor database environment, make changes to data structures and Database Management Systems (DBMS) subsystems to optimize performance.
- Plan and upgrade the database to enhance product features and technologies, and to maintain vendor support.
- Work with application developers to ensure success of new development roll out.
- Troubleshoot on matters pertaining to database access, performance, integrity and security.
- Create and maintain technology standards, guidelines and best practices for databases.
- Assist with new DBMS technology evaluations and implementations.
- Communicate clearly and positively with clients, key partners and management in formal and informal settings. Always maintaining a professional demeanor as a representative of the Database Support team.
Qualifications
- A degree in Computer Science, Commerce, Engineering, Math or related field with at least 3 years of Information Technology experience including 1 year of Database Administrator (DBA) experience; OR
- A completed 2 year technical diploma with at least 5 years of Information Technology experience including 3 years of DBA experience.
- Preference will be given to individuals with experience in Oracle, Microsoft SQL Server and Azure, and MySQL database administration in a large data centre, Oracle Enterprise Manager Cloud Control, Oracle Recovery Manager, Dell Spotlight, Remedy, ESRI ArcSDE, Vmware and UNIX/Linux/Windows operating systems.
- Working knowledge on Open-Source NoSQL Database and strong Project Management skills will be assets.
- You are independent, well-organized and self-motivated individual who has strong teamwork, excellent organizational, communication and customer service skills.
Pre-employment Requirements
- A security clearance will be conducted.
- Successful applicants must provide proof of qualifications.
Workstyle
- This position may be eligible to work from home for at least part of the time as one of several flexible work options available to City employees. These arrangements depend on the operational requirements of the role, employee suitability, and are subject to change based on operational needs and corporate direction.
Union: CUPE Local 38
Business Unit: Information Technology
Position Type: 1 Permanent
Location: 133 6 Avenue SE
Compensation: Pay Grade 11 $46.21 - 61.78 per hour.
Out-of-Schedule Rates: $57.27 - 69.67 per hour.
This position is presently paid at an Out-of-Schedule rate
to reflect current market conditions. Should market
conditions change, the salary may be reviewed and
may revert to the base rate.
Days of Work: This position typically works a 5 day
work week, with 1 day off in each 3 week cycle.
Hours of work: Standard 35 hour work week
Audience: Internal/External
Apply By: February 26, 2026
Job ID #: 313496
About City of Calgary
City of Calgary employees deliver the services, run the programs and operate the facilities that support a city of over one million people. If you are committed to public service, enjoy collaborating with others, and have a desire to learn and grow, join us and make a difference in the lives of Calgarians. We offer competitive wages, comprehensive health benefits and insurance, defined benefit pension plan, work-life balance, flexible work options, health-spending account, diverse and inclusive workplace, learning and development opportunities, wellness programs and more.
A common purpose guides all our choices and decisions - to make life better every day. We anticipate the future and are committed to fostering a culture of innovation, creativity and best practices. We are at our best when we take responsibility for our actions and work together for the benefit of the people of Calgary. Together we make Calgary a great place to make a living, a great place to make a life.
Make working for The City work for you, apply today at www.calgary.ca/careers.
To speak with a City recruiter, connect with Ashu Gandhi, David Fletcher or Jaci Spence-Eising on LinkedIn.