SQL DBA

Valiant Technologies LLC; Harrisburg (Dauphin County); On-site; USD 90,000 - 130,000; Full time

Job summary

Valiant Technologies LLC is seeking an experienced SQL Server DBA in Harrisburg, PA. The role requires 4+ years of experience with SQL Server 2022 or later, including installation, upgrades, maintenance, and security auditing.

You will manage backups, disaster recovery, HA configurations, and integrate with AWS storage. Proficiency with SSMS, SQL Server Agent, Profiler, Extended Events, and DMVs is required.

Qualifications

• 4+ years of SQL Server DBA experience with 2022 or later versions.
• Experience installing and upgrading SQL Servers, including service packs and CU
• Perform routine database maintenance and security auditing
• Strong knowledge of backups, recovery, and disaster recovery planning
• Experience with high availability, including WFCS and MSDTC
• Familiarity with cloud storage (AWS) and encryption at rest/transit

Responsibilities

• Maintain SQL Server performance and health, monitor logs and alerts
• Configure and manage SQL Server Agent jobs and schedules
• Perform backups, restore tests, and point-in-time recoveries
• Establish and enforce DR plans and recovery objectives
• Implement security controls and auditing for databases
• Work with IT to manage storage and WFCS environments

Skills

SQL Server Administration

T-SQL Coding

Database Performance Monitoring

Backup and Recovery

Security and Auditing

Disaster Recovery Planning

Tools

SQL Server Management Studio (SSMS)

SQL Server Agent

SQL Server Profiler

Extended Events

Dynamic Management Views

AWS Storage

Windows Failover Cluster Service

MSDTC

Job description

Job Description:

• 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 maintenance


• Knowledge of SQL Server Agent and jobs


• Monitoring error logs and event logs for database errors and warnings


• 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 Databases knowledge


• SQL Server Health Checks and Policies


• Managing SQL Server security and auditing


• User security


• 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 storage and experience with AWS storage systems to ensure storage is properly utilized


• Managing disk storage for Windows Failover Cluster Service (WFCS)


• 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

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.