Sr. SQL DBA

V.L.S. Systems, Inc
Little rock, AR
26 Jan 2025

Vacancy expired!

Role: - Sr. SQL DBALocation: Little Rock, AR- OnsiteDuration: 6+ MonthsInterview: Skype/WebEx/Video

ON-SITE WORK ONLY Expert Level SQL Database AdministratorThe position is available for extensions. Description:The Sr SQL Database Administrator will be responsible for providing reliable, cost-effective, & secure enterprise-wide support for business-critical production & non-production databases for the Arkansas Integrated Revenue System (AIRS). MINIMUM: 7 Years’ Experience SQL Server 2016 and/or SQL Server 2019 database administration:
  • Installing and upgrading SQL Servers, including applying service packs
  • Performing routine database maintenance
o Creating and scheduling SQL Server jobs to perform database maintenance activity. o Rebuilding indexes o Updating statistics o Consistency checks o Monitoring error logs and event logs for database errors
  • SQL Server native tools and services
o SQL Server Profiler o Index Tuning Advisor o SQL Server Configuration Manager o Extended Events o Performance Monitor o Dynamic Management View o SQL Server Broker Service o Linked Servers o MSDTC o SQL Server System Databases o Database Mail o SQL Server Health Checks and Policies
  • Managing SQL Server security and auditing
o User security o Database roles o Authentication methods o SQL Server and database auditing o Encryption at rest, transit, and backup
  • Capacity Planning for storage and database objects
o Maintaining and managing SQL Server disk space to ensure storage is properly utilized. o Index and statistics usage o Managing disk storage for Windows Failover Cluster Service (WFSC)
  • Database backup and recovery
o Establishing standards and schedules for database backups. o Developing recovery procedures to meet RPO and RTO o 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
o Mirroring o Always On Required: 5 Years Windows Server Administration experience:
  • Building and maintaining Windows Host and Guest Servers
  • Installing and managing end point protection
  • Nessus configuration and vulnerability scans
  • 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
Required: 3 Years VMware environment setup and maintenance experience
  • VM hosts and guests.
  • vCenter
  • Data Stores and Clustering
  • vNetworking
  • VSAN
Preferred Knowledge and Skills:
  • Familiarity with industry security standards (PUB1075, FIPS, and PII)
  • CommVault backup solution administration
  • F5 administration
  • Firewall administration and maintenance
  • SAN, RAID Controller, and other storage device maintenance knowledge
  • Active Directory knowledge (GPO, FQDN, DNS Server, SPN)
  • Email, SMTP, and Proxy Server troubleshooting
  • GenTax architecture and application maintenance
  • Web Services development and support
  • Availability to provide 24 hour support
  • Strong communication skills, both oral and written
Skill Required / Desired Amount of Experience SQL Server 2016 and/or SQL Server 2019 database administration (see sub-bullets in JD)-Required 8 YearsWindows Server Administration experience (see sub-bullets in JD)- Required 6 YearsVMware environment setup and maintenance experience (see sub bullets in JD)- Highly desired.Certifications- Required24hr Support- RequiredGenTax Software Application architecture and application maintenance- Desired
  • ID: #48835496
  • State: Arkansas Little rock 72201 Little rock USA
  • City: Little rock
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2023-01-26
  • Deadline: 2023-03-25
  • Category: Et cetera