DATABASE ANALYST

Primary Responsibilities

• Analyze and evaluate database requirements for various state agencies and develop strategies to improve database functionality and performance.
• Aid 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.
• Generate reports and conduct data analysis to support decision-making for state agencies.
• Afford assistance with database backups and recovery procedures as part of the disaster recovery plan.

Knowledge And Skills

• Strong understanding of database design principles, data modeling, and normalization techniques.
• Proficiency in SQL and experience with query optimization and performance tuning.
• 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.