Intermediate Database Administrator

Erp International - Falls Church, VA

Full-time - Mid Level

Falls Church, VA

Professional, Scientific, and Technical Services

About the position

ERP International is seeking an Intermediate MS SQL Server Database Administrator to support our Department of Defense (DoD) customer in Falls Church, Virginia. The ideal candidate will possess strong experience with MS SQL Server and MS Azure, and must be able to pass a DoD Background Check. This position is critical in managing, maintaining, and performance tuning MS SQL Server Databases within the MS Azure Cloud environment, ensuring that all cybersecurity and DoD compliance requirements are met. The Intermediate DBA will be responsible for ensuring data integrity, optimizing performance, and supporting the team with various database-related tasks. The role also involves ensuring that database systems and services are certified for operational readiness, which includes maintaining desired state configuration, security, health, and performance. The objectives of this role include ensuring the smooth operation of the database framework, recommending approaches for separating transactional data from historical reporting, deploying new database functionalities as necessary, and ensuring high availability of database and related services. The DBA will work to improve performance through index implementation and optimization, while safeguarding sensitive information and ensuring data integrity. This position offers the opportunity to work with leading-edge technology and participate in community outreach and charity work, reflecting ERP's commitment to employee engagement and social responsibility.

Responsibilities

• Design, install, configure, and administer database systems.
• Implement and manage data security protocols, including access controls and encryption.
• Create and manage DB schema objects including tables, indexes, views, stored procedures, and triggers.
• Collaborate with developers and system administrators to integrate new features and resolve data-related issues.
• Monitor DB performance, tune for optimal efficiency, and troubleshoot issues.
• Perform DB tuning, coordinate application releases, and troubleshoot DB issues including slowness and latencies.
• Patching the DB and applying any relevant product updates.
• Address all identified SQL Server platform-related vulnerabilities.
• Perform upgrades of the DB and software to new release levels and handle database migrations.
• Recommend approach for separating transactional data and historical reporting.
• Assist development with query construction and optimization.
• Build automation scripts for managing database infrastructure.
• Implement database high availability solutions and multiple types of replications.
• Establish metrics and observability of the DB platform.
• Coordinate and assist with performing SQL DB STIG checks.
• Support boundary accreditation DB efforts (e.g., site or enclave ATO requirements).
• Maintain comprehensive DB documentation, including data standards, procedures, and Security Technical Implementation Guide (STIG) checklists.
• Develop and execute disaster recovery plans to ensure database availability during outages.

Requirements

• Bachelor's degree in computer science, Information Technology, or a related field.
• 3-5 years of experience in database administration.
• Experience installing and operating MS SQL Server in MS Azure.
• Strong analytical and problem-solving skills.
• Experience with refactoring old database systems.
• Excellent communication skills and ability to thrive on an Agile delivery team.

Nice-to-haves

• Experience implementing Azure SQL.
• MS Certification(s) in Azure or SQL Server.

Benefits

• Competitive Salaries & Benefits
• Health Advocate & Concierge Services
• Unlimited Job-Related Training & Development
• Employee Recognition & Incentive Programs
• Employee Appreciation & Company Sponsored Events
• Opportunity to work with leading edge technology
• Community Outreach & Charity Work