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: 2025-06-27

🚀 Role Summary

Lead database creation and management effort through data modeling and create data marts.
Manage all operations consistently with database management and perform troubleshooting for SQL Server backups and performance tuning.
Collaborate with cross-functional teams to ensure data consistency, integrity, and availability.
Stay current with emerging database technologies and best practices.

📝 Enhancement Note: This role requires a high level of expertise in database management, with a focus on Microsoft SQL Server and data modeling. The remote nature of the position necessitates strong communication and collaboration skills, as well as the ability to work independently.

💻 Primary Responsibilities

Database Design and Management: Lead the database creation and management effort through data modeling. Design, develop, and maintain database structures to support business needs.
Data Mart Creation: Create and maintain data marts to support business intelligence and analytics initiatives.
Database Administration: Manage all operations consistently with database management, including performance tuning, backup and recovery strategies, and security.
Troubleshooting and Optimization: Perform and troubleshooting for SQL Server backups, restores, replication, performance tuning, and query optimization.
Collaboration: Work closely with cross-functional teams, including developers, business analysts, and project managers, to ensure data consistency, integrity, and availability.
Stay Current: Stay current with emerging database technologies and best practices, and apply them to improve database performance and functionality.

📝 Enhancement Note: This role requires a deep understanding of database design principles, SQL Server administration, and data modeling. The ability to work with diverse teams and adapt to changing business needs is crucial for success in this role.

🎓 Skills & Qualifications

Education: A Bachelor's degree or higher in Computer Science, Information Technology, or a related field is required.

Experience: Candidates must have 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 setting up Microsoft SQL Server databases.
Proficiency in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
Strong knowledge of SQL Server Integration Services (SSIS), Extensible Markup Language (XML), Operational Data Store (ODS), Extract, Transform, and Load (ETL), and Data Warehouse (DWH) processes.
Experience with Shell, PowerShell, and Bash Scripting.
Excellent communication and collaboration skills.

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 DevOps practices and CI/CD pipelines.

📝 Enhancement Note: This role requires a high level of technical proficiency in Microsoft SQL Server and related technologies. While not explicitly stated, a strong understanding of data warehousing, ETL processes, and business intelligence concepts would be highly beneficial.

📊 Web Portfolio & Project Requirements

Portfolio Essentials:

A comprehensive portfolio showcasing your database design and management skills, with a focus on Microsoft SQL Server and data modeling.
Examples of data marts created and maintained, highlighting your ability to support business intelligence and analytics initiatives.
Case studies demonstrating your troubleshooting and optimization skills, with a focus on SQL Server performance tuning and query optimization.

Technical Documentation:

Detailed documentation outlining your database design principles, data modeling techniques, and ETL processes.
Code samples and scripts showcasing your proficiency in SQL Server administration, backup and recovery strategies, and security best practices.
Performance metrics and optimization techniques, with a focus on improving database functionality and efficiency.

📝 Enhancement Note: This role requires a strong portfolio demonstrating your database administration skills. While not explicitly stated, including examples of your ability to work with cross-functional teams and adapt to changing business needs would be highly beneficial.

💵 Compensation & Benefits

Salary Range: The salary range for this role is estimated to be between $120,000 and $160,000 per year, based on industry standards for senior database administrators with 8+ years of experience and a focus on Microsoft SQL Server and data modeling. This estimate is inclusive of regional adjustments and considers the remote nature of the position.

Benefits:

Competitive health, dental, and vision insurance plans.
Retirement savings plans, including 401(k) matching.
Generous paid time off (PTO) and holiday schedule.
Professional development opportunities, including training and certification reimbursement.
Employee assistance programs (EAP) for mental health and wellness support.

Working Hours: This is a full-time remote position, with a typical workweek of 40 hours. Some flexibility is available for working hours, with a focus on meeting project deadlines and maintenance windows.

📝 Enhancement Note: The salary range provided is an estimate based on industry standards and regional adjustments. The actual salary offered may vary depending on the candidate's experience, skills, and the company's internal compensation structure. The benefits package is competitive and designed to support the well-being and professional growth of employees.

🎯 Team & Company Context

🏢 Company Culture

Industry: Syms Strategic Group, LLC (SSG) operates in the government services and technology consulting industry, providing a range of services to federal, state, and local government agencies.

Company Size: As a mid-sized company, SSG offers the stability and resources of a larger organization while maintaining a close-knit, collaborative work environment.

Founded: SSG was founded in 2005, with a strong commitment to delivering innovative, cost-effective solutions to government clients.

Team Structure:

The database administration team consists of experienced professionals with a range of expertise in Microsoft SQL Server, data modeling, and data warehousing.
The team works closely with cross-functional teams, including software developers, business analysts, and project managers, to ensure data consistency, integrity, and availability.
The team is structured to support both project-based and ongoing database management needs.

Development Methodology:

