Requisition ID: 7036
Department: Finance and Corporate Services Dept.
Service: Information Technology Services
Branch: Network Engineering & Operations Branch
Employment Type: 1 Full-time Temporary - Up to 2 years
Work Hours: 35.00 /hours per week
Affiliation: CIPP
Salary Information: $87,068.80 - $105,951.30 annually (2022 rates of pay)
Location: 100 Constellation, Nepean
City: Ottawa, ON
Job Category: Information Technology
Application Close: 15/03/2023

JOB SUMMARY

The Network Engineering and Operations Branch is responsible for network engineering and operational support and maintenance of the City of Ottawa\xe2\x80\x99s network infrastructure and related networking solutions, which are key enablers of the delivery of all IT services to the corporation and residents, including strategic planning for complex networking engineering technologies and projects. You are responsible to manage a portfolio of databases, and contribute to the database and extract, transformation and load (ETL) infrastructures and architectures. You also lead assigned database and/or ETL projects, and serve as the unit/branch representative on inter-branch, departmental, corporate and client projects.

This position is for a Senior Database Administrator with strong experience supporting Oracle and or Microsoft SQL Server. Experience supporting Microsoft Azure databases will be considered an asset.

EDUCATION AND EXPERIENCE

Completion of 3 year university degree or community college diploma in Computer Science or a related field Minimum of 5 years of information technology experience and a minimum of 3 years focusing on database and/or ETL administration and development Experience using IBM Infosphere DataStage is desirable

KNOWLEDGE

• Extensive knowledge of databases
• Concepts, tools and techniques used in managing Oracle and or SQL Server database platforms and Unix (ie Solaris), Linux or Windows platforms
• Database and/or ETL performance tuning practices
• Data modelling techniques and practices
• Methodologies and techniques used in developing databases (i.e. PL/SQL, T-SQL)
• LAN, WAN concepts and TCP/IP protocol as applicable to database management
• Web based and/or client server application design concepts
• Data Warehousing concepts
• Methodologies and tools used in managing and developing enterprise ETL solutions
• IT security best practices and standards relating to application development and/or integration
• 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:

• Techniques and practices used in managing MySQL
• 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
• 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
• 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

WHAT YOU NEED TO KNOW

• Language Requirement: English oral, reading, writing
• Police Record Check: The successful candidate will be required to complete a Criminal Records and Judicial Matters Check with the Police Services detachment in their jurisdiction to the City of Ottawa\xe2\x80\x99s satisfaction.; Police record checks completed by a third-party company will not be accepted.
• 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 during all parts of the hiring process, upon request, to applicants with disabilities. 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 HR Service Centre at 613-580-2424, extension 47411.