Senior Database Technical Analyst

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.
  
  

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.

Union: CUPE Local 38
Position Type: 1 Permanent
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.
Hours of work: Standard 35 hour work week
Audience: Internal/External
Business Unit: Information Technology
Location: 133 6 Avenue SE
Days of Work: This position works a 5 day work week with 1 day off in a 3 week cycle.
Apply By: November 5, 2024
Job ID #: 310548