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