View job listing
Apply to Sr. SQL DBA
14992 - Sr. SQL DBA (Onsite) - Little Rock, AR
Start Date: ASAP
Type: Temporary Project.
Estimated Duration: 12 months with possible extensions
Work Setting: 100% of the time at the Client's site.
No telecommuting or remote work. This is a non-negotiable requirement from the client.
Only candidates able to relocate as required should apply to avoid removal from future consideration.
Our client is filling this contract position exclusively through approved staffing partners, so this opportunity is not available by applying directly with the client. If you're interested, we'd be happy to represent you throughout the hiring process.
Required:
• Availability to work 100% of the time at the Client's site in Little Rock, AR (required).
• Experience with SQL Server 2022 (or later versions) database administration (4+ years).
• Experience with Windows Server Administration (3+ years).
• Experience with Installing and upgrading SQL Servers, including applying service packs and cumulative updates.
• Experience with Performing routine database maintenance.
• Experience with SQL Server Agent and jobs.
• Experience with Monitoring error logs and event logs for database errors and warnings.
• Experience with SQL Server native tools and services (Profiler, Index Tuning Advisor, Configuration Manager, Extended Events, Performance Monitor, Dynamic Management View, Broker Service, Linked Servers, MSDTC, System Databases, Health Checks and Policies).
• Experience with Managing SQL Server security and auditing (user security, authentication methods, SQL Server and database auditing, encryption at rest, transit, and backup).
• Experience with Capacity Planning for storage and database objects.
• Experience with Maintaining and managing SQL Server disk storage and Amazon Web Services (AWS) storage systems.
• Experience with Managing disk storage for Windows Failover Cluster Service (WFCS).
• Experience with Database backup and recovery (establishing standards and schedules, developing recovery procedures to meet RPO and RTO, point in time recovery).
• Experience with Creating and testing Disaster Recovery plans.
• Experience with Transact-SQL (TSQL) coding, tuning, and ETL methodologies.
• SQL Server High Availability Methods (Always On and AWS HA Zones).
• Experience with Very Large Databases (VLDB).
• Experience with Monitoring, supporting, and troubleshooting high intense systems with both online and batch transactions.
• Experience with Building and maintaining Windows Servers and EC2 Instances.
• Experience with Installing and managing end point protection.
• Experience with Application Server, Web Server, File Server, and FTP Server configuration and maintenance.
• Experience with PowerShell for administration tasks.
• Experience with Windows Failover Cluster configuration and maintenance.
• Experience with Windows Server Roles and Features.
• Experience with .NET Framework Components.
Preferred:
• Experience with FAST GenTax /DS-VS architecture and application maintenance.
• Experience with Industry security standards (PUB1075, FIPS, and PII).
• Experience with Cloud computing.
• Experience with Cloud storage, backup, and restore mechanisms.
• Experience with Firewall administration and maintenance.
• Experience with Active Directory (GPO, FQDN, DNS Server, SPN).
Responsibilities:
• Provide reliable, cost-effective, and secure enterprise-wide support for business-critical production and non-production SQL Server databases for the Arkansas Integrated Revenue System (AIRS).
• Install and upgrade SQL Server instances, including applying service packs and cumulative updates, and perform routine maintenance, including monitoring SQL Server Agent jobs and reviewing error and event logs for database errors and warnings.
• Manage SQL Server security and auditing, including user security, authentication methods, SQL Server and database auditing, and encryption at rest, in transit, and in backups.
• Establish backup standards and schedules, develop recovery procedures to meet RPO and RTO targets, perform point-in-time restores, and create and test disaster recovery plans.
• Plan capacity for storage and database objects, maintain SQL Server disk storage on AWS and Windows Failover Cluster Service, and ensure storage is properly utilized.
• Support high availability configurations, including Always On, AWS HA Zones, and VLDB environments, and monitor and troubleshoot high-intensity systems handling both online and batch transactions.
• Availability to provide 24 hour support
Start Date: ASAP
Type: Temporary Project.
Estimated Duration: 12 months with possible extensions
Work Setting: 100% of the time at the Client's site.
No telecommuting or remote work. This is a non-negotiable requirement from the client.
Only candidates able to relocate as required should apply to avoid removal from future consideration.
Our client is filling this contract position exclusively through approved staffing partners, so this opportunity is not available by applying directly with the client. If you're interested, we'd be happy to represent you throughout the hiring process.
Required:
• Availability to work 100% of the time at the Client's site in Little Rock, AR (required).
• Experience with SQL Server 2022 (or later versions) database administration (4+ years).
• Experience with Windows Server Administration (3+ years).
• Experience with Installing and upgrading SQL Servers, including applying service packs and cumulative updates.
• Experience with Performing routine database maintenance.
• Experience with SQL Server Agent and jobs.
• Experience with Monitoring error logs and event logs for database errors and warnings.
• Experience with SQL Server native tools and services (Profiler, Index Tuning Advisor, Configuration Manager, Extended Events, Performance Monitor, Dynamic Management View, Broker Service, Linked Servers, MSDTC, System Databases, Health Checks and Policies).
• Experience with Managing SQL Server security and auditing (user security, authentication methods, SQL Server and database auditing, encryption at rest, transit, and backup).
• Experience with Capacity Planning for storage and database objects.
• Experience with Maintaining and managing SQL Server disk storage and Amazon Web Services (AWS) storage systems.
• Experience with Managing disk storage for Windows Failover Cluster Service (WFCS).
• Experience with Database backup and recovery (establishing standards and schedules, developing recovery procedures to meet RPO and RTO, point in time recovery).
• Experience with Creating and testing Disaster Recovery plans.
• Experience with Transact-SQL (TSQL) coding, tuning, and ETL methodologies.
• SQL Server High Availability Methods (Always On and AWS HA Zones).
• Experience with Very Large Databases (VLDB).
• Experience with Monitoring, supporting, and troubleshooting high intense systems with both online and batch transactions.
• Experience with Building and maintaining Windows Servers and EC2 Instances.
• Experience with Installing and managing end point protection.
• Experience with Application Server, Web Server, File Server, and FTP Server configuration and maintenance.
• Experience with PowerShell for administration tasks.
• Experience with Windows Failover Cluster configuration and maintenance.
• Experience with Windows Server Roles and Features.
• Experience with .NET Framework Components.
Preferred:
• Experience with FAST GenTax /DS-VS architecture and application maintenance.
• Experience with Industry security standards (PUB1075, FIPS, and PII).
• Experience with Cloud computing.
• Experience with Cloud storage, backup, and restore mechanisms.
• Experience with Firewall administration and maintenance.
• Experience with Active Directory (GPO, FQDN, DNS Server, SPN).
Responsibilities:
• Provide reliable, cost-effective, and secure enterprise-wide support for business-critical production and non-production SQL Server databases for the Arkansas Integrated Revenue System (AIRS).
• Install and upgrade SQL Server instances, including applying service packs and cumulative updates, and perform routine maintenance, including monitoring SQL Server Agent jobs and reviewing error and event logs for database errors and warnings.
• Manage SQL Server security and auditing, including user security, authentication methods, SQL Server and database auditing, and encryption at rest, in transit, and in backups.
• Establish backup standards and schedules, develop recovery procedures to meet RPO and RTO targets, perform point-in-time restores, and create and test disaster recovery plans.
• Plan capacity for storage and database objects, maintain SQL Server disk storage on AWS and Windows Failover Cluster Service, and ensure storage is properly utilized.
• Support high availability configurations, including Always On, AWS HA Zones, and VLDB environments, and monitor and troubleshoot high-intensity systems handling both online and batch transactions.
• Availability to provide 24 hour support