Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
Truck Driver Position Occupational Therapist 0 0 PR Digital Marketing Intern Delivery Driver Paid Healthy Trial Participant Paid Clinical Trial Participant Paid Research Participant BairesWash Incorpora Personal Para Software Developer Bread Baker Dental Receptionist-Full Time Driller Delivery Driver Carpenter Bud Tender Hiring Mortgage Agents and Brokers Marketing Assistant Amazon Picker Amazon Warehouse Associate - Immediate Amazon Warehouse Associate - Immediate Amazon Order Packer Seasonal Full-Time Warehouse Team Member Amazon Picker Amazon Warehouse Associate Full-Time Warehouse Team Member Amazon Warehouse Worker Amazon Picker Amazon Picker Amazon Warehouse Associate - Immediate Amazon Picker Full-Time Warehouse Team Member Amazon Picker Amazon Picker Amazon Warehouse Worker Amazon Warehouse Associate - Immediate Amazon Warehouse Associate - Free Amazon Warehouse Worker Amazon Warehouse Worker Amazon Warehouse Associate Amazon Order Packer Amazon Warehouse Associate - Free Seasonal Full-Time Warehouse Team Member Amazon Warehouse Worker Amazon Picker Amazon Warehouse Worker Full-Time Warehouse Team Member Amazon Warehouse Worker Newest Jobs
Companies
Yelp ContactMonkey CareGuide Clearbanc Sterling-Turner Exact Media Aerotek Two Sigma Aecom Peel Regional Police AsteroidX Akira Jane Street Borrowell Insight Global WeWork Shopify First Convenience Bank American Income Life Doordash Amazon Flex Square Microsoft AT&T Instacart Clickworker Vector Marketing Scotiabank Creative Circle Hatchways Walgreens UnitedHealth Group Recovhub LowCostWebDesignFirm.com Desjardins CI&T mappedin 51talk Top Hat Checkout 51 Paylocity Mobeewave TD Bank The Youth Connection Hootsuite SnapTravel ScribbleLive autoTRADER.ca GoParkr Xiaomi All Companies
Top Cities
Chicago, Illinois Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs New York, New York Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Toronto, Ontario Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Vancouver, British Columbia Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Calgary, Alberta Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs San Francisco, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Montréal, Quebec Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Los Angeles, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs
Navigation
My Profile Log Out

Senior Database Administrator At City of Cambridge

Location: Cambridge, Ontario

Job Description

People, Place, Prosperity


Working within our Strategic Plan of People, Place, and Prosperity, and committing to our values of Integrity, Respect, Inclusiveness and Service, the successful candidate will work together to make the City of Cambridge a place for people to prosper – alive with opportunity.




Job Profile


The Senior Database Administrator will work collaboratively to provide support to all departments and provide a balance between technology and customer needs. This position will assist in the adoption of an Enterprise Architecture and provide support for the development of corporate data standards, data maintenance processes and authoritative, corporate datasets that can facilitate integration between systems and processes.




What you will be doing


  • Provides support to various corporate applications, data modeling and business reporting functions.
  • Designs, documents, and supports data integrity, automation, reporting, and data mining needs using database objects such as: views, functions, stored procedures, triggers, etc. using Oracle PL/SQL, SAP HANA, SQL or MS SQL.
  • Lead design reviews for database designs, application code, and pre and post-implementation capacity meetings; estimate sizes of new databases.
  • Be capable of producing entity-relationship diagram; data flow diagram; database normalization schema; logical-to-physical database mapping; DDL and database commands.
  • Perform application refreshes on request: Refresh data from one environment to another at the request of the application development staff; execute necessary tasks to accomplish this, including export, drop, create, and import; build and schedule a script to accomplish refreshes to minimize impact; provide application development staff optimal development environment with current data.
  • Work closely with business system analysts and developers, understand system requirements from conceptual models, analyze transactions and data volumes, and design the physical database.
  • Assist in the definition and development of database documentation and standards.
  • Work closely with other DBA’s, network and security teams to develop technical requirements necessary to implement successful projects with minimal risk.



Education


Undergraduate Level - Four years or equivalent in Computer Science or Similar




Required Certificates


Oracle Professional Certification within Oracle’s DBA Development Path including completed courses on: PL/SQL, Architecture and Administration, Backup and Recovery, Performance Tuning and Network Administration.




Experience and Knowledge


  • Thorough understanding of the relational database model and solid theoretical knowledge of relational database techniques.
  • 5+ years of professional experience in Design, Administration, Programming and Support of RDBMSs (e.g., Oracle, SAP HANA, SQL Server) is essential.
  • Experience in designing, modeling, developing, and supporting large RDBMS system, such as Oracle, MS SQL and SAP HANA in one or more computing environments, such as Windows, Linux and Cloud.
  • Experience in BI tools, such as SAP crystal report, Lumira.
  • Experience with spatial database programing using ESRI SDE functions and procedures.
  • Ability to handle system administration tasks to fulfill backup role if needed.
  • Highly desirable that individual has earned certification as a developer or DBA.



We will ask you for these items if you are hired


Proof of your current and valid certificate(s) and/or educational qualifications.

Worker Health and Safety Awareness Training certificate from the Ministry of Labour.

Valid G driver's license.




Your compensation


The annual salary range for this non-union position is $81,258 to $99,093, Band Level 5




Hours of work


Based on a 35 hour work week, 8:30 a.m. to 4:30 p.m., Monday to Friday.




Advertisement expiration date


This posting closes on October 22, 2018.




Accommodation needs and protection of privacy


The City of Cambridge is committed to inclusion and diversity and encourages applications from all qualified individuals. Accommodations are available on request for candidates taking part in all aspects of the selection process. Please make your needs known in advance by contacting the Human Resources Division.

Personal information collected in relation to the recruitment process is collected under the authority outlined in the Municipal Freedom of Information and Protection of Privacy Act and used solely to determine eligibility for employment with the City of Cambridge only.