SSG employs Agile development methodologies, with a focus on iterative development, continuous integration, and collaboration.
The company uses a combination of on-premises and cloud-based infrastructure, with a strong commitment to security and compliance.
SSG's development process emphasizes code review, testing, and quality assurance practices to ensure the delivery of high-quality, reliable solutions.

Company Website: Syms Strategic Group, LLC

📝 Enhancement Note: SSG's company culture emphasizes collaboration, innovation, and a strong commitment to delivering high-quality solutions to government clients. The company's size and industry focus provide unique opportunities for database administrators to work on complex, mission-critical projects and develop their skills in a dynamic, challenging environment.

📈 Career & Growth Analysis

Web Technology Career Level: This role is at the senior level, requiring a high degree of technical expertise and experience in database administration, with a focus on Microsoft SQL Server and data modeling.

Reporting Structure: The senior database administrator reports directly to the database management team lead and works closely with cross-functional teams to ensure data consistency, integrity, and availability.

Technical Impact: In this role, you will have a significant impact on the design, management, and performance of critical databases supporting SSG's government clients. Your work will directly influence the quality and timeliness of data-driven decisions, enabling SSG to deliver innovative, cost-effective solutions.

Growth Opportunities:

Technical Leadership: As a senior database administrator, you will have the opportunity to mentor junior team members and contribute to the development of database management best practices and standards within SSG.
Architecture Decisions: With your extensive experience and expertise, you will be involved in making critical architecture decisions that shape SSG's database infrastructure and support the company's long-term growth and success.
Emerging Technologies: SSG encourages its employees to stay current with emerging technologies and best practices. As a senior database administrator, you will have the opportunity to explore and implement new database technologies and tools to improve SSG's competitive position in the market.

📝 Enhancement Note: This role offers significant opportunities for career growth and technical leadership within SSG's database administration team. With your extensive experience and expertise, you will have the chance to make a real impact on the company's database infrastructure and support its long-term success.

🌐 Work Environment

Office Type: As a remote position, this role does not require regular on-site presence. However, some travel may be required to support client needs and attend team meetings.

Office Location(s): While this role is remote, SSG's headquarters is located in Wichita, Kansas, and the company has offices in various locations across the United States.

Workspace Context:

Remote Workspace: As a remote employee, you will be provided with the necessary hardware and software to create a productive and comfortable workspace at home.
Collaboration Tools: SSG uses a range of collaboration tools, including Microsoft Teams, Slack, and Zoom, to facilitate communication and collaboration among team members.
Development Tools: SSG's development environment includes a combination of on-premises and cloud-based tools, with a focus on security, compliance, and efficiency.

Work Schedule: This is a full-time remote position, with a typical workweek of 40 hours. Some flexibility is available for working hours, with a focus on meeting project deadlines and maintenance windows. SSG encourages a healthy work-life balance and provides employees with the resources and support they need to succeed in their roles.

📝 Enhancement Note: As a remote employee, you will have the flexibility to create a workspace that suits your needs and preferences. SSG's remote work policy emphasizes communication, collaboration, and results-driven work, with a focus on meeting project deadlines and maintaining high-quality standards.

🛠 Technology Stack & Web Infrastructure

Database Technologies:

Microsoft SQL Server: Expertise in Microsoft SQL Server is required for this role, with a strong focus on database design, management, and performance tuning.
SQL Server Analysis Services (SSAS): Proficiency in SSAS is required for creating and managing data marts and supporting business intelligence initiatives.
SQL Server Reporting Services (SSRS): Familiarity with SSRS is required for designing and implementing reporting solutions that meet business needs.
SQL Server Integration Services (SSIS): Experience with SSIS is required for designing, implementing, and managing ETL processes that support data warehousing and business intelligence initiatives.

Development & DevOps Tools:

Version Control: Familiarity with version control systems, such as Git, is required for collaborating with development teams and ensuring the integrity of database schemas and scripts.
CI/CD Pipelines: Experience with CI/CD pipelines is preferred for automating database deployment and ensuring consistent, reliable database environments.
Infrastructure as Code (IaC): Familiarity with IaC tools, such as Terraform or Azure Resource Manager, is preferred for managing database infrastructure as code and ensuring consistent, automated deployments.
Cloud Platforms: Experience with cloud-based database management systems, such as Azure SQL Database or Amazon RDS, is preferred for supporting SSG's hybrid cloud infrastructure and ensuring consistent, secure database environments.

📝 Enhancement Note: SSG's technology stack emphasizes Microsoft SQL Server and related technologies, with a focus on database design, management, and performance tuning. Familiarity with cloud-based database management systems, CI/CD pipelines, and IaC tools is highly beneficial for success in this role.

👥 Team Culture & Values

Database Administration Values:

Data Integrity: SSG places a strong emphasis on data integrity, with a focus on ensuring the accuracy, consistency, and availability of critical data.
Collaboration: SSG values collaboration and teamwork, with a focus on working closely with cross-functional teams to ensure data consistency, integrity, and availability.
Continuous Learning: SSG encourages continuous learning and professional development, with a focus on staying current with emerging technologies and best practices.
Customer Focus: SSG is committed to delivering high-quality, customer-focused solutions that meet the unique needs of its government clients.

