Sr. SQL DBA

JPS Tech Solutions; Arkansas; On-site; USD 95,000 - 150,000; Full time

Job summary

JPS Tech Solutions Pvt Ltd in Arkansas seeks an experienced Senior SQL Database Administrator to support AIRS. The role requires hands‑on SQL Server 2022+ administration, performance tuning, security, backup/recovery, HA, and Windows Server management.

The ideal candidate will optimize large databases, automate tasks with PowerShell, and collaborate with cross‑functional teams. The position emphasizes Always On, AWS EC2, and scalable disaster recovery.

Qualifications

• Minimum 4 years of hands‑on SQL Server 2022+ administration.
• Strong experience with installation, upgrades, maintenance, security, and performance tuning.
• Proficiency in T-SQL coding, query optimization, and ETL methodologies.
• Experience with SQL Server Profiler, Extended Events, DMVs, and related monitoring tools.
• Minimum 3 years of Windows Server administration experience.

Responsibilities

• Install, configure, and maintain SQL Server 2022+ and updates.
• Perform maintenance, health checks, monitoring, and troubleshooting.
• Manage SQL Server Agent jobs, logs, Extended Events, and DMVs.
• Administer security, authentication, auditing, and encryption.
• Back up, restore, point‑in‑time recovery, and DR procedures.
• Develop recovery strategies aligned with RPO and RTO requirements.
• Monitor and optimize performance, indexing, storage, and resources.
• Support Always On and AWS Availability Zones for HA.
• Manage VLDB environments and large online/batch workloads.
• Administer Windows Servers, EC2, and Failover Clusters.
• Use PowerShell to automate admin tasks.

Skills

SQL Server 2022+

T-SQL

Performance tuning

Security & Auditing

Backup & Recovery

High Availability

Windows Server

PowerShell

AWS EC2

Tools

SQL Server Profiler

Extended Events

DMVs

Index Tuning Advisor

Configuration Manager

Failover Clustering

Job description

Job Summary

We are seeking an experienced Senior SQL Database Administrator to provide reliable, secure, and cost-effective support for business-critical production and non-production databases supporting the Arkansas Integrated Revenue System (AIRS). The role requires strong hands-on expertise in SQL Server administration, performance tuning, database security, backup and recovery, high availability, and Windows Server administration.

Key Responsibilities

• Install, configure, upgrade, and maintain SQL Server 2022 or later, including service packs and cumulative updates.
• Perform database maintenance, health checks, monitoring, and troubleshooting.
• Manage SQL Server Agent jobs, error logs, Extended Events, and Dynamic Management Views (DMVs).
• Administer SQL Server security, authentication, auditing, and encryption.
• Manage database backups, restores, point-in-time recovery, and disaster recovery procedures.
• Develop and maintain recovery strategies aligned with RPO and RTO requirements.
• Monitor and optimize database performance, indexing, storage capacity, and resource utilization.
• Support high-availability solutions, including Always On and AWS Availability Zones.
• Manage large and high-volume databases, including VLDB environments and systems supporting online and batch transactions.
• Administer Windows Servers, EC2 instances, and Windows Failover Clusters.
• Use PowerShell to automate and perform database and server administration tasks.

Required Qualifications

• Minimum 4 years of recent hands‑on experience administering SQL Server 2022 or later.
• Strong experience with SQL Server installation, upgrades, maintenance, security, and performance tuning.
• Proficiency in T‑SQL coding, query optimization, and ETL methodologies.
• Experience with SQL Server Profiler, Index Tuning Advisor, Configuration Manager, Extended Events, Performance Monitor, and DMVs.
• Knowledge of SQL Server Broker, Linked Servers, MSDTC, system databases, and SQL Server health checks.
• Experience with database backup, recovery, disaster recovery, and high-availability solutions.
• Minimum 3 years of Windows Server administration experience.
• Experience managing Windows Server roles, features, Failover Clusters, EC2 instances, and PowerShell administration.

Preferred Qualifications

• Experience with FAST GenTax/DS‑VS architecture and application maintenance.
• Familiarity with security standards such as PUB1075, FIPS, and PII requirements.
• Knowledge of cloud computing, AWS storage, backup, and recovery mechanisms.
• Experience with firewall administration, Active Directory, GPO, DNS, FQDN, and SPN.
• Knowledge of SMTP, email, proxy servers, and web services.
• Availability to provide 24‑hour support.
• Strong written and verbal communication skills.

Core Technical Skills

• SQL Server 2022 or Later
• SQL Server Administration and Performance Tuning
• T‑SQL and ETL
• Database Security and Auditing
• Backup, Recovery, and Disaster Recovery
• Always On and High Availability
• AWS Storage and EC2
• Windows Server Administration
• PowerShell and Windows Failover Clustering
• FAST GenTax/DS‑VS

Local candidates are preferred.