Database Administrator 2

City of Calgary; Calgary; On-site; CAD 70,000 - 90,000; Full time

Benefits offered by this job

Work-life balance

Competitive wages

Pensions and benefits

Flexible work options

Job summary

A municipal government in Alberta is hiring a Database Administrator 2 responsible for deploying and managing database solutions. This position involves maintaining database integrity and collaborating with teams to optimize performance. Candidates should possess a degree or diploma in relevant fields and have demonstrated DBA experience, especially with Oracle, SQL Server, and Azure. The City promotes a work-life balance and supports flexible work from home options depending on operational needs.

Qualifications

• At least 3 years of Information Technology experience including 1 year of Database Administrator experience.
• Preference will be given to those with large data centre administration experience.

Responsibilities

• Deploy database solutions and manage backups.
• Create and maintain databases for development, testing and production.
• Administer database objects including tables and procedures.
• Monitor database usage and security issues.
• Make changes to optimize database performance.
• Plan database upgrades and maintain vendor support.
• Work with application developers during rollouts.
• Troubleshoot issues related to database access and performance.

Skills

Database management

Team collaboration

Project Management

Communication skills

Education

Degree in Computer Science, Commerce, Engineering, Math

2-year technical diploma

Tools

Oracle

Microsoft SQL Server

Azure

MySQL

UNIX/Linux/Windows

Oracle Enterprise Manager

Dell Spotlight

Remedy

ESRI ArcSDE

Open-Source NoSQL Database

Job description

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.