Sr. SQL DBA

Varmoda; Little Rock (AR); Presencial; USD 110.000 - 140.000; Jornada completa

Descripción de la vacante

Varmoda is seeking an experienced Senior SQL Database Administrator to support a highly available SQL Server environment on-site in Little Rock, Arkansas. The role focuses on SQL Server 2022+, Windows Server, and AWS infrastructure, with 24/7 production support as needed.

The Senior DBA will manage backups, security, performance, DR/HA, T-SQL, ETL, and SQL Server tools, coordinating with stakeholders to meet RPO/RTO targets and ensure VLDB performance.

Formación

• 4+ years as Senior SQL Database Administrator.
• 4+ years of SQL Server database administration experience with SQL Server 2016 or later.
• 3+ years of Windows Server Administration experience.
• Experience with SQL Server installation, upgrades, patching, and maintenance.
• Experience with performance monitoring and troubleshooting.
• Experience with SQL Server security, auditing, backups, restores, and DR.

Responsabilidades

• Install, configure, and maintain SQL Server 2022 or later environments.
• Perform routine maintenance, monitoring, health checks, and performance optimization.
• Administer SQL Server Agent and scheduled jobs.
• Monitor error logs and Windows event logs for issues.
• Manage security, authentication, auditing, and encryption for data at rest, in transit, and in backups.
• Develop recovery procedures and perform point-in-time restores.
• Implement and test Disaster Recovery plans and Always On availability groups.
• Build and maintain Windows Servers and AWS EC2 instances.
• Collaborate with stakeholders and support on-site interviews.

Conocimientos

SQL Server

PowerShell

Windows Server

AWS EC2

T-SQL

Always On

Backup & Restore

Disaster Recovery

VLDB

Security & Auditing

Herramientas

SQL Server Profiler

Extended Events

DMVs

Performance Monitor

Index Tuning Advisor

SQL Server Configuration Manager

SQL Server Agent

Descripción del empleo

Varmoda is seeking an experienced Senior SQL Database Administrator to support a highly available, enterprise SQL Server environment. This is an on-site position in Little Rock, Arkansas, and only qualified candidates located in the Little Rock area will be considered. On-site interviews are required.

The Senior SQL DBA will administer SQL Server 2022 and later environments, support Windows Server and AWS infrastructure, manage database availability, security, performance, backup and recovery, and provide 24-hour production support as required.

Key Responsibilities

• Install, configure, upgrade, and maintain SQL Server 2022 or later, including service packs and cumulative updates.
• Perform routine database maintenance, monitoring, health checks, and performance optimization.
• Administer SQL Server Agent and scheduled jobs.
• Monitor SQL Server error logs and Windows event logs for errors and warnings.
• Utilize SQL Server administration and diagnostic tools, including:
  • SQL Server Profiler
  • Index Tuning Advisor
  • SQL Server Configuration Manager
  • Extended Events
  • Performance Monitor
  • Dynamic Management Views (DMVs)
• Administer SQL Server Broker Service, Linked Servers, MSDTC, and SQL Server system databases.
• Manage SQL Server security, authentication, auditing, user access, and encryption for data at rest, in transit, and in backups.
• Perform capacity planning for database objects and storage.
• Administer SQL Server disk storage and work with AWS storage systems.
• Manage storage associated with Windows Failover Cluster Service (WFCS).
• Establish database backup standards and schedules.
• Develop recovery procedures that meet established RPO and RTO requirements.
• Perform database restores, including point-in-time recovery.
• Develop and test Disaster Recovery plans.
• Write and optimize T-SQL and support ETL methodologies.
• Administer SQL Server High Availability solutions, including Always On and AWS High Availability Zones.
• Support very large databases (VLDBs) and high-intensity systems involving online and batch transactions.
• Build and maintain Windows Servers and AWS EC2 instances.
• Configure and maintain Windows Failover Clusters, server roles, features, and .NET Framework components.
• Install and manage endpoint protection.
• Configure and maintain Application, Web, File, and FTP servers.
• Use PowerShell for Windows and infrastructure administration.
• Support the design, development, maintenance, and enhancement of ASP.NET Web Forms applications.
• Participate in technical design and code reviews.
• Identify technical risks and recommend appropriate best practices.
• Communicate with key stakeholders and manage technical expectations.

Required Qualifications

• 4+ years of Senior SQL Database Administrator experience.
• 4+ years of SQL Server database administration experience with SQL Server 2016 or later.
• Strong hands-on experience administering SQL Server 2022 or later environments.
• 3+ years of Windows Server Administration experience.
• Strong experience with:
  • SQL Server installation, upgrades, patching, and maintenance
  • Performance monitoring and troubleshooting
  • SQL Server Agent and jobs
  • SQL Server Profiler and Extended Events
  • DMVs and Performance Monitor
  • SQL Server security and auditing
  • Backup, restore, and point-in-time recovery
  • Disaster Recovery and RPO/RTO
  • T-SQL coding and tuning
  • ETL methodologies
  • SQL Server High Availability
  • Always On
  • Windows Failover Clustering
  • VLDB environments
• Experience administering Windows Server environments and AWS EC2 instances.
• Experience using PowerShell for administration.
• Experience supporting AWS-based storage and highly available environments.
• Ability to provide 24-hour support as required.
• Must be located in the Little Rock, AR area and able to work on-site.
• Must be available for an on-site interview.

Preferred Qualifications

• Experience with GenTax software architecture and application maintenance.
• Experience with FAST GenTax/DS-VS architecture and maintenance.
• Familiarity with PUB 1075, FIPS, and PII security requirements.
• Cloud computing experience.
• Experience with cloud storage, backup, and restoration mechanisms.
• Firewall administration and maintenance experience.
• Active Directory knowledge, including GPO, FQDN, DNS Server, and SPN.
• Experience troubleshooting email, SMTP, and proxy servers.
• Web Services development and support experience.
• Strong written and verbal communication skills.