Database Developer / Analyst

JPS Tech Solutions Pvt Ltd; Little Rock (AR); On-site; USD 85,000 - 110,000; Full time

Job summary

JPS Tech Solutions Pvt Ltd in Little Rock, AR seeks an experienced Database Developer/Analyst to build, maintain, and optimize APCD data infrastructure. You will develop ETL processes, integrate multi-source data, and ensure performance and data quality across the data warehouse environment.

The role focuses on SQL Server expertise, SSIS/SSRS, database release management, testing, and deployment. Strong analytical and communication skills are required to succeed in a collaborative team setting.

Qualifications

• 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 SSIS or 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.

Responsibilities

• Build, maintain, and support database systems and data infrastructure.
• Design, develop, and maintain 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.

Skills

Microsoft SQL Server

SQL query development

ETL

Data integration

Data modeling

Performance tuning

Shell scripting

Release management

Data warehousing

Analytical thinking

Communication skills

Education

Bachelor's degree in Information Technology, Computer Science, Social Science, or a related field

Tools

SSIS

SSRS

T-SQL

SQL Server

Job description

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.

Key Responsibilities

• 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.

Required Qualifications

• 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.

Preferred Qualifications

• 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.

Core Technical Skills

• 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