Location
Little Rock, AR | United States
Job description
Title
Sr. SQL DBA
Location Little Rock AR (Onsite)
Rate DOE /If your experience and skills match call us immediately for submission
Duration 4 Months
Interview Type Either Webcam Interview or In Person
Job Type C2CC2HW2
Experience 10 Years
Job Description
The SENIOR SQL Database Administrator will be responsible for providing reliable costeffective & secure enterprisewide support for business critical production & nonproduction databases for the Arkansas Integrated Revenue System (AIRS) .
Expert Level SQL Database Administrator
- Position is available for extensions.
MINIMUM: 7 Years Experience SQL Server 2016 (or later versions) database administration:
- Installing and upgrading SQL Servers including applying service packs
- Performing routine database maintenance
- Creating and scheduling SQL Server jobs to perform database maintenance activity
- Rebuilding indexes
- Updating statistics
- Consistency checks
- Monitoring error logs and event logs for database errors
- 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
- Database Mail
- SQL Server Health Checks and Policies
- Managing SQL Server security and auditing
- User security
- Database roles
- 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 space to ensure storage is properly utilized
- Index and statistics usage
- Managing disk storage for Windows Failover Cluster Service (WFSC)
- 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
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
Preferred Knowledge and Skills:
- Familiarity with industry security standards (PUB1075 FIPS and PII)
- Cloud computing knowledge
- Cloud storage backup and restore mechanisms
- 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 |
| SENIOR SQL Database Administrator Skills and Experience | Required | 10 | Years |
| SQL Database administration (see subbullets in JD) SQL Server 2016 or later | Required | 8 | Years |
| Windows Server Administration experience (see subbullets in JD) | Required | 6 | Years |
| Certifications | Required |
| 24hr Support | Required |
| GenTax Software Application architecture and application maintenance | Desired |
Job tags
Salary
