Senior Database Administrator

 

 

Requisition ID: 20502  
Department: Finance and Corporate Services Dept.  
Service: Information Technology Services  
Branch: Network Engineering & Operations Branch 
Employment Type: 1 Full Time Temporary Position (Up to 2 Years) 
Work Hours: 35.00 hours per week
Affiliation: CIPP 
Salary Information: $93,764.58 - $114,097.62  annually (2025 rates of pay)
Location: 100 Constellation, Nepean  
City: Ottawa, ON 
Job Category: Information Technology 
Application Close: 13/03/2026

JOB SUMMARY

The Network Engineering and Operations Branch provides network engineering and operational support and maintenance of the City of Ottawa’s network infrastructure and related networking solutions, which are key enablers of the delivery of all IT services to the corporate and residents.

You provide technical expertise for the management of corporate databases and related platforms and services. You are responsible for the day-to-day operations of a portfolio of databases and related services, and contribute to the ongoing planning for underlying infrastructures and architectures. You also lead database and related activities for complex projects, and actively participate in the unit’s and branch’s business planning functions.

EDUCATION AND EXPERIENCE

Completion of 3 year  community college diploma in Computer Science or a related field. University degree is preferred.

Minimum of  5 years of information technology experience and a minimum of 3 years focusing on database administration and development

KNOWLEDGE

• Knowledge of PowerShell scripting, SQL Server, and SQL Server Integration Services will be considered an asset
• Concepts, operations and management, infrastructure, architecture, configuration, performance, security, backup & restore, best practices and tools relating to Oracle, Microsoft SQL Server, MySQL and other database platforms including open source and cloud-based database services (i.e., Azure, Oracle & AWS),
• Concepts, operations, scripting, security, best practices, and tools relating to Windows, Unix and Linux for database management and operations,
• General understanding of the information technology field, including the different sub-disciplines (i.e., application architectures, networking, servers, storage, cloud, and security) and their relationships with database architecture and management,
• Advanced programming methodologies, techniques, security standards, and tools for databases and related platforms and services (i.e., PL/SQL, T-SQL, Shell scripting, PowerShell, Python, etc.),
• Database related analytic concepts (i.e. data warehouses & data lakes)
• Database performance tuning processes, strategies, and tools, 
• Industry trends and developments in database architecture, operations, management, and infrastructure management
• Project management
• Data transformation concepts and tools (i.e., SSIS, Data Factory)
• Data modelling techniques and practices
• Applicable legislation (e.g. the Municipal Freedom of Information and Protection of Privacy Act), and Payment Card Industry Standards
• Knowledge of applicable health and safety legislation, including the rights and duties of workers.
• Desirable Qualifications:
• Experience managing NoSQL and Graph database products
• Experience managing Azure cloud database services including analytical database services such as Data Lakes
• Experience with data transformation platforms such as SSIS, Data Factory
• Knowledge of Enterprise Architecture principles
• City services and applications

COMPETENCIES, SKILLS AND ABILITIES

• Database design, development and administration
• ETL design, development and administration
• Troubleshoot and resolve complex technical problems
• Performance tuning
• Analyze statistics and trends and forecast future requirements
• Write reports, documentation and procedures
• Provide technical leadership and take initiative
• Liaise effectively with all levels of staff, city partners and vendors, across multiple business lines
• Plan for the impact of technology changes on the city
• Organize work and meet deadlines
• Use effective judgment when immediate supervision is unavailable
• Research and analytical skills
• Mentor junior staff (where applicable)
• Good organization and prioritization skills to handle multi-tasking
• Enterprise scale application deployments
• Communication skills to challenge vendor/contractor solutions 
• Research, analytical and forecasting skills
• Exceptional critical thinking and problem-solving skills
• Build and lead teams, and supervise the work of external technical specialists
• Diplomatic and tactful
• Collaborative approach in working with others
• Able to interact with other organizations' technical staff effectively
• Well organized and reliable
• Able to handle multiple tasks and work independently with minimum supervision
• Trustworthy with privileged accounts and information
• Work well under pressure
• Commitment to client service/satisfaction
• Self-motivated
• Demonstrates initiative and a good work ethic
• Willing to work flexible hours, including evenings and weekends
• Work systematically and calmly under pressure 

WHAT YOU NEED TO KNOW

• Language Requirement: English oral, reading, writing       
• Experience and formal training combined with demonstrated performance and ability may substitute for stipulated academic requirements. 
• Please save a copy of the job poster. Once the closing date has passed, it will no longer be available. 

 

We wish to thank all applicants for their interest and effort in applying for this position. Only candidates selected for interviews will be contacted. 

 

The City of Ottawa promotes the principles of diversity and inclusion and adheres to the tenets of the Canadian Human Rights Act and the Ontario Human Rights Code. We encourage applications from members of Indigenous, Black and other racialized communities, persons with disabilities, women and non-binary persons, persons of all ethnic origins, religions, sexual orientations, classes, gender identities and expressions. 
Candidates are encouraged to self-identify as a member of one or more designated employment equity groups in the self-identification questionnaire.

 

The City of Ottawa provides accommodation to applicants during all parts of the hiring process, upon request. If contacted to proceed to the selection process, please advise us if you require any accommodation.

 

Accessible formats and communication supports are available upon request. Please contact the Employee Service Centre at 613-580-2424 extension 12211 or via email at esc-cse@ottawa.ca.