SQL Server DBA

Softworld - Reston, VA

Full-time

Reston, VA

Administrative and Support Services

About the position

We are seeking an experienced SQL Server Database Administrator (DBA) to lead the transformation of our database infrastructure. This role is critical in addressing our current database needs and challenges while implementing best practices to ensure efficiency, reliability, and security across our systems. The DBA will collaborate closely with cross-functional teams to design, maintain, and optimize databases that integrate seamlessly with applications and support robust reporting and analytics capabilities.

Responsibilities

• Lead the database infrastructure transformation, data migration, and integration with MS Dynamics ERP.
• Design and model well-structured database schemas, defining relationships and applying normalization to support data integrity.
• Regularly optimize database performance through indexing, query tuning, and other techniques.
• Collaborate with development and IT teams to ensure database design aligns with application requirements and reporting needs.
• Contribute to the design and maintenance of a data warehouse to support reporting needs.
• Implement data synchronization mechanisms for data consistency between different sources and Elasticsearch.
• Manage and enforce robust access controls and ensure compliance with industry regulations.
• Develop and implement comprehensive backup strategies and disaster recovery plans.
• Analyze database usage patterns and implement strategies for scaling databases effectively.
• Automate routine tasks such as backups and performance monitoring to streamline operations.
• Document database configurations, processes, and procedures for consistency and knowledge sharing.
• Plan and execute data migration projects with minimal disruption to operations.

Requirements

• Bachelor's degree in computer science, Information Technology, or a related field (or equivalent experience).
• 5+ years of experience as a DBA, particularly with Microsoft SQL Server on Windows Server.
• Proven experience in database design, optimization, and performance tuning.
• Hands-on experience with data warehousing, ETL processes, and integration with ERP and BI/reporting tools.
• Proficient in SQL and database performance tuning, indexing strategies, and schema design.
• Knowledge of database security best practices and access management principles.
• Familiarity with automation tools and scripting languages (e.g., PowerShell, Python).
• Experience with backup strategies, disaster recovery planning, and execution.

Nice-to-haves

• Experience integrating databases with Elasticsearch or similar indexing/search tools.
• Familiarity with CI/CD practices and tools for database deployment and version control.
• Knowledge of database optimization tools and methodologies for cloud environments.

Benefits

• Hybrid work policy allowing 2 days a week in-office commitment.
• Full-time position with eligibility to work in the United States.