Job Summary
Duties And Responsibilities
- Configure and provide database performance and general health/capacity monitoring as an ongoing task for the City to conduct business in a safe, reliable and stable environment.
- Monitor reports generated from the system and take necessary action to resolve incidents that may affect business continuity.
- Monitor vendor notifications for patches and alerts---review, evaluate the impact on City data and infrastructure, and make necessary recommendations.
- Lead and coordinate other City staff to implement changes i.e. version upgrade of database where a major upgrade could span over two years and a minor upgrade could span over several months.
- Tune databases for optimal performance and implement database load-balancing technologies.
- Provide maintenance on databases for optimal performance, i.e., rebuilding databases/indexes.
- Support the development and implementation of projects, performing installations, database loading, data conversions, promoting application changes to various environments, testing, etc.
- Troubleshoot and resolve database problems in a timely manner.
- Design and Implement the electronic storage structures using industry-standard software, such as Oracle Database Server, SQL Server, and cloud-related databases.
- Configure to ensure that the data in these structures is reliable and secure by adhering to policies and guidelines regarding database security to meet legislative, audit and Privacy Act requirements i.e. audit database security for projects to meet audit requirements.
- Review, recommend, plan and implement database patches to mitigate issues and to ensure the databases are maintained in supported versions.
Skills And Qualifications
- Post-secondary degree/diploma in computer science or a related discipline with a minimum of five years of database administration experience using Microsoft SQL Server, Oracle, and Cloud-related databases.
- Database related certifications related to Oracle, SQL Server, Amazon Web Services (AWS), Microsoft Azure, etc.
- Detailed knowledge of Oracle, SQL Server database and application server concepts and design.
- Thorough knowledge of conceptual, logical data repository development and management, database administration and data architecture technologies, i.e. desktop client, web-based, cloud computing.
- In-depth knowledge of relational objects such as tables, stored procedures, triggers and DTS/SSIS packages is required.
- Knowledge of related technologies such as AD, Windows OS, Amazon, Azure, Dynamics, MySQL, .Net, Oracle and Microsoft products, and IIS application Server.
- Must understand the impact of new applications on existing information technology infrastructures (hardware platforms, communications network, standards, security, etc.
- Thorough knowledge of interface methods for database and enterprise applications.
- Must have an overall knowledge of the City's technical infrastructure i.e. Servers, Windows, operating systems, and Communication networks in place.
- Excellent technical, project management, analytical and communication skills.
- May require some light lifting of supplies/materials.
Equity, Diversity and Inclusion
Accommodations
