Sign upLog in
See more jobs

Sr. SQL Server Database Administrator

Apollo Technology Solutions LLC

  • Little Rock, AR
  • 2 days ago

    Highlights

    Utilize SQL Server native tools and services including SQL Server Profiler, Index Tuning Advisor, SQL Server Configuration Manager, Extended Events, Performance Monitor, and Dynamic Management Views. Required Skills: 4+ years of hands-on SQL Server database administration experience with SQL Server 2022, SQL Server 2019, SQL Server 2017, or SQL Server 2016.

    Numbers & Facts

    LocationLittle Rock, AR

    Description

    Title: Sr. SQL Server Database Administrator
    Location: Little Rock, AR
    Duration: 7+ Months
    Job Description:
    • Install, configure, upgrade, and maintain Microsoft SQL Server 2022 environments, including service packs and cumulative updates
    • Perform routine database administration, monitoring, maintenance, and troubleshooting activities
    • Manage SQL Server Agent jobs, monitor error logs and event logs, and proactively resolve database issues
    • Utilize SQL Server native tools and services including SQL Server Profiler, Index Tuning Advisor, SQL Server Configuration Manager, Extended Events, Performance Monitor, and Dynamic Management Views
    • Administer SQL Server security, auditing, authentication, encryption, and compliance controls
    • Develop and maintain database backup, recovery, and retention processes to achieve business RPO and RTO objectives
    • Create, test, and maintain disaster recovery plans and recovery procedures
    • Perform database performance tuning, T-SQL optimization, and ETL process support
    • Support SQL Server high availability solutions including Always On Availability Groups and AWS-based HA architectures
    • Monitor and support very large databases (VLDBs) and high-volume transactional and batch processing systems
    • Manage Linked Servers, MSDTC, Service Broker, system databases, health checks, and SQL Server policies
    • Perform capacity planning activities and manage database storage utilization across SQL Server and AWS storage platforms
    • Administer Windows Failover Cluster Services and clustered storage environments
    • Build, configure, maintain, and troubleshoot Windows Servers and AWS EC2 instances
    • Utilize PowerShell automation for administrative and operational tasks
    • Install and manage endpoint protection solutions and maintain server roles and features
    • Support application, web, file, and FTP servers as required
    • Participate in on-call support and provide 24-hour production support when necessary
    • Collaborate with infrastructure, application support, security, and business teams to ensure reliable system operations
    Required Skills:
    • 4+ years of hands-on SQL Server database administration experience with SQL Server 2022, SQL Server 2019, SQL Server 2017, or SQL Server 2016
    • Experience installing, upgrading, patching, and maintaining SQL Server environments
    • Strong knowledge of SQL Server security, auditing, encryption, backup, recovery, and disaster recovery practices
    • Experience with SQL Server performance monitoring, tuning, and troubleshooting
    • Advanced T-SQL development and optimization skills
    • Experience supporting SQL Server high availability technologies, including Always On Availability Groups
    • Experience managing large-scale or mission-critical database environments
    • 3+ years of Windows Server administration experience
    • Experience building and maintaining Windows Servers and AWS EC2 instances
    • Experience with Windows Failover Clustering and clustered environments
    • Proficiency with PowerShell administration and automation
    • Strong understanding of server roles, features, and .NET Framework components
    • Relevant technical certifications
    • Availability to provide 24-hour support as needed
    • Strong verbal and written communication skills
    Preferred Skills:
    • Experience with FAST GenTax / DS-VS architecture and application maintenance
    • Knowledge of AWS cloud services and cloud computing concepts
    • Experience with cloud storage, backup, and recovery solutions
    • Familiarity with security standards including PUB1075, FIPS, and PII requirements
    • Active Directory administration experience, including GPOs, DNS, FQDN, and SPN management
    • Firewall administration and maintenance experience
    • Experience troubleshooting email, SMTP, and proxy servers
    • Web services development or support experience
    • Experience supporting government tax, revenue, or regulatory systems

    Similar Jobs