SQL Server Database Administrator (DBA)

About DMIDMI is a leading global provider of digital services working at the intersection of public and private sectors. With broad capabilities across IT managed services, cybersecurity, cloud migration and application development, DMI provides on-site and remote support to clients within governments, healthcare, financial services, transportation, manufacturing, and other critical infrastructure sectors. DMI has grown to over 2,100+ employees globally and has been continually recognized as a Top Workplace in both regional and national categories.About the OpportunityDMI is looking for a SQL Server Database Administrator (DBA) to support a Federal project.Duties and Responsibilities:• Manage the development and performance of SQL databases for web applications on-prem, Azure cloud platforms experience is preferred.• Configure and maintain database servers and processes.• Ensure high levels of performance, availability, sustainability, and security.• Designs install, 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.• 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.QualificationsEducation and Years of Experience: Minimum with 6+ years of technical experience in SQL Server similar Application support or Development environmentRequired and Desired Skills/Certifications:· Knowledge and strong experience and understanding of database structures, theories, principles, and practices.· Strong experience with SQL Server 2012 and above· Knowledgeable of T-SQL (Indexes, Triggers, Functions, Packages, and Procedures)· Familiarity with SSAS, SSIS, SSRS· Experience with Windows and Linux server operating systems· Experience with Azure Cloud technologies (Azure SQL Server, Analysis Services, Synapse, Active Directory)· 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 multi-disciplinary teamsMin Citizenship Status Required: H1-B/US/GC/EADPhysical Requirements: No Physical requirement needed for this position.Location: Hybrid/Tysons Office, VAWorking at DMIDMI is a diverse, prosperous, and rewarding place to work. Being part of the DMI family means we care about your wellbeing. We offer a variety of perks and benefits that help meet various interests and needs, while still having the opportunity to work directly with several of our award-winning, Fortune 1000 clients. The following categories make up your DMI wellbeing:• Convenience/Concierge - Virtual visits through health insurance, pet insurance, commuter benefits, discount tickets for movies, travel, and many other items to provide convenience.• Development – Annual performance management, continuing education, and tuition assistance, internal job opportunities along with career enrichment and advancement to help each employee with their professional and personal development.• Financial – Generous 401k matches both pre-tax and post-tax (ROTH) contributions along with financial wellness education, EAP, Life Insurance and Disability help provide financial stability for each DMI employee.• Recognition – Great achievements do not go unnoticed by DMI through Annual Awards ceremony, service anniversaries, peer-to-peer acknowledgment, employee referral bonuses.• Wellness – Healthcare benefits, Wellness programs, Flu Shots, Biometric screenings, and several other wellness options.Employees are valued for their talents and contributions. We all take pride in helping our customers achieve their goals, which in turn contributes to the overall success of the company. The company does and will take affirmative action to employ and advance in employment individuals with disabilities and protected veterans, and to treat qualified individuals without discrimination based on their physical or mental disability or veteran status. DMI is an Equal Opportunity Employer Minority/Female/Veterans/Disability. DMI maintains a drug-free workplace.#LI-SA1• **************** No Agencies Please *****************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.Location: Pimmit, VA, USPosted Date: 9/3/2024