Database Developer​/Analyst

We are seeking an experienced Database Developer / Analyst to develop, maintain, and support the Arkansas All-Payer Claims Database (APCD). The role focuses on database development, ETL processes, data integration, analysis, performance optimization, and reporting. The ideal candidate will have strong Microsoft SQL Server expertise, experience with SSIS/SSRS, and the ability to support database release management, testing, and deployment activities.

• Build, maintain, and support database systems and data infrastructure.
• Design, develop, and maintain Extract, Transform, and Load (ETL) processes.
• Perform data integration, transformation, migration, and validation across multiple data sources.
• Design, install, convert, and maintain database structures.
• Manage database backup and recovery procedures, access security, and data integrity.
• Design and manage physical data storage and database storage requirements.
• Define and maintain data dictionary standards and related documentation.
• Perform database performance tuning and monitor database performance and storage capacity.
• Schedule and monitor data warehousing and end-of-day processing jobs.
• Develop tables, reports, and data analysis outputs using statistical and database tools.
• Perform application unit testing and support functional, integration, and performance testing.
• Develop and maintain database release management and deployment procedures.
• Coordinate software releases with development, quality assurance, and support teams.
• Provide production support, troubleshoot issues, and participate in on-call support when required.
• Develop shell scripts for backup, restore, and database monitoring activities.
• Maintain process, system, and technical documentation.
• Identify and track project issues, risks, and action items.
• Provide accurate status updates to project leads and managers.
• Estimate and schedule assigned work, resolve issues promptly, and contribute to continuous process improvement.

• Bachelor's degree in Information Technology, Computer Science, Social Science, or a related field.
• Minimum 7 years of experience with Microsoft SQL Server and SQL query development.
• Minimum 2 years of experience with multi-source database integration solutions.
• Minimum 3 years of experience with Microsoft SQL Server Integration Services (SSIS) or SQL Server Reporting Services (SSRS).
• Strong experience with ETL processes, database development, and data management.
• Experience with database design, logical data modeling, installations, and conversions.
• Knowledge of database backup, recovery, security, and integrity management.
• Experience with database performance tuning and monitoring.
• Experience with business systems analysis and database design.
• Knowledge of data analysis, database management techniques, and production environment tools/utilities.
• Experience with database administration and scripting on relevant platforms.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent written and verbal communication skills.
• Ability to work independently with minimal supervision and collaboratively within a project team.

• Experience supporting enterprise data warehousing and reporting environments.
• Experience with database release management and deployment procedures.
• Experience with statistical software and preparing analytical reports.
• Experience with production support, issue tracking, and process improvement.

• Microsoft SQL Server
• T-SQL and SQL Query Development
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• ETL and Data Integration
• Multi-Source Database Integration
• Database Design and Logical Data Modeling
• Database Performance Tuning
• Data Warehousing and Reporting
• Database Backup and Recovery
• Shell Scripting and Database Monitoring
• Release Management and Deployment