Job Class Search
Job Details
Database Analyst
The Database Analyst is a mid-level position responsible for analyzing, designing, and supporting the state’s database systems. The Database Analyst works closely with database administrators and application development teams to ensure that the database structures meet the functional and performance requirements of various state agencies. This role involves a balance of technical skills and business analysis to help guide the design and optimization of databases used for state operations.
Class Code:
IDM02P
Job Grade:
IST07
Special Job Requirements:
Typical Functions:
Analyze and evaluate database requirements for various state agencies and develop strategies to improve database functionality and performance.
Assist in the design and implementation of database structures to support state applications and data requirements.
Conduct data modeling, including logical and physical database design, to support both operational and analytical databases.
Collaborate with development teams to ensure that database systems integrate effectively with applications.
Optimize database queries and indexes to ensure the efficient retrieval and storage of data.
Support database troubleshooting and assist with resolving issues related to data quality, integrity, and performance.
Perform database testing and quality assurance to ensure the reliability and stability of database systems.
Generate reports and conduct data analysis to support decision-making for state agencies.
Assist with database backups and recovery procedures as part of the disaster recovery plan.
Knowledge, Abilities, and Skills:
Strong understanding of database design principles, data modeling, and normalization techniques.
Proficiency in SQL and experience with query optimization and performance tuning.
Knowledge of relational database systems (e.g., Oracle, SQL Server, MySQL) and experience working with these technologies.
Familiarity with data analysis and reporting tools.
Ability to work closely with both technical teams (developers, DBAs) and non-technical stakeholders (business users, project managers).
Strong analytical skills and the ability to work with complex data structures and business requirements.
Excellent problem-solving and troubleshooting skills.
Experience with SQL and database query optimization.
Good communication skills, with the ability to present technical concepts to non-technical audiences.
Minimum Qualifications:
A bachelor’s degree in computer science, information technology, or a related field. Three years of experience in database analysis, database design, or database management.
Required Certificates:
N/A
OTHER JOB RELATED EDUCATION AND/OR EXPERIENCE MAY BE SUBSTITUTED FOR ALL OR PART OF THESE BASIC REQUIREMENTS, EXCEPT FOR CERTIFICATION OR LICENSURE REQUIREMENTS, UPON APPROVAL OF THE QUALIFICATIONS REVIEW COMMITTEE.
Exempt:
E