Collaboration Style:

Cross-Functional Integration: SSG's collaboration style emphasizes cross-functional integration, with a focus on working closely with software developers, business analysts, and project managers to ensure data consistency, integrity, and availability.
Code Review Culture: SSG's development process emphasizes code review, with a focus on ensuring the quality, security, and reliability of database schemas and scripts.
Knowledge Sharing: SSG encourages knowledge sharing and mentoring, with a focus on fostering a culture of continuous learning and professional development.

📝 Enhancement Note: SSG's team culture emphasizes collaboration, knowledge sharing, and continuous learning. As a senior database administrator, you will have the opportunity to contribute to the development of database management best practices and standards within SSG, while working closely with cross-functional teams to ensure data consistency, integrity, and availability.

⚡ Challenges & Growth Opportunities

Technical Challenges:

Data Modeling: This role requires a deep understanding of data modeling principles and the ability to design and implement complex database structures that support business needs.
Performance Tuning: As a senior database administrator, you will be responsible for identifying and addressing performance bottlenecks, with a focus on optimizing SQL queries, indexing, and database design.
Backup and Recovery: This role requires a strong understanding of SQL Server backup and recovery strategies, with a focus on ensuring the availability and integrity of critical data.
Security: As a senior database administrator, you will be responsible for implementing and maintaining database security best practices, with a focus on protecting critical data from unauthorized access and malicious attacks.

Learning & Development Opportunities:

Emerging Technologies: SSG encourages its employees to stay current with emerging technologies and best practices. As a senior database administrator, you will have the opportunity to explore and implement new database technologies and tools to improve SSG's competitive position in the market.
Technical Mentoring: With your extensive experience and expertise, you will have the opportunity to mentor junior team members and contribute to the development of database management best practices and standards within SSG.
Architecture Decisions: As a senior database administrator, you will be involved in making critical architecture decisions that shape SSG's database infrastructure and support the company's long-term growth and success.

📝 Enhancement Note: This role offers significant technical challenges and learning opportunities for senior database administrators with a strong focus on Microsoft SQL Server and data modeling. With your extensive experience and expertise, you will have the chance to make a real impact on SSG's database infrastructure and support its long-term success.

💡 Interview Preparation

Technical Questions:

SQL Server Expertise: Prepare for technical questions focused on Microsoft SQL Server, including data modeling, performance tuning, backup and recovery, and security best practices.
Data Marts and Business Intelligence: Brush up on your knowledge of data marts, SSAS, and SSRS, with a focus on designing and implementing solutions that support business intelligence initiatives.
ETL Processes and Data Warehousing: Review your understanding of ETL processes, data warehousing, and related technologies, with a focus on designing and implementing efficient, reliable data pipelines.

Company & Culture Questions:

SSG's Mission and Values: Familiarize yourself with SSG's mission, values, and company culture, with a focus on how your skills and experience align with the company's goals and objectives.
Government Services and Technology Consulting: Research SSG's industry and the government services and technology consulting landscape, with a focus on how your expertise can contribute to the company's success.
Collaboration and Teamwork: Prepare for questions focused on your ability to work effectively with cross-functional teams, with a focus on ensuring data consistency, integrity, and availability.

Portfolio Presentation Strategy:

Database Design and Management: Highlight your expertise in database design and management, with a focus on Microsoft SQL Server and data modeling.
Data Marts and Business Intelligence: Showcase your ability to create and maintain data marts that support business intelligence initiatives, with a focus on SSAS and SSRS.
Performance Tuning and Optimization: Demonstrate your proficiency in SQL Server performance tuning and optimization, with a focus on improving database functionality and efficiency.
Backup and Recovery: Emphasize your understanding of SQL Server backup and recovery strategies, with a focus on ensuring the availability and integrity of critical data.

📝 Enhancement Note: Preparing for this interview involves a deep understanding of Microsoft SQL Server, data modeling, and related technologies. Familiarize yourself with SSG's company culture, mission, and values, and be prepared to discuss how your expertise aligns with the company's goals and objectives.

📌 Application Steps

To apply for this Senior Database Administrator position at Syms Strategic Group, LLC (SSG):

Customize Your Resume: Tailor your resume to highlight your relevant experience, skills, and accomplishments in database administration, with a focus on Microsoft SQL Server and data modeling.
Prepare Your Portfolio: Curate a portfolio showcasing your database design and management skills, with a focus on Microsoft SQL Server and data modeling. Include examples of data marts, performance tuning, and backup and recovery strategies.
Research SSG: Familiarize yourself with SSG's company culture, mission, and values, and be prepared to discuss how your expertise aligns with the company's goals and objectives.
Prepare for Technical Interviews: Brush up on your knowledge of Microsoft SQL Server, data modeling, and related technologies, with a focus on designing and implementing efficient, reliable database environments.
Submit Your Application: Submit your application through the provided link, including your tailored resume and portfolio.

⚠️ 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