SQL Server Database Administrator (DBA)

Job Description

Benefits:

401(k) matching

Dental insurance

Health insurance

Paid time off

MSM Technology is seeking to fill the SQL Database Administrator position. We strive to provide the next generation of cutting-edge technologies. Our growth means exciting career opportunities for talented professionals in engineering, software development, and other key areas. We offer competitive compensation and benefits including Health, Vision, and Dental Insurance, a matching 401k plan, and other benefits given below, excellent training, and a vibrant working environment. Our employees are exceptional, giving us a competitive advantage by innovating solutions with a strong sense of mission and integrity.

Position: SQL DBA

Position Type: On-site

Clearance: Secret or HigherDescription

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.Please check the Job Description and let me know if you are interested. If you feel curious, please send me your salary expectations, updated resume, and the best time to reach you on

Usman Khan

Sr. Recruitment Professional

Representing:

MSM Technology, LLC

Direct:

Main: Ext.: 502

Please consider the environment before printing this email.

MSM Technology is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, sexual orientation, gender identity, disability status, protected veteran status, or any other characteristic protected by law.

Full-time