database analyst (DBA)

Education:

Bachelor's degree.

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.

Area of specialization:

E-commerce.

Work conditions and physical capabilities:

• Work under pressure.
• Attention to detail.
• Sitting.

Personal suitability:

• Accurate.
• Client focus.
• Efficient interpersonal skills.
• Excellent oral communication.
• Excellent written communication.
• Initiative.
• Judgement.
• Organized.
• Team player.
• Adaptability.
• Accountability.
• Quick learner.

Screening questions:

Do you have experience working in this field?.

Experience:

2 years to less than 3 years.

Employment terms options:

Day.

Health benefits:

• Dental plan.
• Disability benefits.
• Health care plan.
• Paramedical services coverage.
• Vision care benefits.

Financial benefits:

• Bonus.
• Life insurance.

Other benefits:

Free parking available.