Database analysts/programmers are responsible for programming and analyzing databases for their organization. They are in charge of programming automating scripts that provide regular maintenance to company databases, analyzing business requirements to suggest improvements, providing end-user support, and responding to ticket requests as needed. Additionally, they interact with other information technology staff and department managers. Database analysts/programmers create database mappings to transform data from multiple systems, take part in setting up connectivity to data sources, modify database packages to fit company and project requirements, and create custom databases to achieve all organizational goals.
Database analysts/programmers optimize databases by developing scripts and code to increase network performance and overall productivity. They must maintain accurate documentation of database features and create detailed reports based on their findings. Database analysts/programmers provide service to database software by creating scripts and patches. They are responsible for installing and updating database designs, running and troubleshooting database applications, using a personal computer to modify and oversee existing databases, and improving database performance by analyzing existing database values and processes.
A bachelor's degree in database analysis, software programming, computer science, or a related field is required for this position. In addition, previous experience in a database-managing capacity, as well as relevant certifications, are generally required or preferred. Database analysts/programmers must be organized individuals that pay strong attention to detail and possess excellent communication skills. They should work well on their own with minimal supervision, as well as in a team environment with other analysts/programmers.
Database Analyst/Programmer Tasks
- Work with middle-tier developers to integrate back-end database code with business applications.
- Design, write, test, and debug database stored procedures and complex queries to extract, calculate or manipulate information.
- Design, implement, and test database schemas.