Senior Database Architect

About DMI

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

About the Opportunity

DMI is currently seeking to hire a Senior Database Architect to support a Federal Government customer in the DC metro area. A Senior Database Architect is responsible for designing, implementing, and maintaining high-performance, scalable, and secure database solutions, primarily using Microsoft SQL Server.

Duties and Responsibilities:

• Develop and maintain relational database architectures, focusing on efficiency, scalability, and security
• Create logical and physical data models, ensuring data integrity and consistency.
• Manage the development and performance of SQL databases for web applications
• Configure and maintain database servers and processes
• Ensure high levels of performance, availability, sustainability and security
• Designs, installs, upgrade, 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.
• Work collaboratively with other teams, including data engineering and development, to deliver effective solutions

Qualifications

Education and Years of Experience:  

• Minimum 10+ years of technical experience in database Architecture or similar Application support or Development environment

Required and Desired Skills/Certifications: 

• Knowledge, strong experience, and understanding of database structures, theories, principles, and practices.
• Strong experience with SQL Server 2012 and 2016
• Knowledgeable of T-SQL (Indexes, Triggers, Functions, Packages and Procedures)
• Familiarity with SSAS, SSIS, SSRS
• Strong Experience in High availability (Always On, cluster environment)
• Strong knowledge of backups, restores, 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 teams

Additional Requirements: Successful completion of a Public Trust background investigation and/or a Public Trust clearance.

 

Min Citizenship Status Required: Min H1-B

 

Physical Requirements: No Physical requirement needed for this position.

Location: McLean, Virginia with an option of Hyrbrid (Tysons and Remote, US)

Working at DMI

DMI is a diverse, prosperous, and rewarding place to work. Being part of the DMI family means we care about your wellbeing. As such, we offer a variety of perks and benefits that help meet various interests and needs, while still having the opportunity to work directly with a number 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 Disabil