database analyst (DBA)
- Mississauga, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
Overview
Languages
English
Education
2 years to less than 3 years
On site
Work must be completed at the physical location. There is no option to work remotely.
Responsibilities
Tasks
Computer and technology knowledge
Work conditions and physical capabilities
Health benefits
Languages
English
Education
- Bachelor's degree
2 years to less than 3 years
On site
Work must be completed at the physical location. There is no option to work remotely.
Responsibilities
Tasks
- Collect data to identify areas for improvement within an organization’s IT infrastructure
- Data Science
- Develop and implement a strategic blueprint to follow when deploying databases within their organization
- Develop and maintain computer databases
- Document customers’ requirements for projects
- Document reporting needs, queries, logic, results and recommendations to other information systems professionals
- Enact measures to make sure unauthorized users cannot access the data
- Liaise with staff on data requirements, collection and availability
- Provide advice to other informatics professionals regarding database management tools
- 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
- Develop and implement data administration policy, standards and models
- Research and document data requirements, data collection and administration policy, and data access rules
- Write scripts related to stored procedures and triggers
Computer and technology knowledge
- Excel Visual Basic for Applications (VBA)
- Machine Learning
- Microsoft Visual Studio
- Data Warehouse
- Internet
- Desktop applications
- File management software
- Multimedia software
- Word processing software
- Presentation software
- Mail server software
- Communication software
- Programming software
- Mapping and data visualization software
- Database software
- Programming languages
- Enterprise resource planning (ERP) software
- Data analysis software
- MS Office
- MS Windows
- Spreadsheet
- Big data
- Python
- SQL
- Business intelligence
- Electronic mail
- E-commerce
Work conditions and physical capabilities
- Work under pressure
- Attention to detail
- Sitting
- Accurate
- Client focus
- Efficient interpersonal skills
- Excellent oral communication
- Excellent written communication
- Initiative
- Judgement
- Organized
- Team player
- Adaptability
- Accountability
- Quick learner
Health benefits
- Dental plan
- Disability benefits
- Health care plan
- Paramedical services coverage
- Vision care benefits
- Bonus
- Life insurance
- Free parking available
More about this job
Responsibilities
Design, develop, maintain, and operate databases and database management systems, including creating deployment strategies and supporting application access. Analyze data, document requirements and reporting logic, establish data administration policies, and implement measures to protect data from unauthorized access.
Requirements
A bachelor's degree and 2 to less than 3 years of experience are specified. The role requires knowledge of database software, SQL, Python, data analysis, data warehousing, and related business and productivity applications, along with accuracy, communication, organization, and teamwork.
Skills
- Database Design
- Database Administration
- SQL
- Python
- Data Analysis
- Data Warehousing
- Machine Learning
- Visual Basic for Applications
- Business Intelligence
- Data Visualization
- Data Security
- Stored Procedures
- Triggers
- Data Modeling
- Microsoft Excel
- Enterprise Resource Planning
Benefits
- Dental Plan
- Disability Benefits
- Health Care Plan
- Paramedical Services Coverage
- Vision Care Benefits
- Bonus
- Life Insurance
- Free Parking
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
- Manufacturing
Keywords
- Database Administration
- Database Design
- Database Management Systems
- SQL
- Python
- Data Analysis
- Data Warehousing
- Machine Learning
- Business Intelligence
- Data Modeling
- Data Administration
- Data Security
- Stored Procedures
- Triggers
- Microsoft Excel
- Visual Basic for Applications
- Microsoft Visual Studio
- Enterprise Resource Planning
- Big Data
- Data Visualization
- Microsoft Office
- Microsoft Windows
- E-Commerce
- IT Infrastructure
- Reporting
- Data Collection