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
Experience Level: 10+ years

🚀 Role Summary

Lead database creation and management through data modeling and data mart development.
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 data consistency and integrity.
Maintain high availability and disaster recovery solutions for databases.

📝 Enhancement Note: This role requires a senior-level database administrator with extensive experience in data modeling, Microsoft SQL Server management, and performance tuning. The candidate should be comfortable working remotely and collaborating with diverse teams.

💻 Primary Responsibilities

Database Design and Management: Lead the database creation and management effort through data modeling and create data marts to support business intelligence and reporting needs.
SQL Server Administration: Set up and manage Microsoft SQL Server databases in virtual and clustered environments, ensuring high availability and disaster recovery solutions are in place.
Performance Tuning: Perform and troubleshoot SQL Server backups, restores, replication, performance tuning, and query optimization to maintain optimal database performance.
Collaboration: Work closely with cross-functional teams, including data analysts, business intelligence developers, and software engineers, to ensure data consistency, integrity, and accessibility.
Security and Compliance: Implement and maintain database security measures, including access controls, auditing, and compliance with relevant standards and regulations.

📝 Enhancement Note: The senior database administrator is expected to provide technical leadership, mentor junior team members, and drive best practices in database design, management, and performance tuning. They should also stay current with emerging database technologies and trends.

🎓 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 and data modeling.

Required Skills:

Expertise in creating data marts and data warehouses.
Proven experience in setting up and managing Microsoft SQL Server databases in virtual and clustered environments.
Strong proficiency in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
Experience with SQL Server Integration Services (SSIS), Extensible Markup Language (XML), Operational Data Store (ODS), Extract, Transform, and Load (ETL), and Data Warehouse (DWH) processes.
Familiarity with Shell, PowerShell, and Bash scripting.

Preferred Skills:

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

📝 Enhancement Note: Candidates with a strong background in data modeling, Microsoft SQL Server administration, and performance tuning, as well as experience working with cross-functional teams, will be highly sought after for this role.

📊 Web Portfolio & Project Requirements

Portfolio Essentials:

A comprehensive portfolio showcasing your experience in database design, management, and performance tuning.
Examples of data marts and data warehouses you have created and maintained.
Case studies demonstrating your ability to optimize database performance and implement high availability solutions.
Documentation of your experience with Microsoft SQL Server, including backups, restores, replication, and query optimization.

Technical Documentation:

Detailed documentation of your database design and management processes, including data modeling techniques, normalization, and indexing strategies.
Examples of your SQL Server performance tuning and query optimization efforts, including before-and-after comparisons.
Documentation of your experience with SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
Evidence of your familiarity with scripting languages, such as Shell, PowerShell, and Bash, and their application to database management tasks.

📝 Enhancement Note: A strong portfolio will demonstrate your ability to lead database creation and management efforts, collaborate with cross-functional teams, and maintain optimal database performance. It should also showcase your technical expertise in Microsoft SQL Server and data modeling.

💵 Compensation & Benefits

Salary Range: $120,000 - $160,000 per year (USD), depending on experience and location.

Benefits:

Competitive health, dental, and vision insurance plans.
401(k) retirement plan with company match.
Generous paid time off and holiday schedule.
Flexible work arrangements, including remote work options.
Professional development opportunities, including training and certification reimbursement.

Working Hours: Full-time position with a standard workweek of 40 hours, with some flexibility for remote work.

📝 Enhancement Note: The salary range for this role is based on industry standards for senior database administrators with extensive experience in Microsoft SQL Server and data modeling. The benefits package is designed to attract and retain top talent in the database administration field.

🎯 Team & Company Context

Company Culture: SSG fosters a collaborative and inclusive work environment, encouraging cross-functional teamwork and continuous learning. They value innovation, adaptability, and a customer-focused mindset.

Industry: SSG operates in the government services industry, providing technology and management solutions to federal, state, and local government agencies.

Company Size: Medium-sized company with a team of over 200 employees, allowing for ample opportunities for career growth and development.

Founded: 2005, with a strong track record of delivering high-quality technology and management solutions to government clients.

Team Structure:

Database Administration: A dedicated team of database administrators, including the senior database administrator role.
Data Science & Analytics: A team focused on data analysis, business intelligence, and reporting.
Software Engineering: A team responsible for developing and maintaining custom software solutions.
Project Management: A team dedicated to managing projects and ensuring client satisfaction.

Development Methodology: SSG follows Agile development methodologies, with a focus on iterative development, continuous integration, and collaboration.

Company Website: Syms Strategic Group, LLC

📝 Enhancement Note: SSG's culture emphasizes teamwork, innovation, and a customer-focused approach, making it an attractive workplace for senior database administrators seeking a collaborative and challenging environment.

📈 Career & Growth Analysis

Web Technology Career Level: Senior Database Administrator - Leads database creation and management efforts, mentors junior team members, and drives best practices in database design, management, and performance tuning.

