Intermediate Database Administrator - Dublin, Canada - Information Services Corporation

Information Services Corporation
Information Services Corporation
Verified Company
Dublin, Canada

1 month ago

Sophia Lee

Posted by:

Sophia Lee

beBee Recruiter
Description

Company Name:
Enterprise Registry Solutions Limited


The Intermediate Database Administrator (DBA) designs, creates and maintains databases in a client/service environment with particular focus and attention given to large, complex and / or critical database systems required for client implementations.

You will also be expected to take part in various data migration projects for our clients.

You will be required to identify the data to be migrated and develop programs to map and transform the data into new repositories.


Major Activities:

  • Responsible to lead the design, creation, configuring, installation and maintenance of the database software for clients and in particular where large, complex and critical databases are required.
  • Manage database upgrades patching and ongoing database maintenance.
  • Organize and maintain a secure database by managing employee access, creating logins, managing roles and rights to control database usage and implementing database auditing where necessary.
  • Implement and manage the database backup strategy and database recovery and ensure high availability and disaster recovery (where necessary).
  • Monitor database performance issues, storage and archiving procedures to ensure database is functioning correctly and as efficiently as possible.
  • Perform specialized data handling (data extract, transformation and load (ETL) process and data imports and exports.
  • For new client projects, develop and execute data migration plans, ensuring that all data is accurately transferred from the old system to the new.
  • Perform data cleansing and data transformation tasks as needed during migration projects.
  • Write database documentation including data standards, procedures, and processes.
  • Plan and design high performing database systems using a logical design and translating into an efficient data model.
  • Communicate and advise senior management and users on new or optimal technologies or methods and make recommendations to improve the functionality and/or efficiency of the databases.

Position Requirements:

  • Bachelor of Computer Science or equivalent education and 5+ years of relevant work experience.
  • SQL Certification would be a definite asset.
  • Strong knowledge of database triggers, procedures and functions.
  • Strong knowledge of common database management tools such as SQL Service Management Studio.
  • Strong knowledge of database scripting.
  • Experience working with Azure SQL.
  • Experience in data extract, transformation, and load (ETL) process.
  • Experience in data exports and imports.
  • Experience in handling data formats.
  • Experience in planning and design of high performing database systems.
  • Strong problem solving and troubleshooting skills.
  • Knowledge of tuning to ensure database is operating efficiently.
  • Experience in data migration projects is a must.
  • Expertise in Sql Server Integration Services would be advantageous.
More jobs from Information Services Corporation
See all jobs of Information Services Corporation