SQL Server Architect & DBA | SSIS, PowerShell, Azure DevOps

JPS Tech Solutions Pvt Ltd; Cary (NC); On-site; USD 90,000 - 130,000; Full time

Job summary

JPS Tech Solutions Pvt Ltd is seeking a skilled SQL Server Database Administrator to support enterprise SQL Server environments. You will manage databases, design data models, perform migrations, and optimize performance, while ensuring security, backups, and recovery.

The ideal candidate works independently and collaborates with application, development, and infrastructure teams to deliver reliable data services and continuous improvement across the SDLC.

Qualifications

• 5+ years of experience with SQL Server 2016/2019 administration.
• Experience installing, configuring, maintaining, and upgrading SQL Server databases.
• Strong understanding of database design and data modeling.
• Experience with SQL queries, stored procedures, data migration and data correction.
• Hands-on experience with SSIS and PowerShell scripting.
• Experience monitoring, troubleshooting, and optimizing database performance.
• Knowledge of database security, access management, backup and recovery.
• Experience supporting enterprise applications and DB development lifecycles.
• Experience using Azure DevOps for source control and documentation management.
• Strong analytical, communication, and documentation skills; ability to work independently.

Responsibilities

• Perform database administration and support activities using SQL Server 2016/2019.
• Install, configure, maintain, and upgrade database software.
• Analyze, design, and review logical and physical data models.
• Support application development and maintenance throughout the SDLC.
• Perform data analysis, data correction, loading, and migration activities.
• Review, migrate, and optimize stored procedures to improve performance.
• Develop and maintain SSIS packages and PowerShell scripts.
• Monitor database performance, storage, and resource utilization; propose improvements.
• Analyze and resolve database performance and operational issues.
• Assist with database conversions and migrations to current SQL Server versions.
• Maintain database access security and data integrity; ensure backups and restores.
• Assist with infrastructure evaluations and tool recommendations.
• Follow standards and improve DBA practices.
• Use Azure DevOps for source control, work items, documentation management, and time tracking.
• Provide status updates to leadership and project stakeholders; represent DBA team in meetings.
• Stay current with new database releases and related technologies.

Skills

SQL Server 2016/2019 administration

Database design & modeling

T-SQL & stored procedures

SSIS

PowerShell scripting

Database migration & conversion

Database performance tuning

Database security & backup & recovery

Azure DevOps

Source control / documentation

Tools

Azure DevOps

Job description

JPS Tech Solutions Pvt Ltd is seeking a skilled SQL Server Database Administrator to support enterprise SQL Server environments. You will manage databases, design data models, perform migrations, and optimize performance, while ensuring security, backups, and recovery.

The ideal candidate works independently and collaborates with application, development, and infrastructure teams to deliver reliable data services and continuous improvement across the SDLC.