Reporting Structure: Reports directly to the Director of Technology, with a dotted-line relationship to the Data Science & Analytics and Software Engineering teams for project-specific collaboration.

Technical Impact: The senior database administrator plays a critical role in ensuring data consistency, integrity, and accessibility across SSG's projects. They work closely with data analysts, business intelligence developers, and software engineers to deliver high-quality technology solutions to government clients.

Growth Opportunities:

Technical Leadership: Progress to a Director or Principal Database Architect role, overseeing the database administration team and driving strategic decisions related to database design, management, and performance tuning.
Architecture and Design: Expand your expertise to include database architecture and design, leading the development of enterprise-level database solutions and data warehouses.
Emerging Technologies: Stay current with emerging database technologies and trends, and explore opportunities to implement cutting-edge solutions within SSG's projects.

📝 Enhancement Note: The senior database administrator role at SSG offers significant opportunities for career growth and development, with a clear path to technical leadership and architecture positions. Candidates with a strong background in Microsoft SQL Server, data modeling, and performance tuning will be well-positioned to take advantage of these growth opportunities.

🌐 Work Environment

Office Type: Remote, with occasional on-site meetings and training sessions as needed.

Office Location(s): SSG has offices in various locations across the United States, with a strong focus on remote work and virtual collaboration.

Workspace Context:

Remote Workstation: A dedicated workspace at home, equipped with a high-quality computer, multiple monitors, and any necessary software tools for remote work.
Collaboration Tools: SSG provides access to collaboration tools, such as Microsoft Teams, Slack, and SharePoint, to facilitate communication and teamwork among remote team members.
Training and Development: SSG offers regular training and development opportunities to help employees stay current with emerging technologies and best practices in database administration.

Work Schedule: Full-time position with a standard workweek of 40 hours, with some flexibility for remote work and occasional on-site meetings or training sessions.

📝 Enhancement Note: SSG's remote work environment allows for a flexible and balanced work-life schedule, with the necessary tools and resources to support productive and collaborative remote work.

📄 Application & Technical Interview Process

Interview Process:

Phone Screen: A brief phone or video call to discuss your qualifications, experience, and career goals.
Technical Assessment: A hands-on assessment of your database administration skills, including data modeling, SQL Server management, and performance tuning tasks.
Behavioral Interview: A structured interview focused on your problem-solving skills, teamwork, and cultural fit with SSG.
Final Review: A meeting with the hiring manager and other senior team members to discuss your qualifications and fit for the role.

Portfolio Review Tips:

Data Mart and Data Warehouse Examples: Highlight your experience in creating and managing data marts and data warehouses, demonstrating your ability to support business intelligence and reporting needs.
SQL Server Case Studies: Showcase your proficiency in SQL Server administration, including backups, restores, replication, performance tuning, and query optimization.
Collaboration and Teamwork: Emphasize your experience working with cross-functional teams, including data analysts, business intelligence developers, and software engineers.

Technical Challenge Preparation:

Data Modeling: Brush up on your data modeling skills, including entity-relationship diagrams, normalization, and indexing strategies.
SQL Server Proficiency: Refresh your knowledge of SQL Server administration, including backups, restores, replication, performance tuning, and query optimization.
Problem-Solving Skills: Prepare for behavioral interview questions that assess your problem-solving skills, teamwork, and adaptability in a remote work environment.

ATS Keywords: Database Administration, Microsoft SQL Server, Data Modeling, Data Marts, Data Warehouses, SQL Server Backups, SQL Server Performance Tuning, Query Optimization, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, Extensible Markup Language, Operational Data Store, Extract Transform Load, Data Warehouse, Shell Scripting, PowerShell Scripting, Bash Scripting.

📝 Enhancement Note: By thoroughly preparing for the technical assessment, behavioral interview, and final review, you can demonstrate your qualifications and fit for the senior database administrator role at SSG.

📌 Application Steps

To apply for this senior database administrator position at SSG:

Tailor Your Resume: Highlight your experience in database administration, data modeling, and Microsoft SQL Server management, with a focus on performance tuning, query optimization, and collaboration with cross-functional teams.
Prepare Your Portfolio: Showcase your experience in creating and managing data marts and data warehouses, with a strong emphasis on SQL Server administration, backups, restores, replication, and query optimization.
Research SSG: Familiarize yourself with SSG's company culture, industry, and team structure, and be prepared to discuss how your skills and experience align with their needs.
Practice Technical Interview Questions: Prepare for technical interview questions related to database administration, data modeling, and SQL Server management, with a focus on problem-solving, teamwork, and adaptability in a remote work environment.
Apply: Submit your application through the provided link, and be prepared to provide additional information or documents as requested throughout the interview process.

⚠️ Important Notice: This enhanced job description includes AI-generated insights and web technology industry-standard assumptions. All details should be verified directly with the hiring organization before making application decisions.

Senior Database Administrator