Senior SQL Server & Data Integration Engineer

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

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.