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 www.dminc.com

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.
• → Designs, installs, upgrades, monitors, maintains, and conducts performance tuning procedures in a production MS SQL Server database environment while ensuring high levels of data availability.
• → Develops, implements, and oversees 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 (Structured Query Language) queries, and creation of new records and information updates as needed.
• → Diagnose and troubleshoot database errors.
• → Create automation for repeating database tasks.
• → Troubleshooting and resolving 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 3rd 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

Applicants selected may be subject to a government security investigation and must meet eligibility requirements for access to classified information. US citizenship may be required for some positions.

• Minimum with 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