City of Vancouver

OPEN TO THE PUBLIC

Database/Data Administrator – Comp. 08-0723

Close Date: January 16, 2009

[return to job listings]

The City of Vancouver has a vacancy for a Systems Analyst II (Database/Data Administrator) in the CUBES team in the Information Technology Department, Business Planning & Services, reporting to the Application Development Manager. This exempt position is responsible for working closely with City staff in analyzing and making improvements to business processes; maintaining development and production databases; providing technical guidance; and developing technical solutions to meet the needs of the City’s business units. This position will support the Revenue Services Billing & Collections Systems; apply and test application and database upgrades and patches, monitor and tune performance of the application and database servers, plan for maximum availability and backup & recovery, modify and maintain existing interfaces; provide SQL expertise to programmers; develop and maintain test scripts and scenarios and manage testing; investigate and follow up on system errors/problems; support the system outside of normal working business hours; liaise with vendors; document systems and procedures; ensure security and confidentiality of Revenue services data; act as Project Manager as appropriate on technical projects and participate in the development of training material for customers and developers. The successful candidate will prepare and deliver oral and written presentations and review the use and application of Information Technology standards and procedures, liaising with Information Technology staff to maintain consistency and continuity with the City's technology and information base. This position periodically performs system administration roles for the Revenue Services Billing & Collection Systems.

Qualifications:
You will have a diploma in information technology; a minimum of 3 years database/data administration experience with Oracle 10g. SQL Server 2000 or 2005 database experience is also an asset. You will also have strong analytical and problem solving skills; requires knowledge of current technology, excellent project management and organizational skills; strong background in SQL; experience leading a team; superior analytical and solution techniques applicable to systems; excellent oral, written, and presentation skills; demonstrated excellence in providing customer service; and a good working knowledge of office productivity tools. Knowledge of Tempest database schema and the Tempest Billings & Collections System, the Fairfax Quick Modules System, Centura, Oracle and SQL query tools, Middleware/EAI (i.e. BizTalk) and Oracle Spatial would be an advantage.

An Enhanced Reliability Check security clearance is a requirement of this position.

Salary Range:
Compensation for this exempt position includes an annual salary of $67,370 to $84,207* plus an excellent benefits and vacation package as well as an earned-days-off system.

*Based on 2008 Rates. January 1, 2009 – 3.5% wage increase.

We thank all applicants for their interest. However, only those selected for an interview will be contacted.

19 December 2008, apply at http://vancouver.ca/humanresources/jobs/08-0723O2P.htm