1. Energy careers
  2. Information technology roles
  3. Database Administrator

Database Administrator

NOC #21211

  • Environment Primarily indoor/office work
  • Education Post-secondary degree
  • Average salary $60,000 to $112,000

Career profile

Database administrators (DBAs) use specialized software to store and organize electronic data. They handle the day-to-day operation of database management systems. Additionally, they are often responsible for developing and introducing related policies and standards for employee use of these databases. Their work is critical to ensuring accurate storage and accessibility of the data used by thousands of employees across the energy sector daily.

Database administrators may work in teams within large companies or be the sole expert in a smaller company. They understand and work using database languages, the most common of which is Structured Query Language (SQL), which is used in programming and managing data held in relational database management systems.

Exploration and production, Oil and gas services, Pipelines, Offshore, Oil sands

In this occupation activities may include:

  • Researching and documenting data requirements, data collection and administration policy, data access rules and security.
  • Specifying users and user access levels for each segment of the databases.
  • Monitoring and modifying existing databases and database management systems, or directing programmers and analysts to make changes, to customize for specific company needs.
  • Developing and implementing data administration policy, standards and models.
  • Approving, scheduling, planning, and supervising the installation and testing of new products and improvements to computer systems, such as the installation of new databases.

Education

  • A bachelor’s degree in Computer Science or related field is typically required.
  • Computer programming experience may be required.

Certifications

  • Some employers require applicants to become trained or certified for a specific type of network environment such as:
  • SAP HANA
  • Microsoft SQL Server
  • Oracle SQL
  • IBM Db2
  • There may be a preference for certification/ experience with PL/SQL, Java, SSRS, Python, C++, etc.

Licensing

  • The title Information Systems Professional is a protected title under Alberta’s Professional and Occupational Associations Registration Act. An IT practitioner does not have to be registered if they do not refer to themselves as an Information Systems Professional.

Additional Requirements

  • Specific health and safety certifications may be required, determined by location of work and company requirements

  • Travel likely required
  • Primarily indoor/office work
  • Work not physically demanding

You use your analytical nature to organize large amounts of data into a meaningful pattern that’s easily used. You often work on teams, so you need strong communications and interpersonal skills as well. From a technical viewpoint, you understand database languages, the most common of which is Structured Query Language (SQL), which is used in programming and managing data.

  • Customer and Personal Service
  • Information and Document Management
  • Cyber/Data Security
  • Data Entry
  • Interpreting Documents/Plans
  • Writing, Technical Writing, Document Production
  • Installation
  • Systems Evaluation and Analysis
  • Coordination
  • Planning and Organizing
  • Troubleshooting
  • Attention to Detail