SQL Database Administrator
Expert Level SQL Database Administrator
Location: Little, Rock, AR
Rate:
$40/hr C2CON-SITE INTERVIWS ONLYON-SITE WORK ONLY Locations: Client- State of Arkansas Prime Vendor - Nitya Inc. Position is available for extensions.
NOTE:
This position requires candidates that have recent hands-on experience in ALL aspects of SQL DBA Administration. MINIMUM: 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 maintenanceo Knowledge of SQL Server Agent and jobso Monitoring error logs and event logs for database errors and warnings
- SQL Server native tools and serviceso SQL Server Profilero Index Tuning Advisoro SQL Server Configuration Managero Extended Eventso Performance Monitoro Dynamic Management Viewo SQL Server Broker Serviceo Linked Serverso MSDTCo SQL Server System Databases knowledgeo SQL Server Health Checks and Policies
- Managing SQL Server security and auditingo User securityo Authentication methodso SQL Server and database auditingo Encryption at rest, transit, and backup
- Capacity Planning for storage and database objectso Maintaining and managing SQL Server disk storage and experience with AWS storage systems to ensure storage is properly utilizedo Managing disk storage for Windows Failover Cluster Service (WFCS)
- Database backup and recoveryo Establishing standards and schedules for database backupso Developing recovery procedures to meet RPO and RTOo 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 Methodso Experience with VLDBo Experience monitoring, supporting, troubleshooting high intense systems with both online transactions and batch transactionso Always On and AWS HA Zones Required: 3 Years Windows Server Administration experience:
- Building and maintaining Windows Servers and EC2 Instances
- Installing and managing end point 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 Senior SQL Database Administrator – Skill MatrixS.No.
Required / Desired Skills
Required / Desired
Minimum Experience
Candidate Experience1Senior SQL Database Administrator Skills and ExperienceRequired4 Years2SQL Database Administration – SQL Server 2016 or later
Required4 Years3Windows Server Administration ExperienceRequired3 Years4Certifications
RequiredNot Specified524-Hour Support Availability
RequiredNot Specified6GenTax Software Application Architecture and Application Maintenance
DesiredNot Specified