Explore Careers - Job Market Report

in
Printing Options
Database Analysts and Data Administrators  (NOC 2172)
Prince Edward Island
Description |  Titles |  Duties |   Related Occupations

Database analysts design, develop and administer data management solutions using database management software. Data administrators develop and implement data administration policy, standards and models. They are employed in information technology consulting firms and in information technology units throughout the private and public sectors.

data administrator, data custodian, data dictionary administrator, data warehouse analyst, database administrator (DBA), database analyst, database architect, technical architect – database.

View all

Database analysts perform some or all of the following duties:
  • Collect and document user's requirements
  • Design and develop database architecture for information systems projects
  • Design, construct, modify, integrate, implement and test data models and database management systems
  • Conduct research and provide advice to other informatics professionals regarding the selection, application and implementation of database management tools
  • Operate database management systems to analyze data and perform data mining analysis.
  • May lead, co-ordinate or supervise other workers in this group.
Data administrators perform some or all of the following duties:
  • Develop and implement data administration policy, standards and models
  • Research and document data requirements, data collection and administration policy, data access rules and security
  • Develop policies and procedures for network and/or internet database access and usage and for the backup and recovery of data
  • Conduct research and provide advice to other information systems professionals regarding the collection, availability, security and suitability of data
  • Write scripts related to stored procedures and triggers
  • May lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models.
Included Cities in Region | Service Canada Offices

Charlottetown, Summerside, Alberton, Cornwall, Kensington, Montague, Souris, Stratford

View all

View a list of Service Canada offices in this area.

Education & Job Requirements for Database Analysts and Data Administrators in Prince Edward Island

Education and job requirements can vary by region. Workers in regulated occupations require a licence to work legally. Workers in non-regulated occupations do not require a licence, but employers may have other certification requirements.

List of Associations

AssociationsLink opens in a new window are organizations that may provide news to its members about networking events, professional development and other common issues for people working in the same industry.

[ Source: Labour Market Information - HRSDC ]

CanLearn Searches

  • Programs

    Detailed profiles, requirements and application and admissions information.

  • CEGEPs, Colleges and Universities

    Find the school that best suits your needs.

  • Scholarships

    Information on scholarships, bursaries, grants, and other forms of financial assistance.

[ Source: CanLearn - HRSDC ]

Local Training

Holland College:

Two programs are offered relating to this occupation. In the Computer Information Systems (CIS) program, students learn to work in microcomputer, client/ server, internet/intranet and networked computer environments. It is a two year program and also offered as a 10 week distance program.

The Business Information Systems Development (BISD) program prepares college and university graduates to work in the IT industry as E-Business Programmers/Analysts. It is a 10 month program. Both programs are offered in Charlottetown.

In addition, Holland College has an articulation agreement with UPEI. Graduates of the Computer Programmer Analyst profile of the Computer Information Systems program can receive 39 semester hours credit towards a Bachelor of Science in Computer Science degree.

For further information contact:
Holland College
140 Weymouth Street
Charlottetown, PEI C1A 4Z1
Phone: 1-800-446-5265
www.hollandcollege.com
info@hollandcollege.com

National Home Ed

The Matrix: IT Foundations program is related to this occupation. It is a 52 week program lasting 1,404 hours.

National Home-ed
P.O. Box 2625
590 North River Road
Charlottetown, PE C1A 8C3
Phone: 1-877-277-8839
www.nationalhomeed.com
info@nationalhomeed.com

University of Prince Edward Island:

The Department of Computer Science and Information Technology offers a four-year undergraduate program with a major in computer science as well as a five year major in Computer Science with a co-operative option, both leading to a Bachelor of Science Degree.

For further information contact:
University of Prince Edward Island
550 University Avenue
Charlottetown, PE C1A 4P3
Phone: (902) 628-4353 or 1 800 606-8734
www.upei.ca
newstudent@upei.ca

[ Report Publication Date: 2011-08-26 | Source: Labour Market Information - HRSDC ]
Information for Newcomers

Getting your language skills assessed

If you do not know what your English or French language level is, visit one of the Language Assessment Centres across Canada. They will assess your language level and direct you to the appropriate language training program.

[ Source: Citizenship and Immigration Canada ]
Please consult the Prince Edward Island and Canada tabs for more useful information related to education and job requirements.