Senior Database Administrator at Syms Strategic Group, LLC (SSG)

📍 Job Overview

Job Title: Senior Database Administrator
Company: Syms Strategic Group, LLC (SSG)
Location: Remote (United States)
Job Type: Full Time
Category: Database Administration
Date Posted: June 27, 2025

🚀 Role Summary

Lead database creation and management efforts through data modeling and data mart creation.
Manage and maintain Microsoft SQL Server databases in virtual and clustered environments.
Perform and troubleshoot SQL Server backups, restores, replication, performance tuning, and query optimization.
Collaborate with cross-functional teams to ensure database consistency and optimal performance.
Provide technical guidance and mentorship to junior database administrators.

💻 Primary Responsibilities

🔧 Database Management & Optimization

Lead the database creation and management effort through data modeling.
Create and maintain data marts to support business intelligence and reporting needs.
Set up and manage Microsoft SQL Server databases in virtual and clustered environments.
Perform and troubleshoot SQL Server backups, restores, replication, performance tuning, and query optimization.
Collaborate with cross-functional teams to ensure database consistency and optimal performance.

📊 Data Warehousing & Business Intelligence

Design, develop, and maintain data warehouses and data marts using SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
Develop and maintain Extract, Transform, and Load (ETL) processes using SQL Server Integration Services (SSIS).
Ensure data quality, integrity, and security within the data warehouse environment.

🛠️‍🏻 Technical Leadership & Mentoring

Provide technical guidance and mentorship to junior database administrators.
Stay up-to-date with emerging database technologies and best practices.
Contribute to the development of database standards, policies, and procedures.

🎓 Skills & Qualifications

📚 Education

Bachelor's degree or higher in Computer Science, Information Technology, or a related field.

🕒 Experience

8+ years of professional experience in database administration, with a strong focus on Microsoft SQL Server.
Proven experience in data modeling, data mart creation, and SQL Server performance tuning.
Experience with SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
Familiarity with operational data stores (ODS), data warehouses (DWH), and ETL processes.
Proficiency in shell scripting (Bash, PowerShell), XML, and other relevant technologies.

🛠️‍🏻 Required Skills

Expertise in creating data marts and setting up Microsoft SQL Server databases.
Strong proficiency in SQL Server performance tuning, query optimization, and backup strategies.
Experience with SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
Familiarity with operational data stores (ODS), data warehouses (DWH), and ETL processes.
Proficiency in shell scripting (Bash, PowerShell), XML, and other relevant technologies.

🌟 Preferred Skills

Experience with cloud-based database management systems (e.g., Azure SQL Database, Amazon RDS).
Familiarity with containerization and orchestration tools (e.g., Docker, Kubernetes).
Knowledge of infrastructure as code (IaC) tools (e.g., Terraform, Azure Resource Manager).

📊 Web Portfolio & Project Requirements

📝 Portfolio Essentials

A comprehensive resume highlighting relevant database administration experience, projects, and achievements.
A portfolio showcasing data modeling, data mart creation, and SQL Server performance tuning projects.
Examples of SQL Server backup strategies, replication, and query optimization techniques.

📄 Technical Documentation

Detailed documentation of data modeling processes, data mart design, and ETL processes.
Code comments and documentation demonstrating best practices in SQL Server development.
Performance testing results and optimization strategies for SQL Server databases.

💵 Compensation & Benefits

💰 Salary Range

The salary range for this role is $120,000 - $150,000 per year, depending on experience and location. This estimate is based on market research for senior database administrator roles in the United States.

🏥 Benefits

Comprehensive health, dental, and vision insurance plans.
401(k) retirement plan with company matching.
Generous paid time off (PTO) and holiday schedule.
Professional development opportunities, including training and certifications.
Employee assistance programs (EAP) for mental health and wellness support.
Opportunities for remote work and flexible scheduling.

🕒 Working Hours

Full-time position with a typical workweek of 40 hours, Monday through Friday.
Some flexibility in working hours may be available, depending on the role and team needs.

🎯 Team & Company Context

🏢 Company Culture

🏢 Industry

Syms Strategic Group, LLC (SSG) operates in the government services and technology consulting industry, providing solutions to federal, state, and local government clients.

🏢 Company Size

SSG is a mid-sized company with approximately 500 employees, providing a collaborative and dynamic work environment.

🏢 Founded

SSG was founded in 2005, with a strong focus on delivering innovative technology solutions to government clients.

🏢 Team Structure

The database administration team at SSG consists of database administrators, data architects, and database developers, working collaboratively to ensure optimal database performance and data integrity.
The team follows an Agile/Scrum methodology, with regular sprint planning and code reviews to maintain high-quality standards.

🏢 Development Methodology

SSG follows an Agile/Scrum development methodology, with regular sprint planning, daily stand-ups, and code reviews to ensure high-quality deliverables.
The company emphasizes continuous integration and continuous deployment (CI/CD) pipelines, automated testing, and performance optimization.

📈 Career & Growth Analysis

