Database Administrator

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 No
  
  SQL 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.