Database analysts - also referred to as database administrators - review, evaluate, design and implement databases. These analysts' main duties include database administration, which involves responding to user needs by refining and developing databases. Once the database is established, analysts run periodic testing to ensure correct operation of the system. Database analysts are also responsible for database recovery and back up.
Quality assurance is essential for organizations, and database analysts check quality and ensure issues are handled properly to maintain data integrity.
Database analysts are also responsible for data security, and they are often required to submit background checks and other selective tests. Database analysts generally work in an office setting during regular business hours. They often work closely with related team members and report to their department manager.
A bachelor’s degree in information technology, computer science, software engineering, or a related field is often needed for this position, although employers may require a different level of education (such as an associate's degree). Previous experience is generally preferred. Programming experience is a must for these candidates along with demonstrated ability to take technical complex information. In-depth knowledge of computer systems, along with server management experience, might also be necessary for these positions.
Database Analyst Tasks
Develop best practices for data loading and extraction into and out of the data warehouse.
Identify business requirements of data warehouse.
Design end user interface including reporting.
Design, implement, and test database schemas.
Work with middle-tier developers to integrate back-end database code with business applications.