MINJobs posting: Senior Database Technical Analyst
October 31, 2024
Municipal Information Network

Senior Database Technical Analyst

Organization:
City of Calgary
Region:
Alberta
Application deadline:
November 5, 2024
Type:
Full time
Category:
Information technology
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 Senior Database Technical Analyst reporting to the Supervisor 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 both written and verbally with clients, key partners and management in formal and informal settings. Always maintaining a professional demeanor as a representative of the Database Support team.
Requirements
  • 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.
Salary & Benefits

Compensation: Pay Grade 11 $43.35 - 57.96 per hour (2024 Rates)

Out-of-Schedule Rates: $53.72 - 65.36 per hour (2024 Rates). 

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.

Other relevant information
Apply online at www.calgary.ca/careers