Senior SQL Server Database Administrator

Req number:

Employment type:

Worksite flexibility:

Who we are

CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right-whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

Job Description

We are looking for a Senior SQL Server Database Administrator to provide expert-level SQL Server database administration, performance tuning, security management, backup and recovery planning, disaster recovery support, and Windows Server administration for critical enterprise systems. This position will be Full-Time and Onsite in Little Rock, Arkansas.

Employees are expected to work onsite 5 days per week, with availability to provide 24/7 support as needed.

Only work authorizations that will not require sponsorship now or in the future will be considered.

What You'll Do

• Install, configure, upgrade, and maintain Microsoft SQL Server 2022 environments, including service packs and cumulative updates
• Perform routine database administration, monitoring, maintenance, and troubleshooting activities
• Manage SQL Server Agent jobs, monitor error logs and event logs, and proactively resolve database issues
• Utilize SQL Server native tools and services including SQL Server Profiler, Index Tuning Advisor, SQL Server Configuration Manager, Extended Events, Performance Monitor, and Dynamic Management Views
• Administer SQL Server security, auditing, authentication, encryption, and compliance controls
• Develop and maintain database backup, recovery, and retention processes to achieve business RPO and RTO objectives
• Create, test, and maintain disaster recovery plans and recovery procedures
• Perform database performance tuning, T-SQL optimization, and ETL process support
• Support SQL Server high availability solutions including Always On Availability Groups and AWS-based HA architectures
• Monitor and support very large databases (VLDBs) and high-volume transactional and batch processing systems
• Manage Linked Servers, MSDTC, Service Broker, system databases, health checks, and SQL Server policies
• Perform capacity planning activities and manage database storage utilization across SQL Server and AWS storage platforms
• Administer Windows Failover Cluster Services and clustered storage environments
• Build, configure, maintain, and troubleshoot Windows Servers and AWS EC2 instances
• Utilize PowerShell automation for administrative and operational tasks
• Install and manage endpoint protection solutions and maintain server roles and features
• Support application, web, file, and FTP servers as required
• Participate in on-call support and provide 24-hour production support when necessary
• Collaborate with infrastructure, application support, security, and business teams to ensure reliable system operations

What You'll Need

Required:

• 4+ years of hands-on SQL Server database administration experience with SQL Server 2022, SQL Server 2019, SQL Server 2017, or SQL Server 2016
• Experience installing, upgrading, patching, and maintaining SQL Server environments
• Strong knowledge of SQL Server security, auditing, encryption, backup, recovery, and disaster recovery practices
• Experience with SQL Server performance monitoring, tuning, and troubleshooting
• Advanced T-SQL development and optimization skills
• Experience supporting SQL Server high availability technologies, including Always On Availability Groups
• Experience managing large-scale or mission-critical database environments
• 3+ years of Windows Server administration experience
• Experience building and maintaining Windows Servers and AWS EC2 instances
• Experience with Windows Failover Clustering and clustered environments
• Proficiency with PowerShell administration and automation
• Strong understanding of server roles, features, and .NET Framework components
• Relevant technical certifications
• Availability to provide 24-hour support as needed
• Strong verbal and written communication skills

Preferred:

• Experience with FAST GenTax / DS-VS architecture and application maintenance
• Knowledge of AWS cloud services and cloud computing concepts
• Experience with cloud storage, backup, and recovery solutions
• Familiarity with security standards including PUB1075, FIPS, and PII requirements
• Active Directory administration experience, including GPOs, DNS, FQDN, and SPN management
• Firewall administration and maintenance experience
• Experience troubleshooting email, SMTP, and proxy servers
• Web services development or support experience
• Experience supporting government tax, revenue, or regulatory systems

Physical Demands

• Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards
• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor
• Must be able to communicate with customers/team members over the phone and in person
• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to [email protected] (888) 824 - 8111.

EEO Statement

It is the policy of Computer Aid, Inc.(CAI) not to discriminate against any employee or applicant for employment because of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or because he or she is a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or protected veteran status, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment.

Employees and applicants of CAI will not be subject to harassment on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or because he or she is a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.

The pay range for this position is listed above. Exact compensation may vary based on several factors, including location, experience, and education. Benefit packages include medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role may also be entitled to paid sick leave and/or other paid time off as provided by applicable law.