Sr. SQL DBA

Seeking an expert-level SQL Database Administrator with recent, hands-on experience across all aspects of SQL Server database administration. Candidates must meet the required technical experience and be willing to work on-site from Day 1. Required Qualifications 1. SQL Server Database Administration - Minimum 4 Years Candidates must have hands-on experience with SQL Server 2022 or later, with SQL Server 2016 or later administration experience. Installation and Maintenance

• Installing and upgrading SQL Servers, including service packs and cumulative updates.
• Performing routine database maintenance.
• Managing SQL Server Agent and scheduled jobs.
• Monitoring SQL Server error logs and Windows event logs for errors and warnings.

SQL Server Tools and Services

• SQL Server Profiler
• Index Tuning Advisor
• SQL Server Configuration Manager
• Extended Events
• Performance Monitor
• Dynamic Management Views (DMVs)
• SQL Server Broker Service
• Linked Servers
• Microsoft Distributed Transaction Coordinator (MSDTC)
• SQL Server system databases
• SQL Server health checks and policies

Security and Auditing

• Managing SQL Server and database user security.
• Configuring authentication methods.
• Implementing SQL Server and database auditing.
• Managing encryption at rest, in transit, and for backups.

Capacity and Storage Management

• Planning capacity for databases and storage objects.
• Managing SQL Server disk storage and AWS storage systems.
• Optimizing storage utilization.
• Managing disk storage for Windows Failover Cluster Service (WFCS).

Backup, Recovery, and Disaster Recovery

• Establishing database backup standards and schedules.
• Developing recovery procedures to meet Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
• Performing point-in-time database recovery.
• Creating, testing, and maintaining disaster recovery plans.

• Proficiency in T-SQL coding and query tuning.
• Experience with ETL methodologies.
• Troubleshooting and optimizing database performance.

High Availability and Large Databases

• Experience with Very Large Databases (VLDBs).
• Monitoring, supporting, and troubleshooting high-intensity systems handling online and batch transactions.
• Experience with SQL Server Always On and AWS High Availability Zones.

1. Windows Server Administration - Minimum 3 Years * Building and maintaining Windows Servers and Amazon EC2 instances. * Installing and managing endpoint protection. * Configuring and maintaining application, web, file, and FTP servers. * Using PowerShell for administrative tasks. * Configuring and maintaining Windows Failover Clusters. * Managing Windows Server roles and features. * Managing .NET Framework components.

Preferred Knowledge and Skills

• Experience with GenTax application architecture and application maintenance.
• Familiarity with security standards and requirements, including PUB1075, FIPS, and Personally Identifiable Information (PII).
• Cloud computing knowledge.
• Cloud storage, backup, and restore mechanisms.
• Firewall administration and maintenance.
• Active Directory administration, including Group Policy Objects (GPO), Fully Qualified Domain Names (FQDN), DNS, and Service Principal Names (SPN).
• Troubleshooting email, SMTP, and proxy servers.
• Web services development and support.
• Availability to provide 24-hour support.
• Strong verbal and written communication skills.