SQL Server DBA

Job Title: 80678 - SQL Server DBA

Job Location: Reston VA 20191

Onsite Requirements:

• MS SQL Server DBA (multiple DB's on v2008 R2 to 2019) to lead the database infrastructure transformation, data migration and integration with MS Dynamics ERP
• Proficient/hands-on database design, optimization, security & access control, backup/DR, automation, data migration and integration skills and experience required utilizing ETL, PowerShell, Python, Elasticsearch, running Windows 10, and will be going to Government Community Cloud (GCC) in future
• Excellent communication skills required to collaborate and work closely with cross-functional teams and business stakeholders to design, maintain, and optimize databases that integrate with applications, and support reporting and analytics

Job Description:

• We are seeking an experienced Database Administrator (DBA) to lead the transformation of our database infrastructure.
• This role is critical in addressing our current database needs and challenges and implementing best practices to ensure efficiency, reliability, and security across our systems.
• The DBA will work closely with cross-functional teams, including software engineering manager, developers, system administrators, reporting, pricing etc., to design, maintain, and optimize databases that integrate seamlessly with applications and support robust reporting and analytics capabilities.
• Collaborate closely with cross-functional teams, and business stakeholders, to understand data requirements and align database solutions with organizational goals.

ESSENTIAL FUNCTIONS:

Key Responsibilities:

1. Database Design and Optimization

• Create, install, configure, and maintain database compatible with organizations need.
• Design and model well-structured database schemas, defining relationships and applying normalization where needed to support data integrity.
• Regularly optimize database performance through indexing, query tuning, and other techniques to ensure efficient data retrieval and processing.
• Collaborate with the development and IT teams to ensure that database design aligns with application requirements and reporting needs.
• Assist development with query construction and optimization.

1. Data Warehouse and Reporting Support

• Contribute to the design and maintenance of a data warehouse to support the reporting team's needs for drill-down and drill-up data access. Perform data integration and ETL processes.
• Implement data synchronization mechanisms to ensure data consistency between different sources, relational databases and Elasticsearch for reliable search indexing and reporting.

1. Security and Access Control

• Manage and enforce robust access controls, transitioning from individual user accounts to group-based permissions for better accountability and management.
• Ensure database practices comply with industry regulations and federal requirements, maintaining the highest standards of data security and integrity to meet the needs of our government and regulated customers.
• Regularly audit and update security measures, including data encryption, to protect sensitive information and ensure compliance with relevant regulations.

1. Backup and Disaster Recovery

• Develop and implement comprehensive backup strategies and disaster recovery plans to protect data integrity and ensure quick recovery in case of failures.
• Test and validate recovery plans regularly to maintain preparedness for potential data loss scenarios.

1. Capacity Planning and Scalability

• Analyze database usage patterns, forecasting future needs to ensure the database infrastructure scales effectively with business growth.
• Implement strategies for scaling databases, optimizing resources to handle increasing data volumes and user load efficiently.

1. Automation and Maintenance

• Maintain smooth operation and physical design of databases.
• Automate routine tasks such as backups, performance monitoring, and data maintenance to streamline operations and minimize manual intervention.
• Perform regular maintenance tasks, including updating statistics, rebuilding indexes, and monitoring database health to maintain peak performance.

1. Documentation and Reporting

• Document database configurations, processes, and procedures to support consistency and knowledge sharing across the team.
• Generate regular reports on database performance, usage, and security, providing insights and recommendations regarding enhancements and/or for ongoing improvement.

1. Data Migration and Integration

• Plan and execute data migration projects, ensuring seamless transition and integration of data between old and new systems with minimal disruption.
• Plan and execute the migration of data from old ERP to new ERP system.

1. Collaboration with Cross-Functional Teams and Stakeholders

• Collaborate closely with cross-functional teams, and business stakeholders, to understand data requirements and align database solutions with organizational goals.
• Act as a key liaison, ensuring that database architecture supports the evolving needs of various departments, including but not limited to reporting and analytics, compliance, and pricing. Through regular communication and collaboration.
• Provide guidance on best practices, troubleshoot data-related issues, and proactively identify improvements to enhance system performance and meet stakeholder expectations.

Supervisory Responsibility:

• This position has no direct supervisory responsibilities.

Required Education and Experience:

Education:

• Bachelor's degree in computer science, Information Technology, or a related field (or equivalent experience).

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, BI/reporting tools.

Technical Skills:

• 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) for process automation.
• Experience with backup strategies, disaster recovery planning, and execution.

Soft Skills:

• Strong analytical and problem-solving abilities.
• Excellent communication skills, with the ability to work collaboratively across teams.
• Detail-oriented with a commitment to data integrity and accuracy.

Desired Skills:

• 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.
• The ideal candidate is dedicated to strengthening and maintaining his/her skillset to match the needs of the work environment.

Position Type:

• This is a full-time position.

Work Authorization:

Must be eligible to work in the United States.

Physical Demands:

• While performing the duties of this job, the employee is regularly required to talk or listen. This is largely a sedentary role with no significant physical expectations.
• Hybrid work policy. The employee must be able to commit to the 2-day a week in-office policy.

** 3rd party and subcontract staffing agencies are not eligible for partnership on this position. 3rd party subcontractors need not apply.

This position requires candidates to be eligible to work in the United States, directly for an employer, without sponsorship now or anytime in the future. **