database analyst (DBA)

SunCan Communications Corporation
ON, CA
$43 an hour
Permanent
  • Durée de l'emploi : Permanent
  • Langue de travail : Anglais
  • Heures de travail : 35 hours per week
  • Education :
  • Expérience :

Education

Bachelor's degree

Work setting

  • Consulting firm
  • Information technology (IT) service provider

Tasks

  • Collect data to identify areas for improvement within an organization's IT infrastructure
  • Develop and maintain computer databases
  • Document reporting needs, queries, logic, results and recommendations to other information systems professionals
  • Enact measures to make sure unauthorized users cannot access the data
  • Setup the IT infrastructure to allow applications to access databases
  • Test data models and database management systems
  • Design and develop database
  • Operate database management systems to analyze data
  • Research and document data requirements, data collection and administration policy, and data access rules
  • Develop policies and procedures for network access and usage and for the backup and recovery of data
  • Write scripts related to stored procedures and triggers
  • Design, develop and implement information systems business solutions
  • Collect and document user's requirements

Computer and technology knowledge

  • Microsoft Visual Studio
  • Shell script
  • Data Warehouse
  • Linux
  • Unix
  • Erwin
  • Informix
  • MS SQL Server
  • Servers
  • MySQL
  • Oracle
  • Database software
  • Programming languages
  • Data analysis software
  • Perl
  • Python
  • Unix Shell Scripting
  • Business intelligence

Work conditions and physical capabilities

  • Fast-paced environment
  • Work under pressure

Personal suitability

  • Excellent oral communication
  • Accountability

Screening questions

  • Are you available for shift or on-call work?
  • Are you currently legally able to work in Canada?
  • Do you currently reside in proximity to the advertised location?
  • Do you have previous experience in this field of employment?
  • What is the highest level of study you have completed?

Experience

  • 3 years to less than 5 years
  • 30+ days ago
Related jobs
SunCan Communications Corporation
ON, CA

Develop and maintain computer databases. Setup the IT infrastructure to allow applications to access databases. Test data models and database management systems. Operate database management systems to analyze data. ...

Nimbus Distro
Toronto, Ontario

Develop and implement a strategic blueprint to follow when deploying databases within their organization. Develop and maintain computer databases. Provide advice to other informatics professionals regarding database management tools. Setup the IT infrastructure to allow applications to access databa...

Procom
Toronto, Ontario

MS SQL Database Analyst (DBA)- Mandatory Skills. MS SQL Database Analyst (DBA)- Preferred Skills. MS SQL Database Analyst (DBA)- Assignment Start Date. Reporting to the DBA Manager/Lead, the Database Administrator would be supporting the MS SQL Server on-premises as well as on public cloud. ...

Promoted
Kyndryl
Canada

This role is for a seasoned DBA adept at setting up and streamlining large databases that typically scale by 2-3 terabytes monthly to an annual size of 40 terabytes. ...

Promoted
Dimensional Strategies Inc.
Toronto, Ontario

Our services stack will be primarily Azure Data Lake, Azure Data Factory, Azure Databricks, and Azure Synapse Analytics. Own the execution and delivery of our data platform projects that focus primarily on ingesting and curating data for analytical consumption. Thorough understanding of the entire d...

Promoted
Capgemini Engineering
Canada

As a Senior Engineer, you will build distributed data processing solution and highly loaded database solutions for various cases including reporting, product analytics, marketing optimization and financial reporting. Chip in as part of self-organized team of data engineers working in an innovative e...

Promoted
Tata Consultancy Services
Mississauga, Ontario

Spring Boot, Docker, MongoDB, Oracle, Kafka, Elastic, AMQP, Kubernetes & Open Shift. ...

Promoted
Open Systems Technologies
Mississauga, Ontario

Job Title: Senior Database Developer. Hands on data model design in SQL and NO-SQL database, design and code on the store procedure to implement the business knowledge. ...

Promoted
Fopconsultants
Canada

To meet the needs of its clients in the IT sector, FOP EXPERTS CONSEILS is looking for motivated consultants in DBA analysis (Oracle and SQL Server) for various projects. A minimum of two (2) years of practical experience with the following technologies: Forms/Reports development, Oracle 12C DB, Ora...

Promoted
Zortech Solutions
Toronto, Ontario

Power BI, SQL Developer – 5+ years relevant experience in creating analytics dashboards/reports using Power BI, with experience in handling and manipulating data using SQL. Comfortable with hands-on SQL data handling manipulation – SSIS, SSAS. Experience in data preparation, data warehousing, script...