Database Administrator, IT Full-time Job

Job Summary

Create secure and reliable storage structures that allow business applications to utilize City data.  Plan, develop, forecast, manage and implement a process to monitor and enhance the overall performance of the databases and business applications, ensuring availability.  Manage and monitor database security administration and service performance.  Provide technical leadership and guidance to Information Technology and business units.

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 the continuity of business. 
• Monitor vendor notifications for patches and alerts - review, evaluate impact to 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 implementing database load balancing technologies. 
• Provide maintenance on databases for optimal performance i.e. rebuilding of databases/indexes.
• Support 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 related discipline with a minimum of five years of database administration 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.