Job summary:


Title:
Sr. SQL DBA - Onsite

Location:
Little Rock, AR, United States

Length and terms:
Long term - W2 or C2C


Position created on 02/01/2024 03:29 pm

Job description:


Interview Type: Skype very long term project *** Onsite ***

*** ON SITE WORK for at least the first 3 months, remote allowed after that. ***

Short Description:

The SENIOR 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) .

Job Description:

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 Database
    • 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
    • Mirroring
    • Always On

Required Skills:

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
  • SENIOR SQL Database Administrator Skills and Experience 10 Years
  • SQL Database administration (see sub bullets in JD) SQL Server 2016 or later 8 Years
  • Windows Server Administration experience (see sub bullets in JD) 6 Years
  • Certifications
  • 24hr Support

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
  • Web Services development and support
  • Availability to provide 24 hour support
  • Strong communication skills, both oral and written

Desired Skills:

  • GenTax Software Application architecture and application maintenance

Contact the recruiter working on this position:



The recruiter working on this position is Fazal(Shaji Team) Uddin
His/her contact number is +(1) (703) 4684697
His/her contact email is fazal@msysinc.com

Our recruiters will be more than happy to help you to get this contract.