SQL Server Database Administrator (DBA) at MSM Technology, LLC

Fort Belvoir, Virginia, United States -

Full Time

Start Date

Immediate

Expiry Date

06 Feb, 26

Salary

0.0

Posted On

08 Nov, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Server, Database Management, Performance Tuning, High Availability, Transparent Data Encryption, Replication, Automation, Troubleshooting, Data Modeling, Query Optimization, SSAS, SSIS, SSRS, T-SQL, Windows Server, Backup Strategies

Industry

IT Services and IT Consulting

Description

Description As a SQL Server Database Administrator, you will be responsible for managing and optimizing on-premises SQL databases that support web applications. Your role will ensure high performance, availability, security, and sustainability of database systems through proactive maintenance and strategic planning. Key Responsibilities: Database Management & Maintenance Configure, install, upgrade, and maintain Microsoft SQL Server databases in a production environment. Monitor database performance and conduct tuning procedures to ensure optimal operation. Create and manage scheduled jobs, data extracts, refreshes, loads, and replication processes. Performance, Availability & Security Ensure high levels of database performance, availability, and data integrity. Implement and manage high availability solutions such as Always On and SQL clustering. Apply Transparent Data Encryption (TDE) and manage encrypted database backups and restores. Replication & Automation Develop and implement merge and transactional replication strategies. Automate routine database tasks to improve efficiency and reduce manual intervention. Troubleshooting & Optimization Diagnose and resolve issues related to performance, blocking/deadlocks, replication, connectivity, and security. Perform data modeling, query optimization, and analysis of customer-provided data. Reporting & Analysis Write SQL queries and reports using existing data. Create and update records based on business requirements. Governance & Documentation Develop and enforce database policies and procedures to maintain system integrity and compliance. Maintain documentation for database configurations, processes, and troubleshooting steps. Requirements Technical Expertise 5+ years of experience with Microsoft SQL Server in application support or development environments. Strong proficiency in SQL Server 2016 and newer versions. Deep understanding of database structures, principles, and best practices. Skilled in T-SQL including indexes, triggers, functions, stored procedures, and packages. Experience with SQL Server replication (merge and transactional). Familiarity with SSAS (Analysis Services), SSIS (Integration Services), and SSRS (Reporting Services). Proficient in Windows Server operating systems. Security & Availability Hands-on experience with Transparent Data Encryption (TDE). Strong knowledge of backup strategies, restore procedures, and recovery models. Experience implementing high availability solutions (Always On, clustering). Soft Skills & Collaboration Excellent communication and interpersonal skills for client interaction. Strong analytical and problem-solving abilities. Ability to work effectively in agile, cross-functional development teams. Certifications & Clearance SQL Server certification. CompTIA Security+ certification. Must hold an ACTIVE Secret Clearance or higher.

Responsibilities

The SQL Server Database Administrator will manage and optimize on-premises SQL databases to ensure high performance, availability, security, and sustainability. This includes configuring, monitoring, and maintaining database systems, as well as implementing high availability solutions and troubleshooting issues.