Sr. SQL DBA

The role is based in the vibrant city of Little Rock, AR, offering a unique blend of urban and natural attractions. Join our team and enjoy the benefits of working in a dynamic and growing community.

Short Description:

The Senior SQL Database Administrator will be responsible for providing reliable, cost-effective, and secure enterprise-wide support for business-critical production and non-production databases for the Client.

ON-SITE INTERVIEWS ONLY

ON-SITE WORK ONLY

Position is available for extensions.

NOTE: This position requires candidates that have recent hands-on experience in all aspects of SQL DBA Administration.

Minimum Qualifications

• 4 Years Experience SQL Server 2022 (or later versions) database administration:
  • Installing and upgrading SQL Servers, including applying service packs, cumulative updates
  • Performing routine database maintenance
    • Knowledge of SQL Server Agent and jobs
    • Monitoring error logs and event logs for database errors and warnings
  • SQL Server native tools and services
    • SQL Server Profiler
    • Index Tuning Advisor
    • SQL Server Configuration Manager
    • Extended Events
    • Performance Monitor
    • Dynamic Management View
    • SQL Server Broker Service
    • Linked Servers
    • MSDTC
    • SQL Server System Databases knowledge
    • SQL Server Health Checks and Policies
  • Managing SQL Server security and auditing
    • User security
    • Authentication methods
    • SQL Server and database auditing
    • Encryption at rest, transit, and backup
  • Capacity Planning for storage and database objects
    • Maintaining and managing SQL Server disk storage and experience with AWS storage systems to ensure storage is properly utilized
    • Managing disk storage for Windows Failover Cluster Service (WFCS)
  • Database backup and recovery
    • Establishing standards and schedules for database backups
    • Developing recovery procedures to meet RPO and RTO
    • Restoring databases with point in time recovery
  • Creating and testing Disaster Recovery plans
  • Proficient in TSQL coding, tuning, and ETL methodologies
  • SQL Server High Availability Methods
    • Experience with VLDB
    • Experience monitoring, supporting, troubleshooting high intense systems with both online transactions and batch transactions
    • Always On and AWS HA Zones
• 3 Years Windows Server Administration experience:
  • Building and maintaining Windows Servers and EC2 Instances
  • Installing and managing endpoint protection
  • Application Server, Web Server, File Server, and FTP Server configuration and maintenance
  • Utilizing PowerShell for administration tasks
  • Windows Failover Cluster configuration and maintenance
  • Windows Server Roles and Features
  • .NET Framework Components

Preferred Knowledge and Skills

• Experience with FAST GenTax/DS-VS architecture and application maintenance
• Familiarity with industry security standards (PUB1075, FIPS, and PII)
• Cloud computing knowledge
• Cloud storage, backup, and restore mechanisms
• Firewall administration and maintenance
• Active Directory knowledge (GPO, FQDN, DNS Server, SPN)
• Email, SMTP, and Proxy Server troubleshooting
• Web Services development and support
• Availability to provide 24-hour support
• Strong communication skills, both oral and written