Computer Centre

Computer Centre is an emerging leader in digital services and consulting.

IT System Support Engineer – Level II (1 Position)

We’re HIRING: Database Administrator (DBA) & Data Warehouse Specialist

Responsibilities

Database Administration Responsibilities

• Install, configure, and maintain PostgreSQL, SQL Server, MySQL, and Oracle Database systems.
• Monitor database performance and implement optimizations for speed, reliability, and scalability.
• Manage backup and recovery processes, including routine testing of restore procedures.
• Address and resolve database issues, including performance bottlenecks, query tuning, and connectivity problems.
• Implement strong security measures such as user access control, encryption, auditing, and compliance.
• Perform routine maintenance including upgrades, patching, replication setup, and parameter tuning.
• Document database architecture, ERDs, and standard procedures.

Data Warehouse & ETL Responsibilities

• Extract data from SQL databases, comma-delimited files, and other data sources.
• Write, understand, and optimize T-SQL queries for data extraction, transformation, and reporting.
• Develop and maintain data platforms and systems that meet the required standards for Data Warehouse and ETL processes.
• Implement and maintain ETL workflows to support business intelligence and analytics requirements.
• Adhere to best practices and methodologies in Data Warehousing and Multi-dimensional Data Modeling (OLAP).
• Demonstrate proficiency in ETL development and maintenance, including data pipelines, staging, transformations, and loading.
• Create dashboards and data visualizations to support analytical reporting (Power BI, Tableau, or similar tools).
• Collaborate with business units to understand data requirements and translate them into scalable data warehouse solutions.

Qualifications

• 2-3 years experience as a Database Administrator.
• Experience with PostgreSQL, SQL Server, MySQL, and Oracle Database.
• T-SQL skills for querying, transformations, and performance tuning.
• Experience in ETL design, development, troubleshooting, and maintenance.
• Understanding of Data Warehousing concepts, star/snowflake schemas, staging architectures, OLAP, and multidimensional modeling.
• Ability to work with various data formats, including comma-delimited files and semi-structured data.
• Understanding of database security, backups, replication, and high availability.

• Install, configure, and maintain PostgreSQL, SQL Server, MySQL, and Oracle Database systems.
• Monitor database performance and implement optimizations for speed, reliability, and scalability.
• Manage backup and recovery processes, including routine testing of restore procedures.
• Address and resolve database issues, including performance bottlenecks, query tuning, and connectivity problems.
• Implement strong security measures such as user access control, encryption, auditing, and compliance.
• Perform routine maintenance including upgrades, patching, replication setup, and parameter tuning.
• Document database architecture, ERDs, and standard procedures.
• Extract data from SQL databases, comma-delimited files, and other data sources.
• Write, understand, and optimize T-SQL queries for data extraction, transformation, and reporting.
• Develop and maintain data platforms and systems that meet the required standards for Data Warehouse and ETL processes.
• Implement and maintain ETL workflows to support business intelligence and analytics requirements.
• Adhere to best practices and methodologies in Data Warehousing and Multi-dimensional Data Modeling (OLAP).
• Demonstrate proficiency in ETL development and maintenance, including data pipelines, staging, transformations, and loading.
• Create dashboards and data visualizations to support analytical reporting (Power BI, Tableau, or similar tools).
• Collaborate with business units to understand data requirements and translate them into scalable data warehouse solutions.

• PostgreSQL
• SQL Server
• MySQL
• Oracle Database
• T-SQL
• ETL development
• Data Warehousing
• OLAP
• Power BI
• Tableau
• Database security
• Backups
• Replication
• High availability

• 2-3 years experience as a Database Administrator.
• Experience with PostgreSQL, SQL Server, MySQL, and Oracle Database.
• T-SQL skills for querying, transformations, and performance tuning.
• Experience in ETL design, development, troubleshooting, and maintenance.
• Understanding of Data Warehousing concepts, star/snowflake schemas, staging architectures, OLAP, and multidimensional modeling.
• Ability to work with various data formats, including comma-delimited files and semi-structured data.
• Understanding of database security, backups, replication, and high availability.