Senior SQL DBA: Always On, Security & AWS Mastery

JPS Tech Solutions Pvt Ltd; Arkansas; Presencial; USD 95.000 - 150.000; Jornada completa

Descripción de la vacante

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.

Formación

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

Responsabilidades

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

Conocimientos

SQL Server 2022+

T-SQL

Performance tuning

Security & Auditing

Backup & Recovery

High Availability

Windows Server

PowerShell

AWS EC2

Herramientas

SQL Server Profiler

Extended Events

DMVs

Index Tuning Advisor

Configuration Manager

Failover Clustering

Descripción del empleo

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.