📈 Web Technology Career Level

This role is at the senior level within the database administration career path, requiring extensive experience and expertise in Microsoft SQL Server and related technologies.

📈 Reporting Structure

The senior database administrator reports directly to the database administration manager or a similar role, depending on the organization's structure.
They may also collaborate with data architects, data engineers, and other technical stakeholders to ensure data consistency and optimal performance.

📈 Technical Impact

Senior database administrators have a significant impact on the organization's data infrastructure, ensuring optimal performance, scalability, and security for critical business applications.
They contribute to the development of data-driven strategies, supporting data warehousing, business intelligence, and data analytics initiatives.

🌐 Work Environment

🏢 Office Type

This role is remote, with no physical office location required. However, some travel may be required for client meetings, training, or other business needs.

🏢 Office Location(s)

As a remote position, the senior database administrator can work from any location within the United States.

🏢 Workspace Context

The remote work environment provides a flexible and collaborative workspace, with opportunities for virtual team interaction and cross-functional collaboration.
The company provides remote work equipment, including laptops, monitors, and other necessary tools for a productive home office setup.

🕒 Work Schedule

The typical workweek is 40 hours, Monday through Friday, with some flexibility in working hours depending on the role and team needs.
The work schedule may include occasional evening or weekend work to support maintenance windows, performance tuning, or other critical tasks.

📄 Application & Technical Interview Process

📝 Portfolio Review Tips

Highlight relevant database administration projects, data modeling examples, and SQL Server performance tuning strategies in your portfolio.
Include case studies demonstrating your ability to optimize database performance, improve data quality, and ensure data integrity.
Showcase your technical expertise through code samples, documentation, and live demonstrations of your database administration skills.

📝 Technical Challenge Preparation

Brush up on your SQL Server skills, focusing on performance tuning, query optimization, and backup strategies.
Familiarize yourself with data modeling techniques, data mart creation, and ETL processes using SQL Server Integration Services (SSIS).
Prepare for technical interviews by practicing common database administration interview questions and scenarios.

📝 Company & Culture Questions

Research SSG's company culture, focusing on their commitment to innovation, collaboration, and customer satisfaction.
Prepare questions about the company's growth plans, technology stack, and long-term vision for the database administration team.
Be ready to discuss your fit with the company's culture and your ability to contribute to their ongoing success.

📝 Interview Process

The interview process typically includes a combination of phone screens, technical assessments, and in-depth interviews with technical stakeholders.
Be prepared to discuss your database administration experience, technical skills, and career goals in detail.

🛠️‍🏻 Technology Stack & Web Infrastructure

🔧 Database Management Systems

Microsoft SQL Server (primary database management system)
Azure SQL Database (cloud-based SQL Server alternative)
Amazon RDS (cloud-based SQL Server alternative)

🛠️‍🏻 Server Platforms & Infrastructure Tools

Windows Server (primary server platform)
Linux (for cloud-based infrastructure and containerization)
Docker (containerization and orchestration)
Kubernetes (container orchestration and management)
Terraform (infrastructure as code)
Azure Resource Manager (cloud-based infrastructure as code)

🛠️‍🏻 Development & DevOps Tools

Visual Studio (primary integrated development environment)
Azure DevOps (continuous integration and continuous deployment)
Jenkins (continuous integration and continuous deployment)
Git (version control and collaboration)
PowerShell (scripting and automation)

👥 Team Culture & Values

🌟 Web Development Values

Customer Focus: Prioritize customer needs and deliver high-quality solutions that meet business objectives.
Innovation: Embrace continuous learning and improvement, staying up-to-date with emerging technologies and best practices.
Collaboration: Foster a collaborative work environment, encouraging knowledge sharing and teamwork.
Quality: Maintain high-quality standards in all aspects of database administration, ensuring optimal performance, scalability, and security.

🤝 Collaboration Style

Cross-functional Integration: Work closely with development, data engineering, and business teams to ensure data consistency, integrity, and optimal performance.
Code Review Culture: Participate in code reviews and pair programming to maintain high-quality standards and share knowledge with team members.
Mentoring & Knowledge Sharing: Provide technical guidance and mentorship to junior database administrators, fostering a culture of continuous learning and growth.

📌 Application Steps

To apply for this senior database administrator position at Syms Strategic Group, LLC (SSG):

Customize Your Resume: Highlight your relevant database administration experience, projects, and achievements, tailoring your resume to the specific requirements of this role.
Prepare Your Portfolio: Showcase your data modeling, data mart creation, and SQL Server performance tuning projects, emphasizing your technical expertise and problem-solving skills.
Research the Company: Familiarize yourself with SSG's company culture, technology stack, and long-term vision for the database administration team.
Prepare for Technical Interviews: Brush up on your SQL Server skills, practice common database administration interview questions, and be ready to discuss your career goals and fit with the company's culture.

By following these application steps and demonstrating your technical expertise, you'll be well-prepared to succeed in the senior database administrator role at SSG.