SQL Server DBA​/Windows Server System Administrator

SQL Server DBA/Windows Server System Administrator

DMI is a leading provider of digital services and technology solutions, headquartered in Tysons Corner, VA. With a focus on end-to-end managed IT services, including managed mobility, cloud, cybersecurity, network operations, and application development, DMI supports public sector agencies and commercial enterprises around the globe. Recognized as a Top Workplace, DMI is committed to delivering secure, efficient, and cost-effective solutions that drive measurable results.

Learn more at

DMI, LLC is seeking a SQL Server DBA/Windows Server System Administrator to join our team!

• Manage the development and performance of SQL databases for web applications on prem.
• Configure and maintain database servers and processes.
• Ensure high levels of performance, availability, sustainability, and security.
• Design, install, upgrade, monitor, maintain, and conduct performance tuning procedures in a production MS SQL Server database environment while ensuring high levels of data availability.
• Develop, implement, and oversee SQL Server database policies and procedures to ensure the integrity and availability of databases and their accompanying software.
• Create, maintain, and execute scheduled jobs, data extracts, data refreshes, data loads, and data replication.
• Develop and implement replication processes for merge and transactional SQL Server replication.
• Perform data modeling and optimization, preliminary data received from customer designs, data analysis, report writing from existing data using SQL queries, and creation of new records and information updates as needed.
• Diagnose and troubleshoot database errors.
• Create automation for repeating database tasks.
• Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues, etc.
• Experience with patching Windows 2016 servers.
• Experience with installing and configuring third party software and custom web applications.
• Familiar with Internet Information Services (IIS).
• Familiar with review of ACAS scans and remediation of findings at all levels (critical, high, medium, and low).
• Ability to STIG SQL Server databases/instances, Windows OS, Active Directory/forest, and IIS.
• Knowledgeable with Windows Active Directory and domain controllers.

• Minimum 5+ years of technical experience in Microsoft SQL Server with a similar Application support or Development environment.

• Knowledge and strong experience and understanding of database structures, theories, principles, and practices, and Replication.
• Experience with various types of SQL Server replication, such as merge and transactional.
• SQL Server certification and strong experience with SQL Server 2016 and above.
• CompTIA Security+.
• Knowledgeable of T-SQL (Indexes, Triggers, Functions, Packages, and Procedures).
• Experience with implementing Transparent Database Encryption (TDE) and restoring databases encrypted with TDE.
• Familiarity with SSAS, SSIS, and SSRS.
• Microsoft Windows Server 2016 certification - MCSA:
  Windows Server 2016, strong experience with the Windows server operating system.
• Strong experience in High availability (Always On, cluster environment).
• Strong knowledge of backups, restores, and recovery models.
• Strong communication, interpersonal, and human relations skills to interact with clients.
• Strong analytical and problem-solving skills.
• Ability to work collaboratively on a multi-disciplinary agile development team.

Clearance Requirements:
Must possess or be eligible to obtain and complete a government security screening and/or a Secret security clearance.

Citizenship Status

Required:

Must be a U.S. Citizen.

Location:

Fort Belvoir, Virginia (with the option of Hybrid onsite when needed).

DMI is a diverse, prosperous, and rewarding place to work. Our culture is shaped by five core values that guide how we work, grow, and succeed together:

• Do What's Right – We lead with honesty and integrity.
• Own the Outcome – We take responsibility and deliver.
• Deliver for Our Customers – We are relentless about delivering value.
• Think Bold,…