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         Save