Database Administrator

We want you!

We are seeking an experienced Database Administrator (DBA) for our DataServ / xFact team with strong expertise in ClickHouse, Microsoft SQL Server and PostgreSQL to join our team. The DBA will be responsible for managing, maintaining, and optimizing our database infrastructure to ensure high availability, performance, and scalability. This role requires a detail-oriented professional with a deep knowledge of database design, query optimization, indexing strategies, replication, and load testing.

Why you'll love us :

We care. We coach. We lead. DataServ, founded in 1986, continues to use this approach in all we do for our culture. It's truly the people who make working here great. We are a collaborative environment and supportive of one another, providing flexibility when needed. As lifelong learners, promoting from within is a priority to provide our team members opportunities for internal mobility and growth. DataServ / xFact offer a competitive compensation plan including paid holidays, PPTO, discretionary bonuses, 401K (with match), medical, dental, vision, life, STD, and LTD benefits along with many other inclusive benefits and perks!

About DataServ :

For almost 40 years, DataServ / xFact's primary mission has been to provide managed technology solutions and services to the public and commercial sectors. With our focus of understanding people and processes, we created the concept of Technology as a Utility so that our customers can buy only what they need, without having to make an investment in infrastructure. We take pride in helping to align goals, build trust, and add value to exceed our customer technology expectations.

About xFact :

xFact, Inc. is a rapidly growing company serving many government agencies. We are a team of passionate and driven individuals who are committed to building innovative products and services for the public sector. Join our dynamic team and be part of our innovative and collaborative work environment.

Qualities we want in you :

team player

• excellent written and verbal communicator
• tech savvy
• strategic thinker
• service oriented
• motivated
• self-disciplined
• professional
• flexible in a fast-paced environment
• works independently with minimal supervision
• exhibits strong work ethics
• detail oriented
• handles demanding situations / timelines
• organized
• responsible / dependable
• willing to receive / provide feedback to improve performance
• supportive
• strong desire to support and mentor

What you'll do :

Administer, monitor, and maintain Microsoft SQL Server and PostgreSQL database environments across development, staging, and production.

Design and implement data models and data integration strategies.

Optimize database performance through query tuning, indexing, and partitioning strategies.

Implement and manage database replication, clustering, and failover mechanisms to ensure data integrity and high availability.

Conduct load testing and capacity planning to ensure system scalability.

Design and implement comprehensive backup and disaster recovery strategies including multiple backup types (full, differential, transaction log backups) and automated backup scheduling and monitoring.

Develop and maintain automated backup testing procedures to validate backup integrity and implement automated restore testing to separate environments to ensure backups are recoverable.

Create automated alerts and reporting for backup success / failure status and regularly test and validate backup procedures and recovery processes.

Maintain documentation for recovery procedures and disaster response plans.

Automate routine database tasks including backups, recovery, and maintenance.

Collaborate with software engineering and infrastructure teams to design efficient schemas, queries, and stored procedures.

Monitor database health, troubleshoot issues, and provide timely resolution of performance bottlenecks.

Ensure database security, compliance, and adherence to best practices and regulatory compliance such as the FBI CJIS Security Policy.

Plan, coordinate, and implement security measures to safeguard the database.

Support disaster recovery planning and execution.

Implement database source control and version management tools with database change management processes and deployment pipelines.

Utilize database migration tools and automated deployment strategies.

Stay up to date with database technologies, tools, and best practices to continuously improve infrastructure.

Create and maintain clear, concise, structured and detailed technical documentation.

Manage and optimize ClickHouse database environments for analytics and high-volume data workloads.

Implement and manage ClickHouse replication and distributed table architectures.

Tune ClickHouse specific configurations including memory settings, thread pools, and merge operations.

What we require :

Education :

Bachelor's degree in Computer Science, Information Technology, or equivalent experience.

Experience :

3-5+ years of experience as a Database Administrator with SQL Server, Postgres, and ClickHouse.

Skills :

Strong knowledge of query optimization, indexing strategies, and database tuning.

Strong understanding of columnar database architecture and OLAP workloads.

Experience / knowledge of supporting and tuning ETL / ELT processes.

Experience with replication methods (logical, physical, streaming) and clustering solutions.

Hands-on experience with load / stress testing and capacity planning.

Familiarity with database monitoring tools and performance profiling.

Experience with backup / recovery strategies and disaster recovery planning.

Knowledge of database security best practices, role-based access, and auditing.

Scripting experience (e.g., Python, Bash, PowerShell) a plus.

Strong problem-solving skills and ability to work collaboratively across teams.

Additional proficiencies we seek :

Demonstrates excellent written and verbal communication skills, in both collaborative team and customer-facing environments.

Experience with cloud-based database services (AWS RDS, Azure Database for PostgreSQL, or GCP Cloud SQL).

Knowledge of additional RDBMS platforms (Oracle, MySQL, SQL Server).

Exposure to NoSQL databases (MongoDB, Cassandra, etc.) is a plus.

Familiarity with CI / CD pipelines and DevSecOps practices related to database deployments.

Experience integrating ClickHouse with data pipeline tools.

DataServ is an equal opportunity employer and does not discriminate in hiring or employment, in accordance with the requirements of all applicable laws, including race, color, religion, national origin, ancestry, age, gender, marital status, military status, sexual orientation, disability, or medical condition.