database analyst (DBA)

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
• Tight deadlines

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?