Database Administrator 2

City of Calgary

Calgary

Hybrid

CAD 70,000 - 90,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote-Eligible Database Administrator II
Remote-Eligible Database Administrator II

City of Calgary • Calgary

Hybrid
CAD 70,000 - 90,000
Work-life balance
Competitive wages
Pensions and benefits
+1
Database Administrator
Database Administrator

Eizie • Kitamaat

On-site
CAD 90,000 - 120,000
Competitive salary
Health benefits
Professional development
+5
Senior Database Administrator
Senior Database Administrator

BuzzClan • Toronto

On-site
CAD 83,000 - 165,000
Database Administrator (Oracle & SQL Server)
Database Administrator (Oracle & SQL Server)

Astra-North Infoteck Inc. • Calgary

On-site
CAD 85,000 - 110,000
Senior Database Developer / Administrator
Senior Database Developer / Administrator

Reelcruit • Toronto

Hybrid
CAD 90,000 - 130,000
Inclusive workplace
Growth opportunities
Flexible work arrangements
+3
Database Administrator and Back-up Consultant
Database Administrator and Back-up Consultant

TEEMA Group • Edmonton

On-site
CAD 110,000 - 150,000
Administrator, Database
Administrator, Database

imperial truck & trailer repair ltd • Calgary

On-site
CAD 40,000 - 60,000
RQ11860 – Database Administrator – Senior (Onsite)
RQ11860 – Database Administrator – Senior (Onsite)

S M Software Solutions Inc • Toronto

On-site
CAD 120,000 - 150,000
Database Administrator (DBA) - Vancouver
Database Administrator (DBA) - Vancouver

Yeah! Global • Vancouver

On-site
CAD 70,000 - 90,000
Senior Database Administrator
Senior Database Administrator

Bombardier Inc. • Dorval

Hybrid
CAD 90,000 - 130,000
Insurance plans
Retirement plan
Employee Assistance Program